MySQL / Maria DB - Backup and Restore

[admin]

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