problem to migrate from 2.5 to 3.7.3

[yades]

Hi

T read this https://www.phoca.cz/development/50-joo ... o-joomla-3
and I have an error message at step importing data.

#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 'phpMyAdmin SQL Dump

Thx for your help

Yades

[Jan]

Hi, do you get some exact error message which includes the problematic SQL query code?

Jan

[yades]

Hi jan

This is the fully error message

Requête SQL :

phpMyAdmin SQL Dump
-- version 4.4.15.7
-- http://www.phpmyadmin.net
--
-- Client : mysql55-151.perso
-- Généré le : Jeu 13 Juillet 2017 à 18:46
-- Version du serveur : 5.5.55-0+deb7u1-log
-- Version de PHP : 5.6.30-0+deb8u1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

MySQL a répondu: Documentation
#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 'phpMyAdmin SQL Dump
-- version 4.4.15.7
-- http://www.phpmyadmin.net
--
-- Clien' at line 1

[yades]

Hello

I posted fully error message getting from phpmyadmin. I'm not expert in this area. Is that message may help you to solve my problem?
Otherwise how to get exact error message which includes the problematic SQL query code

Yades

[yades]

Hi folks

I solved this problem. Actually it was encoding issue and not phoca issue. I found with error message with google a forum which talks about this issue. i guess when I opened backup sql file with notepad to change prefix table, I had to modify encoding. So to fix the problem with notepad you "save as" with ANSI encoding and next when you import in new database, you select compatibility mpde ANSI. And it's perfect

Yades

[Jan]

Ok