restarting mysql server

2005-05-25 Thread Ying Sun
Dear there, After install mysql 4.1.12 by using rpm, I have some problems to restart server after shutting down it. When I use "mysqld_safe" try to restart, it give me error as follws: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Hi, I install Mysql 4.1.12-0 by rpm. When I try to create a table, it give me "Lost connection to MySQL server during query". My query is like: CREATE TABLE ArrayBatch ( id int(11) NOT NULL auto_increment, arrayType int(11) NOT NULL default '0', descr text NOT NULL, printStartDate date

problem-Lost connection to MySQL server during query

2005-05-24 Thread Ying Sun
Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY0

Install mysql question

2005-05-19 Thread Ying Sun
Dear there, I have some problems when installing mysql under rpm. Hope some people can give me help. I install MySQL-server-4.1.12-0.i386 package and MySQL--client--4.1.12-0.i386 package under root account. Under the root account, I can start the mysql and it seems working fine. However, wh