热门标签 | HotTags
当前位置:  开发笔记 > 编程语言 > 正文

从mysql生成的数据库转储文件进行导入

TheProblem:-Iwhanttoperiodicalymakeabackupofmydatabase,forthispurpose

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

  • Original author: nijel


推荐阅读
author-avatar
央央说去_531
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有