/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

1 vote282 views2 answers
Mysql extract number from string
SQL
0 vote210 views1 answer
Expose db in virtualbox
SQL
0 vote269 views1 answer
Oracle running queries
SQL
0 vote282 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote235 views1 answer
How to check replication lag in mySQL
SQL
0 vote268 views1 answer
Suse status MySQL
SQL
1 vote201 views1 answer
Postgres reset auto increment
SQL
32 votes262 views6 answers
Insert into values select
SQL
5 votes254 views1 answer
Ignore duplicate rows in sqlite
SQL
0 vote213 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL

Share