GregH Posted March 9, 2006 Posted March 9, 2006 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
Jack_mcs Posted March 9, 2006 Posted March 9, 2006 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
GregH Posted March 9, 2006 Author Posted March 9, 2006 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...
♥Vger Posted March 9, 2006 Posted March 9, 2006 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
GregH Posted March 10, 2006 Author Posted March 10, 2006 Hey thanks Vger, just to let you know that worked perfectly and I really appreciate the help!
Recommended Posts
Archived
This topic is now archived and is closed to further replies.