Table Errror - help

[bartainer]

Hello,

Ok, I am NOT a Data base expert; however I do have an understanding of PHP and MYsql. I'm trying to add my "member_table" to a new data base and the error is "table already exist". I know it exist, but I want to bring my members (200) over from one data base to another. The dump (Mysql setup) is the same (Wordpress), but the site's are different.

How do I take one table from another web site and transfer to a second web site without errors. I do not want the full data base - just the member's table.

I know how to import and I did try, but I'm getting the error.

Thanks.

[wheelie34]

Hi

When you export tell it to only export the data (not structure AND data) looks like when your trying to import it the create table command is still there.

HTH

[bartainer]

I tried that; however this is what I get: #1062 - Duplicate entry '1' for key 1.

[wheelie34]

Is that an auto increment column? maybe try dropping the table from the new DB then use the original dump file to create the table AND add the data

[bartainer]

Perfect! It worked and I thank you.

I had to import user_meta (passwords etc) and users too. I tried importing "users" only and tried logging in and it did not recognize me until I imported "user_meta" too. Now I went from zero members to 188 in a flash. LOL.

Thanks

[wheelie34]

great, glad it worked