Mysql

[Sunil Sunder Raj]

Hi,
Execute
mysqldump -u root -p<root password> --all-databases >> 
WHOLE_DATABASE_DUMP.DMP

Once you reinstall mysql, delete all databases from mysql and then run
cat WHOLE_DATABASE_DUMP.DMP | mysql -u root -p<root password>

This is a tested method.

Regards
SSR



>From: "Ian Barnes" <ian at cerebellum.za.net>
>To: <freebsd-questions at freebsd.org>
>Subject: Mysql
>Date: Thu, 29 May 2003 18:08:53 +0200
>
>Hi,
>
>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 ??
>
>I know this is a stupid question but i dont know this sort of thing.
>
>Anyone maybee have a link to a tutorial or something.
>
>Thanks alot.
>
>Ian
>
>_______________________________________________
>freebsd-questions at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>To unsubscribe, send any mail to 
>"freebsd-questions-unsubscribe at freebsd.org"

_________________________________________________________________
Attention NRIs! Send money to India. 
http://server1.msn.co.in/msnleads/citibankrca/citibankrca2.asp Do it in a 
jiffy!