[solved] Moving Prestashop from hosting server ti local server (WAMP)

[stefa38]

Is a few days I'm trying to move the site from remote to local WAMP server with Prestashop 1.4.8.2.

 

The first thing is obviously to load the data from the database of the site remotely on the site locally (WAMP)

 

But PHPMyAdmin give me always the following error:

 

Errore

 

Query SQL:

INSERT INTO `ps_cms_lang` VALUES ('2','1','Legal Notice','Legal notice','notice, legal, credits','<h2>Legal</h2>\r\n<h3>Credits</h3>\r\n<p>Concept and production:</p>\r\n<p>This Web site was created using <a href=\"http://www.prestashop.com\">PrestaShop</a>™ open-source software.</p>','legal-notice'), ('2','2','Mentions légales','Mentions légales','mentions, légales, crédits','<h2>Mentions légales</h2>\r\n<h3>Crédits</h3>\r\n<p>Concept et production :</p>\r\n<p>Ce site internet a été réalisé en utilisant la solution open-source <a href=\"http://www.prestashop.com\">PrestaShop</a>™ .</p>','mentions-legales'), ('2','3','Aviso legal','Aviso legal','términos, condiciones y créditos fotográficos','<h2><span id=\"result_box\"><span style=\"background-color: #ffffff;\" title=\"Mentions légales\">Pie de imprenta</span></span></h2>\r\n<h2><span id=\"result_box\"><span style=\"background-color: #ffffff;\" title=\"Crédits\">Créditos</span></span></h2>\r\n<h3> </h3>\r\n<p><s[...]

 

I tried to reinstall on another machine, but nothing changes.

 

Upload only 32 tables, I do not think regular.

 

Any idea?

 

Thanks in advance

[stefa38]

Anyone?

[vekia]

can you explain how you want to do it? step by step

[stefa38]

Thanks Vekia, resolved.

 

The Database SQL was corrupted, so i upload a back up

[vekia]

i marked this topic as solved

[stefa38]

Vekia here a more detailed explanation. Thanks for attention.

 

That happens to me, duplicating the test site in local WAMP (or xamp) the import of data from the SQL database phpMyAdmin I found errors in some tables.

 

I got away with restoring the backup *. Bz2.

 

But me and already happened twice and I do not understand the cause.

 

This forces me, every time I do the backup of the SQL database by Prestashop, to test its integrity with phpMyAdmin in WAMP.

 

A beautiful ..... brought her to you this problem and ever?

 

I can try to use the backup of the database because my hosting provider OVH does not support saving native format Inno_db.

 

I state that it is not a matter of size, zip SQL database that do feed it to phpMyAdmin and 'under 2 Mega.

 

(WAMP does not read the *. Bz2 file and then explode the ricomprimo in *. Zip)

 

The same problem appeared with xamp, identically, which reads natively *. Bz2, from which I conclude that it is not a problem of the server configuration locally.

 

 

I would like to know WHAT corrupted at some point some database tables.

 

By the way, if you are subject myself, it will be subject to others that you say?

 

Thanks in advance (traduced by google translate... )