Tag Archives: phpMyAdmin
I use phpMyAdmin to manage mySql databases quite often and I find myself uploading / importing SQL files. I’ve gotten a little spoiled with WordPress’ HTML5 drag and drop ajax style uploader. Every time I go to use phpMyAdmin I start wishing that it had a HTML5 style drag-and-drop file uploader, something like this: I think it would be fairly easy to write a plugin and implement this idea but I have not done it yet. Leave a comment if the lack of a drag and drop HTML5 file uploader for phpMyadmin bugs you too.
In your mf.cnf file: [mysqld] default-character-set = utf8 collation-server = utf8_unicode_ci init-connect=’SET NAMES utf8′ character-set-server = utf8 #try uncommenting these if you have problems #skip-character-set-client-handshake #character_set_client=utf8 #character_set_server=utf8 [mysql] default-character-set=utf8 [client] default-character-set=utf8 And I have this in my confg.inc.php file for phpMyAdmin: $cfg[‘DefaultLang’] = ‘en-utf-8’; $cfg[‘DefaultCharset’] = ‘utf_8’; $cfg[‘DefaultConnectionCollation’] = ‘utf8_general_ci’; $cfg[‘Lang’] = ‘en-utf-8′; To verify, run this command: show variables like “%character%”;show variables like “%collation%”; collation_connection latin1_swedish_ci collation_database utf8_unicode_ci collation_server utf8_unicode_ci It does not really matter what the collation_connection shows up as. This has no bearing on how the mysql commands are run. If it is not utf8 that is fine. Tip: Just make sure that your DATABASE’s coalitions are also set to utf8 (utf8_general_ci), in phpMyAdmin – then tables you create inside the database will have that coallation too.