Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home MySQL Mysql restore database from dump file with GZIP compression

Mysql restore database from dump file with GZIP compression

To restore your mysql database from dump file, specially with large backup file, you should do it from shell command in unix/linux or command prompt in Windows by using mysql command.

1. Restore mysql database from dump sql file

mysql -u root -p your_database_name < your_dump_file.sql

mysql -u root -p your_database_name < your_dump_file.sql

2. Restore mysql database from dump sql file with GZIP compression

gunzip < your_dump_file.sql | mysql -u root -p your_database_name

gunzip < your_dump_file.sql | mysql -u root -p your_database_name

The command above assumes that you would to restore a database named “your_database_name” from a backup sql dump file named: “your_dump_file.sql” with Mysql root account.

Note: you should be asked to enter your mysql account password, once you enter the password just key in your database password and you are done after minutes 🙂

If you need to know how to backup your mysql database, read this post.

Mar 6, 2011Hoan Huynh
MySql backup database with gzip compressionFree service auto post to Facebook,Twitter,Google Buzz and LinkedIn
You Might Also Like:
  • MySql backup database with gzip compression
  • MySQL dump table
  • Schedule Backup And Zip MySQL Database In Windows
  • Linux Find Out PHP/ MySQL/ MySQLD/ HTTPD … Command File Location
  • Install LAMP (Apache, MySQL and PHP in Linux) on CentOS
  • Change or reset MySQL Root Account Password
  • MySQL Incorrect Data Type Value In Column
  • PHP Store Session In MySQL Database
  • Free Mysql Profiler similar to Microsoft SQL Server Profiler – LogMonitor
  • PHP Load Facebook Albums And Save To MySQL Database
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago MySQLgunzip, gzip, restore database2,035
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,646 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,940 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,833 views
JQuery Allow only numeric characters or only alphabet characters in textbox
15,125 views
C# Read Json From URL And Parse/Deserialize Json
11,859 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development