Tag: database | Tutorial Depot

MySQL and UTF-8

April 4, 2012 at 4:33 pm Tags: | |

www.phpwact.orgA 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.


How to Fix MySQL Database (MyISAM / InnoDB)

November 18, 2011 at 9:20 am Tags: | |

www.softwareprojects.comThis 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.


Function Reference/wpdb Class

November 23, 2010 at 3:27 pm Tags: | | |

codex.wordpress.orgI 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)


How-to Move a WordPress Site from one Server to another

November 17, 2010 at 3:12 pm Tags: | |

wparena.comNice 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…


PDO and extending mysqli

November 10, 2010 at 8:17 am Tags: | | | |

blog.myhat.deI’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


PHP: Fast and easy SQL queries using ezSQL

November 7, 2010 at 10:21 am Tags: | | | | |

www.catswhocode.comGreat 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 :(