SQL Database Regenerate

[Maxtar]

Hi...

I'm wondering if someone could give me some advice...

I'm using xCart to build a shopping cart site. I just went into the sql database (via myphp) and accidently deleted the "categories" table. After further "playing around" I deleted the entire database.

I can reload the data... but there's no place to load it.

Since I'm not "SQL-smart"... is there an easy way for my xCart to regenerate the database/tables so I can reinput my data?

(I also have access to cPanel)

thanks for any help on this...

Kindest Regards
snipped

[edited by: DaveAtIFG at 1:21 pm (utc) on Sep. 14, 2004]
[edit reason] No specifics please [/edit]

[cyberws]

It is possible you might be able to view the setup script code and thus see the db structure. Otherwise you will need to run a full install of the program into another directory. This will create the DB structure. Then simply remove the new directory files and point your current install to the DB structure.

[tonyphipps]

Can I also recommend Backup Watcher for MySQL (http://www.dswsoft.com/mbw_features.php) for the future - nothing to do with me - but I use it every day :-)