#BACKUP

  • step-1 Run command prompt as administrator
  • step-2 goto the instalation directory example cd “C:\Program Files\MariaDB 10.2\bin”
  • step-3 mysqldump -u username -p database_name > data-dump.sql

#RESTORE

  • step-1 Run command prompt as administrator
  • step-2 goto the instalation directory example cd “C:\Program Files\MariaDB 10.2\bin”
  • step-3 mysql -u username -p new_database < data-dump.sql
Advertisements