469,117 Members | 1,366 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,117 developers. It's quick & easy.

Problem in restoring database!

JW
I have 2 backup files (using mysqldump.) The first one is for the
whole database, backed up from Januaray to July 25. The second one is
just for 2 tables of that database, backed up from June 29 to July 29.
These 2 tables are updated continuously, and from July 25 to July 29,
there is no new record in the rest of the tables. The data in both
files contains foreign characters, and are encoded by UTF-8 character
set. The problem is that now I have to restore my database, back to
July 29. But I just can read back only 1 file by using mysql command,
because there are some records are duplicated (from June 29 to July
25). So I tried to find some feature like --ignore or --replace, and I
found out that mysqlimport has both! But after testing to import data
by mysqlimport, all records are set to NULL. I guess the problem is
mysqlimport was not parsing foreign characters correctly. I also
noticed that mysqlimport has a --default-character-set option, but
unfortunately, the currently version of MySQL that I'm using (3.23.56)
does not support Unicode...

So is there anyone has any idea how to solve this issue?
Jul 19 '05 #1
0 1191

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Yair Sageev | last post: by
6 posts views Thread by Edwinah63 | last post: by
reply views Thread by bkow | last post: by
9 posts views Thread by GL | last post: by
2 posts views Thread by Fischer Ulrich | last post: by
1 post views Thread by Robbert van Geldrop | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.