Looking for a backup/restore mySQL DB application

[ScanX]

Hello,

I'm looking for a very simple application to backup/restore a mySQL database.

Actually, I would need to be able to launch the application from a command line so that I dont have to select a profile or anything like that...just put the command line in a bat file, run the bat file and everything is done.

I've already tried :

- Backup Watcher for Mysql
- MyWitch
- DumpTimer
- SQLyog
- MySQL Snap

None of them seems to work with a command line.

Thanx in advance for your help

ScanX

 

[ericbrunson]

have you looked at mysqldump?

 

[ScanX]

Is it possible to use the mysqldump to backup to my HD a database located on a server with a simple command line in a bat file ?

Is it possible to restore a DB from a file on my HD with it aswell ?

 

[lgarner]

Yes to both. It's not a binary backup as the term is usually used. It creates text files full of SQL statements which can be run to recreate your tables.

 

[ScanX]

lgarner ok but I got told that the mysqldump has some problems to restore tables from large files (around 6Mb)...it was timeing out.

Ever heard about this ? Know how to solve ?

 

[lgarner]

I haven't run into that, but it can take a while. Remeber that the files created by mysqldump will be larger than the originals. I run it on a MySQL server with about 77gb in the data dirs, and the largest table is about 1gb.

I my experience, it's also a simple matter to just copy the MySQL data directory to create a backup. You do need to stop the server during this, though.

 

[ericbrunson]

The later versions of mysql dump (I'm no the newest 4.1 release) have gotten better and better. And you don't need to fully shut the server down to copy the datadir, it is sufficient to lock the tables ("lock tables read" will allow applications to continue querying the database during the backup).