NixUser.com | Unix User | Linux User | NixUser
Cannot restore from mysqldump file and errors out with message “ERROR 1118 (42000) at line 553: 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”
To export a MySQL database, access your server via ssh and run the following commands: # mysqldump -u username -p database_name > database.sql To import a MySQL Database, run the command: # mysql -u username -p database_name < database.sql That’s it 🙂
When I tried to restore an account I got the error: Sorry, a mysql user with the name x already exists. I know that the user does not exists on the server. To fix this issue, ran the cPanel script. /scripts/updateuserdatacache And the error is gone and I was able to restore the account without More