Difference between revisions of "Backup and Restore Databases"

Revision as of 17:36, 15 March 2010

Backup and Restore Databases

Using the recitaldump Command to Backup Your Data

The recitaldump command is used to perform backups of either a database or a directory tree. The format of the backup file is machine independent and can be restored onto another machine with a different architecture e.g. backup on aix and restore on linux. You use the recitalrestore command to restore the backup onto another machine.

Note: recitaldump and recitalrestore must be run as root. For systems with a hidden root account, please precede the commands with sudo.

The recitaldump command takes the following arguments.

--help

Using the --help or -h argument will display a list of arguments for all the services.

 recitaldump --help

-D database

This argument is used to specify the name of a database to backup. If no -o output file is specified, the backup file will be given the same basename as the database, with a .tar.gz extension.

 recitaldump -D southwind 

-d directory

This argument is used to specify the name of a directory to backup. If no -o output file is specified, the backup file will be given the same basename as the directory, with a .tar.gz extension. If there is a file called _reindex.prg located in the directory this file will be executed to recreate single index files when the backup is restored on a target system. You should add the Recital script commands used to rebuild the index files (.ndx) into this file. Multiple tag index files (.dbx) are handled automatically.

 recitaldump -d /data/application 

-r

This argument is used in conjunction with the -d option to recursively process subdirectories.

recitaldump -d /data/application -r 

-o outfile

Specify the output backup file name. When you need to restore this file use the recitalrestore command. For example to create a backup file of the southwind database called accountants.tar.gz;

 recitaldump -D southwind -o accountants

-t

This argument is used to add a time stamp to the output file name. For example if today was the 2nd of November 2009 at 03:27pm the following command would create a file called southwind-20091102-1527.tar.gz from backing up the southwind database.

 recitaldump -D southwind -t

Using the recitalrestore Command to Restore Your Data

The recitalrestore utility is is used to restore a backup archive created using the recitaldump command. The recitaldump command can be used to create a machine independent backup of a database or directory which is restored onto a target system using recitalrestore.

Note: recitalrestore must be run as root. For systems with a hidden root account, please precede commands with sudo.

The recitalrestore command takes the following arguments.

--help

Using the --help or -h argument will display a list of arguments for all the services.

 recitalrestore --help

-i infile

Specify the input backup file that was created from recitaldump to restore from. If the backup is of a directory, the full path name of the backup file must be specified.

 recitalrestore -i /tmp/application.tar.gz

For a database, only the file name need be given.

 recitalrestore -i southwind.tar.gz

[ -q ]

Run in quiet mode.

 recitalrestore -i southwind.tar.gz -q

[ -v ]

Run in verbose mode.

 recitalrestore -i southwind.tar.gz -v

Using the recitalrollback Command to Rollback to a Timeline

Summary