XF 1.3 Database migration

[CLMontague]

Hello,

I have moved a database of my forum to another MySql database and its failing with

'
Error
SQL query:

--
-- Database: `db_forum`
--
-- --------------------------------------------------------
--
-- Table structure for table `EWRporta_blocks`
--
CREATE TABLE IF NOT EXISTS `EWRporta_blocks` (

`block_id` VARCHAR( 25 ) NOT NULL ,
`title` VARCHAR( 75 ) NOT NULL ,
`version_string` VARCHAR( 30 ) NOT NULL ,
`version_id` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
`url` VARCHAR( 100 ) NOT NULL ,
`install_callback_class` VARCHAR( 75 ) NOT NULL ,
`install_callback_method` VARCHAR( 75 ) NOT NULL ,
`uninstall_callback_class` VARCHAR( 75 ) NOT NULL ,
`uninstall_callback_method` VARCHAR( 75 ) NOT NULL ,
`cache` VARCHAR( 255 ) NOT NULL DEFAULT '+10 minutes',
`display` ENUM( 'show', 'hide' ) NOT NULL ,
`groups` VARCHAR( 255 ) NOT NULL ,
`locked` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
`active` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY ( `block_id` ) ,
KEY `title` ( `title` )
)ENGINE=INNODBDEFAULTCHARSET=utf8;



MySQL said:

#1046 - No database selected


I have exported and imported them before without an issue is any one able to help??

 

[0ptima]

Which tool are you using to do the import?

 

[DeviateDefiant]

You need to select the database first, if you're running the SQL/import using phpMyAdmin just click on the database name first before going to the SQL or Import tab.

 

[CLMontague]

Thanks for your help it turns out it was a user error its been a wile since iv moved DB with phpMyAdmin!

 

[TPerry]

Thanks for your help it turns out it was a user error its been a wile since iv moved DB with phpMyAdmin!

mysql -p dbname < dbname.sql
works for me.

 

[DeviateDefiant]

mysql -p dbname < dbname.sql

mysql -u username -p dbname < dbname.sql

 

[TPerry]

I never worry about the username since I've already created the DB and assigned permissions. Just import it as root and good to go.
I've honestly gotten where I hate phpMyAdmin.

 

[DeviateDefiant]

I never worry about the username since I've already created the DB and assigned permissions. Just import it as root and good to go.
I've honestly gotten where I hate phpMyAdmin.

Yeah I'm quite the same, it's useful for browsing/digesting information but the command line and manual SQL queries do the real work.