Import old tables into existing db for multisite
-
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,
MattError 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.