create database mysql command line ubuntu code example

Example 1: xampp import sql file command line

C:\xampp\mysql\bin>mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql

Example 2: create database terminal mysql

CREATE DATABASE dbname;

Example 3: mysql backup database command line

mysqldump database_name > database_name.sql