stiksandstones Posted March 14, 2006 Posted March 14, 2006 I installed a contribution called attribute sets-well, its slowly eating away tables, loosing data, etc...anyways, in addition to fixing my sitte files to remove, the original install had a SQL base addition/edit. what would I do to write these OUT of the database to return it to a point before I installed. The SQL file had these lines in it; CREATE TABLE products_attributes_sets ( products_attributes_sets_id int(6) NOT NULL auto_increment, products_attributes_sets_name varchar(50) NOT NULL default '', products_attributes_sets_value text NOT NULL default '', PRIMARY KEY (products_attributes_sets_id) ) TYPE=MyISAM; CREATE TABLE products_attributes_sets_to_products ( products_attributes_sets_to_products int(11) NOT NULL auto_increment, products_attributes_sets_id int(6) NOT NULL default '0', products_id int(6) NOT NULL default '0', PRIMARY KEY (products_attributes_sets_to_products) ) TYPE=MyISAM; ALTER TABLE products_attributes ADD sort_order INT DEFAULT 0;
rabbitseffort Posted March 14, 2006 Posted March 14, 2006 it can not be said enough to back up your database before ever modding it--sorry I can't help but maybe someone can--but always backup! "I must admit that I personally measure success in terms of the contributions an individual makes to her or his fellow human beings." ---Margaret Mead--- "The answer is never the answer. What's really interesting is the mystery. If you seek the mystery instead of the answer, you'll always be seeking. I've never seen anybody really find the answer -- they think they have, so they stop thinking. But the job is to seek mystery, evoke mystery, plant a garden in which strange plants grow and mysteries bloom. The need for mystery is greater than the need for an answer. --Ken Kesey"
stiksandstones Posted March 14, 2006 Author Posted March 14, 2006 it can not be said enough to back up your database before ever modding it--sorry I can't help but maybe someone can--but always backup! Yeah-I have backups on top of backups of my backups, only problem is the database has been modded (with sales) since this contrib was added....but it is my understanding to get these sql tables/statements out is very easy, I just need to instruction/command on getting them out, I just do not know how sql 'stuff' is written. Thanks anyway for the bump-I know replies can be hard to come by around here.
stiksandstones Posted March 15, 2006 Author Posted March 15, 2006 Yeah-I have backups on top of backups of my backups, only problem is the database has been modded (with sales) since this contrib was added....but it is my understanding to get these sql tables/statements out is very easy, I just need to instruction/command on getting them out, I just do not know how sql 'stuff' is written.Thanks anyway for the bump-I know replies can be hard to come by around here. I imagine this is a very simple script or command, or whatever it is called, someone had me pull a table out before and it was easy, can anyone help?
carolinagirl Posted March 15, 2006 Posted March 15, 2006 Do you have phpmyadmin? This would allow you to delete the tables in question. This would be the best way , look for the names of the tables you created and drop'em! "There is no disgrace in not knowing, the only disgrace is not to be willing to learn." ...Benjamin Franklin
stiksandstones Posted March 15, 2006 Author Posted March 15, 2006 Do you have phpmyadmin? This would allow you to delete the tables in question. This would be the best way , look for the names of the tables you created and drop'em! Ya, I can use that-I just thought I had to enter one of those lines in phpmyadmin (DELETE>TABLE>etc...??) I can try just deleting the table itself.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.