Magento2 Database Import Error

Question

I am facing below error when try to import Magento 2 Database to 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 some website/article/blog post and most of place suggested to use --routines tag while we do export, so that will remove MySQL Procedure.

Example: mysqldump --routines

I stuck since last 3 day and no solution work to import database.

Please help somebody to sort out issue.

Error Screenshot

It's MySql Procedure issue not MySQL Process. Please correct above in description. Thanks! — Dixit Patel
– Dixit Patel, Commented Mar 30, 2017 at 4:08

Dixit Patel · Accepted Answer · 2017-03-30 04:10:39Z

1

I had same issue and no body can help to you without hosting team. You might have shared hosting and they cant provide supper user privilege, You have to reach to them OR you have to go for own VPS OR Dedicate server.

I personally at that time taken help from Support Team and they imported everything at their end and saved my life :)

Hope it will work fine with you as well.

answered Mar 30, 2017 at 4:10

Dixit Patel

6022 gold badges10 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arvind Hathiya · Accepted Answer · 2019-09-03 09:14:10Z

0

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

Export database

mysqldump -u username -p db_name > sql_file.sql

answered Sep 3, 2019 at 9:14

Arvind Hathiya

32 bronze badges

Collectives™ on Stack Overflow

Magento2 Database Import Error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related