Luigi123 Posted June 24, 2016 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
Guest Marko30 Posted June 24, 2016 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
Luigi123 Posted June 29, 2016 Author 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
wolstech Posted June 29, 2016 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.
Luigi123 Posted June 29, 2016 Author 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.
wolstech Posted June 29, 2016 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.
Luigi123 Posted June 30, 2016 Author Posted June 30, 2016 How can I backup my Fourms Website files and my Sourcebans Website files?
wolstech Posted June 30, 2016 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.
Luigi123 Posted June 30, 2016 Author Posted June 30, 2016 Alright, so, which one do I click? Backups or Backup Wizard?
wolstech Posted June 30, 2016 Posted June 30, 2016 I usually use backups, then select the option for full backup.
Luigi123 Posted June 30, 2016 Author Posted June 30, 2016 Alright, I will try it.Alright, I've backup all my files using Home Directory. What next?
wolstech Posted June 30, 2016 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.
Luigi123 Posted July 1, 2016 Author Posted July 1, 2016 Alright, I've download it all my files into my Laptop after I have backup. Now, what next?
Guest Marko30 Posted July 1, 2016 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.
Recommended Posts