Importing database using myphp

Avatar
  • updated
  • Answered

I have downloaded my Word Press database to place it in my local server in order to update my site. All has gone well until I get to the stage for importing the database into localhost. i keep getting the following message:

--

-- Database: `holmgate1_newch`

--

-- --------------------------------------------------------

--

-- --------------------------------------------------------

--

-- Table structure for table `wpstg0_commentmeta`

--

CREATE TABLE `wpstg0_commentmeta` (

`meta_id` bigint(20) UNSIGNED NOT NULL,

`comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',

`meta_key` varchar(255) DEFAULT NULL,

`meta_value` longtext

) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL said:

#1046 - No database selected

I have definitely selected the downloaded database and I get the same message every time, even though I have downloaded several copies of the DB.

Any help will be greatly appreciated.

Avatar
anonymous
  • Answered

Hello and thanks for contacting us. You could try removing the database name lines. Also, ensure whatever software you're using has matching settings for the database you're importing.