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 the tables for a few seconds or mins. On 12/1/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > 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 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. > > > > Easyhorpak.com Easyhorpak.com wrote: > > 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 > > ************************************************************************ > > http://www.Easyhorpak.com - Find Apartment, Service Apartment, Mansion, > > Condo, Flat, Room for rent, House .. etc Thailand > > http://www.EasyHorpak.com/webdesign - บริการดูแลและออกแบบเว็บไซต์ > > http://www.EasyHorpak.com/air - > > แหล่งรวมผู้ให้บริการติดตั้งเครื่องปรับอากาศ > > http://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: 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 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. > >> > >> > >> > >> > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- Anthony Ettinger hCard: http://chovy.dyndns.org/hcard.html
