adding back database

  • Resolved jaw_23

    (@jaw_23)


    13 years, 3 months ago

    I am in the process of moving a site to a new domain. I backed everything up and have installed wp and the theme into the new site. I just don’t know where to put the database so that wp sees it.

    Are there any simple solutions to this? like ‘just upload it to the main directory and change the wp-config file’? or am I totally off on this?

    Many thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jaw_23

    (@jaw_23)

    13 years, 3 months ago

    Ok I did some more digging and per WordPress.org I tried uploading my database to phpMyadmin but now I get an error message:

    SQL query:

    CREATE TABLE wp_bp_option_tree (
    id mediumint( 9 ) NOT NULL AUTO_INCREMENT ,
    item_id varchar( 50 ) NOT NULL ,
    item_title varchar( 100 ) NOT NULL ,
    item_desc longtext,
    item_type varchar( 30 ) NOT NULL ,
    item_options varchar( 250 ) default NULL ,
    item_sort mediumint( 9 ) NOT NULL default ‘0’,
    PRIMARY KEY ( id ) ,
    UNIQUE KEY item_id ( item_id )
    ) ENGINE = MYISAM AUTO_INCREMENT =115 DEFAULT CHARSET = utf8;

    MySQL said: Documentation
    #1050 – Table ‘wp_bp_option_tree’ already exists

    Anyone know how to correct this?
    Any and all help would be appreciated as my site is now gone.
    Thank you!

    Thread Starter jaw_23

    (@jaw_23)

    13 years, 3 months ago

    Well, I finally figured it out.

    I had to delete all the files from the old database in phyMyadmin before I uploaded the new database (including the wp_bp_option_tree). phpMyadmin will not replace files.

    Job done. Hope that helps anyone else out there who is stuck!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘adding back database’ is closed to new replies.