Tutorial by Topics: backup

mysqldump -u [username] -p[password] [other options] db_name > dumpFileName.sql /// To Backup single database mysqldump -u [username] -p[password] [other options] db_name [tbl_name1 tbl_name2 tbl_name2 ...] > dumpFileName.sql /// To Backup one or more tables mysqldump -u [username] -...

Backing up the filesystem instead of using pg_dumpall and pg_dump It's very important that if you use this, you call the pg_start_backup() function before and pg_stop_backup() function after. Doing filesystem backups is not safe otherwise; even a ZFS or FreeBSD snapshot of the filesystem backed u...

BACKUP DATABASE database TO backup_device [ ,...n ] WITH with_options [ ,...o ] RESTORE DATABASE database FROM backup_device [ ,...n ] WITH with_options [ ,...o ] ParameterDetailsdatabaseThe name of the database to backup or restorebackup_deviceThe device to backup or restore the database f...

ParameterDetailsBackup FileThe file name to use for backups.Add Timestamp suffixTrue or False, define if the file will have a timestamp at the end.Backup scopeDefine what you want to save  BasicSaving the database, server Settings, additional data  All except build artifactsSaving the database, se...

The script allows you to create a backup directory for each execution with the following syntax : Name of database backup directory + date and time of execution Example : prodDir22-11-2016-19h55 After it's created, it creates two backup files with the following syntax : Name of database + date ...

Backing up a remote Redis instance can be achieved with replication. This is useful if you want to take a snapshot of a dataset prior to upgrading, deleting or changing a Redis database.

Backing up and restoration are crucial to maintaining a healthy and thriving database. If anything goes wrong, database restoration can serve as a time machine that takes you back to the point when everything was still in order and helps you prevent the disaster. In this article, you will find an il...