0

tried to execute dump file in mysql as i usually do with the big files:

mysql -u root -p database_name < mysql_dump.sql

and exactly after this i receive error

ERROR at line 1: Unknown command '\�'.

opening file to see what is there... in preview mode looks ok but when i open it in edit mode i see hieroglyphs like enter image description here

seems to me problem in locale encoding or so, im not very good in linux, what should i do to import the dump step by step pls.

Community
  • 1
  • 1
Eugene
  • 1,680
  • 3
  • 14
  • 23
  • is UTF-8 Enabled ? – MatejMecka Aug 15 '16 at 13:32
  • idk how to test, as i said im not very good in linux – Eugene Aug 15 '16 at 13:34
  • Is it mostly English or does it have other languages ? – MatejMecka Aug 15 '16 at 13:35
  • terminal seems to me support UTF-8 jack@Lenovo-ubuntu:~/Downloads$ $LANG > en_US.UTF-8: command not found jack@Lenovo-ubuntu:~/Downloads$ echo -e '\xe2\x82\xac' > € there inside dump could be russian and other languages – Eugene Aug 15 '16 at 13:37
  • what about the Database you are trying to export ? Is it UTF-8, For info refer to this: http://stackoverflow.com/questions/6103595/how-to-check-if-mysql-table-is-utf-8-and-has-storageengine-innodb – MatejMecka Aug 15 '16 at 13:39
  • im trying to import dump file into the newly created database with the UTF8 collation – Eugene Aug 15 '16 at 13:44
  • Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/120965/discussion-between-unknowndeveloper-and-eugene). – MatejMecka Aug 15 '16 at 13:45

0 Answers0