作者:央央说去_531 | 来源:互联网 | 2023-10-15 04:27
The Problem:
- I whant to periodicaly make a backup of my database, for this purpose i use the command-line "mysql"
- I've also views in my database, because of this I use "--routines"
I've created an export using:
mysql --add-drop-database --add-drop-table --quote-names --routines --hex-blob --databases xyz --host localhost --user xyz --password xyz
- A reimport using the commandline of mysql (linux - 5.0.24a-standard) runs without problems,
- but an import using phpMyAdmin - 2.11.0-dev (svn 10034) results in the following error message (anexed).
If I make an export using phpMyAdmin it will save also my views and import them correctly (without errors), but an import of the backup created with the mysql-command-line doesn't run.
Thanks
Claudio
SQL-Befehl:
-- Dumping routines for database 'xyz'
DELIMITER;
MySQL meldet: Dokumentation
1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'DELIMITER' at line 1
- Original URL: "https://sourceforge.net/p/phpmyadmin/bugs/2372/":https://sourceforge.net/p/phpmyadmin/bugs/2372/
- Original author: claudio_thomas
- Found in version: Latest_Git
该提问来源于开源项目:phpmyadmin/phpmyadmin
- Status: closed-fixed --> fixed