Export MySQL Dump

by Kyle on 

mysqldump -h DBHOST -u DBUSER -pDBPASS DBNAME > dump.sql

Replace text in uppercase with the appropriate information:

  • DBHOST - Database hostname, usually localhost
  • DBUSER - User with privileges to the database
  • DBPASS - Password for the user
  • DBNAME - Database name

Import MySQL Dump

by Kyle on 

mysql -h DBHOST -u DBUSER -pDBPASS DBNAME < dump.sql

Replace text in uppercase with the appropriate information:

  • DBHOST - Database hostname, usually localhost
  • DBUSER - User with privileges to the database
  • DBPASS - Password for the user
  • DBNAME - Database name

Hide Sidebar