MySQL Commands

Important MySQL Commands.

• How to check if multiple instance are running on the Server

sudo netstat -tap | grep mysql

• Kill mySql processors

pkill mysqld

• Start , Stop or Restart MySQL

/etc/init.d/mysql start|stop|restart|reload|force-reload|status

• Backup MySQL Database

mysqldump -u root -p DB > database_dump.txt

• Restore MySQL Database

mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]

• Back up MySQL Database with Compress

mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]

• Restore compressed backup files

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

• Restore a database that already exists

mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]