Binkmaster1973 Posted May 20, 2015 Share Posted May 20, 2015 I have/had a clean install of OSC where I have made numerous customization changes to the look and feel. I was making an attempt to sync the database to my business accounting software and made some mistakes my primary mistake was not backing up. Since I am populating the OSC database with data from elsewhere, it is no pain to delete the database and re-install it. What is the easiest way to reinstall OSC without re-installing the files themselves (just the database structure)? Link to comment Share on other sites More sharing options...
clustersolutions Posted May 20, 2015 Share Posted May 20, 2015 From Stackoverflow... mysqldump -u username -p --no-data dbname > schema.sql then mysql -u username -p dbname < schema.sql to import...you may have to create the db first... Link to comment Share on other sites More sharing options...
♥14steve14 Posted May 21, 2015 Share Posted May 21, 2015 Download the version of oscommerce that you are using from the oscommerce website. Open the files and if you look in the catalog/instal file you will finda file called oscommerce.sql, which is the sql file that creates the original database. Then using mysql or similar from your hosting panel you should be able to create a fresh new database back to original. If you have made any modifications to the database you will have to go through each addons files and add the sql needed. You could also contact your hosts and see if they keep any daily backups of the database which they could reinstall. REMEMBER BACKUP, BACKUP AND BACKUP Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.