WordPress.org

Ready to get started?Download WordPress

Forums

How to backup database if website is offline? (8 posts)

  1. xmizer
    Member
    Posted 1 year ago #

    Long story short: I tried to change hosts from Dreamhost to another host and I'm making a lot of mistakes.

    My wordpress files are still saved with Dreamhost. I cannot access Dreamhosts phpMyAdmin or my WordPress panel because earlier, I changed domain name's nameservers to the new host. Now, I can't backup my database.

    I don't want to switch my nameservers back to Dreamhost because that would probably take another couple of days for propagation, so I was wondering if it's possible to backup my database from my files located with Dreamhost.

  2. KaugKo
    Member
    Posted 1 year ago #

    If you created remote SQL and is still open you can download with SQL software. Why don't you open a ticket there and ask them to send you with drop box or something else. I think dream host customer services isn't that bad.

  3. xmizer
    Member
    Posted 1 year ago #

    Thanks. Actually I backed up my database now.

    But now, I have to figure out how to backup my old blog posts. Do you know how I can do that if I don't have access to my WordPress admin panel?

  4. KaugKo
    Member
    Posted 1 year ago #

    I think when you fill your database with old data, it will populate as before. Because as far as I know all the settings and data are saved in the database. don't forget to change the site_url and home in options tables and some other place. look for the old domain name and replace them with current domain name.

  5. xmizer
    Member
    Posted 1 year ago #

    Are you saying the database backup will contain all the old posts?

  6. W.P. Ginfo
    Member
    Posted 1 year ago #

    Yes, it should!

  7. KaugKo
    Member
    Posted 1 year ago #

    as far as I know yes! I would like to suggest you to create new dummy wordpress using with your back up database and check whether you've can see your old post in admin panel.

    Don't forget to change site_url and home coloum of wp_options table in database to your new site address.

  8. Ipstenu-DH
    DreamHost Rep
    Posted 1 year ago #

    xmizer - You can still access your database if you have a dreamhosters domain, but it sounds like you've sorted that out.

    Also remember that your WordPress DB prefix (normally wp_) will be different if you used our one-click installer (we use wp_random_ instead).

    If you need help getting your content off, while we hate to lose you, we're certainly still here to help you.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags