If you have a dedicated database server and the partition with the MySQL database fills up (or starts getting low), you can move your MySQL databases to a different location.

Let’s say you want to move the database to /home/mysql

There are times when you need MySQL to be able to bind to more than one address. In this particular occasion, I was running Nagios locally on the same system as Drupal, my content management system.

There are a variety of ways to change your MySQL password.  One of the easiest is from the command line.  You can use a command like:

 mysqladmin -u root password yourrootsqlpassword

to change your password.  The above command changes the password of the acount root to yourrootsqlpassword.

MySQL is a free database available from My SQL AB (www.mysql.com). This database is a fully relational database environment and there are several tools available to help you manage the database.

User Management

This article only covers backing up from the Command Linux (i.e., the shell, usually bash or korn (ksh) shells).

If you wanted to back up the database timsdata, you would simply use a command like:

mysqldump -c -u tim -p timsdata > timsdata.sql

This would create a file called timsdata.sql in the current directory. You should be aware that where I've entered the name tim in italics, you should specify another authorized user for the database.