/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

2 votes133 views1 answer
How to select first row of database sql
SQL
0 vote134 views1 answer
Version and edition of SQL Server Database Engine
SQL
1 vote135 views1 answer
Sql order by where condition
SQL
41 votes199 views6 answers
Alter table add column in SQL Server
SQL
0 vote138 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
12 votes153 views1 answer
Run mysql instance in docker
SQL
0 vote135 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
-1 vote133 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
1 vote151 views1 answer
Psql connect to another database
SQL
32 votes152 views6 answers
Rename column mysql
SQL

Share