amberbaby Posted April 15, 2003 Share Posted April 15, 2003 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 ? Quote Link to comment Share on other sites More sharing options...
DocSeuss Posted April 15, 2003 Share Posted April 15, 2003 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. Quote Link to comment Share on other sites More sharing options...
amberbaby Posted April 15, 2003 Author Share Posted April 15, 2003 what text area ? Do you mean where it sais \"Or Location of the textfile\" in PHPMyadmin under the new db ? Quote Link to comment Share on other sites More sharing options...
DocSeuss Posted April 15, 2003 Share Posted April 15, 2003 yep Quote Link to comment Share on other sites More sharing options...
amberbaby Posted April 15, 2003 Author Share Posted April 15, 2003 sorry, not working does it have to be a .txt file ? I just used the .sql file I downloaded from the other db Quote Link to comment Share on other sites More sharing options...
DocSeuss Posted April 15, 2003 Share Posted April 15, 2003 hmm, try just typing in the .sql file name in the big box Quote Link to comment Share on other sites More sharing options...
amberbaby Posted April 17, 2003 Author Share Posted April 17, 2003 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 ? Quote Link to comment Share on other sites More sharing options...
Silver Posted April 26, 2003 Share Posted April 26, 2003 You did export structure and data not just structure? Quote Link to comment Share on other sites More sharing options...
amberbaby Posted April 27, 2003 Author Share Posted April 27, 2003 I did Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.