A great list of MySQL functions to work with utf-8 encoding, this article offers all the information you need! While utf-8 is mostly used for database driven websites, is the default encoding used by MySQL still “latin1_swedish_ci”. If you forget to change the collation while creating databases and tables you need to change field types afterwards and maybe you need to re-import your data.
This is a great MySQL 101! Recently I got several problems with a few MySQL databases because the server wasn’t able to write to the SAN storage. I found this page and the command ” /usr/local/mysql/bin/mysqlcheck –all-databases -uUSERNAME -pPASSWORD -r” fixed all the corrupt tables. Sure it took some time to check/repair all the tables, but the work need to be done. One hint, before you start repairing, you should search for the location of the MySQL binaries (use “locate mysqlcheck” for example) otherwise it will not work. You need to have MySQL ROOT access for many functions mentioned on this page.
Login to your server’s console and download MySQLTuner (I use my user’s home directory)
If you don’t like to enter the user details for every test it’s possible to create a .my.cnf file in the same directory and add a mysql admin user to access your database
Use this kind of settings:
[client] Read More…
Great article about using a database abstraction layer! I like EZ a lot, they have great classes, but more interesting is the discussion about PDO (check the comments). Last time I checked PDO, most of the PDO drivers were in an early development stadium. Now it’s possible to use IBM, postgres,… the big ones like Microsoft SQL and Oracle are still experimental