Guide to importing and exporting MySQL databases.
brew install mysql
.mysql-client
package.
mysql-client
package.
EXTERNAL_HOSTNAME
, USERNAME
, PORT
, and DATABASE_NAME
with the information from your database’s External connections. Replace export.sql with the path and name of the database you want to import:
SHOW TABLES;
or a similar command to review the data in your database.
EXTERNAL_HOSTNAME
, USERNAME
, PORT
, and DATABASE_NAME
with the information from your database’s External connections. Replace export.sql with the path and file name of the database you want to export:
mysqldump
command. You can open the file with a plain text editor (e.g. TextEdit, Notepad++, Sublime Text, etc.) or a database tool like TablePlus to review the exported data.