Codezwiz >> PHP Nuke News >> Back Up and Restore your MySQL Database

Official Server Time: April 30, 2025, 9:44 pm EDT

"I have been coming to this site for a few months now, and find it very informative and helpful, esp if I have had problems, and believe me i've had a few!!! Even if I haven't..."

lofty3109

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

Absolutely

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.