I tried -C (--compress), but it still took awhile, since the resulting .sql
file is 218Megs.
I am thinking I will have to write a function which logs into an ssh server
inside the local area network that the db server is on, and hopefully the
bottleneck of the internet will disappear, only locking
Hello.
mysqldump has --compress option, which can help in case
the network is the main bottleneck.
>I'm using the typical --opt with mysqldump, over the internet.
>the problem I'm having is the dump takes 30 mins or so, and during that
>time, every table in the db is locked (so as not
If your servers is Linux based try running mysqldump locally on the
server via ssh. Then you can zip it up and transfer it over.
=C=
|
| Cal Evans
| http://www.calevans.com
|
Anthony Ettinger wrote:
I'm using the typical --opt with mysqldump, over the internet.
the problem I'm having is the d
Very Easy Man.
Use this scripts...
http://www.silisoftware.com/scripts/?scriptname=backupDB
It 's powerful.
Please feel free to reply to this email if you have additional questions or
concerns
ªÇ¹ ¨Ø´ÒºØµÃ
01-7499093
Manager
Easyhorpak.com
***