Command Reference Guide > Command Reference Guide > Using Ingres Commands > copydb Command--Copy and Restore a Database > copydb Example on UNIX
Was this helpful?
copydb Example on UNIX
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.
Last modified date: 11/28/2023