Re: How to back up MSQL

[Thomas Förster]

Hi,
>         How to backup mysql..please help me..

1.) Stop mysql ( on RedHat : /etc/rc.d/init.d/mysql stop)
2.) cd to the DB-Dir, e.h. cd /usr/local/var
3.) tar czf /root/mysql-backup-DDMMYY.tar.gz *
4.) start mysql again /etc/rc.d/init.d/mysql start

The Script can also be mysql.server or mysqld

Greets,
  Thomas