Uwe Brauer wrote: >>>>>> On Thu, 09 Sep 2010 18:02:09 -0400, George Larson >>>>>> <george.g.lar...@gmail.com> wrote: > > > We do nightly backups at work just by taring the mysql directory. In > > my environment, that is /var/lib/mysql. > > > Like this: > > > service mysql stop > > cd /var/lib/mysql > > rm -rf * > > tar zxvf file.tar > > rm -rf ib_logfile* > > chown -R mysql.mysql > > service mysql start > > > Something similar might work for you. Somebody with more MySQL > > expertise than me can probably help you customize the process to your > > environment. > > Ok thanks. What I am afraid of is that in on of these OS, > their might be some other configuration files, which might > be located apart from the main directory say in /etc and > then I should copy them as well. > > Would it be necessary in Linux to generate the db and its > users first? > > Uwe Brauer > The only one I know of, for my environment, is /etc/my.cnf. I believe that it can be located elsewhere but you could just use 'find' to find it. I've broken my dev. MySQL many, many times and that's the only file I know about outside of my data directory. :)
I don't have any good ideas about discerning precisely what version of MySQL was running, though. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org