SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict Zapppa's Avatar
    Join Date
    Aug 2009
    Posts
    315
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need to backup wordpress database

    Hi

    I have a blog on hostultra.com (from a long time ago!). Their website has been down for a few days and I am getting nervous.

    I have backed up all my files.

    However I need to backup my database. I cant get access to my cpanel as the hostultra.com site is down.

    Can I backup just my database from within wordpress?

    What I want to do is move it to another host, but I want to make sure I get the database ASAP.

  2. #2
    SitePoint Addict deadmix's Avatar
    Join Date
    Jun 2009
    Location
    france
    Posts
    210
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    Just be clear, you can get to your wordpress website !? if Yes, just use any Backup Plugin and Get Your Database.

    If you can't get to your website nor to your Hosting Cpanel i don't think you can do something !!

    Goodluck

  3. #3
    SitePoint Addict Zapppa's Avatar
    Join Date
    Aug 2009
    Posts
    315
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can still access the site. I've managed install a plugin and i got a .sql file backed up. Is this all I need along with all the content files off ftp?

  4. #4
    SitePoint Addict deadmix's Avatar
    Join Date
    Jun 2009
    Location
    france
    Posts
    210
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    In order to transfert your website to another hosting, you will need to re-install Wordpress + Adding Your Theme + Adding the Plugins you used + The Database. Like that you will not lose anything...

    Goodluck

  5. #5
    SitePoint Addict Zapppa's Avatar
    Join Date
    Aug 2009
    Posts
    315
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Am I right in thinking inhave to create a new database and user?

    Then import the .sql file into this database and upload?

  6. #6
    SitePoint Enthusiast
    Join Date
    Jul 2011
    Location
    Novi Sad
    Posts
    34
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To migrate files and database on new server, you first need to do a backup of the existing site. You can use this plugin http://wordpress.org/plugins/backwpup/

    The whole process looks like this:
    1. transfer files to the new server
    2. transfer the database
    3. create a new user to the database
    4. change information in wp-config.php (write new data to connect to the database)
    5. do search and replace in the database, to replace the old urls (use this script http://interconnectit.com/products/s...ess-databases/)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •