MySQL CLI команды import/dump

Import DB

mysql -u root -p --default-character-set=utf8 db_name < "db.sql"

Dump DB

mysqldump -u root -p --no-tablespaces db_name > db.sql

with option --add-drop-table

mysqldump -u root -p --no-tablespaces --add-drop-table db_name > db.sql

Import CSV files

mysql -u root --local-infile db_name -e "LOAD DATA LOCAL INFILE 'test.csv'  INTO TABLE TEST_TABLE  FIELDS TERMINATED BY ',' ENCLOSED BY '\"' ESCAPED BY '' LINES TERMINATED BY '\n'"

ignore 1st row

mysql -u root --local-infile db_name -e "LOAD DATA LOCAL INFILE 'test.csv'  INTO TABLE TEST_TABLE  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS;"

mysqlcheck — A Table Maintenance Program

mysqlcheck -u root -p --auto-repair --optimize --all-databases