Changes between Version 1 and Version 2 of TracBackup

Timestamp:

Jul 17, 2018, 2:10:07 PM (6 years ago)

Author:

trac

Comment:

--

TracBackup

@@ -3 +3 @@
 [[TracGuideToc]]
 
-Backups are simply a copied snapshot of the entire [wiki:TracEnvironment project environment] directory, including the database. Backups can be created using the `hotcopy` command in [wiki:TracAdmin trac-admin].
+Trac backups are a copied snapshot of the entire [TracEnvironment project environment] directory, including the database. Backups can be created using the `hotcopy` command of [TracAdmin trac-admin].
 
 '''Note''': Trac uses the `hotcopy` nomenclature to match that of [http://subversion.tigris.org/ Subversion], to make it easier to remember when managing both Trac and Subversion servers.
@@ -9 +9 @@
 == Creating a Backup
 
-To create a backup of a live TracEnvironment simply run:
+Create a backup of a live TracEnvironment by running:
 {{{#!sh
 $ trac-admin /path/to/projenv hotcopy /path/to/backupdir
 }}}
 
-[wiki:TracAdmin trac-admin] will lock the database while copying.
+The database will be locked while hotcopy is running.
 
 The resulting backup directory is safe to handle using standard file-based backup tools like `tar` or `dump`/`restore`.
 
-Please note, the `hotcopy` command will not overwrite a target directory and when such exists, the operation ends with an error: `Command failed: [Errno 17] File exists:` This is discussed in [trac:ticket:3198 #3198].
+Please note, the `hotcopy` command will not overwrite a target directory. When the target exists the operation will end with an error: `Command failed: [Errno 17] File exists:` This is discussed in [trac:#3198 #3198].
 
-=== Restoring a Backup
+== Restoring a Backup
 
-To restore an environment from a backup, stop the process running Trac, ie the Web server or [wiki:TracStandalone tracd], restore the contents of your backup (path/to/backupdir) to your [wiki:TracEnvironment project environment] directory and restart the service.
+To restore an environment from a backup, stop the process running Trac, ie the web server or [TracStandalone tracd], restore the contents of your backup to your [TracEnvironment project environment] directory and restart the process.
+
+If you are using a database other than SQLite, you'll need to restore the database from the dump file. The dump file is saved in the environment `db` directory.
 
 To restore a PostgreSQL database backup, use the command:
 {{{#!sh
-psql -U <user> -d <database> -f postgresql.dump
+$ psql -U <user> -d <database> -f /path/to/postgresql.dump
 }}}
-The `<database>` option is the same as the [TracEnvironment#DatabaseConnectionStrings database connection string] in the `[trac]` `database` option of //trac.ini//.
+
+The `<database>` option is the same as the [TracEnvironment#DatabaseConnectionStrings database connection string] in the [TracIni#trac-database-option "[trac] database"] option of //trac.ini//.
+
+Similarly, for MySQL:
+
+{{{#!sh
+$ mysql -u <user> -p <database> < /path/to/mysql.dump
+}}}
 
 ----
-See also: TracAdmin, TracEnvironment, TracGuide, [trac:TracMigrate TracMigrate]
+See also: TracAdmin, TracEnvironment, [trac:TracMigrate TracMigrate]