Backup Database (local)
$ mysqldump database-name > backup-database-name.sql
Backup Database (remote)
$ mysqldump database-name --user=root --password --host=192.168.21.67 --port=3308 > backup-database-name.sql
$ mariadb-dump database-name --user=root --password --host=192.168.21.67 --port=3308 > backup-database-name.sql
Restore Database
$ mysql --database=database-name < backup-database-name.sql
$ mariadb.exe --database=database-name --user=root --password --host=localhost --port=3308 < C:\Users\dell\Downloads\backup-database-name.sql
Source :
https://stackoverflow.com/questions/42042241/how-to-perform-a-full-backup-of-a-mysql-mariadb-database
https://stackoverflow.com/questions/64410301/how-to-restore-mysql-database-from-a-sql-file
Comments
Post a Comment