Guest Posted August 24, 2006 Posted August 24, 2006 I want t use my product database on the new site, but I don't want earlier registered users to have an access to it. Problem is that I have about 900 customers&orders. Is there way to delete all of them at the same time without going into every single one?
jpweber Posted August 24, 2006 Posted August 24, 2006 I want t use my product database on the new site, but I don't want earlier registered users to have an access to it. Problem is that I have about 900 customers&orders. Is there way to delete all of them at the same time without going into every single one? Sure. Go into your phpmyadmin and run a query and delete all the customers. Do you know the SQL syntax for that, and how to use phpmyadmin? Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...
Guest Posted August 24, 2006 Posted August 24, 2006 Sure. Go into your phpmyadmin and run a query and delete all the customers. Do you know the SQL syntax for that, and how to use phpmyadmin? I know basics of phpmyadmin, I can import/export tables and all that stuff. I thought of deleting it over there, but I'm afraid I don't know where this information is stored and I think can do something wrong.
jpweber Posted August 24, 2006 Posted August 24, 2006 So, what query can I use for this? You're asking the wrong guy; I'm bad at databases. But just post a new thread. Say "How do I run SQL to delete all my customers in phpmyadmin from my cpanel?" and I'm sure you'll get a quick response from someone who knows databases. Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ...
driftwood Posted August 24, 2006 Posted August 24, 2006 I know basics of phpmyadmin, I can import/export tables and all that stuff. I thought of deleting it over there, but I'm afraid I don't know where this information is stored and I think can do something wrong. You don't need code, the is a big button that says "empty" but make sure you copy it first. If you want to get rid of the the lot, you need to do, customers, customers info, addressbook and some others and then the is the past orders. Best way IMO is to export the whole database and open the sql file in a decent text editor. Then look at the "dumping data" and delete the data you don't need. Then just inport the resulting file and you have a clean database. Hope that helps. ----------------------------------------------------------------------------- OSC user for years and no coder, so I've earned my stripes. Feel free to private message me.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.