MySql Data Base Backup

Hi,

it is possible to take a backup of MYSQL database programatically and there are different ways how to do it. One of them will be to use mysqldump utility on your server with syntax similar to
mysqldump -u your_username -p your_password database_name > path\filename_where_to_store_backup (of course you have to write code to access mysqldump on the server. The best will be to create batch and call batch with parameters).

But there are also another possibility (slower). The best will be to take a look at MySQL documentation online at http://dev.mysql.com/doc/refman/5.0/en/backup.html

rgds,
www.bypsoft.com
DBTYP.NET - free cross database comparison and synchronisation tool

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

BYPsoft19y ago
Hi,

it is possible to take a backup of MYSQL database programatically and there are different ways how to do it. One of them will be to use mysqldump utility on your server with syntax similar to
mysqldump -u your_username -p your_password database_name > path\filename_where_to_store_backup (of course you have to write code to access mysqldump on the server. The best will be to create batch and call batch with parameters).

But there are also another possibility (slower). The best will be to take a look at MySQL documentation online at http://dev.mysql.com/doc/refman/5.0/en/backup.html

rgds,
www.bypsoft.com
DBTYP.NET - free cross database comparison and synchronisation tool