Host migration

[smatts]

Hello,

We are trying to move our shop to a new host but am having problems with the database. In phpMyAdmin I have exported the database (as .sql file), then at the new location created a database and import the .sql. We get the following error:

 

Quote

Error

Static analysis:

2 errors were found during analysis.

Variable name was expected. (near "<" at position 54)

Unrecognized statement type. (near "div" at position 1)

SQL query:

<div class="error"><h1>Error</h1><p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SET+SQL_QUOTE_SHOW_CREATE+%3D+1&amp;show_query=1&amp;db=v3_presta"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" />&nbsp

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<div class="error"><h1>Error</h1><p><strong>SQL query:</strong>
<a href="db_sql.' at line 1

 

Any advice is greatly appreciated,

Thanks

[JBW]

Seems your SQL file is corrupt. Look inside, seems there is an error message

[smatts]

I've downloaded it new several times, always exactly the same error. The site is live and working fine on the current host.

[joseantgv]

En 8/3/2021 a las 3:15 PM, smatts dijo:

I've downloaded it new several times, always exactly the same error. The site is live and working fine on the current host.

Your SQL file has HTML code:

<div class="error"><h1>Error</h1><p><strong>SQL query:</strong> <a href="db_sql.php?sql_query=SET+SQL_QUOTE_SHOW_CREATE+%3D+1&amp;show_query=1&amp;db=v3_presta"><span class="nowrap"><img src="themes/dot.gif" title="Edit" alt="Edit" class="icon ic_b_edit" />&nbsp

 

[smatts]

Any ideas how that would have got in there? This is just a normal prestashop site with a theme, no custom modules or any thing strange added or done to the site.