Hi,
> NOT NULL DEFAULT '0'COMMENT
The errors occur because the exported data is incorrect. The problem is there is no space between the '0' and COMMENT and the rest of the table is not exported.
This is not a Wampserver problem, but an export and SQL file creation problem.
I think the server on which you exported SQL is running under Fedora and, it's a Fedora problem only.
See the bug report :
Invalid sql with export import The problem is that Fedora packages do not use sqlparser shipped with phpMyAdmin, but some older version, which does have this bug (and many others).
The problem is that the package uses obsolete package:
Requires: php-composer(udan11/sql-parser) >= 3.4.0
------------------------------------------------------------------------------------------------------------
Wampserver 3.2.9 32 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.9 64 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38/8.0.29 - MariaDB 10.5.15/10.7.3
PhPMyadmin 5.1.3 - MysqlDumper 1.24.5 on W10 and W7 Pro 64 bit
Documentation Apache -
Documentation PHP -
Documentation MySQL -
Wampserver install files & addons« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »