SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[mysql] How to execute a .sql script from bash

Basically, I need to setup a database from a bash script. I have a script db.sql that does all this. Now how do I run this script from bash?

Database system is mysql

This question is related to mysql database linux bash

The answer is

You simply need to start mysql and feed it with the content of db.sql:

mysql -u user -p < db.sql

If you want to run a script to a database:

mysql -u user -p data_base_name_here < db.sql

Source: Stackoverflow.com

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to database

• Implement specialization in ER diagram • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' cannot be loaded • Room - Schema export directory is not provided to the annotation processor so we cannot export the schema • SQL Query Where Date = Today Minus 7 Days • MySQL Error: : 'Access denied for user 'root'@'localhost' • SQL Server date format yyyymmdd • How to create a foreign key in phpmyadmin • WooCommerce: Finding the products in database • TypeError: tuple indices must be integers, not str

Examples related to linux

• grep's at sign caught as whitespace • How to prevent Google Colab from disconnecting? • "E: Unable to locate package python-pip" on Ubuntu 18.04 • How to upgrade Python version to 3.7? • Install Qt on Ubuntu • Get first line of a shell command's output • Cannot connect to the Docker daemon at unix:/var/run/docker.sock. Is the docker daemon running? • Run bash command on jenkins pipeline • How to uninstall an older PHP version from centOS7 • How to update-alternatives to Python 3 without breaking apt?

Examples related to bash

• Comparing a variable with a string python not working when redirecting from bash script • Zipping a file in bash fails • How do I prevent Conda from activating the base environment by default? • Get first line of a shell command's output • Fixing a systemd service 203/EXEC failure (no such file or directory) • /bin/sh: apt-get: not found • VSCode Change Default Terminal • Run bash command on jenkins pipeline • How to check if the docker engine and a docker container are running? • How to switch Python versions in Terminal?