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 protected directory.



On 7/15/09, Sabuj Kundu <manchumahara@...> wrote:

> 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?*

>> [image: My Web Site] <http://anmsaiful.net/> [image: Feed

>> Burner]<http://feeds2.feedburner.com/anmsaiful/anmsaiful/blog/posts>

>> [image:

>> Twitter] <http://twitter.com/anmsaiful> [image: Linked

>> In]<http://www.linkedin.com/in/anmsaiful> [image:

>> Face Book] <http://www.facebook.com/people/Anm-Saiful/1051877161> [image:

>> Yahoo Messenger]

>>

>>

>>

>





--

A K M Mokaddim

http://talk.cmyweb.net

http://twitter.com/shiplu

Stop Top Posting !!

বাংলিশ লেখার চাইতে বাংলা লেখা

অনেক ভাল

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