/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

4 votes350 views1 answer
Oracle nls_date_format
SQL
0 vote343 views1 answer
C# get sql min date
SQL
0 vote325 views1 answer
To change the database owner in SQL server
SQL
4 votes324 views1 answer
Mysql timestamp in laravel migration
SQL
4 votes314 views2 answers
Dbms_scheduler stop job
SQL
4 votes324 views1 answer
Change nls_date_format
SQL
1 vote328 views1 answer
Top 10 rows in mysql
SQL
0 vote313 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
5 votes330 views1 answer
Sql select ciunt
SQL
0 vote352 views1 answer
Mysql command line top 10
SQL

Share