LOW COST JAVA PHP MYSQL CGI PERL
HOSTING SERVICE
LINUX WINDOWS CPANEL WHM PLESK
HOSTING PACKAGES
ECOMMERCE HOSTING ASP JSP MSSQL
FRONTPAGE HOSTING
CPANEL WHM RESELLER DEDICATED
SERVER WEB HOSTING

How to restore a database and take backup of database through shell?

November 30, 2006 at 9:50 am · Filed under MySQL Web Hosting, Windows Web Hosting, cPanel Hosting, dedicated server hosting

Postgresql

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

Mysql

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

Bookmark on del.icio.us digg this

This post is compiled by eUKhost.com

1 Comment »

  1. Web Hosting Reviews said,

    January 2, 2007 @ 4:29 pm

    Following commands also useful to take backup and restore of simple (not contains large objects) postgresql database.
    pg_dump mydb > db.out
    To restore database
    psql -d database -f db.out

RSS feed for comments on this post · TrackBack URI

Leave a Comment

You must be logged in to post a comment.