current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 2 down vote favorite

I'm new to MySQL so please guide me through how to do this via command line; I've tried but I get NO logging in the console output and the character set is not utf-8

Please help.

share|improve this question

2 Answers 2

up vote 5 down vote accepted

Since your SQL script doesn't contain any character set configuration directives, mysql just runs in its default character set Latin1. To change the default character set, start mysql like this:

mysql -e "source /path-to-backup/backup-file.sql" db_name --default-character-set=UTF8
share|improve this answer
up vote 7 down vote 
mysql -e "source /path-to-backup/backup-file.sql" db_name

or 

mysql db_name < backup-file.sql

You probably need -u username -p, too in your command.

mysqldump doc

share|improve this answer
    
I've tried mysql db_name < backup-file.sql but utf-8 data are lost –  Nam G VU Jul 18 '11 at 8:23
    
Did you try both, is the correct data in the SQL file to begin with? –  Jacob Jul 18 '11 at 8:24
    
I've tried both and get the data non-unicode. –  Nam G VU Jul 18 '11 at 8:32
    
Unicode? UTF-8? What's it going to be? Anyway, how does the sql file start? Files created with mysqldump contain all the relevant parameters to set the necessary encoding options, I believe; is your file a straight dump file? –  Kerrek SB Jul 18 '11 at 12:42
1  
Ah, your script is missing any character set configuration commands... (take a look at the result of mysqldump to see what I mean). You could try passing --default-character-set=UTF8 to mysql maybe. –  Kerrek SB Jul 19 '11 at 10:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.