Question #590   Submitted by Answiki on 10/01/2021 at 06:08:20 PM UTC

How to import database dump from command line with mysql?

Answer   Submitted by Answiki on 10/01/2021 at 06:11:58 PM UTC

The following command will import the exported database FILENAME.sql into the database named myDATABASE

mysql -uUSERNAME -pPASSWORD -f myDATABASE < FILENAME.sql

Where USERNAME, PASSWORD, myDATABASE and FILENAME.sql must be replaced by appropriated values.

Log in or sign up to update this answer Login Signup
2 events in history
Answer by Answiki on 10/01/2021 at 06:11:58 PM

The following command will import the exported database FILENAME.sql into the database named myDATABASE

mysql -uUSERNAME -pPASSWORD -f myDATABASE < FILENAME.sql

Where USERNAME, PASSWORD, myDATABASE and FILENAME.sql must be replaced by appropriated values.

Question by Answiki 10/01/2021 at 06:08:20 PM
How to import database dump from command line with mysql?
# ID Query URL Count
0 12113 en https://en.ans.wiki/590/how-to-import-database-dump-from-command-line-with-mysql 6
Icons proudly provided by Friconix.