MySQL Forums
Forum List  »  Newbie

Re: how to dump 10GB table from Amazon. I get MySqlDump Error 2013
Posted by: jimbo pruett
Date: October 19, 2013 09:41AM

This voodoo worked:
(perhaps it will benefit someone else or I can refer here in 1 year when I forget again....)


THIS WORKED (it pulled 7GB file from amazon in 5 hours)

mysqldump --skip-opt --add-drop-table --add-locks --create-options
--quick
--lock-tables
--set-charset
--disable-keys
signs -h signs.c3XXXXX.us-east-1.rds.amazonaws.com -P 3306 -u cartXXXXX -pXXXXXXX > signs.sql &

Options: ReplyQuote


Subject
Written By
Posted
Re: how to dump 10GB table from Amazon. I get MySqlDump Error 2013
October 19, 2013 09:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.