Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to deal with the error when mysql is poured into the database?

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

The following mainly brings you how to deal with the error caused by mysql pouring into the database. I hope these contents can bring you practical use. This is also the main purpose of how to deal with this article after I edit mysql pour into the database. All right, don't talk too much nonsense, let's just read the following.

I backed up a rds library on Aliyun, and then I wanted to pour it into a database I built myself and execute mysql-uroot hu.

< ihnhlife_datafull_201612011334_1612011334.sql 一直报错,提示下面信息 @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON. 解决办法: 后来发现有一个参数-f,可以忽略错误,继续执行 mysql -f -uroot hu < ihnhlife_datafull_201612011334_1612011334.sql 然后登陆mysql查看hu这个数据库,果然可以了! 第二种解决方法: 登录mysql 然后选择一个数据库 mysql>

Source ihnhlife_datafull_201612011334_1612011334.sql

That's okay.

The third solution:

Find and remove code similar to the following at the beginning of the SQL file:

Vim ihnhlife_datafull_201612011334_1612011334.sqlSET @ @ GLOBAL.GTID_PURGED='d0502171-3e23-11e4-9d65-d89d672af420:1-373, d5deee4e-3e23-11e4-9d65-d89d672a9530:1-616234'

Then run, mysql-uroot-p hu < ihnhlife_datafull_201612011334_1612011334.sql; normal

You can also use third-party software to pour in, such as navicat, first select a database, and then right-click to run the sql file, as shown in the figure:

Then select your sql file, some errors may be reported in the process of dumping, but when the pour is complete, I will check which data are found to exist according to the error prompt!

For the above about mysql poured into the database after the error report how to deal with, we do not find it very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report