Category: Hosting

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 […]

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] […]