Database Script

[Huski]

(did request this on previous post but no-one answering)

Shop database has cleared all data for some unknown reason. The tables are all still there - is there a script I can run in myphpadmin that can populate the tables to initial installation state so that I can actually access the admin site again and stop the errors on the front end due to no data in the tables?

I don't want to change any of the PHP files, etc as many mods so hopefully the config files, etc won't need to be changed again. Any help on this please. Anyone - thanks.

[michael_s]

First, use phpmyadmin to take a fill sql backup of your existing db, just in case you have something left there that you want to keep.

Then, look in the osCMax zip file - /install/osCMax.sql

That file has all the default database settings. Either run the entire sql file through phpmyadmin, or edit the file and grab the sql that you want and run it piece by piece through phpmyadmin. See my reply to your other post.

[jpf]

Or use a backup copy of your database....You do backup your database? ---RIGHT!?!?