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

phpexperts

Want to share photos of your group with the world? Add a group photo to Flickr.

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 13257 |

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 13257 |

Expand Messages	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
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
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