Re: mysql/os stuck

2008-07-09 Thread Tsuyoshi Nagata
MarisR さんは書きました: >> 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) >> to fix the problem i have to reboot the entire server. > > Maybe check out file system consistency, check logs. > Yes. create new partition, and move /var/lib/mysql/ to new partion. It may avoids OS dependent file pro

Re: Moving Database from Windows to Linux

2008-07-09 Thread Tsuyoshi Nagata
Aaron Aaron Blew さんは書きました: > mysqldump -u USERNAME -p -h WINDOWS_HOST --opt DATABASE | mysql -u > root -h localhost DATABASE perfect answer.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql/os stuck

2008-07-09 Thread Tsuyoshi Nagata
Marco 2) ERROR 1018 (HY000): Can't read dir of '.' (errno: 24) It seems The current process(mysqld?) can't read current environment. #define EMFILE 24 /* Too many open files */ you have to resolve the environment any of resource below.. CPU(dual core/quad core) memory(need more d

Re: Moving Database from Windows to Linux

2008-06-26 Thread Tsuyoshi Nagata
I move 1giga size of 'JPetstore' record(sql text) from RH4.6 to RH5.2. mysqldump&mysql commands are no problem. pg_dump&psql commands are same result. It takes about 10 minutes of my Celeron 1G.hz note. First I gziped sql text to small size, then ftp, unpacked on Target(Linux). I forgot any of dat