dev:kb:database:mysql

This is an old revision of the document!

Table of Contents

MySQL
- - Create backup account
  - MySQL backup & restore SQL file

MySQL

Create backup account

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

MySQL backup & restore SQL file

mysqldump -uusername -ppassword --all-databases > all.sql
mysql -uusername -ppassword < all.sql;

dev/kb/database/mysql.1391255276.txt.gz · Last modified: 2020/06/06 23:32 (external edit)