Dumping large live database

Dumping a large database while it is live requires a slightly different command

mysqldump –single-transaction very_large_db > bakup_of_db.sql

This dumps the database (or table) at a point in time while not locking the database

Ref: here

Advertisements
  • Calendar

    • November 2017
      M T W T F S S
      « Dec    
       12345
      6789101112
      13141516171819
      20212223242526
      27282930  
  • Search