Author Topic: restoring database from zip file using ssh (mysql)  (Read 3872 times)

Anay

  • Newbie
  • *
  • Posts: 32
restoring database from zip file using ssh (mysql)
« on: December 19, 2011, 06:01:00 AM »
Hi

I have database backup which is .zip format and now I need to restore it to a database. I know how to do it for simple sql file but I don't know how to do it diretly from zip file. I can uncomress it and then restore it but I want to do it in one line.

For simple upload ie. uncompress file I do like this :
Code: [Select]
mysql -u user -ppassword -D databasename < backupfile.sql

How can do it directly ie uncompressing and restoring both at same time..

 

X

Do you know?

By participating in our community you can get free top level domain as well learn about Search Engine Optimization, Server management and more..
Join Now!