954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

problem when importing mysql database

hi everyone
when i tried to import my web site database to local sql server myphpadmin
show me this errors i dont know why ??
please help me
Error
SQL query:

--
-- Database: `hakaek10_alqemaalhakaek`
--
-- --------------------------------------------------------
--
-- Table structure for table `rafia_admin_menu`
--
CREATE TABLE IF NOT EXISTS `rafia_admin_menu` (

`menuid` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`submenu` INT( 1 ) NOT NULL DEFAULT '0',
`orderby` INT( 10 ) NOT NULL DEFAULT '0',
`menutitle` VARCHAR( 100 ) DEFAULT NULL ,
`menuurl` VARCHAR( 100 ) DEFAULT NULL ,
PRIMARY KEY ( `menuid` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =82;

MySQL said:

#1046 - No database selected

kingofnothing
Newbie Poster
16 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
 

How did you do the import ? You have to select a database first, but how to do that depends on your method.

pritaeas
Posting Expert
Moderator
5,480 posts since Jul 2006
Reputation Points: 653
Solved Threads: 875
 

Add the following to the beginning of your text file:

USE Database ;


Where Database is the name of the database you want to create the table in.

rch1231
Posting Shark
959 posts since Sep 2009
Reputation Points: 119
Solved Threads: 142
 

yes i import its by choosing file from import tab in myphpadmin
any suggestion ?

kingofnothing
Newbie Poster
16 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
 

sorry i notice that im not select it
thankx

kingofnothing
Newbie Poster
16 posts since Jul 2010
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: