MySQL Forums
Forum List  »  Data Recovery

Re: How to restore the database double encoded by mysqldump
Posted by: George Sun
Date: July 08, 2011 09:08AM

I got my data back. Thanks everyone, though nobody replies me.
By this way,
1.import the messy data
2.use sqldump as 'mysqldump -h "$DB_HOST -u "$DB_USER" -p"$DB_PASSWORD" --opt --quote-names --skip-set-charset --default-character-set=latin1 "$DB_NAME" > /tmp/temp.sql'

Reference
http://pastebin.com/iSwVPk1w

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to restore the database double encoded by mysqldump
1445
July 08, 2011 09:08AM


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.