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

What's the quickest way to find duplicated files?

find . ! -empty -type f -exec md5sum {} + | sort | uniq -w32 -dD fdupes -r / linux_czkawka_gui.AppImage