[RESOLVED] Could not read at phmyadmin after restoring.

hanpedro

Could not read at phmyadmin after restoring.

I did backup and restore with these commands:

mysqldum -u -p --default-character-set=latin1 dmdb > mydb-back.sql

converting mydb-back.sql's character latin1 to utf8 with notepad++
reaplced "latin1" with "utf8".
mysql> CREATE DATABASE "mydb_utf8" DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql -p --default-character-set=lutf8 mydb_utf8 < mydb-back.sql

After restoring sql, I opened phmyadmin, but I coul not read letters of database.

But the sql file can be read at notepad++ with utf8.

Any comment would be appreciated.

Krik

Phpmyadmin has an export and an import utility built in, it is a lot easier to use that then to do it via command line.

If the sql looks good in notepad++ I would say empty the database and use the import utility in phpmyadmin.

hanpedro

Krik;10961862 wrote:
Phpmyadmin has an export and an import utility built in, it is a lot easier to use that then to do it via command line.

If the sql looks good in notepad++ I would say empty the database and use the import utility in phpmyadmin.

Thanks for your kind reply.

I tried to import after empty database. But same result.

The part of language settings of phpmyadmin is here:

character set client utf8 
(Global value) latin1 
character set connection utf8 
(Global value) latin1 
character set database latin1 
character set filesystem binary 
character set results utf8 
(Global value) latin1 
character set server latin1 
character set system utf8 
character sets dir /opt/lampp/share/mysql/charsets/ 
collation connection utf8_general_ci 
(Global value) latin1_swedish_ci 
collation database latin1_swedish_ci 
collation server latin1_swedish_ci

Krik

Try just importing the sql file with no changes.

Then see if it looks ok. If so you can use the "Operations" tab to make the change. Or if needs be you can also use the "Query" tab to make changes.

bradgrafelman

What about the database/table/columns? The default collation shown in your output above is latin1_swedish_ci, so you'd have to create/modify the database/table/columns so that they use utf8 collation instead of the default.

hanpedro

Thanks Krik and bradfelman,

I changed my.cnf with utf8, and I successfully restored utf8 sql, and so I read my data.