19
Mar 14

Delete multiple database tables depending on conditions

Hello,

MySQLA short article today to give you a tips on how to delete table from multiple databases, based on criteria. Sometimes you have to delete lot of tables but you can’t drop the database(s). Here is the method to select all the tables you want to delete and delete them !

Continue reading →


03
Mar 13

Switch from MyISAM to InnoDB engine in MySQL

MySQLHello,

If, I as do, you have MyISAM tables (default storage engine until 5.5.5) and you want to switch them to InnoDB,  because you plan to update to MySQL >= 5.5.5, you will be able to switch but be careful with indexes !

Continue reading →


09
Feb 13

Knowing MySQL databases’ and tables’ size using two requests

MySQLHello,

I guess that, as I do, you appreciate to know MySQL database’ and tables size. It is possible using simple requests based on the database information_schema

Continue reading →