Skip to main content

MySQL Commands

mac mysql 启动失败​

Terminal 操作：

start

sudo /usr/local/mysql/support-files/mysql.server start

stop

sudo /usr/local/mysql/support-files/mysql.server stop

restart

sudo /usr/local/mysql/support-files/mysql.server restart

mysql 在 docker 中备份与恢复​

  1. Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --no-tablespaces --password=root DATABASE > backup.sql
  1. Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE