User Tools

Site Tools


dev:kb:database:mysql

This is an old revision of the document!


MySQL

Create backup account

DROP USER backupuser@localhost;
CREATE USER backupuser@localhost IDENTIFIED BY 'backuppassword';
GRANT LOCK TABLES, SELECT ON *.* TO backupuser@localhost IDENTIFIED BY 'backuppassword';

MySQL backup & restore SQL file

mysqldump -ubackupuser -pbackuppassword --all-databases > all.sql
mysql -ubackupuser -pbackuppassword < all.sql;
dev/kb/database/mysql.1391255351.txt.gz · Last modified: 2020/06/06 23:32 (external edit)