NO_AUTO_VALUE_ON_ZERO error on import

Started by pixelpadre, May 12, 2019, 03:49:46 PM

Previous topic - Next topic

pixelpadre

Im importing database from old cwp to new cwp.  I get an error but import appears to be successful. Can I ignore the error?

Mysql error:
phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'phpMyAdmin SQL Dump

Igor S.

Hi, try to check the SQL dump or re-create it.
Or try to import the database via SSH console.



You can ask me to solve any problem with your server for some money in pm  ;)






Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions

Get Fast Support Here
http://centos-webpanel.com/support-services

pixelpadre

Quote from: Igor S. on May 22, 2019, 05:58:23 PM
Hi, try to check the SQL dump or re-create it.
Or try to import the database via SSH console.

Yes, as I posted in a different thread, I had to use shell to export.  phpmyadmin export gives a bad unuseable sql file.