All geek questions in one place

Error importing Magento2 database

I encountered an error while trying to import Magento 2 database into a popular hosting company,

ERROR 1227 (42000) at line 1251: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I read a post on a website / article / blog, and most places suggested using the --routines tag during export to remove MySQL.

Example: mysqldump --routines

I am stuck from the last 3 days and no solution works for importing a database.

Please help someone sort out the problem.

Error screenshot

+5
source share
2 answers

I had the same problem, and no authority could help you without a hosting team. Perhaps you had shared hosting, and they cannot provide dinner user privileges, you must contact them, or you need to go to your own VPS or Dedicate server.

At that time, I personally took help from the support team, and they imported everything at the end and saved my life :)

I hope that everything will be fine with you.

+1
source

Import

Same server

 mysql -u username -p db_name < sql_file.sql

Another server

000.000.0.00 = server ip

 mysql -u username -p db_name -h 000.000.0.00 < sql_file.sql

Database Export

 mysqldump -u username -p db_name > sql_file.sql
0
source

Source: https://habr.com/ru/post/1266101/

More articles:


All Articles