Data base backup


Mysql Database Backup

Rule 1 You should always backup your database

Rule 2 You should backup your database regularly, and always before an upgrade


Rule 3 If you don't backup your database, eventually something will happen, you will lose all your data and you will wish you had backed up your database

 

Now for the good news, If you use Database Backup Generator, you can sit back safe in the knowledge that your database is being backed up, and its child's play to restore a corrupt database.

More information on the hard way to backup your mysql database

Article Index
1.
 Backing up and Restoring your MySQL Database  
2. What about Multiple Databases  
3. Easy Restore  
4. PHPMy Admin  
5. Backing up and Restoring your databse with PHPMy Admin  
6. Home  
     

Database - PHPMyAdmin
(Page 4 of 5 )

PHPMyAdmin is an easy to use web-interface to control MySQL databases. You can run this from any system which has a web server which runs PHP scripts. PHPMyAdmin also lets you administer multiple database servers using the same interface. If you don't have telnet or shell access to your database server , this is probably how you would be administering your databases. If you haven't used PHPMyAdmin, head over to http://www.phpmyadmin.net/ and download the latest version to experiment with.

Configure PHPMyAdmin

Before I go on to show you how you can back up and restore your databases using PHPMyAdmin, let me take a little while to show those who going to be first time users of PHPMyAdmin how to configure their installation. Once you've downloaded the latest version of PHPMyAdmin, copy the files from the installation source to your web server. Before you run the program, you'll have to edit a few lines in config.inc.php to get your installation to work properly. You can find this file in the root folder of the installation.

Head over to the line which reads:

$cfg['PmaAbsoluteUri'] = '';

Change this to the web URL of the installation. Let's say you've copied the files to the directory 'phpmyadmin' under the URL 'http://dbserver.com', you should change the option to:

$cfg['PmaAbsoluteUri'] = 'http://dbserver.com/phpmyadmin/';

Here are some more options about your database server which you'll have to modify before you save the configuration file. Let's say you have to connect to your database server, which is residing at 202.32.12.2 and connects on port 432, with the username 'jester' and password 'freddy32', the options you have to change will look like this:

$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'; 

Once you've got the correct setting for the database entered in these options, you can save your configuration file and head over to your PHPMyAdmin installation through your browser.

Next: Backing Up and Restoring Your Database with PHPMyAdmin >>