From: "BSD baby" <[EMAIL PROTECTED]> To: "Ian Barnes" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 29, 2003 11:16 AM Subject: Re: Mysql
> > 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 > There is also "mysqldump" with complete instructions at the mysql.com website. IIRC, it creates SQL language files that would be used to entirely recreate the database from the commandline once the new server is up & running. HTH, Kevin Kinsey DaleCo, S.P. _______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
