[DiscordArchive] I am just getting started with backup/restore testing. Keeping it pretty simple currently. HeidiSQL
[DiscordArchive] I am just getting started with backup/restore testing. Keeping it pretty simple currently. HeidiSQL
Original source
I am just getting started with backup/restore testing. Keeping it pretty simple currently. HeidiSQL > [Backup] Export database as SQL / [Restore] Run SQL file. For the export, should I just set it to replace, assuming I am doing a full restore?
rektbyfaith
10-05-2023, 10:49 PM #1Archived author: LightsaberTrix • Posted: 2023-10-05T22:49:13.020000+00:00
Original source
I am just getting started with backup/restore testing. Keeping it pretty simple currently. HeidiSQL > [Backup] Export database as SQL / [Restore] Run SQL file. For the export, should I just set it to replace, assuming I am doing a full restore?
Original source
For the export I just set it to drop and create the tables and use inserts. Doesn't make sense to me to replace into new tables or even worse not to export the tables along with the data.
rektbyfaith
10-05-2023, 11:11 PM #2Archived author: Revision • Posted: 2023-10-05T23:11:39.639000+00:00
Original source
For the export I just set it to drop and create the tables and use inserts. Doesn't make sense to me to replace into new tables or even worse not to export the tables along with the data.
Original source
I tried Create Database + Create Table(s) + Data Insert. But on a restore test I got an error 1062 duplicate entries and I noticed tables like realmlist didn't update. My last test with Data Replace gave me a 1:1 match. File sizes are larger and it seems a bit overkill.
Your recommendation is setting Data to Delete + Insert (2nd option)?
![[Image: image.png?ex=690bdc47&is=690a8ac7&hm=e1b...c36344f22&]](https://cdn.discordapp.com/attachments/369084351129845760/1159631808137269268/image.png?ex=690bdc47&is=690a8ac7&hm=e1b052721805059d577ec61a9cff81c49218d26ba4d13e955af573ac36344f22&)
rektbyfaith
10-05-2023, 11:22 PM #3Archived author: LightsaberTrix • Posted: 2023-10-05T23:22:48.032000+00:00
Original source
I tried Create Database + Create Table(s) + Data Insert. But on a restore test I got an error 1062 duplicate entries and I noticed tables like realmlist didn't update. My last test with Data Replace gave me a 1:1 match. File sizes are larger and it seems a bit overkill.
Your recommendation is setting Data to Delete + Insert (2nd option)?
Original source
Yes, I select drop and create tables and use insert. That is, when I need to do a manual export which is extremely rare.
rektbyfaith
10-05-2023, 11:24 PM #4Archived author: Revision • Posted: 2023-10-05T23:24:20.429000+00:00
Original source
Yes, I select drop and create tables and use insert. That is, when I need to do a manual export which is extremely rare.
Original source
The idea is to be able to import the database as it was and still be able to update it straight away.
rektbyfaith
10-05-2023, 11:26 PM #5Archived author: Revision • Posted: 2023-10-05T23:26:31.836000+00:00
Original source
The idea is to be able to import the database as it was and still be able to update it straight away.
Original source
Thanks for the help!
rektbyfaith
10-05-2023, 11:30 PM #6Archived author: LightsaberTrix • Posted: 2023-10-05T23:30:05.011000+00:00
Original source
Thanks for the help!