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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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
_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
_________________________________________________________________
Attention NRIs! Send money to India. http://server1.msn.co.in/msnleads/citibankrca/citibankrca2.asp Do it in a jiffy!
_______________________________________________ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
