/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

2 votes334 views1 answer
Mysql last 7 days including today
SQL
3 votes356 views2 answers
Oracle sql first day of month
SQL
0 vote330 views1 answer
Power bi find all ids not in other tables
SQL
0 vote344 views1 answer
How to find the most occuring in SQL
SQL
0 vote336 views2 answers
Mysql decimal remove trailing zeros
SQL
2 votes346 views2 answers
Sql query to list all tables in a database sql server
SQL
2 votes353 views3 answers
Row number mysql
SQL
5 votes327 views1 answer
Postgres integer to serial
SQL
12 votes360 views2 answers
Insert multiple rows from another table sql
SQL
0 vote333 views1 answer
Less mysql display
SQL

Share