Home / server / Questions / 156423
Accepted
Charles Faiga
Asked: 2010-07-01 11:34:16 +0800 CST

Restoring a Mysql database that is 7zip

  • 772

I use

Mysqldump –u root –ppassword databasename | 7z a -si -t7z outputfile.sql.7z -mx9

To backup my Mysql 5.1 database on my windows vista system.

Question:

How can I restore the database without first having to expand the 7zip file?

mysql backup-restoration

1 Answers

  1. Best Answer

    I am not that familar with the 7zip command line but I suspect you would do something like this.

    7z e -so outputfile.sql.7z | mysql -u username -p databasename
    • 3