mysql – 导入db phpMyAdmin – 错误格式参数不正确
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql – 导入db phpMyAdmin – 错误格式参数不正确,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含6817字,纯文字阅读大概需要10分钟。
内容图文
我试图将生产mysql数据库导入到本地xampp测试环境中.通过连接到web admin(mozff)和简单的导出sql(从不需要任何其他东西).然后转到本地phpmyadmin仪表板并导入.它抛出以下错误
错误:
生活环境:
DB-服务器
Server: db01.l2.url.com via TCP/IP
Server-Typ: MariaDB
Server-Version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1
Protokoll-Version: 10
User: user
Server-encoding: UTF-8 Unicode (utf8)
网络服务器
Apache
Datenbank-Client Version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
PHP-Erweiterung: mysqliDokumentation curlDokumentation mbstringDokumentation
PHP-Version: 7.0.27-0+deb9u1
phpMyAdmin的
Version informationen: 4.6.6deb4
测试环境
DB-服务器
Server: 127.0.0.1 via TCP/IP
Server-Typ: MariaDB
Server-connection: SSL not used
Server-Version: 10.1.33-MariaDB - mariadb.org binary distribution
Protokoll-Version: 10
user: root@localhost
Server-encoding: UTF-8 Unicode (utf8)
网络服务器
Apache/2.4.33 (Win32) OpenSSL/1.1.0h PHP/7.2.6
Datenbank-Client Version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 38fea24f2847fa7519001be390c98ae0acafe387 $
PHP-extension: mysqliDokumentation curlDokumentation mbstringDokumentation
PHP-Version: 7.2.6
phpMyAdmin的
Version informationen: 4.8.1, aktuelle stabile Version: 4.8.2
题:
>我在哪里可以看到哪个参数不正确?
>我假设mysql 4.8.1 db向后兼容4.6.6deb4
??
我试过的:
phpMyAdmin – Error > Incorrect format parameter?
xampp phpmyadmin, Incorrect format parameter
日志:
180709 11:52:25 246 Connect pma@localhost as anonymous on
247 Connect root@localhost as anonymous on
247 Query SELECT @@version, @@version_comment
247 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
247 Query SET lc_messages = 'de_DE'
246 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
246 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
247 Query SET collation_connection = 'utf8mb4_unicode_ci'
247 Init DB mysql
247 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
180709 11:52:26 247 Quit
246 Quit
180709 11:52:33 248 Connect pma@localhost as anonymous on
249 Connect root@localhost as anonymous on
249 Query SELECT @@version, @@version_comment
249 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
249 Query SET lc_messages = 'de_DE'
248 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
249 Query SET collation_connection = 'utf8mb4_unicode_ci'
249 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC
248 Query SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' GROUP BY `db_name`
249 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
249 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
248 Query SELECT * FROM `phpmyadmin`.`pma__bookmark` WHERE ( `user` = '' OR `user` = 'root' ) ORDER BY label ASC
249 Quit
248 Quit
180709 11:52:51 250 Connect pma@localhost as anonymous on
251 Connect root@localhost as anonymous on
251 Query SELECT @@version, @@version_comment
251 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
251 Query SET lc_messages = 'de_DE'
250 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
251 Query SET collation_connection = 'utf8mb4_unicode_ci'
180709 11:52:52 251 Quit
250 Quit
180709 11:52:53 252 Connect pma@localhost as anonymous on
253 Connect root@localhost as anonymous on
253 Query SELECT @@version, @@version_comment
253 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
253 Query SET lc_messages = 'de_DE'
252 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
253 Query SET collation_connection = 'utf8mb4_unicode_ci'
253 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`, (SELECT DB_first_level FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t ORDER BY DB_first_level ASC LIMIT 0, 100) t2 WHERE TRUE AND 1 = LOCATE(CONCAT(DB_first_level, '_'), CONCAT(SCHEMA_NAME, '_')) ORDER BY SCHEMA_NAME ASC
252 Query SELECT `db_name`, COUNT(*) AS `count` FROM `phpmyadmin`.`pma__navigationhiding` WHERE `username`='root' GROUP BY `db_name`
253 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
253 Query SELECT COUNT(*) FROM ( SELECT DISTINCT SUBSTRING_INDEX(SCHEMA_NAME, '_', 1) DB_first_level FROM INFORMATION_SCHEMA.SCHEMATA WHERE TRUE ) t
180709 11:52:54 253 Quit
252 Quit
254 Connect pma@localhost as anonymous on
255 Connect root@localhost as anonymous on
255 Query SELECT @@version, @@version_comment
255 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
255 Query SET lc_messages = 'de_DE'
254 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
255 Query SET collation_connection = 'utf8mb4_unicode_ci'
254 Quit
256 Connect pma@localhost as anonymous on
257 Connect root@localhost as anonymous on
257 Query SELECT @@version, @@version_comment
257 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
257 Query SET lc_messages = 'de_DE'
256 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
257 Query SET collation_connection = 'utf8mb4_unicode_ci'
256 Query SELECT `config_data`, UNIX_TIMESTAMP(`timevalue`) ts FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
256 Query SELECT `username` FROM `phpmyadmin`.`pma__userconfig` WHERE `username` = 'root'
256 Query UPDATE `phpmyadmin`.`pma__userconfig` SET `timevalue` = NOW(), `config_data` = '{\"lang\":\"de\",\"Console\\/Mode\":\"collapse\"}' WHERE `username` = 'root'
180709 11:52:58 257退出
256退出
解决方法:
我遇到了同样的问题,尝试了很多东西,特别是增加了php.ini的时间限制,但没有真正起作用.最后,我完成了我的命令,我通过命令行导入sql文件:
mysql -u username -p databasename< /path/to/file.sql 在大多数情况下,用户名只是root.如果旧数据库和新数据库备份文件中都有相同的表,则可能会出现如下错误: 第31行的ERROR 1050(42S01):表’wp_commentmeta’已存在 在这种情况下,删除(删除)现有数据库,然后通过上述命令导入新文件.
内容总结
以上是互联网集市为您收集整理的mysql – 导入db phpMyAdmin – 错误格式参数不正确全部内容,希望文章能够帮你解决mysql – 导入db phpMyAdmin – 错误格式参数不正确所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。