Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export/Import database problem #19142

Open
dev-hit opened this issue May 2, 2024 · 0 comments
Open

Export/Import database problem #19142

dev-hit opened this issue May 2, 2024 · 0 comments

Comments

@dev-hit
Copy link

dev-hit commented May 2, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant