mysql

> The MySQL command-line tool.

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 work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

-- Response ended

-- Page fetched on Tue May 21 06:27:43 2024