digi Posted August 6, 2004 Posted August 6, 2004 I have a oscommerce shop that has about 12,000 products in it, how do I drop all products? and there releated tables in mysql? digi *Outlined in chalk everone looks the same* Currently useing OSC 2.2 MS1 running on Apache/1.3.27 (Unix) (Red-Hat/Linux) mod_jk/1.2.0 mod_perl/1.26 PHP/4.3.3 FrontPage/5.0.2 mod_ssl/2.8.12 OpenSSL/0.9.6b
niknakgroup Posted August 7, 2004 Posted August 7, 2004 If you really want to kill the whole store, go to databse manager and empty every database. Will take about 10 mins (20 for a heavily modded store) and leave you with a blank canvas and an intact store to rebuild. If you want to start from scratch, click drop instead of empty, then reinstall from basic oscommerce download file. hth! :huh: Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) }
digi Posted August 7, 2004 Author Posted August 7, 2004 Hey thanks tony, I was hopeing I didnt have to go through that route... I created a sql script that will do this automatic, I will post in contributions soon. digi *Outlined in chalk everone looks the same* Currently useing OSC 2.2 MS1 running on Apache/1.3.27 (Unix) (Red-Hat/Linux) mod_jk/1.2.0 mod_perl/1.26 PHP/4.3.3 FrontPage/5.0.2 mod_ssl/2.8.12 OpenSSL/0.9.6b
-=neo=- Posted August 7, 2004 Posted August 7, 2004 Hey Digi, I'm too late but there's simple script you can run also... Looks like you already figured it out. It would be a great contrib. -=neo=- The problem with winning the rat race is at the end you're still a rat.
♥yesudo Posted August 9, 2004 Posted August 9, 2004 may help: http://www.oscommerce.com/forums/index.php?showtopic=105973 Your online success is Paramount.
shayrgob Posted August 9, 2004 Posted August 9, 2004 May I ask why your dropping them? I would cry if i had to do something like that, loL!!
Guest Posted August 9, 2004 Posted August 9, 2004 If you really want to kill the whole store, go to databse manager and empty every database. Will take about 10 mins (20 for a heavily modded store) and leave you with a blank canvas and an intact store to rebuild. If you want to start from scratch, click drop instead of empty, then reinstall from basic oscommerce download file. hth! :huh: or one could use phpMyAdmin and it will take 1/2 a second.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.