• Resolved bozobo

    (@bozobo)


    I have a new local site with unique prefixing that I’d like to host on the same db as another live site. I therefore want to export all tables from my local db and re-import them to the production db. When I try to import, I get the error below. Is there an export option or other technique which will assist smooth importation?

    Thanks,
    Matt

    Error
    SQL query:
    
    --
    -- Database: <code>feedback_films</code>
    --
    -- --------------------------------------------------------
    --
    -- Table structure for table <code>wwp_commentmeta</code>
    --
    CREATE TABLE  <code>wwp_commentmeta</code> (
    
     <code>meta_id</code> BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
     <code>comment_id</code> BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT  '0',
     <code>meta_key</code> VARCHAR( 255 ) DEFAULT NULL ,
     <code>meta_value</code> LONGTEXT,
    PRIMARY KEY (  <code>meta_id</code> ) ,
    KEY  <code>comment_id</code> (  <code>comment_id</code> ) ,
    KEY  <code>meta_key</code> (  <code>meta_key</code> )
    ) ENGINE = INNODB DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;
    
    MySQL said: 
    
    #1046 - No database selected
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Import old tables into existing db for multisite’ is closed to new replies.