how to restore backup file in mysql command line

how to restore backup file in mysql command line

1.To restore a backup file into the mysql database

Syntax:
mysql -u [username] -p[password] [datebase_name] > [File_path]

Example:
mysql -u root -p sample > c:/backupfile.sql;

2.To restore a compressed file into the mysql database

Syntax:
gunzip

Leave a Reply


All material @ copyrighted by chrisranjana.com. If you want to link to this article you are welcome to do so. Unauthorized publication is strictly prohibited. This developer tutorial website contains articles by Php programmers , Software developers, Mysql programmers and asp c# programmers. This website also contains ajax tutorials and advanced mysql sql stored procedures and functions tutorials and sample codes.