[DiscordArchive] is there a way to reset databases if i applied some unwanted sql changes?
[DiscordArchive] is there a way to reset databases if i applied some unwanted sql changes?
Original source
is there a way to reset databases if i applied some unwanted sql changes?
rektbyfaith
05-20-2022, 07:21 AM #1Archived author: Schizoi6 • Posted: 2022-05-20T07:21:39.264000+00:00
Original source
is there a way to reset databases if i applied some unwanted sql changes?
Original source
There is no one-step-back function for SQL dbs.
You want to save all your custom changes as re-applicable SQL files, e.g. with DELETE and INSERT, and store them in your "custom" folder. That way they're re-applied after every core-update automatically.
And if you drop your database because of corruption or mistakes, it's gonna be re-created full automode.
rektbyfaith
05-20-2022, 07:36 AM #2Archived author: Honey • Posted: 2022-05-20T07:36:31.932000+00:00
Original source
There is no one-step-back function for SQL dbs.
You want to save all your custom changes as re-applicable SQL files, e.g. with DELETE and INSERT, and store them in your "custom" folder. That way they're re-applied after every core-update automatically.
And if you drop your database because of corruption or mistakes, it's gonna be re-created full automode.
Original source
how do I drop my database?
rektbyfaith
05-20-2022, 07:37 AM #3Archived author: Schizoi6 • Posted: 2022-05-20T07:37:16.858000+00:00
Original source
how do I drop my database?
Original source
I don't mind losing my changes
rektbyfaith
05-20-2022, 07:37 AM #4Archived author: Schizoi6 • Posted: 2022-05-20T07:37:24.514000+00:00
Original source
I don't mind losing my changes
Original source
assuming you use heidisql or mysql workbench, right click it and select `drop scheme`
rektbyfaith
05-20-2022, 07:40 AM #5Archived author: Honey • Posted: 2022-05-20T07:40:06.740000+00:00
Original source
assuming you use heidisql or mysql workbench, right click it and select `drop scheme`
Original source
alright
rektbyfaith
05-20-2022, 07:40 AM #6Archived author: Schizoi6 • Posted: 2022-05-20T07:40:32.044000+00:00
Original source
alright
Original source
thank you
rektbyfaith
05-20-2022, 07:40 AM #7Archived author: Schizoi6 • Posted: 2022-05-20T07:40:35.556000+00:00
Original source
thank you