Hello all,
New to posting here as we’ve generally not had any issues with our use of SQLBackupAndFTP. currently struggling with the following though:
I’m performing a full backup of a database which has a number of columns across a number of tables set as utf8mb4 character set.
When I don’t specify an ‘Extra command line parameters’ and the default character set utf8 is used the full backup completes in let’s say 1 hour (but with ??? replacing some of the utf8mb4 characters upon restoration).
In an attempt to capture those characters fully I’m faced with an issue when adding the extra command line parameters of:
–default-character-set=utf8mb4
The full backup then ‘completes’ within about 30 seconds having only attended to the first table and it’s 5 columns (3 of which are utf8mb4).
For what it’s worth in terms of further information - I have two jobs configured on the latest version of SQLBackupAndFTP (12.7.27):
1 - is the full backup without extra command line parameters that is successful except for the utf8mb4 characters
2 - is the mirror job of job 1 but with the extra command line parameter and a local (to the SQLBackupAndFTP installation) storage location.
I am stumped. Can anyone provide any insight on why only the first table is backed up and/or next steps in performing a full backup with utf8mb4 character set?
Thank you
