Using the following command, you can take a backup of your postgresql database.
# pg_dump -u -C -f backupfile.sql database_name
You can restore a pgsql database using the following command
# pg_restore -v -C -O -d database_name backupfile.sql.tar
Using the following command you can take backup of a mysql database.
# mysqldump database_name > backup.sql
You can a restore mysql database using the following command
# mysql database_name
Latest posts by Freestyler (see all)
- Optimizing Keywords From Free Directory Submissions - June 15, 2007
- Why do I get an error when I try to send emails? - December 26, 2006
- My IP address is blacklisted. How can it be unlisted? - December 26, 2006