It sounds like you may have an sql compatibility issue.
When importing the sql file, experiment with the SQL compatibility mode
under the heading Format of imported file
There is also a Partial import
section that may be selected by default and de-selecting it can be tried or the alternate if it is not selected.
Number of records(queries) to skip from start
is used if you have a partial import and to skip those already imported.
Also worth looking at and again possibly experimenting with the settings, is the mySQL configuration file in xampp\mysql\bin\my.cnf
file or it may be just called my
and look like a shortcut, but I mainly suspect a compatibility issue.
Make a backup first of configuration files before editing and restart the servers after editing for the edits to be recognized.
1. The new DeskTopXampp
launch control for XAMPP / XAMPPlite
Posted by Ridgewood
available from Ridgewood'sDTX web site
2. Make Richer Ajax Applications - Faster
TIBCO General Interface Pro Edition
and Open Source
Fully working with NO
donations required to get a user/password