Page 1 of 1

DROP TABLE IF EXISTS `alerts

Posted: Wed Nov 30, 2011 9:44 pm
by lovehack
m tring to import a table that i downloaded from cpanel,,,i cant get past this part, help me,,,lol

im using WampServer 2.2
Apache 2.2.2
PHP 5.2.0
MySql 5.5.16
phpmyadmin 3.4.7.1


Error

SQL query:

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

MySQL said: Documentation
#1046 - No database selected

Re: DROP TABLE IF EXISTS `alerts

Posted: Thu Dec 01, 2011 6:59 am
by Celauran
You need to specify the database you wish to import into.

Code: Select all

mysql database_name < file_to_import

Re: DROP TABLE IF EXISTS `alerts

Posted: Sun Dec 11, 2011 3:21 pm
by lovehack
thx for the help,,i say this all the time to myself,,,,,READ READ READ,,,,i found out how to do it,,,i was trying to import a database table structure into mysql with out the database even being there,,,i fix that by making the database,,,wow,,