warden db import #815
Unanswered
atty31
asked this question in
Help & Support
Replies: 1 comment
-
If you're using the Magento template, the root credentials for the db are |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Version of Warden
in-dev
Operating System and Installation Method
Ubuntu, Linux
Describe the Bug
Hello,
I am trying to do a database import: cat data.sql | warden db import , but i'm stuck with one table with a lot of varchar columns.
Getting this error:
Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline
.Running this query:
SHOW VARIABLES LIKE 'innodb_strict_mode';
will show that the value is set toON
. Following the instructions from: https://stackoverflow.com/questions/22637733/mysql-error-code-1118-row-size-too-large-8126-changing-some-columns-to-te i want to turn it off withSET GLOBAL innodb_strict_mode = OFF;
. But I'm getting:42000][1227] Access denied; you need (at least one of) the SUPER privilege(s) for this operation
How can I run that query with root access maybe ?
Thank you
To Reproduce
No response
Expected Behavior
No response
Additional context
No response
Beta Was this translation helpful? Give feedback.
All reactions