Backup as separate tables


#1

I want the backup to be done, not as one big sql file holding all-tables info, but one file for each table. I don’t see a setting for that. Pls advise.


#2

Hi Anees_Khan,

Could you please clarify what server type do you backup?


#3

server type is linux. DB type is mysql.


#4

Hi Anees_Khan,

Thank you for the clarification.

SQLBackupAndFTP creates backups of MySQL Server databases via mysqldump.exe. To backup only one table from your database please go to the “MySQL Backup Options” window and use --ignore-table=db_name.tbl_name command at the “Extra command line parameters” box.


Please find more details at https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_ignore-table

Sorry for the inconvenience.