Exporting products to new store

[knifeman]

I did this once last fall and it worked good.

I am trying today with a new store.

 

I am exporting certain columns from my old products table.

So i run sql at the top of phpmyadmin to select only the columns I want.

then I click the select all at the bottom of the sql results, then the export.

But, I only get one page of results exported. The first 30 products on page one. Phpmyadmin is not selecting all 15 pages of products for export.

 

Does anyone have a clue what is going wrong??

 

Tim

[knifeman]

Must be some change in phpmyadmin.

 

For those with the same problem

near the top is a box you can set the number of rows, then click the 'show' button.

Select any number greater than the actual number of rows and wait. All rows will be displayed, then clicking select all, will actually -- select all.

 

Tim