/SQL/Import mysql dump command line

Import mysql dump command line

Linux command line import mysql database

# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql

10

Import dump mysql

mysql -u username -p database_name < file.sql

10

Database dump mysql command

mysqldump -u username -p dbname > filename.sql

4

Import mysql dump command line

mysql -u username -p database_name < file.sql

1

Source: stackoverflow.com

Similar codes

0 vote340 views1 answer
Postgres list tables and row counts
SQL
15 votes293 views6 answers
Psql
SQL
0 vote305 views1 answer
Oracle query archivemode
SQL
14 votes354 views6 answers
Finding duplicate rows mysql
SQL
0 vote321 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote321 views1 answer
Postgresql port 5432 not open
SQL
0 vote314 views1 answer
Group by two columns postgres
SQL
0 vote285 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote335 views1 answer
Sql sort ages
SQL
-1 vote296 views1 answer
Su: Authentication failure mysql
SQL

Share