I have done this exact method with mysql on both Linux and Windows machines without failure. If there is a better way, I'll keep reading the posts!
David M. --- Michael Thompson <[EMAIL PROTECTED]> wrote: > 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 __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com _______________________________________________ TriLUG mailing list http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ: http://www.trilug.org/~lovelace/faq/TriLUG-faq.html
