Category: MySQL

12+ Useful SQL Queries for WordPress Database Cleanup

If you are using WordPress for a long time, it is possible that you have many spam comments, revisions, transients […]

[Snippet] MySQL Function to Strip HTML Tags

Unfortunately, there is no core function to strip HTML tags from a MySQL field. But, if you really need this […]

Optimizing MySQL configuration using MySQLTuner

MySQL server comes with a default configuration that is suitable for most small websites. But for large websites, you may […]

[How to] Backup and Restore MySQL Database using mysqldump

Backing up a database using mysqldump: mysqldump -u [username] [dbname] > [dump_filename] Restoring database from a backup: mysql -u [username] […]

[How to] Convert Database Charset to UTF8 Using PHP

If you need to use UTF8 charset and want to convert your database charset to UTF8 here is a simple […]