Support » Installing WordPress » Host's WordPress Installation or FTP?

  • Which is the best option? I’m a novice, but I don’t want to shy away from doing it the more ‘difficult’ way if it’s better…

    My concerns:
    1. Is it safer one way or another from a ‘lose your stuff’ perspective?
    2. If I opt for the host installation, is it fairly simple to keep database backups on my computer?
    3. Heck, does ‘database backup’ mean all your content or something else?

    And is 2 + 2 still 4?


Viewing 6 replies - 1 through 6 (of 6 total)
  • Oh yeah–please just send me to an article if one is out there… Im always nervous about asking dumb questions in these forums!

    I prefer to turn on ssh access and use it both for file transfer and command line access to do database backups. Most hosting accounts I’ve dealt with have it turned off by default, so I go into the C-panel and turn it on. C-panel is also great for phpmyadmin access to the database.
    All the ftp clients I’ve seen (filezilla, etc) support the use of ssh, just select port 22 instead of port 21, which is for ftp, and the same goes for terminal clients like Putty.
    You have all kinds of options, like opening a command-line terminal session into the server, downloading, unzipping, and editing directly on the server, but it’s not really worth it. Besides, downloading it locally, running WAMP to preview changes you make to it, and sending files up means that you have a local copy, and thus at least one backup.
    It is a lot easier to do database backups over command-line access. You open Putty, connect your session, and type (or paste it in):
    mysqldump -u username -p -h hostname databasename > backup.sql
    Substitute in your info, of course, and enter your database password when prompted. Check the server with your ftp client and you should have a new file called backup.sql, just copy it to your local machine and you have a backup of your database. If you ever have to restore it, just send backup.sql up to the server, log in, and type:
    mysql -u username -p -h hostname databasename < backup.sql
    As long as you have a database backup and a copy of the wp-content folder, you have enough to recreate the whole site. You can always redownload the base install, paste in the wp-content backup, restore the database, edit the wp-config file to restore the connection to the database, and you’re back up and running.
    Have fun and don’t let it intimidate you.

    After my post, I did the standard FTP thing w/ Cyberduck and all of that.

    What I’m excited about is that I think I followed what you are saying above–or at least enough to know where to go and look and follow step by step.

    I do have 2 or 3 other blogs that I’m moving over to Bluehost. I’ll try following your instructions above on one of my other ones (of course they have their own problems: one is a blogger migration, one is currently hosted at Hostgator and one is at Godaddy. I hear moving WordPress from one hosting to another is more complicated than the blogger migration.

    Site migration is not to hard. We build our client’s sites on a staging server and when it’s ready we have to transfer it to a live server or hosting account.
    1. Transfer the files.
    2. Create the new, empty database on the new server. Create a backup .sql file from the old server using the database login credentials for the old database, ftp the file up to the new server, restore the .sql file into the new database you created using the login credentials you’ll be given when you created the database ( I’m assuming you’re using C-panel to do database management and phpmyadmin access, since that’s the most common setup ). Edit the wp-config file on the new server to use the login credentials for the new database.
    3. Access the new database using phpmyadmin and change the two entries in the wp_options table that wordpress uses to know what domain it is on ( One is on the first screen of 30 entries and one is on the second ) I know one is “home” and the other is either “url” or “domain”. Just look on those first two pages for “” and change them to “”

    That’s a minimum to be able to pull up the site, login to the backend, etc. I usually go through after that and do a search in the database for the old site domain name and change the guid for the posts, links to images, etc. Then I use grep to search through the files in the wp-content folder doing the same thing.

    I just heard about a find and replace plugin that will do the database changes, but I think you would still need to do those first two entries manually in order to get into the backend and activate the plugin.

    Do these instructions apply to both a WP migration and a Blogger migration?

    I don’t know about blogger, I’ve never worked with it. If you are trying to migrate it from a blogger installation to a wordpress installation, I would say definitely not, because they have different file and database structures.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Host's WordPress Installation or FTP?’ is closed to new replies.