locked
How to take back up of mysql database excluding specific tables RRS feed

  • Question

  • User-1621255906 posted

    Hello team,

        How to take backup of mysql database excluding specific tables

    Regards,
    Pravnitz

    Monday, December 5, 2011 3:05 AM

Answers

  • User-1621255906 posted

    Hi,

        glad.... I could sort it off...


    Tried the script:

    mysqldump -u [user_name] -p[password] --ignore-table=db_name.table1 --ignore-table=db_name.table2 db_name > locationtobackup\fileName.sql

    Regards,
    Pravnitz

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, December 5, 2011 3:08 AM