database migration

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

database migration

Post by greeneel »

hello all,

I created a site and was able to create a database using mysql , now i want to remove the site but I want to keep the original database is it possible to make a copy of it back it up on my system and restore it again when I have setup my new site..
can phpmyqdmin be used for it?
User avatar
DuFF
Forum Contributor
Posts: 495
Joined: Tue Jun 24, 2003 7:49 pm
Location: USA

Post by DuFF »

Yes, its very easy with PHPMyAdmin. Just select the database you want and an export button will be on the top menu on inside the right-side frame. Click this button and then select all the tables and press the Go button. This will output a text file. Copy and paste this. Then when you set up your new server with PHPMyAdmin you can just paste the text file into the Query box.
User avatar
greeneel
Forum Commoner
Posts: 47
Joined: Wed Jul 30, 2003 5:19 pm

Post by greeneel »

Thx
Post Reply