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 ? Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/ 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. Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1147 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 ? Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1148 Share on other sites More sharing options...
DocSeuss Posted April 15, 2003 Share Posted April 15, 2003 yep Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1149 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 Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1151 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 Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1152 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 ? Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1182 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? Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1335 Share on other sites More sharing options...
amberbaby Posted April 27, 2003 Author Share Posted April 27, 2003 I did Link to comment https://forums.phpfreaks.com/topic/353-phpmyadmin-problem/#findComment-1346 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.