Mysqldump not exporting emojis correctly – MySQL
How to fix mysqldump to export emoji with the correct codification / charset using the terminal command…
HTML, CSS and JavaScript
How to fix mysqldump to export emoji with the correct codification / charset using the terminal command…
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…
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.
Select random rows from a database base with MySQL
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.