Error Importing .sql from old host onto new

Need help installing Joomla!? For all Joomla! installation issues please use this forum.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
fiazio
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Feb 18, 2010 11:51 am

Error Importing .sql from old host onto new

Post by fiazio » Wed Apr 20, 2011 8:43 pm

Hello,
I am moving a joomla 1.0 installation from another host to a new one.
I am having error when i import the .sql onto the new host.
"Error
SQL query:

--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner` ;


MySQL said:

#1046 - No database selected "

I am stuck on this, everything else has been done.

Help is greatly appreciated

doriangray
Joomla! Apprentice
Joomla! Apprentice
Posts: 44
Joined: Wed Jan 27, 2010 6:14 pm
Location: Germany
Contact:

Re: Error Importing .sql from old host onto new

Post by doriangray » Wed Apr 20, 2011 11:06 pm

which database administration software do you use?
i prefer phpmyadmin. there you can select the database and run the sql query for this database.
this should also be possible with other tools.
4-visions Internet
http://www.4-visions.de

fiazio
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Feb 18, 2010 11:51 am

Re: Error Importing .sql from old host onto new

Post by fiazio » Sun Sep 14, 2014 8:01 pm

Sorry for the delay, I have sorted this out.

Instead of exporting from the PHPmyadmin, i used the cPanel's backup and restore system on both the ends and works great. Thank you for the kind reply.


Locked

Return to “Installation - 1.0.x”