Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

I've killed my database


steve***

Recommended Posts

Don't ask me why, but i've managed to destroy my database, and was stoopid enough not to keep an upto date back up of it. I dropped the contents of some tables and now the site won't work.

 

Basically what I want is a way of getting all the new account info from the old one and move it into the new store

Link to comment
Share on other sites

Do you mean 'customer' information?

 

And if your database is 'killed', are you sure the customer information still exists?

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

I'm not sure it exists, but i think it still does.

 

All I hav done is drop info from one of the tables. Other than that the data is still in there. All I need to do is to get the names, addresses, e-mail addresses from the old site to insert it into the new site.

Link to comment
Share on other sites

Well, first you should use 'phpmyadmin' to dump the data from the customers table, and then use the same tool connected to your new database to 'import' the dump.

 

If you are using a webhost, and are on cpanel, it should come with phpmyadmin installed already. IF not, that's another *must have* piece of saftware you'll need to administer your oscommerce cart.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Excellent, thanks for the help.

 

I've also dumped and then re inserted the customers_info tables

 

The only problem I have now is when I try to edit (so I can see the address details) i get this error

 

Warning: reset(): Passed variable is not an array or object in /home/steve/public_html/jigsawshop/admin/includes/classes/object_info.php on line 17

 

Warning: Variable passed to each() is not an array or object in /home/steve/public_html/jigsawshop/admin/includes/classes/object_info.php on line 18

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...