NixUser

NixUser.com | Unix User | Linux User | NixUser

database

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”

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 🙂