Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Trouble Restoring Database


Recommended Posts


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:




SQL query:


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



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.



Link to comment
Share on other sites


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

  • Create New...