copydb Example on Linux
The following commands:
1. Create a printable data file encoded with the UTF8 character set (copydb ‑c flag). Remove the paths from the file names (‑relpath flag) so that the files will be created and copied from the current directory.
2. Generate the user defined table files in the database dbname.
3. Archive all the files that were just generated in the current directory.
copydb -c -relpath dbname
sql dbname <copy.out
tar -cvf backup.tar *
You can move the archive file to your backup server.
4. The following example creates a new database newdb and restores data into it:
createdb newdb
sql newdb<copy.in
sysmod newdb
Last modified date: 01/28/2026