show progress on MySQL DB Import

You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with:

yum install pv

# pv db1.sql.gz | gunzip | mysql -u root -p db1
  693MiB 1:00:33 [ 325kiB/s] [====================>              ] 68% ETA 0:16:20



Related Posts

  • 48
    What is database? Database is an organized collection of information about an entity having controlled redundancy and serves multiple applications. DBMS (database management system) is an application software that is developed to create and manipulate the data in database. A query language can easily access a data in a database.…
    Tags: database, mysql, db
  • 41
    To learn more about what is binary log and how to setup Click here MySQL binary log : mysqlbinlog utility mysqldump – MySQL Database Backup and restore program Purge Binary log MySQL Master-Master-Slave-Slave Replication Database Recover from MySQL binary log: Binary logs store all the queries (in STATEMENT format) or…
    Tags: database, mysql, db
  • 32
    MySql export schema without data Login to DB server Run the below command to take backup of schema of database without data. # mysqldump -u root –p  -d olddb > backup.sql OR # mysqldump -u root -p --no-data dbname > schema.sql    
    Tags: root, database, mysql, db
  • 31
    SHOW GLOBAL VARIABLES LIKE 'storage_engine'
    Tags: database, mysql, db
  • 30
      [root@mysqlDB]# mysqladmin -u root -p create eduguru Enter password:****** This will create a MySQL database eduguru. This is a simple example to create database called eduguru. Example: <?php $dbhost = 'localhost:3036'; //If mysql server is on same server $dbuser = 'root'; //mysql user who has the permission to create database $dbpass…
    Tags: database, mysql

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: