-
- Posts: 1948
- Joined: Wed Dec 16, 2009 12:46 pm
Re: Mysql
Hi,
Yes, you can do that. Here is an article about how to do that:
http://www.backup4all.com/kb/backup-ms- ... a-120.html
Yes, you can do that. Here is an article about how to do that:
http://www.backup4all.com/kb/backup-ms- ... a-120.html
-
- Posts: 1948
- Joined: Wed Dec 16, 2009 12:46 pm
Re: Mysql
Hi,
Here is how you can back up Mysql data.
1. Create a batch file with the following command:
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe –e –u[username] -p[password] -h[hostname] [database name] > C:\[filename].sql
If you supplied all the arguments properly, the program will connect to your current mysql server and create a dump of your whole database in the file you specified on your C:\ drive.
2. Open Backup Properties->Advanced and put the batch file in the "Run action before backup" section.
3. Set the backup to include the exported file as backup source.
4. Run the backup.
Here is how you can back up Mysql data.
1. Create a batch file with the following command:
C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe –e –u[username] -p[password] -h[hostname] [database name] > C:\[filename].sql
If you supplied all the arguments properly, the program will connect to your current mysql server and create a dump of your whole database in the file you specified on your C:\ drive.
2. Open Backup Properties->Advanced and put the batch file in the "Run action before backup" section.
3. Set the backup to include the exported file as backup source.
4. Run the backup.