Title: Cannot restore Database Files (using PHPmyAdmin) Last modified: August 22, 2016 --- # Cannot restore Database Files (using PHPmyAdmin) * Resolved [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 6 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/) * used BackupWordpress to do backups, placing my latest one in Dropbox. Computer crashed, where the soon to be active website is located. Lost all data, had to format HD and redo (Win7-64bit. Now, when I try to restore the files, I first replace the System Files – “includes, admin and content”, then, when I try to restore db through PHPmyAdmin, I follow the procedure, but it runs for about 30-50 seconds and then I get a “page can’t be displayed” error. The DB from the backup does not load, what am I missing? Please help! Thanks, Russ * [https://wordpress.org/plugins/backupwordpress/](https://wordpress.org/plugins/backupwordpress/) Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Contributor [Paul de Wouters](https://wordpress.org/support/users/pauldewouters/) * (@pauldewouters) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566432) * It seems like your phpMyAdmin process is timing out. You’ll have to contact your hosting provider about the issue. * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566434) * it is on a LocalHost not with a Provider * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566437) * NOT RESOLVED – poor help from developer, spent weeks waiting for a response, went direct to the maker, no real help. Backup/website lost. Live and learn, use something else! * Plugin Author [cuvelier](https://wordpress.org/support/users/cuvelier/) * (@cuvelier) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566439) * Hey Russ, * I’m sorry you’ve been having a frustrating experience. * I am actually still awaiting a reply from you from an email I sent you. * As Paul mentioned, phpMyAdmin is timing out, the SQL file is working fine as I was able to import it without any issues. * I’m not sure how you’re hosting your sites locally, but it’s a very broad issue, and somewhat outside the scope of BackUpWordPress. * If you’d like to reply to my email perhaps I can help you with your local hosting environment. * All the best, Owain * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566440) * As I mentioned, the website was in development and not hosted by anyone, except on my computer, still being made. Lost my Windows 7 install and reformatted HD, then tried to backup the development (website) on my computer and found I could not. Dropbox had a copy of the most recent backup. * Plugin Author [cuvelier](https://wordpress.org/support/users/cuvelier/) * (@cuvelier) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566441) * Hey Russ, * I understand you lost your local setup. I know what a pain that can be. * But there’s (more then likely) something wrong with how you’re running your sites locally. Not with BackUpWordPress’s backup. * If you tell me how you’ve setup your server stack locally. Is it an IIS setup? Or are you using a MAMP stack or similar? * Cheers, Owain * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566442) * I didn’t do anything different from the last installation, it’s through Bitnami WordPress Stack, I’ve tried installing the original plugins, replacing the Contents, Admin and Includes files and then going into phpMyAdmin to update, and, as I provided to you, in previous emails (my attached screenshots), the db times out and the “page not displayed” comes up. I am following directions and coming up with this error, even though the Install of Bitnami WP Stack is clean, the import doesn’t like the Admin/Includes or Content file I’ve replaced and is timing out. I can provide a link to the Dropbox Backup, if you like–have a look at the Backup * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566452) * so…you guys haven’t responded in a while, although it was the holidays. Anyway, I have most of the backup, I think, installed, the issues now are: there is lots of wp-postdata in phpmyadmin, but, no WooCommerce products (there were about 1500) and no Pages (about 30+)on the localhost site. I see lots of data, the sql file has not sewn it all together. Any suggestions? or that I may have missed? or anything I could supply for a look-see? thanks Russ * Plugin Author [Tom Willmot](https://wordpress.org/support/users/willmot/) * (@willmot) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566455) * Hey Russ, * phpMyAdmin timing out is an issue with your phpMyAdmin setup, likely your local server (The Bitnami Stack you mention) either doesn’t have enough memory or is hitting a timeout before phpMyAdmin can finish importing the backup. * There’s plenty of help available through Google on how to work around those issues in phpMyAdmin (e.g. [http://stackoverflow.com/questions/20264324/how-to-import-1gb-sql-file-to-wamp-phpmyadmin](http://stackoverflow.com/questions/20264324/how-to-import-1gb-sql-file-to-wamp-phpmyadmin)) * Resolving this as it’s not an issue with BWP. * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566456) * Thanks Tom, looked at your link, trying SQLyog right now, thanks for the communication on this matter. * Plugin Author [Tom Willmot](https://wordpress.org/support/users/willmot/) * (@willmot) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566457) * Excellent, hope you are able to get it working 🙂 * Thread Starter [Russdb705](https://wordpress.org/support/users/russdb705/) * (@russdb705) * [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566458) * SUCCESS!!!!!!!!!!!!!! thank you for your links and feedback, I am so happy this is back up. I appreciate your help. Thank you, thank you! Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Cannot restore Database Files (using PHPmyAdmin)’ is closed to new replies. * ![](https://ps.w.org/backupwordpress/assets/icon-256x256.jpg?rev=1105225) * [BackUpWordPress](https://wordpress.org/plugins/backupwordpress/) * [Frequently Asked Questions](https://wordpress.org/plugins/backupwordpress/#faq) * [Support Threads](https://wordpress.org/support/plugin/backupwordpress/) * [Active Topics](https://wordpress.org/support/plugin/backupwordpress/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/backupwordpress/unresolved/) * [Reviews](https://wordpress.org/support/plugin/backupwordpress/reviews/) ## Tags * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * 12 replies * 4 participants * Last reply from: [Russdb705](https://wordpress.org/support/users/russdb705/) * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/cannot-restore-database-files-using-phpmyadmin-1/#post-5566458) * Status: resolved