Import Sql file to Mysql Database

MySQL 30/03/2019 23/04/2019 Diana Igorovna

For import sql file to database: mysql -uUsername -p database_name_backup.sql < database_name.sql Then write password and start import process. For compressed files like sql.bz2 : bunzip2 < database_filename.sql.bz2 | mysql

Take a Database Backup on Terminal

MySQL 14/03/2019 23/04/2019 Diana Igorovna

It' simple to use mysqldump to taking a database backup on terminal: mysqldump -uDATABASEUSERNAME -pPASSWORD database_name > database_name.sql If you don't want to use the password with command line: mysqldump

Create a database via MySQL console

MySQL 13/03/2019 23/04/2019 Diana Igorovna

Login to MySQL console in terminal use: mysql -u=root -p Create a database: Create Database DATABASENAME Character Set utf8mb4 Collate utf8mb4_unicode_ci; Define a user for the database: Grant All Privileges