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