Thursday, December 1st 2022

Import and export mysql database

export (mydb):

mysqldump --host=localhost --port=3306 --default-character-set=utf8 --user=root --protocol=tcp --column-statistics=FALSE --skip-triggers "mydb" -p > data.sql

import (mydb):

mysql --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=mydb  < "./data.sql" -p