REPAIR TABLE and OPTIMIZE TABLE When working with very large amounts of data, it happens to me that MySQL spits out strange error messages when accessing tables, such as “Table xxx is corrupt” or “Table XXX doesn’t exist” (although SHOW TABLES shows the table). This can occur through bugs in MySQL without doing anything wrong […]
Relations / Linked Tables in PHPMyAdmin When upgrading from an ancient version of PHPMyAdmin to the latest version 3.2.1, I wanted to try out the new relation features today. After about two hours of trying it out, it worked. Perhaps the following tips will help one or the other to speed up the process:In the […]
Quasi-MySQL dump for individual columns There is a simple trick to copy data from individual columns from one MySQL table to another (e.g. from the development server to the production server): Use the CONCAT function to generate UPDATE statements. In this example I would like to extract the information in the primecost column of the […]
Destructors and session data in the database One of my projects uses its own session handler to write the session data to the database instead of to the file system. The first step is to mount and call your own functions with session_set_save_handler (). However, the problem arose here that PHP had already destroyed most […]
Relations / Linked Tables in PHPMyAdmin When upgrading from an ancient version of PHPMyAdmin to the latest version 3.2.1, I wanted to try out the new relation features today. After about two hours of trying it out, it worked. Perhaps the following tips will help one or the other to speed up the process:In the […]