/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

6 votes109 views4 answers
How to remove unique key in mysql
SQL
0 vote131 views1 answer
C# select Mysql
SQL
0 vote112 views1 answer
Microsoft sql server python connection
SQL
0 vote136 views1 answer
Reindexing all tables sql server
SQL
16 votes115 views6 answers
Python sqlite
SQL
0 vote66 views1 answer
Ms sql unique
SQL
2 votes120 views3 answers
Sql delete duplicate
SQL
17 votes108 views6 answers
Current date in sql
SQL
0 vote108 views1 answer
Alasql delete column
SQL
-1 vote127 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL

Share