robpataki/MySQL-Notes.md

## MySQL-Notes.md

      
    Raw
  

              MySQL-Notes.md
            
          
    Important MySQL Commands

Enter MySQL

$ sudo mysql

List databases

$ show databases;

Create database dump (exit MySQL first)

$ sudo mysqldump database_name > backup_file.sql;

Restore database state from dump

$ sudo mysql
$ USE database_name;
$ source db_dump.sql