LAMP 3.5 MySQL Backup and recovery

Commands for backing up libraries

Mysqldump-uroot-pwangshaojun discuz >/data/discuz.sql

Specify user password, redirect to a file

Recovery

Mysql-uroot-pwangshaojun Discuz </data/discuz.sql

You can also back up a table

Mysqldump-uroot-pwangshaojun discuz pre_forum_post >/data/post.sql

Recovery table

Mysql-uroot-pwangshaojun Discuz  </data/post.sql

Specifying a character Set backup

Mysqldump-uroot--default-character-set=gbk-pwangshaojun discuz pre_forum_post >/data/ Post.sql

Specify character Set recovery

Mysql-uroot--default-character-set=gbk-pwangshaojun discuz </data/post.sql

Avoid character set inconsistency garbled problem.

LAMP 3.5 MySQL Backup and recovery