Restore backup according to specified table

charmfeel's profile image charmfeel posted 12 months ago in General Permalink

The imported SQl backup file sometimes has a database backup size of 4GB, and the entire restore sometimes takes an hour too long. Actually, I only want the data of one of the tables. Can I specify that only the required tables should be restored during the restore, but can I skip it?

ansgar's profile image ansgar posted 12 months ago Permalink

You can achieve that when you create the backup, by selecting the table you want to restore later. In HeidiSQL's SQL export window, you can use the checkboxes on the right tree to select/deselect tables.

Please login to leave a reply, or register at first.