💾 Archived View for freeshell.de › tldr › mysql.gmi captured on 2023-09-28 at 16:42:40. Gemini links have been rewritten to link to archived content

View Raw

More Information

⬅️ Previous capture (2022-04-28)

-=-=-=-=-=-=-

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