I am trying to import a 15 MB mySQL DB in phpMyAdmin but I get an error. How can I fix this?
This is the error I get:
#1118 - 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.
I searched the error and found some people talking about adding this to /etc/mysql/my.cnf
innodb_log_file_size = 512M
I did that and restarted Apache but I still get the error. I’ve also updated my php.ini file with:
memory_limit = 600M
I’m running a 1GB / 30GB Disk Ubuntu droplet. Is there something I am missing?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.