Discussion:
MySQL backup tools
(too old to reply)
d***@gmail.com
2006-09-26 15:19:25 UTC
Permalink
Hello

I have a rather large database (about 102 megabytes when dumped to an
SQL file) and need advice on backup software for MySql databases. So
far I've only tried Navicat and it takes about 30 hours to restore the
entire database using its backup function, something I find
unacceptable. Are there other tools on the market that will let me
backup/restore my database but are significantly faster?

I am using a P4 3.2 ghz with 1024 megs of ram.

Thanks
Jonathan
2006-09-26 15:38:01 UTC
Permalink
Post by d***@gmail.com
Hello
I have a rather large database (about 102 megabytes when dumped to an
SQL file) and need advice on backup software for MySql databases. So
far I've only tried Navicat and it takes about 30 hours to restore the
entire database using its backup function, something I find
unacceptable. Are there other tools on the market that will let me
backup/restore my database but are significantly faster?
I am using a P4 3.2 ghz with 1024 megs of ram.
Thanks
I have been using this backup script
(http://worldcommunity.com/opensource/utilities/mysql_backup.html) for
years now and it works very success full. I am able to dump and compress
(.tar.gz) the same amount of data in about few minutes, the report is
received less than 5 minutes after the job has started.

Restoring is done with the command line tool as this saves a lot of
overhead. I also disable indexes while importing and use compressed
insert statements to speed everything up. Restoring takes a little
longer but certainly not 30 hours... last restore has been a while ago
but it certainly did not take more than one hour.

Jonathan
Ian Pawson
2006-09-26 16:31:32 UTC
Permalink
Post by d***@gmail.com
Hello
I have a rather large database (about 102 megabytes when dumped to an
SQL file) and need advice on backup software for MySql databases. So
far I've only tried Navicat and it takes about 30 hours to restore the
entire database using its backup function, something I find
unacceptable. Are there other tools on the market that will let me
backup/restore my database but are significantly faster?
I am using a P4 3.2 ghz with 1024 megs of ram.
Thanks
MySQL provide the MySQL Administrator, one of its functions is backup
and restore. It even allows scheduled backups. Easy to setup in the GUI
and works very quickly - recommended.
David Ayres
2006-09-29 01:09:09 UTC
Permalink
Post by Ian Pawson
Post by d***@gmail.com
Hello
I have a rather large database (about 102 megabytes when dumped to an
SQL file) and need advice on backup software for MySql databases. So
far I've only tried Navicat and it takes about 30 hours to restore the
entire database using its backup function, something I find
unacceptable. Are there other tools on the market that will let me
backup/restore my database but are significantly faster?
I am using a P4 3.2 ghz with 1024 megs of ram.
Thanks
MySQL provide the MySQL Administrator, one of its functions is backup
and restore. It even allows scheduled backups. Easy to setup in the GUI
and works very quickly - recommended.
I like MySQL Administrator as well, I think it's a great app. However,
I haven't had great luck with restoring data using it. Most of the
time, I get a huge amount of failures.
s***@gmail.com
2013-03-27 06:35:53 UTC
Permalink
We would recommend our GUI backup tool for MySql - MySQL Backup FTP (MySqlBF) http://mysqlbackupftp.com/.

1. MySqlBF can work as a service.
2. Run backups on a flexible schedule.
3. Allow backup several databases from several websites.
4. Tool have a completely Free and powerful version.
5. MySqlBF allow to to save backups to the Network, on FTP and most popular cloud storage (Dropbox, Amazon S3, Google Drive, SkyDrive, Box).
6. Connect to remote servers throws TCP, SSH or phpMyAdmin(unique feature)
7. We offer a high quality support and detailed manuals.
Post by Ian Pawson
Post by d***@gmail.com
Hello
I have a rather large database (about 102 megabytes when dumped to an
SQL file) and need advice on backup software for MySql databases. So
far I've only tried Navicat and it takes about 30 hours to restore the
entire database using its backup function, something I find
unacceptable. Are there other tools on the market that will let me
backup/restore my database but are significantly faster?
I am using a P4 3.2 ghz with 1024 megs of ram.
Thanks
MySQL provide the MySQL Administrator, one of its functions is backup
and restore. It even allows scheduled backups. Easy to setup in the GUI
and works very quickly - recommended.
Loading...