From: Junaid Nazir Date: October 13 2010 2:15pm Subject: PhpMyAdmin and Large MySQL Database Backup Timeouts List-Archive: http://lists.mysql.com/backup/149 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=000e0cd48b42aefab50492803ba1 --000e0cd48b42aefab50492803ba1 Content-Type: text/plain; charset=ISO-8859-1 PhpMyAdmin is commonly used to administer MySQL databases including for backup and export purposes - however, sometimes a test database becomes considerably large in size running into several gigabytes of data - attempting to backup such a database via PhpMyAdmin invariably leads to timeout errors. What alternatives are there or what is the recommended procedure for creating a large backup with the correct settings for a full export, whether it is via PhpMyAdmin or at the command line? Best regards, Junaid Nazir SuperStoreSearch Team -------------------------- Merchant Support http://www.superstoresearch.com | Online Shopping Guide Email: junaid.nazir@stripped Phone: 0798 555 333 0 + + + + + SuperStoreSearch on Facebook & Twitter: http://www.facebook.com/SuperStoreSearch http://twitter.com/Guidester Buzz Shopping Blog: Interesting technology news, how to guides, tips and popular product comparisons & reviews. http://www.superstoresearch.com/buzz/ + + + + + --000e0cd48b42aefab50492803ba1--