/SQL/Mysql run sql file

Mysql run sql file

Execute mysql file

mysql -u yourusername -p yourpassword yourdatabase < text_file

4

Mysql load sql from file

 mysql> use db_name;
 mysql> source file_name.sql;

3

Source: stackoverflow.com

Mysql run sql file

mysql> source \home\user\Desktop\test.sql;

2

Similar codes

3 votes157 views2 answers
How to start postgresql on windows
SQL
6 votes162 views1 answer
Allsource oracle
SQL
0 vote152 views1 answer
Convert sql server guid to varbinary
SQL
2 votes155 views6 answers
Mysql change timezone
SQL
1 vote184 views1 answer
Mysql default port
SQL
0 vote185 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote168 views1 answer
How to open mysql in docker
SQL
2 votes169 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote154 views1 answer
Create-table-with-index-organization
SQL
0 vote158 views1 answer
Mysql get last 2 month data
SQL

Share