MySQL and UTF-8

Notes Good support from 4.1 utf-8 is utf8 in MySQL. A collation defines the sort order for the data, it may be case sensitive or not To find out your current setup: SHOW VARIABLES LIKE ‘character_set_database’;SHOW VARIABLES LIKE ‘character_set_client’; To see available character sets and collations on your database: SHOW CHARACTER SET;SHOW COLLATION LIKE ‘utf8%’; Character set and… Continue reading MySQL and UTF-8

mysql, import sql file from command line

Method 1: A quick way to duplicate MySQL databases is to do the following: Step 1: Dump the database either through PHPMyAdmin’s export form or through mysqldump (as I mentioned above). Note (usually, it’s mysqldump <database-name> -h<hostname> -u<username> -p<password> if you ommit the -h switch it will default to “localhost”). After you enter the command… Continue reading mysql, import sql file from command line