MySQL 5.0 install and management.

Can be installed by apt-get. After that need to change the root's password by following:

mysqladmin -u root password 'password'

Then add users inside mysql.

mysql> GRANT USAGE ON *.*
-> to Dave@localhost identified
-> by "password";

MySQL backup and recovery

The most common use of mysqldump is probably for making a backup of an entire database:

shell> mysqldump --opt db_name > backup-file.sql 

You can read the dump file back into the server like this:

shell> mysql db_name < backup-file.sql