Chargin Posted April 20, 2009 Share Posted April 20, 2009 I want to copy some but not all categories on a CC site which contain about 400 products, over to a new site. Whats the process? Ive used php myadmin plenty of times, am familiar with Sir Williams DB import mod but am unsure whats going to be the most painless way to do this? Quote Link to comment Share on other sites More sharing options...
Guest fandango Posted April 20, 2009 Share Posted April 20, 2009 Hiya, i would do the following: download the entire database as an sql file, upload to the new sites mysql, log in to admin and delete the catagories from the admin area manually. Quote Link to comment Share on other sites More sharing options...
Chargin Posted April 20, 2009 Author Share Posted April 20, 2009 Problem is there are 6000+ products and about 200 categories. Cant delete a cat with products in it would be a problem too? Quote Link to comment Share on other sites More sharing options...
Guest fandango Posted April 21, 2009 Share Posted April 21, 2009 Ahh i see the dilema. In that case what i would do is in the php myadmin mysql, select your database and export the individual tables i.e catagories / inventory / catidx etc etc and save them to your hard drive as excell for windows format, then just edit / delete them as required and upload to the new site's php myadmin mysql. I needed to change the ; to , though in the delimiter field in mysql when i did it to get it working prior to uploading. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.