phpmyadmin
Exported Triggers not usable for import again
Describe the bug
When I try to export all my triggers for any database schema, no delimiter is added to the output. Because of this it's impossible to import those triggers again.
Why do I need this? Because I needed to change the creator (user) of that triggers. The initial one was removed and no updates have been possible on that database.
To Reproduce
Steps to reproduce the behavior:
- Go to a database with many triggers
- Click on menu item 'Trigger'
- Select all trigger on very end of the page
- Klick export on the very end of page
Expected behavior
A sql file is downloaded OR the modal which opens has delimiters in generated sql code.
Screenshots
none.
Server configuration
phpMyAdmin: Versionsinformationen: 5.1.1 Operating system: Linux Ubuntu Server: Localhost via UNIX socket Server-Typ: MariaDB Server-Verbindung: SSL wird nicht verwendet Dokumentation Server-Version: 10.2.39-MariaDB-1:10.2.39+maria~bionic-log - mariadb.org binary distribution Protokoll-Version: 10 Benutzer: admin@localhost Server-Zeichensatz: UTF-8 Unicode (utf8mb4) nginx/1.20.1 Datenbank-Client Version: libmysql - mysqlnd 7.4.26 PHP-Erweiterung: mysqli Dokumentation curl Dokumentation mbstring Dokumentation PHP-Version: 7.4.26
Client configuration
- Browser: Chrome
- Operating system: Windows 10
Additional context
none.
Hi @Up2Boat
Could you please try the latest 5.1 version in development (phpMyAdmin 5.1+snapshot) and let me know if it works better ?
Ran into this just now, still happens in 5.2.3
It is missing DELIMITER $$ at the start and $$ after each exported trigger.
