Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Lost database


Guest

Recommended Posts

I removed an old oscommerce store from cpanel, not realising it would take the database with it, which I am using for my 2.3.1 store!

Fortunately I have a backed up db from yesterday in cpanel, but when I go to restore it it won't allow me coz the new db I created has a diff id. So how can I change the id in either my newly created db or the one that is backed up in cpanel?

 

Need help fast, coz the only sql I could find to import is months old and so many orders, customers, and addons are missing.

 

John

Link to comment
Share on other sites

The database for 2.3.1 has some additional tables. I am sure that there was a post somewhere that explained what tables need to be added. Failing that i am sure that there is an upgrade guide supplied with the 2.3.1 download from this site which will tell you how to modify your 2.2 database.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

Restore the db and then change the details in your 2 configuration files.

 

These file are in

 

/includes/configure.php

 

and

 

/admin/includes/configure.php

 

HTH

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Restore the db and then change the details in your 2 configuration files.

 

These file are in

 

/includes/configure.php

 

and

 

/admin/includes/configure.php

 

HTH

 

G

 

 

I tried that Geoff. but when I go to restore the database it says that it is looking for a database with the old id number. There doesn't seem to be any mention of id number in the config files, just database name and password. Any other thoughts? I think I will check with my servers host to see if they can change the new database id number. I'd appreciate any other thoughts on the matter tho, cheers.

 

John

Link to comment
Share on other sites

If it doesn't exist, create a db with the old db name using phpmyadmin.

 

Copy your backup file.

 

Edit the backupfile so it does not refer to the old db and import to your new db.

 

Find the user name and set a password for it.

 

Then update your config files so the application uses your new db.

 

Cheers

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

If it doesn't exist, create a db with the old db name using phpmyadmin.

 

Copy your backup file.

 

Edit the backupfile so it does not refer to the old db and import to your new db.

 

Find the user name and set a password for it.

 

Then update your config files so the application uses your new db.

 

Cheers

 

G

Thanks for the help Geoff. I don't know how to copy the backup to the computer or edit it. Is that something I do in phpadmin?

 

John

Link to comment
Share on other sites

That is just so you have a copy of your backup.

 

Moving files around can be done using ftp depending where the files are, on the site or windows explorer if it is on your pc.

 

Off shopping now.

 

Cheers

 

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...