curiousminds Posted September 13, 2010 Share Posted September 13, 2010 Hi, I would like to back up all my customer details and their orders (50+ pages), delete them all and then later restore them. Is there an easy way to do this? One of the reasons is that I am considering giving someone temporary access to my site but want to protect the privacy of my customers and their details. Thanks, Greg Link to comment Share on other sites More sharing options...
FIMBLE Posted September 13, 2010 Share Posted September 13, 2010 If you make a back up (admin / tools / backup) then download it to your desktop, you now have a complete Database back up Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
curiousminds Posted September 13, 2010 Author Share Posted September 13, 2010 If you make a back up (admin / tools / backup) then download it to your desktop, you now have a complete Database back up Nic Thanks Nic, I have done that. Greg Link to comment Share on other sites More sharing options...
FIMBLE Posted September 13, 2010 Share Posted September 13, 2010 No Worries Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
curiousminds Posted September 13, 2010 Author Share Posted September 13, 2010 If you make a back up (admin / tools / backup) then download it to your desktop, you now have a complete Database back up Nic Thanks Nic, Is there an easy way to delete all my orders in one hit? Greg Link to comment Share on other sites More sharing options...
FIMBLE Posted September 13, 2010 Share Posted September 13, 2010 use phpmyadmin to clear those tables from your databse Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
curiousminds Posted September 13, 2010 Author Share Posted September 13, 2010 use phpmyadmin to clear those tables from your databse Nic Thanks, I'll google it - I'm guessing that it is a software download. Greg Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted September 13, 2010 Share Posted September 13, 2010 phpmyadmin is a software, but not normally something you would need to download/install. your webhost should offer it in your hosting panel, it's normally to be found in the database section. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
curiousminds Posted September 13, 2010 Author Share Posted September 13, 2010 phpmyadmin is a software, but not normally something you would need to download/install. your webhost should offer it in your hosting panel, it's normally to be found in the database section. Thanks Monika, I will see i I can do it that way :) Greg Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.