Upload database mysql command line

Mysql load sql from file

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

Source: stackoverflow.com

Upload database mysql command line

mysql -u username -p database_name < file.sql


Note-1: It is better to use the full path of the SQL file file.sql.

How to import mysql database command line

mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;

Source: stackoverflow.com

Import mysql database command line

Source : https://www.programmingquest.com/2018/08/how-to-export-mysql-database-using.html
open cmd
set mysql path in cmd
	set path=c:\wamp\bin\mysql\mysql5.6.17\bin
For database import (Restore): 
	mysql -u YourUser -p YourDatabaseName < filename.sql

Source: programmingquest.com

Similar codes

1 vote179 views1 answer
T-SQL / AZURE Reseed
SQL
2 votes180 views1 answer
How to show the whole table in sql
SQL
4 votes150 views2 answers
Oracle set date format
SQL
8 votes170 views1 answer
How to remove tables from postgresql
SQL
61 votes285 views6 answers
Mysql add column
SQL
1 vote294 views3 answers
Uninstall postgresql mac
SQL
0 vote198 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote171 views1 answer
Oracle sql winter time change
SQL
11 votes173 views6 answers
Distinct sql
SQL
0 vote194 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL