Backing Up and Restoring Your MySQL 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 >>
More MySQL Articles
More By Vinu Thomas
