cPanel backup error : mysqldump: Got error: 1049: “Unknown database when selecting the database”
cPanel backup error : mysqldump: Got error: 1049: “Unknown database when selecting the database”
database
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
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”
cPanel backup error mysqldump: Got error: 1049: Unknown database when selecting the database
Sometimes cPanel full backup fails with the following error. Storing mysql dbs…mydatabase……… /usr/bin/mysqlcheck: Got error: 1049: Unknown database ‘mydatabase’ when selecting the database (755 bytes) mydatabase_db(1031138 bytes) mydatabase_tab Check in cPanel that if you have any 0kb or empty database by the database name in error message. If you have it, delete it from More
How to Import & Export MySQL Databases with SSH
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 🙂