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?
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?