mysql

The MySQL command-line tool.

=> More information.

• 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}

Copyright © 2014—present the tldr-pages team and contributors.

This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

=> CC-BY