drums Posted November 3, 2009 Share Posted November 3, 2009 I have basic level expertise in database creation and querying, basically a noob. I have a number of sites I will be moving in a week. I have some really simple databases and then some Wordpress ones which I'm not too worried about because I think WP has a plug in or steps. With my simple ones, I really want to avoid having to recreate them. I can see an export feature in phpMyAdmin 2.6.3-pl1 but not sure what to do with it. I can export to a csv but how do I import it and also create the tables/database in the new location? Or do I have to recreate these tables/dB's? Thanks very much for your time! Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/ Share on other sites More sharing options...
Mchl Posted November 3, 2009 Share Posted November 3, 2009 There's also Import option in phpMyAdmin It might be better to do export/import in SQL format, as this will carry over all your database structure as well as data. Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950002 Share on other sites More sharing options...
lmhart Posted November 3, 2009 Share Posted November 3, 2009 I agree. I would export in sql and save to a file. Then use the import function and just select the file to import. It should recreate everything. Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950335 Share on other sites More sharing options...
drums Posted November 3, 2009 Author Share Posted November 3, 2009 Ok, Thanks for responding! So I went into Export and basically kept the defaults and clicked GO. And that opens a page of text that looks like what I need. Now do I copy this and then go to the new server and import? Does it save it as a file or do I need to paste this in somehow? I'm unsure how the next steps should go. Thanks again! Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950463 Share on other sites More sharing options...
Mchl Posted November 3, 2009 Share Posted November 3, 2009 You should have an option to save it as a file before you click 'GO'. You download this file, and when doing import upload it using import form. Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950517 Share on other sites More sharing options...
drums Posted November 3, 2009 Author Share Posted November 3, 2009 Cool, I hadn't noticed that before. Thanks for your help!!! Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950587 Share on other sites More sharing options...
drums Posted November 4, 2009 Author Share Posted November 4, 2009 It worked perfectly. Thanks for the hand holding! Quote Link to comment https://forums.phpfreaks.com/topic/180072-solved-i-am-switching-hosts-and-need-to-move-databases/#findComment-950745 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.