Restore / selects tables to restore


#1

Hello, if it is possible to only restore some tables? Could we select that tables who should be restored?
And could we only place that restore content without override that table?
For example we want only restore old content of table but we not want delete that content who is now inside table.


#2

Hi Sebastian_Linge,

Could you please clarify what database’s server do you backup? Is it MSSQL, MySQL or PostgreSQL?


#3

Hi Alexander,
We have the same need on PostgreSQL database.


#4

Hello Atmo,

Thank you for the clarification.

Sorry, but there is no way to restore just one table, but you can backup the needed table and then restore it. You can find that setting at the “PostgreSQL Backup Options”.

Sorry for the inconvenience.


#5

Is it not possible to do a
pg_restore --data-only --table= tablename
equivalent ?

As we don’t know at backup time wich table we’ll need to restore !


#6

Hi Atmo,

Sorry, but there is no way to do it via SQLBackupAndFTP, but you can issue a restore manually.

Sorry for the inconvenience.


#7

Any chance to see it in future version ?


#8

Currently, we do not have plans to add this option, but we have forwarded this request to our dev team for consideration.

Thank you.