Article Discussion: Backing Up and Restoring Your MySQL Database

Do you need to shift your web host or shift your database server? This is probably when you think of backing up your MySQL data to move to the new server. If you've got a website with a database or your custom database running for your applications, it is imperative that you make regular backups of the database. In this article, I shall outline two easy ways of backing up and restoring databases in MySQL.


Read the full article here: Backing Up and Restoring Your MySQL Database

Great article and just the kind of thing to help fledgeling administrators get started.

But I say that you should add an addendum to this or write a followup talking about the binary log file and tools such as mysql_binlog. It can be a great help in some of those stranger situations that are sure to arise. I know I've had a few.

Cheers,
BDKR

You said there are some variables that have to be changed in the config.inc.php file:

$cfg['Servers'][$i]['host'] = '202.32.12.2';
$cfg['Servers'][$i]['port'] = '432';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'jester';
$cfg['Servers'][$i]['password'] = 'freddy32';

How do you get this info about a remote server?

Thanks
Mike

did you mention how to restore those multiple database backups? I didn't see it...? I am in a rush right now though