Error upload database from localhost to server – need insights

  • ovitch

    (@ovitch)


    11 years, 4 months ago

    Hello there,

    I’ve encounter an error that never happened to me before. I’m uploading a local version of wordpress online. While importing the SQL I get the following error:

    SQL query:

--
-- Database: <code>[redacted by me]_wp</code>
--
-- --------------------------------------------------------
--
-- Table structure for table <code>wp_commentmeta</code>
--
CREATE TABLE  <code>wp_commentmeta</code> (

 <code>meta_id</code> BIGINT( 20 ) UNSIGNED NOT NULL ,
 <code>comment_id</code> BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT  '0',
 <code>meta_key</code> VARCHAR( 255 ) DEFAULT NULL ,
 <code>meta_value</code> LONGTEXT
) ENGINE = INNODB DEFAULT CHARSET = utf8;

MySQL said: Documentation

#1046 - No database selected

    I’m a bit confused. I tried many option both on the export side or import side, such as “Do not use AUTO_INCREMENT for zero values…without better results.

    Any idea what the error means, I researched the forum but each error seemed tailors to each problems.

    Can anybody enlightened me about it?

Viewing 1 replies (of 1 total)
  • catacaustic

    (@catacaustic)

    11 years, 4 months ago

    Im MySQL you need to select the database before you uload the export file.

    If you’re using phpMyAdmin then you just need to click on the link for that database, and if you’re using the command line you can use:

    USE my_database_name

Viewing 1 replies (of 1 total)

The topic ‘Error upload database from localhost to server – need insights’ is closed to new replies.