How to take back up of mysql database excluding specific tables RSS

• • Reply
  

  Sincuabator

  Member

  106 Points

  47 Posts

  How to take back up of mysql database excluding specific tables

  Dec 05, 2011 07:05 AM|LINK

  Hello team,
  
      How to take backup of mysql database excluding specific tables

  Regards,
  Pravnitz

• • Reply
  

  Sincuabator

  Member

  106 Points

  47 Posts

  Re: How to take back up of mysql database excluding specific tables

  Dec 05, 2011 07:08 AM|LINK

  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 Sincuabator on Dec 05, 2011 07:08 AM