Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Trouble Restoring Database


theinkjetmarket

Recommended Posts

Posted

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

Archived

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

×
×
  • Create New...