PHP: Backup Your Website’s MySQL Database It is always good to backup your MySQL database regularly. You should also create a backup before making any major changes, in case something goes wrong and you need to revert to the unmodified version, then you will found yourself in safe hand. Database backups can also be…
Turning or convert MySQL data latin1 to utf8 The default character set for MySQL is latin1 (As of PHP 5.6.0, default_charset value is used as the default. From PHP 5.4.0, UTF-8 was the default, but prior to PHP 5.4.0, ISO-8859-1 was used as the default. It’s therefore a good idea to always explicitly specify…
Delete all duplicate rows except for one in MySql having no primary key. Someone asked me to delete all rows from a table except one entry with a single query. This is not so easy for me :), Anyway after work and research I have found the solution, I am sharing with you How you can…