DROP TABLE IF EXISTS `alerts

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
lovehack
Forum Newbie
Posts: 5
Joined: Fri Nov 25, 2011 12:16 am

DROP TABLE IF EXISTS `alerts

Post 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
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: DROP TABLE IF EXISTS `alerts

Post by Celauran »

You need to specify the database you wish to import into.

Code: Select all

mysql database_name < file_to_import
lovehack
Forum Newbie
Posts: 5
Joined: Fri Nov 25, 2011 12:16 am

Re: DROP TABLE IF EXISTS `alerts

Post 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,,
Post Reply