WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Can I rebuild missing database from local WordPress folder? (10 posts)

  1. silvergenes
    Member
    Posted 1 year ago #

    I created a local WordPress site on my Mac using Mamp, the database created through phpmyadmin. The Mac crashed completely and I could not connect to export the database from Mamp but I was able to get the local WordPress folder off the hard drive. I'm now on a PC with Windows 7 and installed Wamp. I created a new database with exactly the same information as in WP config but the database is empty. I can see the files for the tables inside the folder. Is there any way this can be rebuilt? Can I copy the table files somehow into Wamp? Absolutely any ideas would be welcome!
    Yes, I'm desperate! I have to get this site up fast!

  2. ALVAW3
    Member
    Posted 1 year ago #

    clarify what you mean by I can see the tables in the files... do you mean to say you have a .sql file? if so that is all you need.

    If you do not have the .sql backup of the database you will not be able to rebuilt it with the WordPress core files unfortunately.

    Let me know if that is helpful. :)

  3. silvergenes
    Member
    Posted 1 year ago #

    Unfortunately, I don't have an .sql file. It would be on the Mamp server, because I didn't back it up before the crash. Within the local folder I can see several table files so thought perhaps there was a chance. I'm bypassing Wamp entirely at this point and trying a few things on Bluehost.

    This is probably a silly question but do you think it might work if I copied the WordPress local folder to another Mac and created the same settings in a new Mamp setup?

  4. ALVAW3
    Member
    Posted 1 year ago #

    no that wont work. Basically nothing can replace the database that was deleted. This will require a rebuild or a backup from Bluehost. I believe they can provide you one if it is shared hosting but there may be a cost associated with it.

  5. silvergenes
    Member
    Posted 1 year ago #

    It was never uploaded to Bluehost. I was working on my Mac so had everything in a local file and used Mamp as the server. It sounds like it's going to be a rebuild. I thought perhaps if I recreated the exact same settings in Mamp on a borrowed Mac that it might work.

  6. ALVAW3
    Member
    Posted 1 year ago #

    No I do wish I could say it would... unfortunately today I have to bear you this bad news. However there is hope and here is a link to some info you might enjoy about the WordPress backups.

    http://codex.wordpress.org/WordPress_Backups

  7. silvergenes
    Member
    Posted 1 year ago #

    Thank you. It's going to be a busy week.

  8. michael.mariart
    Member
    Posted 1 year ago #

    There are some ways to do this. As an example, here's some questions from people that are trying to do the same thing:

    http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files

    http://ailoo.net/2011/03/restore-mysql-databases-from-raw-frm-files/

    While I believe that it can work, it doesn't look like it's an easy thing to do, and gets very geeky very quickly.

    As much as it's bad to say, this is a good lesson in why a good backup system is a required part of any website.

  9. silvergenes
    Member
    Posted 1 year ago #

    Absolutely! And dont keep it on the computer either. Im going to see if I can set up my salvaged hard drive from the Mac as an external device and with luck, may be able to find the database in the Mamp app files and export it.

    Thanks very much for the links! Ill be having a look at those too. At this point, Im willing to try no matter how geeky.

  10. silvergenes
    Member
    Posted 1 year ago #

    Just in case anyone else is in the same situation one day, I solved it by finding the Mamp file folder on the Mac HD and copying the table files to Windows. I set up Wamp on windows and imported the files to create the database. Exported the database and it worked. Much easier though to backup somewhere other than the computer! Lesson learned.

Topic Closed

This topic has been closed to new replies.

About this Topic