Linux MySQL Commands

Written by

Sanjay Bhowmick

in

Log into mysql

mysql -u root -p

Import database as root user

mysql -u root -p mydatabase < backup.sql

Import database as non root user

mysql -u myuser -p mydatabase < backup.sql

Check tables

USE mydatabase;
SHOW TABLES;

Delete all tables one by one

SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS table1, table2, table3, ...;
SET FOREIGN_KEY_CHECKS = 1;

Take Backup of Database

mysqldump -u root -p mydatabase > mydatabase_backup.sql

More posts