Mysqldump not exporting emojis correctly – MySQL
How to fix mysqldump to export emoji with the correct codification / charset using the terminal command…
MySQL
How to Optimize your MySQL tables from the command line
All the MySQL tables have the be optimized once in a while. Ideally, once a week perhaps. You can do that by either going to your phpMyAdmin or, if you’re a badass command line user, run the following command…
Optimize MySQL turning Off InnoDB
If your MySQL databases uses MyISAM instead of InnoDB you should turn the last one Off. It should free memory and optimize your MySQL performance.
How to select Random with MySQL
Select random rows from a database base with MySQL
How to Delete Post Revisions WordPress
Following yesterday’s post about Turning Off Post Revisions today I’m going to show you how to delete those revisions from the data base.