如何还原由mysqldump双重编码的数据库 [英] How to restore the database double encoded by mysqldump

问题描述

我使用mysqldump备份数据库. 我的数据库因意外而被破坏，现在我想恢复它. 但是该SQL文件是由bug#28969双重编码的. http://bugs.mysql.com/bug.php?id=28969 有什么解决方案可以使我的数据恢复原状吗? 我只有mysqldump制作的SQL文件. 谢谢.

I use the mysqldump to make a backup of my database. My database was destroyed by an accident and now I want to restore it. But the SQL file is double encoded by bug#28969. http://bugs.mysql.com/bug.php?id=28969 Is there any solution for my data to go back? I only have the SQL file made by mysqldump. Thanks.

我找回了我的数据.谢谢大家.

I got my data back. Thanks everyone.

这样，

1.导入凌乱的数据

2.使用sqldump作为'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'

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'

参考

http://pastebin.com/iSwVPk1w

推荐答案

我找回了我的数据.谢谢大家.

I got my data back. Thanks everyone.

这样，

1.导入凌乱的数据

2.使用sqldump作为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

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

参考

#!/bin/bash -e

DB_HOST="$1"
DB_USER="$2"
DB_PASSWORD="$3"
DB_NAME="$4"


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

mysql -h "$DB_HOST" -u "$DB_USER" -p"$DB_PASSWORD" \
    --default-character-set=utf8 "$DB_NAME" < /tmp/temp.sql

这篇关于如何还原由mysqldump双重编码的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！