phpexperts : Message: Re: [phpXperts] :: Backing up large MySQL database ::

phpexperts

Hear how Yahoo! Groups has changed the lives of others. Take me there.

Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

:: Backing up large MySQL database ::

Message #12638 of 13321 |

Re: [phpXperts] :: Backing up large MySQL database ::

I don't know what is best, but can tell some better solution from real life experience

1.use ssh
2.to restore/import big dump if you don't have ssh then bigdump(http://www.ozerov.de/bigdump.php) is a nice tool
3.for large database and slow bandwidth, take backup of large tables in single.
4.Use high speed and dedicated internet con
........................
Sabuj Kumar Kundu
About Me: http://blog.manchumahara.com/about/
http:/blog.manchumahara.com
http://forum.amaderprojukti.com
http://gallery.amaderprojukti.com
http://mkabya.page.tl

On Tue, Jul 14, 2009 at 11:53 AM, $@!ful™ <anm.saiful@...> wrote:

Which is the best way and format to backing up large MySQL (relational) database?

Tue Jul 14, 2009 6:03 pm

Sabuj Kundu <manchumahara@...>

Offline

Message #12638 of 13321 |

Expand Messages \| View Threaded	Author	Sort by Date
Which is the best way and format to backing up large MySQL (relational) database?...	$@!ful™ anm.saiful	Jul 14, 2009 5:19 pm
I don't know what is best, but can tell some better solution from real life experience 1.use ssh 2.to restore/import big dump if you don't have ssh then...	Sabuj Kundu manchu_mahara	Jul 14, 2009 6:09 pm
Via shell command or cron job use something like this: shell:~$ mysqldump --opt --single-transaction --databases database_one database_two >...	Bobby Easland bobby.easland	Jul 15, 2009 2:57 am
you can do this, 1. log in to the server via ssh. 2. do a mysqldump. 3. Gzip/Bzip2 the output file. 4. download it. But make sure you put the dump file in a...	shiplu staticint	Jul 15, 2009 2:59 am