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 Quote 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........ Quote 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? Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/51721-moving-large-database/#findComment-256686 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.