I have a server and within that server I have an sql script in the /var/www/ directory. That script is to create tables and databases. I need to know how to execute this sql script from terminal or some client while keeping the file on the server.
PS- I don't know much of the terminology for this topic so I will look into other suggestions for my approach.
I presume that it is MYSQL. To run it from Unix / Linux environment you must do this:
$ mysql -h "server-name" -u "your_username" -p "your_password" "database-name" < "filename.sql"
There is another way:
mysql --host=localhost --user=your_username --password=your_password -e "filename.sql"
-e is a valid SQL statement, not a path. E.g.: mysql --host=127.0.0.1 --port=3306 --user=root --password=your_password -e "select 1;"
$ mysql -h "server-name" -u "your_username" -p "your_password" "database-name" < "filename.sql", do you have any ideas?
Try this:
mysql -u your_username -p your_password
use db_name
source <path_to_sql_file>/file.sql
If you want to run an SQL file for a specific database, then select the database first:
mysql -u your_username -p your_password
use db_name
source <path_to_sql_file>/file.sql
The above answer of @Tomislav is correct but I do not like to write the password with the command-line option.
If you did not create the new database and want to create it with a .SQL file then use the below statement.
mysql -h {YOUR_HOST} -u {USERNAME} -p < {FILENAME.sql}
then MySQL CLI will ask for the password (The best way to prevent the password from anyone). Write your password and hit Enter
If you have already created a database then use the below command.
mysql -h {YOUR_HOST} -u {USERNAME} -p {DATABASE_NAME} < {FILENAME.sql}
then MySQL CLI will ask for the password. Write your password and hit Enter
Usually, the .SQL file doesn't have any print statements. So you have to enter and check with your MySQL CLI.
mysql -u {username} -p {databasename}
enter password
then add file path or filename
\. { filename } | source { filename }
file must have .sql extension
