jbmtk Posted June 15, 2007 Posted June 15, 2007 I recently added RMA Service contribution, but the sql database did not execute all the way, because there was an error with one of the querys. Anyways, I did make a backup of the CATALOG only, so i restored that and now I want to restore my database. I did not backup my sql database before hand. Is there anyway I can "drop" the querys individually or automatically? the exact file is: rma_system_db_structure.sql
Bloged Posted June 15, 2007 Posted June 15, 2007 I recently added RMA Service contribution, but the sql database did not execute all the way, because there was an error with one of the querys. Anyways, I did make a backup of the CATALOG only, so i restored that and now I want to restore my database. I did not backup my sql database before hand. Is there anyway I can "drop" the querys individually or automatically? the exact file is: rma_system_db_structure.sql It can be done... MySQL has the possibility to drop tables. The most simple option is to get all the table names from rma_system_db_structure.sql and use them like this in phpMyAdmin. DROP TABLE table_nm1, table_nm2 Grtz, Arjan Gelderblom I think computer viruses should count as life. I think it says something about human nature that the only form of life we have created so far is purely destructive. We've created life in our own image. -- Stephen Hawking
jbmtk Posted June 17, 2007 Author Posted June 17, 2007 I'm not sure if u lookded at that file, but I tried dropping all the tables, but in a lot of the tables, rma_system_db_structure.sql simply inserted extra strings into all ready existing tables. How would I go about deleting those? UPdate---Nevermind my questin, I simpy copy-pasted missing code into the sql database. I should've though bout this first. Problem was, I installed this contirubion earlier, but it failed, and I could never execute the sql query back in because it would always come up, "column xxxx all ready exists" because it dosn't overwrite.
Bloged Posted June 18, 2007 Posted June 18, 2007 I'm not sure if u lookded at that file, but I tried dropping all the tables, but in a lot of the tables, rma_system_db_structure.sql simply inserted extra strings into all ready existing tables. How would I go about deleting those? UPdate---Nevermind my questin, I simpy copy-pasted missing code into the sql database. I should've though bout this first. Problem was, I installed this contirubion earlier, but it failed, and I could never execute the sql query back in because it would always come up, "column xxxx all ready exists" because it dosn't overwrite. Ok no problem! Super that it worked out ok! Grtz, Arjan Gelderblom I think computer viruses should count as life. I think it says something about human nature that the only form of life we have created so far is purely destructive. We've created life in our own image. -- Stephen Hawking
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.