How to clean SQL datebase

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Alternativa
Registered User
Posts: 102
Joined: Mon Dec 01, 2008 5:26 pm
Location: Croatia
Contact:

How to clean SQL datebase

Post by Alternativa »

Is there any easy way of cleaning SQL datebase of all changes that mods have made?

I would like to transfer my datebase to clean phpbb3 install.
Last edited by AdamR on Sat Aug 08, 2009 11:38 pm, edited 1 time in total.
Reason: Topic icon changed

User avatar
AdamR
Former Team Member
Posts: 9731
Joined: Tue Mar 02, 2004 5:40 pm
Location: Tampa, Florida
Name: Adam Reyher
Contact:

Re: How to clean SQL datebase

Post by AdamR »

Having extra tables unused really should not effect performance of your board and will basically just sit there. To remove all MODs from the files:
  • Be sure you have a backup of your phpBB Files and database (ACP > Maintenance > Backup > Choose to download the file). If you are unable to get into the Admin Panel, see the "Database Backup" section of this article
  • Delete all of your phpBB files except config.php, images/, files/, and styles/
  • Upload a fresh copy of the phpBB 3.0.5 files except config.php, images/, and files/
  • Point your browser to install/database_update.php. If it completes successfully, delete the install/ folder.
  • Before viewing the board again, ensure that there is nothing but index.htm and .htaccess in the cache/ folder.
You may also want to grab the latest version of your style and upload that to ensure you have any and all changes in 3.0.5.

- Adam
phpBB Support: Welcome | Userguide | Knowledge Base | Search
Honored supporter of the phpBB Group!
"If I have seen a little further it is by standing on the shoulders of Giants." - Isaac Newton

User avatar
Alternativa
Registered User
Posts: 102
Joined: Mon Dec 01, 2008 5:26 pm
Location: Croatia
Contact:

Re: How to clean SQL datebase

Post by Alternativa »

Thanks.

User avatar
Alternativa
Registered User
Posts: 102
Joined: Mon Dec 01, 2008 5:26 pm
Location: Croatia
Contact:

Re: How to clean SQL datebase

Post by Alternativa »

I have done it all.
No errors and board is runing.
Datebase has been updated with NO errors.


I have found how to remove modules. :D

Locked

Return to “[3.0.x] Support Forum”