FW: FW: mySQL Question

-----Original Message-----
From: J. Phul [mailto:jpbox@pacbell.net]
Sent: Monday, October 28, 2002 2:44 PM
To: 'Sergei Golubchik'
Cc: 'bugs@lists.mysql.com'
Subject: RE: FW: mySQL Question

Hello Sergei,
I found a fix to the problem I was having. I removed all files related
to mysql (How-to-repeat):
- /usr/local/mysql (the install dir)
- /etc/my.cnf
- /etc/rc.d/init.d/mysqld
- /databases (the location where all data is kept)

I did a fresh reboot and reinstalled the source code from scratch. The
new install is working fine so far. My assumption is that either the
first source dist I got was corrupted somehow or this problem crops up
after an extended use.

If I don't reply back to this issue, it would imply the fresh install
solved my problems ;)

NOTE: Just so other users know the complete install params... I'm also
using InnoDB support and manually adjusted the source to support a
single character search.
~jerry


-----Original Message-----
From: Sergei Golubchik [mailto:serg@mysql.com]
Sent: Thursday, October 24, 2002 5:22 PM
To: J. Phul
Cc: bugs@lists.mysql.com
Subject: Re: FW: mySQL Question

Hi!

On Oct 24, J. Phul wrote:
> Hi... and thanks for all the prompt responses! :)
> Answers to your questions first:
> Yes, I'm using 'mysql-3.23.52-pc-linux-gnu-i686.tar.gz' and had
> downloaded it from the mySQL site.
>
> I also did SELECT VERSION() and got: 3.23.52-log
>
> As for the update, I've listed it below along with the script for
> creating the test table and values.

Still no luck :(

============================================================ ==

% mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.52

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 3.23.52 |
+-----------+
1 row in set (0.01 sec)

mysql> CREATE TABLE `myTest` (
-> `id` tinyint(3) unsigned NOT NULL auto_increment,
-> `name` varchar(60) default NULL,
-> `description` text,
-> PRIMARY KEY (`id`),
-> UNIQUE KEY `id` (`id`),
-> KEY `id_2` (`id`),
-> FULLTEXT KEY `ft_name` (`name`,`description`)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO `myTest` VALUES("1","name 1","This is record 1.");
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO `myTest` VALUES("2","name 2","This should be the
second record.\r\n");
Query OK, 1 row affected (0.00 sec)

mysql> UPDATE myTest SET name='name1 Changed' WHERE name='name 1';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> SELECT * FROM myTest;
+----+---------------+-------------------------------------+
| id | name | description |
+----+---------------+-------------------------------------+
| 1 | name1 Changed | This is record 1. |
| 2 | name 2 | This should be the second record.
|
+----+---------------+-------------------------------------+
2 rows in set (0.01 sec)

mysql> Bye
============================================================ ==

Regards,
Sergei

--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12871@lists.mysql.com
To unsubscribe, e-mail