#1050 - Table 'serendipity_comments' already exists

[saipun]

i try to upload s9y database from hard disk trough phpmyadmin.. but everytime when i try to upload the file.. i got

MySQL said: Documentation
#1050 - Table 'serendipity_***' already exists

when i delete the table.. and try to upload again.. it will stuck in other table with the same error..

i know it said that my table already exist and need to be deleted from database. how to solve that problem? how can i upload my sqldatabase without having any error like #1050 or any..??

thanks...

[garvinhicking]

Hi!

You'll need to first delete all existing tables that are contained in your s9y database dump, only then you can upload it.

Once you start an upload, some tables will be created which is the reason why you can't re-uplaod the dump without first deleting the tables again.

If that is unclear to you, you might want to visit the phpMyAdmin or general MySQL support boards on the web...

Best regards,
GArvin

[scottwalsh]

Hi Saipun,

One way, is to delete the database completely and start again (of course this delets all data).

As Garvin suggested have a look at the mysql website.

The command to delete a whole database in mysql is:
drop database [db_name]

http://dev.mysql.com/doc/refman/5.0/en/ ... abase.html