Wordpress Themes - WP Forum at BFA
There will be no more development for Atahualpa (or any other theme), and no support. Also no new registrations. I turned off the donation system. I may turn the forum to read only if it gets abused for spam. Unfortunately I have no time for the forum or the themes. Thanks a lot to the people who helped in all these years, especially Larry and of course: Paul. Take care and stay healthy -- Flynn, Atahualpa developer, Sep 2021

Wordpress Themes - WP Forum at BFA » Running WordPress » Web Hosting for WordPress »

Moving WP blog to new domain--not sure what to do with database??

Prev Previous Post   Next Post Next
Old Oct 31, 2009, 08:26 AM
25 posts · Oct 2009
Moving WP blog to new domain--not sure what to do with database??


I'm trying to migrate my blog from trywine.net/wordpress to kellymagyarics.com. I tried these instructions:


Moving WordPress
Languages: English • 日本語 • Русский • 中文(简体) • (Add your language)

1 Moving WordPress Within Your Site
2 Giving WordPress its Own Directory While Leaving the WordPress Index File in the Root Directory
3 Moving WordPress to a New Server
4 Moving WordPress to a New Server with Fantastico
5 Additional Information

There are times when you need to move WordPress around within your server, and times when you need to move WordPress from one server to another. You don't need to reinstall. WordPress is flexible enough to handle all of these situations.

Easy answer for most installations:

If database and URL remains the same, you can move by just copying your files and database.
If database name or user changes, edit wp-config.php to have the correct values.
If you want to test before you switch, you must temporarily change "siteurl" and "home" in the database table "wp_options" (through phpMyAdmin or similar).
If you had any kind of rewrites (permalinks) setup you must disable .htaccess and reconfigure permalinks when it goes live.

Moving WordPress Within Your Site
Moving the WordPress files from one location on your server to another - changing its URL - requires some special care.

Here are the step-by-step instructions:

Create the new location using one of these two options:
If you will be moving your WordPress core files to a new directory, create the new directory.
If you want to move WordPress to your root directory, make sure all index.php, .htaccess, and other files that might be copied over are backed up and/or moved, and that the root directory is ready for the new WordPress files.
Login to your blog.
Go to the Administration > Settings > General panel.
In the box for WordPress address (URI): change the address to the new location of your main WordPress core files.
In the box for Blog address (URI): change the address to the new location, which should match the WordPress address (URI).
Click Save Settings.
(Do not try to open/view your blog now!)
WordPress 2.0 only: Delete the folder wp-content/cache.
Move your WordPress core files to the new location. This includes the files found within the original directory, such as http://example.com/wordpress, and all the sub-directories, to the new location.
If you are using Permalinks, go to the Administration > Settings > Permalinks panel and update your Permalink structure to your .htaccess file, which should be in the same directory as the main index.php file.
If you have problems with missing images that you've uploaded, you need to change the path to the images on every post directly on your SQL database. For this, follow the instructions on Tamba2's Tutorial "Moving your weblog inside your PC".
You must also check and edit 'store uploads folder' under Settings-Miscellaneous or all your new uploads will continue to go into the old folder.
Existing image/media links uploaded media will refer to the old folder and must be updated with the new location.
It is important that you set the URI locations BEFORE you move the files.

Suppose you accidentally moved the files before you changed the URIs: you have two options.

OPTION 1. Suppose the files were originally in /path/to/old/ and you moved them to /path/to/new before changing the URIs. The way to fix this would be to make /path/to/old/ a symlink (for Windows users, "symlink" is equivalent to "shortcut") to /path/to/new/, i.e.

ln -s /path/to/new /path/to/oldand then follow the steps above as normal. Afterwards delete the symlink if you want.

OPTION 2. If you forget to change the WordPress Address and Blog Address, you will be unable to change it using the wordpress interface. However, you can fix it if you have access to the database. Go to the database of your blog and find the wp_options table. This table stores all the options that you can set in the interface. The WordPress Address and Blog Address are stored as siteurl and home (the option_name field). All you have to do is change the option_value field to the correct URL for the records with option_name=’siteurl‘ or option_name=’home‘.

You're done. Test your site to make sure that it works right. If the change involves a new address for your blog, make sure you let people know the new address, and consider adding some redirection instructions in your .htaccess file to guide visitors to the new location.

Changing The Site URL also provides the details of this process!

Giving WordPress its Own Directory While Leaving the WordPress Index File in the Root Directory
Please see this article, Giving WordPress Its Own Directory, for detailed instructions.

Moving WordPress to a New Server
If you are moving WordPress from one server to another, begin by backing up your data. This includes backing up your WordPress database as well as all the core files, images, plugins, and other files on your site. See WordPress Backups and Backing Up Your Database for more details.

Note: If you are changing to a new server but same domain, all you need to do is edit wp-config.php and upload everything as it is to your new server.
If You Don't Care If Your Old Blog Works

1. Download a copy of the main wordpress files from your OLD blog to your hard drive and edit wp-config.php to suit the new server.

2. Go back to your OLD blog and go to options and change the url (both of them) to that of your new site.

3.Again, download your database (but keep the old one just in case), upload this new database and the copy of the wordpress core files with the edited wp-config.php to your new server. Thats it!

I did the first two steps, and when I changed the url I was kicked of the admin site for my old blog. I don't really understand what I'm supposed to do with my new/old databases, and what else I need to configure.

I uploaded all the WP files with an FTP client, and now I'm getting this message on my home page:

Parse error: syntax error, unexpected T_STRING in /home/content/k/m/a/kmagyarics/html/wp-config.php on line 2

Can someone please give me some direction about my SQL DB? Do I need to rename the old one and restore it? How? And what else do I need to configure?

Thanks--I'm not well versed in SQL and this is driving me nuts...it's taken me awhile to get this far, and I feel like I'm so close...hopefully.


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving header Karin Atahualpa 3 Wordpress theme 3 Oct 26, 2009 10:37 AM
How to display "Recent Posts" from 'Blog / wordpress' domain on home different domain Geoff Plugins & Atahualpa 1 Aug 27, 2009 09:07 PM
reinstall Atahualpa with Options with access to old database grasshopper Installing & running WordPress 1 Aug 8, 2009 06:52 AM
[SOLVED] How to save the theme options for moving my blog on an other server ? Manu-PierreB Atahualpa 3 Wordpress theme 1 Jun 20, 2009 08:05 AM
Front/Home Page (only) not working after domain change prophet224 Atahualpa 3 Wordpress theme 1 May 12, 2009 03:17 PM

All times are GMT -6. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.