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 dump takes 30 mins or so, and during that
time, every table in the db is locked (so as not to throw it out of sync).
How can I optmize this? I'm trying to come up with a centralized database
backup tool, and I do not have direct access to the database server to run
it locally.
--
Anthony Ettinger
hCard: http://chovy.dyndns.org/hcard.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
