Product descriptions were chopped off during database transfer

[mustang62]

I successfully transfered an oscommerce site from one host to a new one this week.

-Copied the entire oscommerce files to the new host.

-Exported the database from the old host and imported on the new host, after having created a new blank one.

-Changed the two configure files to reflect the new server and database name.

 

Shopping cart is fully functional.

However all the product descriptions over a certain number of characters are cut off.

I checked on the old phpadmin and all the products' full descriptions are there.

I also checked on the new phyadmin and noticed that they have not all been fully copied

 

I would like to import only the 1 table, product_descriptions to the database again.

I've never done this before. What measures should I take that I don't totally mess up?

Is this the way to go or is there another alternative?

 

Any help would be greatly appreciated.

Thanks.

[Guest]

Hello,

 

This should be easy if you have phpadmin on both servers.

 

1. Export the product_descriptions table from the old server to your local computer

 

2. Import the product_descriptions table from local computer to the new server.

 

Best regards

[mustang62]

Hello,

 

This should be easy if you have phpadmin on both servers.

 

1. Export the product_descriptions table from the old server to your local computer

 

2. Import the product_descriptions table from local computer to the new server.

 

Best regards

 

Yes, so I thought. I tried importing only the table again this morning and get the same error.

However, I did a comparison in both Myphpadmins by taking a closer look at the structure of this table.

 

When I did a 'ExplainSQL' on both, the new table came up with an new command in the Extra field (ie Using temporary; Using filesort)

This is not present in the table on the old database.

If I delete this command, will it affect anything? Where do I go to update this field?

 

Also:

The old table has a row length of 1183 and row size of 1225.

The new table has only a row length of 462 and row size of 513.

I looked all over to try to change these two fields and then import once more the data.

Where do I go in the Myphpadmin to change these two fields?

 

Unfortunately my knowledge of mysql is very limited.

I've been googling since last night to find out how to do this and haven't found the answer yet.

 

Thanks.

[mustang62]

Yes, so I thought. I tried importing only the table again this morning and get the same error.

However, I did a comparison in both Myphpadmins by taking a closer look at the structure of this table.

 

When I did a 'ExplainSQL' on both, the new table came up with an new command in the Extra field (ie Using temporary; Using filesort)

This is not present in the table on the old database.

If I delete this command, will it affect anything? Where do I go to update this field?

 

Also:

The old table has a row length of 1183 and row size of 1225.

The new table has only a row length of 462 and row size of 513.

I looked all over to try to change these two fields and then import once more the data.

Where do I go in the Myphpadmin to change these two fields?

 

Unfortunately my knowledge of mysql is very limited.

I've been googling since last night to find out how to do this and haven't found the answer yet.

 

Thanks.

 

 

 

I never did find the answer to this problem so I had to manually enter the missing product descriptions in the oscommerce admin side.

 

How different is the Mysql 4.0.24 version compared to the MySql 5.1.0?

 

I just had to do another website transfer for a client and got the same issue arising again.

 

The product descriptions that were in English were copied ok but the product descritpions in French only 5 or 6 characters get copied and the rest are cut.

 

Are the databases so incompatible that some information gets chopped off?

 

Thanks.

[Jan Zonjee]

The product descriptions that were in English were copied ok but the product descritpions in French only 5 or 6 characters get copied and the rest are cut.

 

Are the databases so incompatible that some information gets chopped off?

No. Perhaps there is an issue with the character set of the two databases? One being utf-8 and the other iso-8859-1?

 

You downloaded the dump of the product_description table. This is plain text so if you open it in a text editor you can see if the text is OK in the backup. If so, the problem is at least not there.