Normally We are exporting and Importing Mysql database using .sql format.It's exporting and importing process speed depend on size of Database.But while using compress format increase the speed of export.
Use of gzip we can increase speed of import and export process of mysql databases.
For Export Database
mysqldump -uroot -p database_name | gzip -v > database_name.sql.gz
For Import Database
zcat database_name.sql.gz | mysql -uroot -p database_name
These comments very useful for database size is very large.
Use of gzip we can increase speed of import and export process of mysql databases.
For Export Database
mysqldump -uroot -p database_name | gzip -v > database_name.sql.gz
For Import Database
zcat database_name.sql.gz | mysql -uroot -p database_name
These comments very useful for database size is very large.
