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.
I think this part of the WordPress developer manual is the most important section. This page explains how-to get database data from single fields, rows, columns and complete results. They show you also how-to insert/update a table row from your WordPress database. It’s like short database manual for WordPress (the part you know from MySQL on php.net)
Nice and detailed guide for moving a WordPress site to a new host. I don’t like the idea to set the old site into “maintenance mode”. How long should you do this 24 hours? It’s pretty dangerous if the GoogleBot has visited your site to often in the meantime. In my opinion it’s much safer to change the DNS after the site is moved and yes the comments in meantime…
I’m at the begin of a new project and it’s time to have a look on something new. I like the OOP version of mysqli a lot because of all the new features. On the other site PDO is very simple (less code). This tutorial is an great example how you can extend the mysqli class
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