Backup and Restore
Backup and restore of AntsDB can be achieved in two different ways.
mysqldump is the official command line utility for backing up database for MySQL. It can also be used with AntsDB. On Linux, the utility can be found in package mysql in most of the distributions. On Windows, it is included in the standard MySQL installation.
AntsDB can be backed up using the command below for example where test is the name of the database that is going to be backed up.
mysqldump -h 127.0.0.1 test > dump.sql
Compression can be enabled as well during the backup. Below is an example
mysqldump -h 127.0.0.1 test | gzip > dump.sql.gz
To restore the database, follow the example below where test is the name of the database where the dump is going to be restored. Be noted, database must be created before the restore process.
gzip < dump.sql.gz | mysql -h 127.0.0.1 test
AntsDB can also be backed up using the methods suggested by HBase - HBase Backup. To properly backup AntsDB, follow the steps below
- Shutdown AntsDB
- Use one of the backup methods suggested by HBase
To restore AntsDB, use the hbase-relink command line.