show progress on MySQL DB Import

Rate this post

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
  • 35
    The mysqli_connect() function opens a new connection to the MySQL server. Syntax: mysqli_connect(host,username,password,dbname,port,socket); Parameter Description host Specifies a host name or an IP address username Specifies the MySQL username password Specifies the MySQL password dbname Optional. Specifies the default database to be used port Optional. Specifies the port number to…
    Tags: mysql, pipe, database, db
  • 32
    For this process We should noted that there must have the same architecture on both machines. I.e. if we have 32 bit on one server then other server would also have 32 bit. But in case if we have 32 bit on one server and 64-bit on another then we will have to…
    Tags: mysql, database, dump
  • 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

Leave a Reply

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

%d bloggers like this: