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

Official Server Time: January 20, 2025, 7:44 pm EST

"When I was made admin of our league and given the responsibility of decorating and adding new things..I was in a panic ! I had no idea how to do these things..however I did..."

Niece57

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.