I am sorry if this is the wrong forum for my question, but I am getting a bit desperate (as usual):

I need to restore my Xoops-site SQL-database. I made a backup the 1st of June with phpMyadmin. Now I tried to restore this sql-file by uploading it with "Run SQL-query", but all I get is an error message:

Error

SQL-query :

CREATE TABLE `xoops_articles_cat` (

`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`cat_parent_id` int( 10 ) NOT NULL default '0',
`cat_name` varchar( 50 ) NOT NULL default '0',
`cat_description` text,
`cat_weight` int( 10 ) NOT NULL default '0',
`cat_showme` int( 5 ) NOT NULL default '0',
PRIMARY KEY ( `id` )
) TYPE = MYISAM AUTO_INCREMENT =7

MySQL said:


#1050 - Table 'xoops_articles_cat' already exists

Can anyone plz help me out? I don't know much about database handling.

Since you don't seem to have the lines DROP IF EXISTS (wish is not needed btw), you first have to drop all tables before re-inserting.

Or delete all existing tables before importing your sql file.

Next time when you export your DB, make sure click the add drop tables option.

Thanks a lot both of you - it works fine now!