Hello. I am migrating a website developed with Joomla on a different server than the one where the website will be permanently hosted.
After making the entire copy of the site in its new location, I have done the import of the database through PHPMyAdmin but it gives me an error when I finish importing. The message I get is:
Mistake
SQL query:
—
— Database: `database_name`
—
— ———————————————— ——–
—
— Table structure for the `bak_assignments` table
—
CREATE TABLE IF NOT EXISTS `bak_assignments` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`access_type` varchar( 60 ) NOT NULL ,
`access_id` text NOT NULL ,
`role` varchar( 60 ) NOT NULL ,
PRIMARY KEY ( `id` ) ,
KEY `access_type` ( `access_type` , `access_id` ( 60 ) , `role` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
MySQL has said:
#1046 – No database selected
Could someone tell me what I’m doing wrong to make this happen?
Greetings.
Answered : 07/15/2010 7:12 pm