Forwarded to devs Database Export Dump of database with procedures

[Johannes Kingma]

Username:

TITLE

Database Export Dump of database with procedures

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

Obsidian, Linux ,64 Maria 10.3.31

PROBLEM DESCRIPTION

Creating a database dump with "Export dump" creates succesfully creates a dump file. Where tables and views preclude a drop command procedures do not .The problem is that stored procedures can than not be created with an error ERROR 1304 (42000) at line 1917: PROCEDURE sp_create_pricelist already exists

STEPS TO REPRODUCE

Export dump
Import dump

ACTUAL RESULT

ERROR 1304 (42000) at line 1917: PROCEDURE sp_create_pricelist already exists

EXPECTED RESULT

import of database

ANY ADDITIONAL INFORMATION

Importing to a MariaDB 10.6.5

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[IgorG]

From the developer:

A test database was created on the Plesk server with MariaDB 10.6 and procedure was added. Export/import dump in Plesk finished successfully. The STR should contain exact steps to reproduce the issue.

Also, Plesk uses native mysqldump utility to dump and import databases. Please verify that it is possible to export/import database dump using mysqldump utility. If it is failing as well, it should be reported to MariaDB bug tracker: https://mariadb.com/kb/en/mariadb-community-bug-reporting/#reporting-a-bug

 

[Johannes Kingma]

ERROR 1304 (42000) at line 64: FUNCTION get_url already exists

when importing the attached file, created by the "Export dump" in plesk a second time to the same local database.
Local db: MariaDB 10.6.5
Command:

c:\wamp\bin\mariadb\mariadb10.6.5\bin\mysql.exe --user=root --password plesk_test < kingmaking_code_2022-04-06_20-57-31.sql

Exported from Plesk Obsidian.

 

[Johannes Kingma]

What did work is export from WIthin PhpMyAdmin within Plesk. Which creates the attaced file:

 

[Johannes Kingma]

I created a database on Plesk Obsidian with one sp (see attached dump)
I imported it once in an empty local database ob Mariadb 10.6.5 with
C:\wamp\bin\mariadb\mariadb10.6.5\bin\mysql.exe" --user=test_sp --password=password test_sp 0<Y:\test_sp_2022-04-20_09-49-49.sql

The database was extended with the sp_year

A second run of the same command resulted in:
ERROR 1304 (42000) at line 37: PROCEDURE sp_year already exists