MySQL / Maria DB - Backup and Restore
Posted: Tue Sep 10, 2024 11:41 am
Backup Data
mysqldump -u [USERNAME] -p [databasename] > filname.txt
Restore Data
(From MySQL / Maria DB CMD line)
Drop [DB NAME];
create [DB NAME];
use [DB Name];
source "Full path to backup file"
NOTE: Do not terminate the source line with a semi-colon
mysqldump -u [USERNAME] -p [databasename] > filname.txt
Restore Data
(From MySQL / Maria DB CMD line)
Drop [DB NAME];
create [DB NAME];
use [DB Name];
source "Full path to backup file"
NOTE: Do not terminate the source line with a semi-colon