Control Web Panel

WebPanel => MySQL => Topic started by: pixelpadre on May 12, 2019, 03:49:46 PM

Title: NO_AUTO_VALUE_ON_ZERO error on import
Post by: pixelpadre on May 12, 2019, 03:49:46 PM
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
Title: Re: NO_AUTO_VALUE_ON_ZERO error on import
Post by: 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.
Title: Re: NO_AUTO_VALUE_ON_ZERO error on import
Post by: pixelpadre on May 23, 2019, 11:35:32 AM
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.