NixUser

NixUser.com | Unix User | Linux User | NixUser

dump sql

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 🙂