Skip to main content

Restoring Tables

  1. Log on to Accelerator.

  2. Copy the backup file onto the server (SCP) and into the directory that the backup was created from (see Hubble Accelerator Database Table Backup section).

  3. Decompress the file if required.

    Note: If the location of the files is different to the location the backup was made from you will need to edit the copy.in file and change the location specified in the file to the new location of the backup files. The copy.in file contains sections for Creating Tables, Grant Select and Copying Data, if you want to restore the data, but the table already exists in the database, then you will need to edit the copy.in file accordingly.    

  4. Then to use the copy.in file to import the data run:

    sql <database_name> -u<DB_UserName> < copy.in

    For example:

    sql db -uhubble < copy.in