Mysql

[BSD baby]

> I want to remove my mysql installation and re-install from scratch. Now the
> problem. I have 6 active databases. How can i make sure that i dont loose
> those. And that when i have re-installed, that they work immediatilly ??

The databases are in /var/db/mysql

The smartest thing would be to do (as root user):

mysqladmin -u YourUsername -p shutdown
cd /var/db/mysql
tar cvfz MyDatabases.tgz *
mv MyDatabases.tgz /home/

That will stop your database server, and save all your data in your /home/ dir.

Then, when you want to restore them, IF they're not there after a new install, just do:

cd /var/db/mysql
rm *
tar xvfz /home/MyDatabases.tgz