WordPress.org

Ready to get started?Download WordPress

Forums

Restore database question (12 posts)

  1. cdrakeau
    Member
    Posted 2 years ago #

    I plan to change servers at the end of the year and have a question about restoring a WP database. I know about the import/export function in phpmyadmin, but am wondering...would I have to run a fresh WP install on the new server first, then import the database?

  2. No need for a fresh install, but you do need to copy files. See Moving WordPress « WordPress Codex

  3. cdrakeau
    Member
    Posted 2 years ago #

    I have to copy files along with the database? Isn't the whole website contained within the database? Which files do I have to copy?

  4. Elan Technosys
    Member
    Posted 2 years ago #

    You need to download a backup your WordPress files and download a backup of database.

  5. cdrakeau
    Member
    Posted 2 years ago #

    Then what's the point of backing up the database, if it won't backup the files with it?

  6. ClaytonJames
    Member
    Posted 2 years ago #

    I have to copy files along with the database?

    Yes.

    Isn't the whole website contained within the database?

    No.

    Then what's the point of backing up the database, if it won't backup the files with it?

    The physical files located in your web space make up the platform upon which the information located in your database is displayed. Your files also provide the foundation for the physical appearance of your web site. WordPress core files, theme files, plugins and extensions all reside in your physical files. Your content, is stored in your database. Two separate entities, that function together to make your web site work. This is true with any web based platform that takes advantage of SQL, not just WordPress. Learning how to take care of these is also a basic prerequisite for owning and maintaining a web site. You can find some detailed information and instructions on how to backup your WordPress files and database located here in the WordPress documentation: WordPress Backups That page also includes Database Backup Instructions

  7. zanniat
    Member
    Posted 2 years ago #

    My site http://www.zanniat.com was working well. Later I couldn't login by admin account. I tried, manual logout, clear cookies and deleted all the plugins, but still I couldn't login. I changed the user password from phpMyAdmin but didn't work. At last i deleted all the wordpress files and re installed WordPress using the same database, username and password. After this WordPress works but the data (posts, pages, images) don't display and also not loaded in wordpress.

    I don't want to lose the data. Can somebody help me?

  8. cdrakeau
    Member
    Posted 2 years ago #

    If I copied the files, then used the export plugin to generate an XML file containing my posts, pages, categories, etc... would there still be a point in backing up the database? I've always backed it up that way and am now considering a database backup because I'm thinking that I won't have to reset my menus and widgets, among other things.

  9. Elan Technosys
    Member
    Posted 2 years ago #

    @zanniat:Did you deleted tables from the database?

  10. Krishna
    Volunteer Moderator
    Posted 2 years ago #

    Try these steps:
    One: Your theme seems to be broken. So revert to the default WP theme and see if anything changes.
    Two: rename all your plugins using FTP or c-panel
    Three: Your WordPress is installed. So you can go to your dashboard and see if all your posts are listed there. If not, it is a database problem.
    Four: Go to myphpAdmin, drop all the tables and import your database, if you have a backed up copy.
    If you can do these, you should be able to solve the problem.
    BTW, do you have a backed up copy of the database?
    If nothing works, contact your host Dreamhost for help.

  11. zanniat
    Member
    Posted 2 years ago #

    Dear friends, my site is restored,but no image. It was database problem and Dreamhost fixed it. I uploaded the images that i had saved but not working yet. Addition to this I can not login wordpress. I have renamed the plugin folder to plugin.hold to deactivate it but still not working to login.

    Can some body help please.

  12. Krishna
    Volunteer Moderator
    Posted 2 years ago #

    Try this link: http://www.zanniat.com/wp-admin/ You will be redirected to the login page.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.