I am fairly new to mysql myself but I beleive if you back up the directories in /var/lib/mysql you will get all of the databases. The databases are stored in their own directory (named after the db) and can be copied from one server to another and be accesible. If you do not backup the /var/lib/mysql/mysql with the other databases, you will have to re-create users and permissions. If this is NOT correct, would someone please correct me, as this is my current plan of action for my databases (unless I find something better...).
Oh yeah, I'm running Red Hat 7.3, your distribution may use a different data directory(?). To find out: `cat /etc/my.cnf` and check the datadir= line. HTH & TIA! --mike On Fri, 2003-03-21 at 04:31, Jerry M. Howell II wrote: > Hello all, > > I have been using mysqldump -a to backup my clients sites. > I have discovered a problem with this aproach. I decided to > try and restore it with mysqlimport on my local hd and it'll > restore it up to a certian point then stop. What I'm looking > for is any other recomendations to backup and restore 71 > databases. Any scripts for backing it all up will of course > be welcom as well. second off, how do I wipe these old > databases off my puter :) > > thnx, > -- > > Jerry M. Howell II > > > _______________________________________________ > TriLUG mailing list > http://www.trilug.org/mailman/listinfo/trilug > TriLUG Organizational FAQ: > http://www.trilug.org/~lovelace/faq/TriLUG-faq.html > _______________________________________________ TriLUG mailing list http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ: http://www.trilug.org/~lovelace/faq/TriLUG-faq.html
