Skip to main content

Posts

Showing posts with the label mysql

MySQL and UTF-8

By
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 collation can be set per server, database, table, connection; Server ( /etc/my.cnf ): [mysqld] ... default-character-set=utf8 default-collation=utf8_general_ci Database: (CREATE | ALTER) DATABASE ... DEFAULT CHARACTER SET utf8 Table: (CREATE | ALTER) TABLE ... DEFAULT CHARACTER SET utf8 Connection: SET NAMES 'utf8'; A  PHP  mysql connection ( not totally confirmed , but see tests below) defaults to a latin1 connection, so, your first query after connection should be: mysql_query("SET NAMES 'utf8'"); In php versio...
Read more

mysql, import sql file from command line

By
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 below and press enter, you will be prompted for a password because you did not enter the password after the -p switch. $ mysqldump <database-name> -u<username> -p >> somedatabasetable.sql Step 2:  Once you have the sql file, log into mysql and create a database or “use” an existing database – again, ommiting the -h will default to localhost and you will be prompted for a password if you don’t enter a password after the -p switch. $ mysql -u<username> -p Step 3:  After logging in, you will need to either create a new database and select the database for use w...
Read more