How to transfer existing blog

Well when transferring your site to another domain then there are two main steps to take.

Firstly you need to export your WordPress database. You can do this in phpmyadmin. Once done this should create a .sql file. You will then upload this to your new site.

Secondly you need to make a copy of all the files from your old site. Download them all using FTP.

Next open your downloaded .sql file in a text editor and find and replace all instances of the old url with the new one. Then create a new database of the new domain and upload this sql file. Your new database is then on your new site.

Upload all the files to your new domain using FTP remembering to reflect any changes needed in your wp-config.php file. Go to the new domain URL and that should work.

That is a bit complicated. All the files are on my Bluehost webhost account so no need to ftp anything.

I think I’ll just install WordPress on my new domain and copy and paste the verbiage from the old blog. It’s still pretty small.

You can always do an export from WordPress on the Tools > Export section and then import into the new install of WordPress

What if I forgot to “export”?
I only have a backup from my old host. And now I got a new host.
When install WordPress it shows me this.

Already Installed

You appear to have already installed WordPress. To reinstall please clear your old database tables first.

So I goto my SQL database to import the SQL file and then I get this error

#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 ‘DELIMITER’ at line 1

Pls help

Did I miss a step?

You’ll have to select all of your tables in the newly installed database, empty them, and then import your new database. The following link, as well as the comments on it, may be able to better help you: https://wordpress.shadowlantern.com/?p=67