News:

Wondering if this will always be free?  See why free is better.

Main Menu

Error moving database

Started by Cristian10, June 28, 2011, 12:59:54 PM

Previous topic - Next topic

Cristian10

i've downloaded database from phpmyadmin and after i move it with importing on other host i get this error what to do!? Please help! :-[
Error

SQL query:

--
-- Database: `b9_7632423_smfrc5`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_1admin_info_files`
--
CREATE TABLE IF NOT EXISTS `smf_1admin_info_files` (
`id_file` tinyint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
`filename` varchar( 255 ) NOT NULL default '',
`path` varchar( 255 ) NOT NULL default '',
`parameters` varchar( 255 ) NOT NULL default '',
`data` text NOT NULL ,
`filetype` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `id_file` ) ,
KEY `filename` ( `filename` ( 30 ) )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =8;

MySQL said: Documentation
#1046 - No database selected


Cristian10


Illori

please do not bump within 24 hours, we are all volunteers and will reply if and when we know the answer. the more you bump the less likely someone will reply.

Cristian10

Quote from: Illori on June 28, 2011, 02:09:37 PM
please do not bump within 24 hours, we are all volunteers and will reply if and when we know the answer. the more you bump the less likely someone will reply.
ok sorry but i'm said cuz' my forum is going to be dead :'(

Cristian10

Quote from: Illori on June 28, 2011, 02:09:37 PM
please do not bump within 24 hours, we are all volunteers and will reply if and when we know the answer. the more you bump the less likely someone will reply.
Please tell someone why i get that error :(

cicka

Quote from: Cristian10 on July 02, 2011, 09:12:59 AM
Quote from: Illori on June 28, 2011, 02:09:37 PM
please do not bump within 24 hours, we are all volunteers and will reply if and when we know the answer. the more you bump the less likely someone will reply.
Please tell someone why i get that error :(

That is because you have not chosen a database to restore the backup file.

Cristian10

i've chosen!
the database name is :
-- Database: `b9_7632423_smfrc5`

Illori

that database does not appear in the screenshot you are showing, so it looks like it does not exist so it has to be created first.

Cristian10

Quote from: Illori on July 04, 2011, 12:03:44 PM
that database does not appear in the screenshot you are showing, so it looks like it does not exist so it has to be created first.
ohhh i know now what i did wrong hmm
gonna fix now
Hope that works 8)

Advertisement: