Date: Fri, 30 May 2003 08:23:33 +0530 From: "Sunil Sunder Raj" <unixtools@hotmail.com> To: ian@cerebellum.za.net Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Message-ID: <BAY8-F121SOiPPKEgtf00004543@hotmail.com>
next in thread | raw e-mail | index | archive | help
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@cerebellum.za.net> >To: <freebsd-questions@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@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to >"freebsd-questions-unsubscribe@freebsd.org" _________________________________________________________________ Attention NRIs! Send money to India. http://server1.msn.co.in/msnleads/citibankrca/citibankrca2.asp Do it in a jiffy!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?BAY8-F121SOiPPKEgtf00004543>