You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
As also indicated in issue #18035 by another user we are experiencing a very similar problem.
When we proceed with the export of a database (all its tables, views, procedures) we get errors when restoring the database.
Often fields are duplicated when we have GROUP BYs (e.g. SELECT ... FROM ... GROUP BY idRispidRisp) or DESC values are mistakenly inserted by the system to our ORDER BYs (e.g. SELECT ... FROM ... ORDER BY idRisp ASCDESC) which then lead us to an error when importing queries into a new database.
We are also experiencing errors when exporting/importing some views. Conversions are in fact added by the system automatically, but they are not present in the views we wrote ( ... CONVERT(name USING utf8mb4) ...) and which cause us an error when importing the query into a new database.
Additional information:
We perform the export in SQL format.
Browser: Google Chrome v. 123.0.6312.124
Server Version: 8.0.36-0ubuntu0.20.04.1 - (Ubuntu)
Protocol VErsion: 10
Server Character Code: UTF-8 Unicode (utf8mb4)
As also indicated in issue #18035 by another user we are experiencing a very similar problem.
When we proceed with the export of a database (all its tables, views, procedures) we get errors when restoring the database.
Often fields are duplicated when we have GROUP BYs (e.g. SELECT ... FROM ... GROUP BY idRispidRisp) or DESC values are mistakenly inserted by the system to our ORDER BYs (e.g. SELECT ... FROM ... ORDER BY idRisp ASCDESC) which then lead us to an error when importing queries into a new database.
We are also experiencing errors when exporting/importing some views. Conversions are in fact added by the system automatically, but they are not present in the views we wrote ( ... CONVERT(name USING utf8mb4) ...) and which cause us an error when importing the query into a new database.
Additional information:
We perform the export in SQL format.
Browser: Google Chrome v. 123.0.6312.124
Server Version: 8.0.36-0ubuntu0.20.04.1 - (Ubuntu)
Protocol VErsion: 10
Server Character Code: UTF-8 Unicode (utf8mb4)
Web server
Apache/2.4.41 (Ubuntu)
Database client version: libmysql - mysqlnd 7.4.3-4ubuntu2.20
PHP extension: mysqli, curl, mbstring
PHP version: 7.4.3-4ubuntu2.20
phpMyAdmin version: 5.2.1
The text was updated successfully, but these errors were encountered: