Follow SMF on Twitter.
Started by Hatshepsut, September 01, 2018, 02:41:49 AM
Quote from: Hatshepsut on September 01, 2018, 02:41:49 AMБих искал да разбера как да се прочисти базата данни след ъпгрейда. Има ли предвидена някаква процедура в админ панела за прочистване на базата данни от архивните записи или пък някакъв инструмент в cPanel?
Quote from: Hatshepsut on September 11, 2018, 12:50:10 AMThat's no errors, upgrader just has duplicated all database records, adding "backup" prefix:...
Quote from: GigaWatt on September 11, 2018, 07:53:48 PMQuote from: Hatshepsut on September 11, 2018, 12:50:10 AMThat's no errors, upgrader just has duplicated all database records, adding "backup" prefix:...Well, that's basically the backup. If you want to download just the backup of the database, in phpMyAdmin select those tables that have the "backup" prefix in them, go to the Export tab and export them. You'd get a clean backup of your database, but if you'd want to restore that backup, you'd have to upload that dump in a clean database and remove the prefix "backup" in all of the tables. You could actually do that now by exporting the backup (explained previously), define a new database in cPanel, upload the database dump with the "backup" prefixes in that newly created database, rename the tables (remove "backup" in the name of the tables) and export that newly created database . You can delete the newly created database afterwards.In any case, you should have done a manual database and files backup before doing the upgrade. Sure, the upgrade procedure does offer this option, but it's not recommended to use it since the best and most secure way SMF could do this is what it actually did - create a duplicate of all of the tables with a different name (adding "backup" in the name of the tables) within the same database.