Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I am trying to move my wp site and upload my current database to phpmyadmin. When I do that I get the following error:

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:

#1050 - Table 'wp_bp_option_tree' already exists

Can anyone address what this problem is and how I can fix it?

share|improve this question
1  
The message is pretty clear: that table already exists. I'm not sure how anyone could help you apart from the dumb answer of "don't create the same table twice". What process did you follow to move your site? – Mat Dec 18 '12 at 12:27
I agree with Mat. The error is self-explanatory. Given that, I don't think this is really a question for DBAs. It might be more appropriate--and get quicker/better answers--in Stack Overflow, as a general question on migrating blogging software. – mdoyle Dec 18 '12 at 17:08

closed as off topic by jcolebrand♦ Dec 18 '12 at 17:53

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.