A useful thing is to monitor the load on your MySQL database server. To check mysql queries per second you’ll need a simple helper script:
Blog Archives
Dump database to text file and then restore it
The mysqldump command dumps databases/tables to standart output. You can use pipe redirect to save it to file: mysqldump [options] >dump.sql When you dump a database there are some options of mysqladmin you need to understand: