WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Restoring from Back up using Humanmade's backup and restore (5 posts)

  1. focusfitness
    Member
    Posted 1 year ago #

    Hi

    I used the Human Made backupwordpress plugin and I’ve been trying to restore for a while, gave up and I’m back at it. I think I’m on the right track based on following closely all the steps in Human Made’s short guide to restoring from backup.

    My question is, when restoring the database using phpmyadmin, what should the database file extension look like? I was using an SQL file extension and was getting error messages. I came across a posting for somebody else’s question making reference to the fact that it should be a php file extension. Can anyone tell me if the following may be the database I have to use (from the wp-contents folder)

    Would it be any of the following?:

    From this path:
    1. WP-contents folder - Plugins folder – backupwordpress folder - hm-backup folder: hm-backup.php (29KB) – is this the file and should it be this small (I didn’t have much content on my site)
    database_wp_focusfitnessandsports_com.sql – I assume this would not be the one as it is the one I’ve been trying to import into phpmyadmin with no success.

    |My blog is focusfitnessandsports.com/blog

    Thanks in advance for any insight anyone will provide.

    All the best,
    Stephen

  2. focusfitness
    Member
    Posted 1 year ago #

    This is the actual message I get when I try to import my database:

    Error

    SQL query:

    #
    # Data contents of table wp_em_bookings (1 records)
    #
    INSERT INTO wp_em_bookings
    VALUES ( 1, 4, 1, 1, '', 2011 -07 -1910 :11 :35, 0, '0.00', NULL ) ;

    MySQL said: Documentation
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '10:11:35, 0, '0.00', NULL)' at line 1

    Thanks for any help anyone can provide. I'm looking for a simple solution if possible. Thanks

  3. Svetoslav Marinov
    Member
    Posted 1 year ago #

    Hi Stephen,

    Here is what I would do when starting the backup restore process.

    • Wait until the site doesn't get lots of traffic. Let's say after 9pm
    • Connect using FTP client and move all the existing files from your site to a folder called old-2013-01-01 (or whatever the date is).
    • On your computer unzip backups
    • Upload the files
    • Go in phpmyadmin, select database and then click on import and select the exported .sql file.

    Good luck,
    Slavi
    http://orbisius.com

  4. focusfitness
    Member
    Posted 1 year ago #

    Hi Slavi,

    First and foremost thanks for sharing your insight.

    I'll give it a shot and see if that may resolve the issue. I will post how it went.

    Thanks again!
    Stephen

  5. focusfitness
    Member
    Posted 1 year ago #

    Hi Slavi,
    I wasn't successful when I tried this before, most likely due to me not doing it properly.

    Fortunately Tom Wilmont, who is the plugin author for backupwordpress, http://hmn.md/humans/, resolved the problem by looking at the specific error and correcting it.

    Thanks Slavi and Thank you Tom!

    Wishing you the very best, always.
    Stephen

Topic Closed

This topic has been closed to new replies.

About this Topic