Wednesday, March 25, 2020

mysqldump

#dump
mysqldump -uroot -p database -r utf8.dump

#dump the schema
mysqldump -uroot -p --no-data database -r utf8.dump

#import
mysql -uroot -p --default-character-set=utf8 database
mysql> SET names 'utf8'
mysql> SOURCE utf8.dump

No comments:

Post a Comment

systemd-timesyncd

sudo apt update && sudo apt install systemd-timesyncd && sudo systemctl enable --now systemd-timesyncd