Category Archives: MySQL

How to import a compressed mysql file .sql.gz using linux shell?

Login into your server using a shell program like putty. Type in the following command on the command line zcat DB_File_Name.sql.gz | mysql -u username -p Target_DB_Name where DB_File_Name.sql.gz = full path of the sql.gz file to be imported username … Continue reading

Posted in MySQL | Leave a comment