Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Trouble Restoring Database


theinkjetmarket

Recommended Posts

Hi

Hope someone can help.

I am trying to restore my database. I have created a fresh database. I had created a database backup using cPanel. I have tried opening the backup sql file with a text editor and copied and pasted the contents into phpMyadmin SQL box. I ave aso tried doing a straight import.

I get the following error:

 

Error

 

SQL query:

 

INSERT INTO `products_description` VALUES (195,1,'Hahnemuhle White Etching 268gsm A3 Fine Art Photo Paper','

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n

Description

Hahnemuhle 268gsm White Etching is a white, 25% rag, \r\nage resistant fine art photo paper which is printable on one side and has a \r\nsoft, homogenous surface structure. “White Etching 268†deliberately takes its \r\nname from the oldest and most successful paper on the inkjet market – “German \r\nEtchingâ€. This paper is also an etching board that has been refined for inkjet \r\nprinting. “White Etching†is slightly whiter and has a soft, very homogenous \r\nsurface structure due to the 25% rag content.

Product Uses

Designed for fine art reproductions, portfolios, photo \r\nalbums[...]

 

MySQL said: Documentation

#1406 - Data too long for column 'products_description' at row 1

 

My site worked okay with the original database before backing up.

 

Hope someone can help.

Regards

Garry

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...