/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 vote183 views1 answer
Subquery aggregation
SQL
0 vote184 views1 answer
Linebreak sql
SQL
3 votes224 views1 answer
Oracle list invalid password logon denied
SQL
1 vote182 views2 answers
Install mysqldump ubuntu
SQL
0 vote184 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
3 votes173 views1 answer
Oracle user quota unlimited
SQL
0 vote176 views1 answer
Soql more than today
SQL
1 vote181 views1 answer
Mysql list bigger table
SQL
3 votes191 views2 answers
Sql select data from last week
SQL
0 vote206 views1 answer
Declare or use variable in snowflake
SQL

Share