MySQL DB Backup

  • I am moving from a server that has the WP DB to a new server. I have had to backup the WP DB before but was never able to restore the complete DB. I use phpmyadmin for DB backup. So, my question is how do i backup the whole DB so i can restore that exact DB back to the new server with mysql? Here are the phpmyadmin SQL options for backup:
    SQL options
    Add custom comment into header (\n splits lines):
    Enclose export in a transaction
    Disable foreign key checks
    Structure:
    Add DROP TABLE
    Add IF NOT EXISTS
    Add AUTO_INCREMENT value
    Enclose table and field names with backquotes
    Add into comments
    Creation/Update/Check dates
    Data:
    Complete inserts
    Extended inserts
    Use delayed inserts
    Use ignore inserts
    Use hexadecimal for binary fields
    Export type:

  • The topic ‘MySQL DB Backup’ is closed to new replies.