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

    • September 2017
      M T W T F S S
      « Dec    
       123
      45678910
      11121314151617
      18192021222324
      252627282930  
  • Search