I you totally screw up Mysql

markopolox · 09-22-2003, 01:48 PM

I have debian running with mysql php mode_perl apache.
If I want to reset just mysql (getting rid of whatever tables users etc I have created what would I do.

apt-get -remove <package mysql>

Is that enough or should I worry about other config files on the system.

Then all I would have to apt-get install (mysql-server) again correct???

druuna · 09-22-2003, 02:03 PM

A bit overkill if you only want to get rid of usersettings/excisting tables etc).

Find the directory that holds these files (among others in that dir):

user.frm
user.MYD
user.MYI

This can be found inside the mysql_install_db file and starts with this:

test -z "$ldata" && ldata=
It's the path behind ldata=

Delete all files in this dir and run the following script (mysql should provide this one):

/opt/mysql/bin/mysql_install_db (path could be different).

This will create a 'fresh mysql'.