Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Anyone good with SQL???


GregH

Recommended Posts

Posted

Hi all,

 

I hope someone can help with this. I am no good with SQL databases and I accidentally droppped a table from my database. Luckily I have 2 identical shops and my other database is fine.

 

The table I dropped was:

 

categories_descriptions

 

Is it possible to copy the table with all fields from one sql database to another?

 

All help very welcome!

 

Thanks

Posted

You can copy one table but, in this case, that will corrupt your database since that table is linked to the categories and products_to_categories tables, which in turn links to all of the products tables. If the two databases are identical then you should be OK just copying the one table but I wouldn't do it if you are not sure. The better way would be to download your products from the good database using Easy Populate, delete all products/categories in the bad database (this will probably have to be done via phpmyadmin since the one tabel is missing), add the missnig table and upload the products using Easy Populate.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

All of My Addons

Get the latest versions of my addons

Recommended SEO Addons

Posted

Hi JACK

 

I haven't got any products yet as I am just setting up the categories structure. Does this mean I can copy the 1 table over without any problems? Is there any chance you can give me instructions on how to do it because I am not sure!?

Thanks...

Posted

If this is a new install then why not just go to your database via phpMydmin, tick all of the tables and elect to 'drop' them all. Then click on the SQL tab and use the Browse box to locate the original installl/oscommerce.sql file on your computer, then click 'Go'. This will restore your site with the default database.

 

Vger

Posted

Hey thanks Vger, just to let you know that worked perfectly and I really appreciate the help!

Archived

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

×
×
  • Create New...