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]