SMF Support > Install and Upgrade Help

Moving to new domain, can't import database

(1/1)

oaqm:
Hi.

I am moving (or attempting to move) my SMF database from one domain to another. I used myPHPadmin to download "gallen_smf2.sql" to my desktop. I downloaded it as an uncompressed SQL file.

When I attempt to import it via myPHPadmin at the new domain, I end up with the following error message:

SQL query:

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

MySQL said: Documentation
#1046 - No database selected

Am I saving the file in the wrong format? To the best of your knowledge am I doing something wrong on the downloading end, the uploading end, or possibly both?

Any help would be greatly appreciated.

oaqm:
Disregard.

Resolved the issue by creating a new database on the new domain, renamed the downloaded database on my desktop to the newly created db name, opened database on desktop and changed database name via notepad, saved, closed.

Then selected new database via PHPMYADMIN (sorry I was miscalling that in my original post) and imported the database on my desktop.

Ran repair_settings.php, corrected the paths to a theme and everything looks to be in order.

I have marked the issue as resolved.

SpeedQuest:
I am in the process of moving our server as well and I am experiencing this same issue.  However, upon trying your fixes I am not getting any different result.

I have backed up our database to my Mac Desktop 'skcsmf1.sql'.  I have opened it with an editor and verified that all the data seems to be there and in order.  The file is only 1.4MB in size.

Then, using phpMyadmin I am attempting to 'Import' the above mentioned file.  I get an almost identical error message:

Error

SQL query:

--
-- Database: `skcsmf`
--
-- --------------------------------------------------------
--
-- Table structure for table `smf_admin_info_files`
--
CREATE TABLE IF NOT EXISTS `smf_admin_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

Not sure what I am missing can anyone help?

ChalkCat:
In your PHPMyAdmin, on the new domain, you have to create a new database and give it a name before you import.  You should have a "Create Database" button somewhere.

Navigation

[0] Message Index