LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   how to do mysql backup while the database is ON (https://www.linuxquestions.org/questions/linux-newbie-8/how-to-do-mysql-backup-while-the-database-is-on-948452/)

sam_nyc 06-04-2012 09:54 AM

how to do mysql backup while the database is ON
 
Hi,

I want to backup mysql database on the fly.
Is this the correct way to do this.... Since I don't know how many database out there on my server, I want to backup every thing on the server.

Code:

mysqldump -u sql_admin -pxyz --all- database > june4mysql_backup.sql
Thanks.

kasl33 06-04-2012 07:59 PM

mysqldump -u sql_admin --all-databases --skip-lock-tables -p > june4mysql_backup.sql


All times are GMT -5. The time now is 07:09 PM.