[TriLUG] MySql backup

[Turnpike Man]

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 <thompson at easternrad.com> 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