[DiscordArchive] isn't that where all the databases are stored?
[DiscordArchive] isn't that where all the databases are stored?
Archived author: Jinnai • Posted: 2021-09-18T15:58:18.719000+00:00
Original source
if everything fails, you might have to recreate your database ;D
Archived author: Jinnai • Posted: 2021-09-18T15:58:35.376000+00:00
Original source
anyway, cant assist any further, i have a empty fridge and therefore have to go shopping now
Archived author: Sanctuary • Posted: 2021-09-18T15:59:04.003000+00:00
Original source
thank you for your help
Archived author: KingPin • Posted: 2021-09-18T15:59:12.901000+00:00
Original source
you are welcome.
Archived author: <o> • Posted: 2021-09-18T15:59:41.569000+00:00
Original source
you can create a new fresh database from source, dump both the fresh and your current one, compare the sql output, re-query the differences
Archived author: Sanctuary • Posted: 2021-09-18T15:59:42.955000+00:00
Original source
can i force stop the query? It seems to be going no where.
Archived author: <o> • Posted: 2021-09-18T16:01:18.493000+00:00
Original source
if you didn't specify a transaction, that can cause half-written data
Archived author: Sanctuary • Posted: 2021-09-18T16:04:00.447000+00:00
Original source
ok, so dump the item_template before i run the sql file this time?
Archived author: Sanctuary • Posted: 2021-09-18T16:04:08.823000+00:00
Original source
to delete the half-written data?
Archived author: <o> • Posted: 2021-09-18T16:04:35.013000+00:00
Original source
if you're rebuilding item_template, yes, you'll likely have to nuke it to avoid errors