[SOLVED] Backup Mysql

[adeelarifbhatti]

Hi all,
I have executed the following command for the backup of mysql.
mysqldump -u mysql --all-databases > /opt/zimbra/zimbra.sql.bu
but as a result only test's database backup is taken.
Any one who can help me with the backup of rest of the databases?
I guess "mysqldump -u mysql --all-databases > /opt/zimbra/zimbra.sql.bu"
should be taking the backup of all the databases present in mysql server ?

Any IDEAS.
Regards
Adeel

[bougui]

your only baking up your default mysql database you should probably give the path to the zimbra database.

What platefome are you on ?

/opt/zimbra/mysqlbin/mysqldump could maybe do the trick ?

Bye

[adeelarifbhatti]

Well, this is right that the command was taking the backup of the mysql comes with linux rather then zimbra.

I also have to provide the path where the DB is store, may be database files.

Do some onw know about the right path I am suppose to give.
Well, this is right that the command was taking the backup of the mysql comes with linux rather then zimbra.
Regards
Adeel

[adeelarifbhatti]

Hi all,
I had tried the following but didn't had any luck.
mysqldump --u mysql --all-databases -P 7306 --socket /opt/zimbra/db/mysql.sock > /opt/zimbra/zimbra.sql.bu

regards
Adeel

[uxbod]

Perhaps if you checked the wiki you would have found your answer Mysql Crash Recovery - Zimbra :: Wiki - Read section 2.

[adeelarifbhatti]

It worked,


Thanks you very much