Page 1 of 1

database migration

Posted: Fri Oct 24, 2003 12:18 am
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?

Posted: Fri Oct 24, 2003 12:43 am
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.

Posted: Fri Oct 24, 2003 10:50 am
by greeneel
Thx