danny_woo Posted May 12, 2011 Share Posted May 12, 2011 Hi guys I recently change my hosting because of down time issues. Anyway on my new web hosting provider, when I try to import my SQL DB I get this error: Error SQL query: -- --Table structure for table 'accounts'; -- DROP TABLE IF EXISTS 'accounts' ; MySQL said: Documentation #1046 - No database selected I hope some one out there can help me out on this, you guys have been great in the past. Many thanks in advance. Danny. PS. I didn't create this SQL DB and I know very little about MySQL so please go easy on me! Quote Link to comment https://forums.phpfreaks.com/topic/236194-error-tying-to-import-mysql-db-on-a-new-server/ Share on other sites More sharing options...
phppaper Posted May 12, 2011 Share Posted May 12, 2011 #1046 - No database selected Are you suing phpmyadmin? this means you have not enter a database or its not created yet, create one and run the sql in there Quote Link to comment https://forums.phpfreaks.com/topic/236194-error-tying-to-import-mysql-db-on-a-new-server/#findComment-1214365 Share on other sites More sharing options...
danny_woo Posted May 12, 2011 Author Share Posted May 12, 2011 Yes your right mate, I was in php my admin and had not created a DB yet. I will try that and get back to you. Thanks for your quick reply. Danny. Quote Link to comment https://forums.phpfreaks.com/topic/236194-error-tying-to-import-mysql-db-on-a-new-server/#findComment-1214367 Share on other sites More sharing options...
danny_woo Posted May 12, 2011 Author Share Posted May 12, 2011 Just to confirm, that did the trick. Thanks for the advice , I know it was pretty basic stuff that I should of already known but thanks for helping me out dude. The people on this forum kick ass. Love you guys. Cheers. Danny. Quote Link to comment https://forums.phpfreaks.com/topic/236194-error-tying-to-import-mysql-db-on-a-new-server/#findComment-1214451 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.