MySQL backup tools

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

Re: MySQL backup tools

deepstar@gmail.com wrote:
> 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

Re: MySQL backup tools

deepstar@gmail.com wrote:
> 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.

Re: MySQL backup tools

Ian Pawson wrote:
> deepstar@gmail.com wrote:
> > 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.