How to Copy All of the Tables from One Database to Another

Under normal circumstances, one of the easiest ways to copy the contents of one MySQL database to another is to use phpMyAdmin to dump the database to a file. You can then import the contents into your destination database. This usually works, but I recently encountered a situation where phpMyAdmin could not handle a particularly […]

How to Automatically Optimize MySQL Databases

Running a dedicated server can be time consuming. There are a myriad of logs, services, and users to check and recheck. Any automation you can setup will greatly reduce your daily, weekly, and monthly work load. Cron is a handy way to automate tasks, as we have previously demonstrated.
MySQL databases, in particular, […]