How to Import a Compressed MySQL Database From bz2 Format

gintautas Linux

If you have a compressed MySQL database in bz2 format that you need to import, just do the following:

bunzip2 < db_filename.sql.bz2 | mysql -u root -p target_db_name