TLDR
Enter a command. For example: interdiff, clojure, behat, history.

mysql

 
The MySQL command-line tool. More information: https://www.mysql.com/.
 
  • Connect to a database:
     
    mysql {{database_name}}
     
  • Connect to a database, user will be prompted for a password:
     
    mysql -u {{user}} --password {{database_name}}
     
  • Connect to a database on another host:
     
    mysql -h {{database_host}} {{database_name}}
     
  • Connect to a database through a Unix socket:
     
    mysql --socket {{path/to/socket.sock}}
     
  • Execute SQL statements in a script file (batch file):
     
    mysql -e "source {{filename.sql}}" {{database_name}}
     
  • Restore a database from a backup created with mysqldump (user will be prompted for a password):
     
    mysql --user {{user}} --password {{database_name}} < {{path/to/backup.sql}}
     
  • Restore all databases from a backup (user will be prompted for a password):
     
    mysql --user {{user}} --password < {{path/to/backup.sql}}

This is a tldr pages (source, CC BY 4.0) web wrapper for cheat-sheets.org. All commands, popular commands, most used linux commands. Referrals. Progressive Web Application (PWA) version to install on your device.