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.

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

Icons proudly provided by Friconix.