Jump to content

Archived

This topic is now archived and is closed to further replies.

amberbaby

phpMyAdmin problem

Recommended Posts

How do I copy an existing sql database on an apache server with phpMyAdmin ?

DB1= existing database

DB2= new database where I need the same data as DB1

I have root access.

 

Anyone ?

Share this post


Link to post
Share on other sites

go to the database you wish to copy, click on the Export tab and decide on the options you want to dump the database with.

create your new(backup) database with name only.

go to the SQL section(tab) of this new database and at the bottom of the big textarea is a input box, browese to the location of the dump file you created in step one, and whola.

Share this post


Link to post
Share on other sites

what text area ?

Do you mean where it sais \"Or Location of the textfile\" in PHPMyadmin under the new db ?

Share this post


Link to post
Share on other sites

sorry, not working

does it have to be a .txt file ? I just used the .sql file I downloaded from the other db

Share this post


Link to post
Share on other sites

I know it sounds stupid but it\'s just not working properly. I managed to export and then import the structure, but I can\'t import the data, I have no idea why. I exported the data to a .sql file but it\'s not importing. It\'s probably just something silly that I\'m missing.

How can I do it with comand line in SSH ?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.