Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 325 Bytes

seed-mysql-database-from-file.md

File metadata and controls

18 lines (13 loc) · 325 Bytes

To run seed a mysql database from the CLI:

mysql -p -u $USERNAME $DATABASE < $FILENAME

To dump the database into a sql script:

mysqldump -p -u $USERNAME $DATABASE > $FILENAME

For example:

mysql -p -u root my_database < dummy_data.sql
mysqldump -p -u root my_database > dummy_data.sql