kth5 wrote:if you do not have files/data in /var/lib/mysql, the easiest way to recreate mysql would be to simply remove it or move it away, then restart mysql with /etc/rc.d/mysqld.
if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.
in any case, starting from scratch and importing a backup is always a way better idea!
I tryied and all is fine now.For other with my problem : I removed my old /var/lib/mysql dir then i run mysql_install_db then I chowned /var/lib/mysql to mysql:mysql.That's all and thanks.
that's exactly what /etc/rc.d/mysqld does when /var/lib/mysql does not exists btw.
]]>if you do not have files/data in /var/lib/mysql, the easiest way to recreate mysql would be to simply remove it or move it away, then restart mysql with /etc/rc.d/mysqld.
if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.
in any case, starting from scratch and importing a backup is always a way better idea!
I tryied and all is fine now.For other with my problem : I removed my old /var/lib/mysql dir then i run mysql_install_db then I chowned /var/lib/mysql to mysql:mysql.That's all and thanks.
]]>if you still have data, that's a lot trickier. I would need to check but maybe it is possible to move the directory, restart mysql, stop it and move all folders except for mysql back. then start it up again. in the case all goes well, you shouldn't have lost any data except for the priviledges.
in any case, starting from scratch and importing a backup is always a way better idea!
]]>It seems like the daemon is having problems creating/using database files found in /var/lib/mysql. First of all, check if they are owned by mysql/mysql and are rw- for owner and group. I'm not sure if the arrangement is the same as in Slackware, but I'm pretty sure that mysql is running as user mysql and group mysql.
]]>[root@InSaNe DeViL]#
Why happend this ? I start the server but it stops by itself?The errorlog should help i think :
[DeViL@InSaNe ~]$ cat /var/lib/mysql/InSaNe.err
060404 17:39:59 mysqld started
060404 17:40:00 InnoDB: Started; log sequence number 0 43665
060404 17:40:00 [ERROR] bdb: unable to initialize mutex: Function not implemented
060404 17:40:00 [ERROR] bdb: process-private: unable to initialize environment lock: Function not implemented
060404 17:40:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
060404 17:40:00 mysqld ended
[DeViL@InSaNe ~]$
]]>