Luigi123 Posted June 24, 2016 Share Posted June 24, 2016 Hello,Is there a problem with Stevie or it's just me? Screenshots:1: Forums Website:https://www.dropbox.com/s/fcb79f29rp3140g/Forums%20Website.PNG?dl=0 2. Sourcebans Website:https://www.dropbox.com/s/22lkpu1lcjl79e9/Sourcebans%20Website.PNG?dl=0 Link to comment Share on other sites More sharing options...
Guest Marko30 Posted June 24, 2016 Share Posted June 24, 2016 Delete database users and recreate them again. Also, if you can't access phpMyAdmin, change your cPanel password (tick Synchronize MySQL password). 1 Link to comment Share on other sites More sharing options...
Luigi123 Posted June 26, 2016 Author Share Posted June 26, 2016 Alright, I will try it. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 29, 2016 Author Share Posted June 29, 2016 I've done what you said, but, it's still not working. Screenshots:1. Forums Websitehttps://www.dropbox.com/s/5fmb2x72ty2yo7k/Forums%2002.PNG?dl=0 2. Sourcebans Website:https://www.dropbox.com/s/3flquv3qeqcb9qk/Sourcebans%2002.PNG?dl=0 Link to comment Share on other sites More sharing options...
wolstech Posted June 29, 2016 Share Posted June 29, 2016 The data got lost. Everyone who had InnoDB tables in their databases lost their data. Drop the database, then create a new database with a different name. Restore your backups into that database using PhpMyAdmin. Then assign the user you already recreated to the new database, and edit your software's config file to use the new database name. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 29, 2016 Author Share Posted June 29, 2016 Do I have to reinstall my Forums Website and my Sourcebans Website after I have Create new Database with different name? Or, I don't have too. Link to comment Share on other sites More sharing options...
wolstech Posted June 29, 2016 Share Posted June 29, 2016 If you restore a backup and edit the config files, you won't need to, since the software will look in the new database, see the data it expects, and know it is already installed. If you don't have a backup, then yes. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 30, 2016 Author Share Posted June 30, 2016 How can I backup my Fourms Website files and my Sourcebans Website files? Link to comment Share on other sites More sharing options...
wolstech Posted June 30, 2016 Share Posted June 30, 2016 You can back up your entire account in cpanel. There's an option for a full backup, which includes files, databases, and other data. You can also just make a home directory backup if you want just the files. Note that making a backup now will not allow you to restore the lost databases. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 30, 2016 Author Share Posted June 30, 2016 Alright, so, which one do I click? Backups or Backup Wizard? Link to comment Share on other sites More sharing options...
wolstech Posted June 30, 2016 Share Posted June 30, 2016 I usually use backups, then select the option for full backup. Link to comment Share on other sites More sharing options...
Luigi123 Posted June 30, 2016 Author Share Posted June 30, 2016 Alright, I will try it.Alright, I've backup all my files using Home Directory. What next? Link to comment Share on other sites More sharing options...
wolstech Posted June 30, 2016 Share Posted June 30, 2016 It's a backup...there should be an archive to download containing the files. A backup will not fix your website unless it was made before the crash. If you don't have a backup from before the crash, you have to start over. Link to comment Share on other sites More sharing options...
Luigi123 Posted July 1, 2016 Author Share Posted July 1, 2016 Alright, I've download it all my files into my Laptop after I have backup. Now, what next? Link to comment Share on other sites More sharing options...
Guest Marko30 Posted July 1, 2016 Share Posted July 1, 2016 Go to phpMyAdmin, in right sidebar click on + near your cPanel username and then click on new database that you created and want to restore. After that, click on Import tab, select backup file, uncheck Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. and click on Go. Your database should be restored now. If you need to restore another database, repeat same steps. After you have restored all databases, open the config file and enter new database name and password. That's it. Link to comment Share on other sites More sharing options...
Recommended Posts