Question
The file size in the VertiGIS Transfer Portal is limited to 16 GB. Raster files or database dumps are often larger. How can I proceed if I want to provide files with a file size >16GB?
Answer
As the restriction applies per file and not in total, the file can be split up. This can be done, for example, by providing several zip archives. When creating database dumps, it is usually also possible to split them into several files.
Procedure zip archive
In the following description, 7-Zip is used as an example. Comparable functionalities are also provided by other archiving tools.
- Navigate to the Folder:
- Locate the folder containing the files you want to zip and, if required, split.
- Locate the folder containing the files you want to zip and, if required, split.
- Select Files:
- Select all the files and folders you wish to include in the zip archive. To select multiple files, hold down the "Ctrl" key while clicking on each file.
- Select all the files and folders you wish to include in the zip archive. To select multiple files, hold down the "Ctrl" key while clicking on each file.
- Right-Click and Zip with Manual Splitting:
- Right-click one of the selected files.
- From the context menu, hover over "7-Zip," and select "Add to archive."
- Configure Split Size:
- In the "Add to Archive" window, edit the Archive name (by default saved to the same folder).
- Ensure the Archive format is Zip and Compression level is Normal
- If you want to split the compress files into several small files then set Split to volumes, bytes to file size you want (e.g. 15GB).
- Add any other special settings such as passwords etc, ...
- Click "OK" to create the zip file/s. The segments will be saved in the same location as the original zip file.
- Wait for the zip files to be created.
- Once complete you will see a list of files in your folder with the suffix .zip or .001, .002 etc.
- These files can then be provided via the VertiGIS Transfer Portal.
Procedure database dumps
- PostgreSQL
pg_dump
https://www.postgresql.org/docs/current/backup-dump.html#BACKUP-DUMP-LARGEdbname
| split -b 2G -filename
- Oracle
expdp DUMPFILE=expdir:exp%U.dmp FILESIZE=2G
https://oracle-base.com/articles/10g/oracle-data-pump-10g#expdp
- SQL Server
https://www.sqlshack.com/split-sql-database-backups-into-multiple-backup-files-using-ssms/
Comments
0 comments
Please sign in to leave a comment.