coldfission Posted May 16, 2007 Share Posted May 16, 2007 I need to move a datbase with 40,000 records from one MySQL to another MySQL server. I have tried just exporting and importing the SQL with phpmyadmin, but the file is too large (over 2mb). I have tried using BigDump, but that doesn't do anything to the database. I have tried just copying and pasting the SQL in phpmyadmin, but it goes for a while then ends at a white screen and nothing is changed. How do i do this? thanks Link to comment https://forums.phpfreaks.com/topic/51721-moving-large-database/ Share on other sites More sharing options...
hitman6003 Posted May 17, 2007 Share Posted May 17, 2007 use mysql administrator.... http://www.mysql.com/products/tools/administrator/ 2mb and 40,000 records is nothing........ Link to comment https://forums.phpfreaks.com/topic/51721-moving-large-database/#findComment-254977 Share on other sites More sharing options...
coldfission Posted May 17, 2007 Author Share Posted May 17, 2007 The Restore window is all greyed out. It doesn't say in the corner that i need to be connected through localhost though. I understand that 40,000 records is nothing to some people, but for phpmyadmin, it recommends using BigDump. Big = Large? How do i move this table? Link to comment https://forums.phpfreaks.com/topic/51721-moving-large-database/#findComment-255560 Share on other sites More sharing options...
fenway Posted May 18, 2007 Share Posted May 18, 2007 Try mysqldump. Link to comment https://forums.phpfreaks.com/topic/51721-moving-large-database/#findComment-256686 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.