backup mysql

[Zbigniew Koziol]

Noah John Gellner wrote:
> I continue to have problems with mozilla crashing on certain sites. I
> know that a complete reinstall will fix the problem but have no idea
> why. Be that as it may, one result of reinstalling my OS is that I will
> be reinstalling mysql. I currently have databases set up for the Horde,
> Egroupware, and Wordpress. I would rather not redo all of this work.
> 
> How do I archive my mysql settings and database so that I can easily
> restore onto my new OS install? If it is helpful, I am running Gentoo.

man mysqldump -- will explain how to create backup copy. Use for that a 
mysql useraccount that has access to reading all data, so possibly root).

After that:
mysql -uroot -p < mysql-dump.sql -- will restore all databases dumped, 
together with privileges tables (if were backuped properly).

zb.

> Noah

-- 
Zbigniew Koziol, SoftQuake^(tm) Open Source Business Solutions
Toronto, Canada, http://www.softquake.ca, info-lcEyp1+e+UdAFePFGvp55w at public.gmane.org
--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml