Back Up and Restore your MySQL Database


Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
Share:
Sponsors:

Do you need to change your web host or switch your database server? This is probably the only time when you really think of backing up your MySQL data. 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 will outline two easy ways of backing up and restoring databases in MySQL.

The easiest way to backup your database would be to telnet to the your database server machine and use the mysqldump command to dump your whole database to a backup file. If you do not have telnet or shell access to your server, don't worry about it; I shall outline a method of doing so using the PHPMyAdmin web interface, which you can setup on any web server which executes PHP scripts.
>> Read Full Story Here <<

Article submitted by: Telli
Last Update: 06-16-2004
Category: PHP Nuke News

Print | E-mail


Current rating: 5.33 by 72 users
Would you recommend this article to a friend?

Not a Chance 12345678910 Absolutely
Comments

Re: Back Up and Restore your MySQL Database

By: Silverfox @ 09:30:52 : 06-18-2004

Great batch of info. Came in handy. Thanks teli

Cheers

Re: Back Up and Restore your MySQL Database

By: Telli @ 15:01:10 : 06-18-2004

My pleasure. Glad someone else can use it besides me.


Please register or sign-in to post comments.


Related News Stories

(7,012 reads) 04-13-2009
 · Professional Nuke Installation/Repair Services
(12,729 reads) 02-03-2009
 · New PHP-Nuke Turkey Community Site
(17,813 reads) 08-20-2007
 · Php Nuke 8.1 Patched
(18,871 reads) 08-04-2007
 · PHP-Nuke 8.1 Released
(19,270 reads) 01-11-2007
 · PNC 4.0 Release Date
(14,769 reads) 01-11-2007
 · Clan Themes BBToNuke Pack Released
(15,708 reads) 09-21-2006
 · Php Nuke 8.0 Released
(14,596 reads) 07-18-2006
 · PhpThemes.Net