backup/restore MYSQL

Post Reply
zemerdon
Site Admin
Posts: 310
Joined: Mon Jan 23, 2023 8:13 pm

backup/restore MYSQL

Post by zemerdon »

mysqldump --user=XXXXXXXX --password=XXXXXXX --databases zm > /PATH/TO/DUMPFILE.SQL
mysqldump -u [username] -p --all-databases > alldatabases_backup.sql


mysqldump --user=root --password=passwordhere --all-databases > /home/zoneminder_16-05-2023_v1.36.33.sql

** RESTORE MYSQLDB **

mysql --user=XXXXXXXX --password=XXXXXXXX zm < /PATH/TO/DUMPFILE.SQL
mysql -u root < /PATH/TO/DUMPFILE.SQL
Post Reply