-
áËÅè§ÃÇÁ¼ÙéãËéºÃÔ¡ÒõԴµÑé§ÍÔ¹àµÍÃìà¹çµã¹Í¾ÒÃì·àÁ¹·ì
http://www.EasyHorpak.com/software - áËÅè§ÃÇÁâ»Ãá¡ÃÁÊÓËÃѺ;ÒÃì·àÁ¹·ì
http://www.EasyHorpak.com/move -
From: Anthony Ettinger [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: optimizing mysqldump
Date: Wed, 30
]
To: mysql@lists.mysql.com
Subject: optimizing mysqldump
Date: Wed, 30 Nov 2005 16:44:02 -0800
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
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,
://www.EasyHorpak.com/internet -
áËÅè§ÃÇÁ¼ÙéãËéºÃÔ¡ÒõԴµÑé§ÍÔ¹àµÍÃìà¹çµã¹Í¾ÒÃì·àÁ¹·ì
http://www.EasyHorpak.com/software - áËÅè§ÃÇÁâ»Ãá¡ÃÁÊÓËÃѺ;ÒÃì·àÁ¹·ì
http://www.EasyHorpak.com/move -
From: Anthony Ettinger [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: optimizing mysqldump
Date
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