move 100 products from one cat to another, How?

[Guest]

Just wondering any quick ways to move such a big amount of products from one cat to another? :wink:

[Guest]

If it is the same just extract using phpmyadmin and then move over to the other. Or - backup using one catalog, edit the sql dump file for only the catalog items to remain and then restore to file.

[Guest]

Thanks for the reply, but how can i do it in phpmyadmin as i have never done this before. Thanks.

 

 

Micky

[Guest]

Hi,

 

Do you have access to ssh or your root of your server?

 

If so, you can use this command:

mysql NEWDBNAME < SQLDUMPFILENAME PATH

 

This will move your store files to a completely empty database.

 

Is this what you need or do you just need to move a table?

[Guest]

Hi,

 

I do have access to the phpmyadmin, i just want to move more than 100 products from one category to another category. not emptying the whole table. cheers :wink:

 

 

 

Micky

[Guest]

you can use the move , in the catalog in the product listing, one by one, or try to fpt the catalog, or list, change the name and ftp back

I never tried that , but its an idea. But I have moved stuff from one catagorie t another , thats easy but time consuming

[Guest]

Ok,

 

Click on the name of the db in phpmyadmin.

 

On the right click on "export".

 

Highlight the table you want to keep, data only, save, and open and then save it to your desktop.

 

Go to the other db you want to copy to and "empty that particular table.

 

Then click on "sql" and copy the "data" from the db you saved on your desktop to that box.

 

Then click "go"