Sunday, May 23, 2010

Restore compressed backup files (MYSQL)

the commandline is :

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

** if you dump file bz2 you can use bunzip2

1 comment: