[Hacking WordPress]: How To Clone And Migrate Your WordPress Blog To New Server

wordpress logoIn the event that you need to migrate your current WordPress blog to a new server, or a new URL, the last thing that you want to do is to reinstall WordPress on your new server and reconfigure the setting all over again.

While you can use the export/import function under the ‘Manage‘ menu to migrate your database over, it is definitely not the best and ideal solution, especially if you have a huge database. In addition, if any of your plugins created their own databases, they aren’t going to be migrated by the export/import function.

To migrate your WordPress blog, the best and the easiest way is to clone it and plug it into the new server. Since WordPress is a database driven platform where all its configuration settings are kept in the database, we can achieve a cloning effect simply by backing up all its database tables (including those created by the plugins) and dump it into the new server database. There is no need for reinstallation or reconfiguration.

Here’s how you can clone and migrate your WordPress blog to a new server in 10 steps:

  1. Download the wp-db-backup plugin.
  2. Upload to your existing server and activate it via the ‘Plugins‘ menu.
  3. Go to the ‘Manage‘ -> ‘Backup‘ menu. Select all the tables (including those tables created by the plugins) and click the Backup button to download the gzip file to your computer.
  4. In your computer, extract the gzip backup file. You should now have a sql file.
  5. Open the sql file with a text editor. Search for the line

    INSERT INTO `wp_options` VALUES (1, 0, 'siteurl'

    You should see something of this format:

    INSERT INTO `wp_options` VALUES (1, 0, 'siteurl', 'http://www.your-old-url.com', 'yes')
    Replace the URL with your new server URL

    Next, search for the line

    INSERT INTO `wp_options` VALUES (39, 0, 'home',

    You should see
    INSERT INTO `wp_options` VALUES (39, 0, 'home', 'http://www.your-old-url.com', 'yes')
    Replace the url with your new URL. Save and exit.

  6. Using a FTP program, download the whole WordPress folder from your current server to your computer. Keep the folder structure intact, especially the wp-content folder.
  7. Log in to the PhpMyAdmin in the new server (here is the instruction to access your PhpMyAdmin)
  8. Create a new database for your wordpress and import the sql file to the database
  9. Change the database configuration in the wp-config file in the WordPress folder that you have downloaded
  10. Upload the whole WordPress folder to the new server.

Done. You can now proceed to your wp-login page at the new server and login with the same username and password. All the configuration and settings will be the same as before.

If your WordPress database (the sql file you have created) is more than 2MB, the above method might not work since PhpMyAdmin only allows a maximum of 2MB file import.

To overcome this, you can use bigdump to dump the sql file to your new database.

  1. Download the bigdump file from here (This is a customised version that I have modified to work with wordpress blog)
  2. Unzip the file.
  3. In the ‘restore‘ folder, open up config.php and change the database configuration.
  4. Copy and paste the sql file into the folder.
  5. Upload the ‘restore‘ folder to your new web URL
  6. On your browser, navigate to the url http://your-new-web-url.com/restore/bigdump.php
  7. Click on the “Start import” to import the sql file to the database
  8. Once completed, upload the whole WordPress folder to your new web server.

Done.

Update: for GoDaddy, ‘localhost’ will not work. But any user can access their account, access the control panel for hosting products and then see SQL databases. When in edit mode, the page will display the hosting path – this worked. – Mike Chung.

Thanks to Mike Chung for the tips.



Print this pageSave as PDF

Damien Oh is the owner and chief editor of Make Tech Easier
  • http://thedailyubuntu.blogspot.com/ Mary Riley

    Thanks for the useful information. Too bad there isn’t a good way to transfer backlinks when you move to a server with a different domain name.

  • http://thedailyubuntu.blogspot.com/ Mary Riley

    Thanks for the useful information. Too bad there isn’t a good way to transfer backlinks when you move to a server with a different domain name.

  • http://maketecheasier.com/ Damien Oh

    @Mary: A good way to bring the backlinks along with you is to place a Redirect 301 on your old server, pointing to your new site. Though the backlinks won’t show in your blog, but the traffic will still reach your new site.

  • http://maketecheasier.com Damien Oh

    @Mary: A good way to bring the backlinks along with you is to place a Redirect 301 on your old server, pointing to your new site. Though the backlinks won’t show in your blog, but the traffic will still reach your new site.

  • Pingback: Interesting Posts Around the Web - Feb 11 | Interesting Observations

  • http://imafish.co.uk/blog Pete White

    Alternatively you can use the export and import function already built into WordPress without having to install any additional modules.

  • http://imafish.co.uk/blog Pete White

    Alternatively you can use the export and import function already built into WordPress without having to install any additional modules.

  • http://qp-84.com/ oscarlopez

    hello i don´t seem to find
    INSERT INTO `wp_options` VALUES (1, 0, ‘siteurl’ nor
    INSERT INTO `wp_options` VALUES (39, 0, ‘home’, in my sql can u tell me why? i´m useing wp 2,6 version

    • http://www.matteoweb.it/ Matteo

      Are you using a prefix to the tables? es: INSERT INTO `prefix_wp_options` VALUES

      Hope this would help you.

    • http://www.matteoweb.it/ Matteo

      Are you using a prefix to the tables? es: INSERT INTO `prefix_wp_options` VALUES

      Hope this would help you.

  • http://qp-84.com oscarlopez

    hello i don´t seem to find
    INSERT INTO `wp_options` VALUES (1, 0, ‘siteurl’ nor
    INSERT INTO `wp_options` VALUES (39, 0, ‘home’, in my sql can u tell me why? i´m useing wp 2,6 version

    • http://www.matteoweb.it Matteo

      Are you using a prefix to the tables? es: INSERT INTO `prefix_wp_options` VALUES

      Hope this would help you.

  • http://maketecheasier.com/ Damien

    @oscarlopez: Did you use the wp-db-backup plugin? The above technique should work in WP2.6 as well.

  • http://maketecheasier.com Damien

    @oscarlopez: Did you use the wp-db-backup plugin? The above technique should work in WP2.6 as well.

  • http://qp-84.com/ oscarlopez

    hi yes i did…but i can´t find this in the sql..

  • http://qp-84.com oscarlopez

    hi yes i did…but i can´t find this in the sql..

  • http://maketecheasier.com/ Damien

    @oscarlopez: Which version of wordpress are you importing from?

  • http://maketecheasier.com Damien

    @oscarlopez: Which version of wordpress are you importing from?

  • http://qp-84.com/ oscarlopez

    2,6

  • http://qp-84.com oscarlopez

    2,6

  • http://elcuaderno.co.cc/ Mario

    Hello Damien, I think this is a good tutorial for this kind of issue, but I wonder if the special characters get lost in spanish blogs, for example the ñ and accented characters ?

  • http://elcuaderno.co.cc Mario

    Hello Damien, I think this is a good tutorial for this kind of issue, but I wonder if the special characters get lost in spanish blogs, for example the ñ and accented characters ?

  • Pingback: Mudanza del blog | Thuer.com.ar

  • http://www.jeremymeyers.com/ Jeremy Meyers

    What about the URLs contained in the INSERT INTO wp_posts fields?

  • http://www.jeremymeyers.com/ jeremym

    What about the URLs contained in the INSERT INTO wp_posts fields?

  • http://maketecheasier.com/ Damien

    @jeremym:The URL displayed on the address bar is based on the premalink structure that you configured within your WP admin page. The URL contained in the wp_posts field will not affect the actual URL displayed.

  • http://maketecheasier.com Damien

    @jeremym:The URL displayed on the address bar is based on the premalink structure that you configured within your WP admin page. The URL contained in the wp_posts field will not affect the actual URL displayed.

  • Pingback: Metal Martian » this is a test

  • http://www.koshky.com/ AFUNA

    Thanks a lot for this tutorial I think it was very helpful ..

  • http://www.koshky.com AFUNA

    Thanks a lot for this tutorial I think it was very helpful ..

  • Nick

    Hi Damien

    Great tutorial. I’m testing it now, but I did notice that there is a line:

    INSERT INTO `wp_options` VALUES (60, 0, ‘upload_path’,

    and that line contains the server path to my uploads folder.

    Assuming I’m cloning the installation to another domain, won’t I need to change that to match the new server path?

    Also I can see my URL in multiple additional places:

    INSERT INTO `wp_options` VALUES (85, 0, ‘dashboard_widget_options’,

    In 2 or 3 places regarding Google Blogsearch.

    INSERT INTO `wp_options` VALUES (90,

    that looks like it’s something to do with recent RSS feeds on the Dashboard?

    INSERT INTO `wp_options` VALUES (100,

    which look like my FTP settings

    and

    INSERT INTO `wp_options` VALUES (132, 0, ‘sociable_conditionals’

    (Something to do with the Sociable plugin?)

    Wouldn’t these all have to be changed accordingly?

    Cheers

    Nick

    P.S. If you email me at the address I’ve used to post this comment, I can email you a copy of the SQL dump file so you can see for yourself.

  • Nick

    Hi Damien

    Great tutorial. I’m testing it now, but I did notice that there is a line:

    INSERT INTO `wp_options` VALUES (60, 0, ‘upload_path’,

    and that line contains the server path to my uploads folder.

    Assuming I’m cloning the installation to another domain, won’t I need to change that to match the new server path?

    Also I can see my URL in multiple additional places:

    INSERT INTO `wp_options` VALUES (85, 0, ‘dashboard_widget_options’,

    In 2 or 3 places regarding Google Blogsearch.

    INSERT INTO `wp_options` VALUES (90,

    that looks like it’s something to do with recent RSS feeds on the Dashboard?

    INSERT INTO `wp_options` VALUES (100,

    which look like my FTP settings

    and

    INSERT INTO `wp_options` VALUES (132, 0, ‘sociable_conditionals’

    (Something to do with the Sociable plugin?)

    Wouldn’t these all have to be changed accordingly?

    Cheers

    Nick

    P.S. If you email me at the address I’ve used to post this comment, I can email you a copy of the SQL dump file so you can see for yourself.

  • Russ Lipton

    Won’t the guid values of the posts in the remote database need to be changed, or is this covered by your reply above that the URL on the address bar of the remote weblog is determined by the permalink?

  • Russ Lipton

    Won’t the guid values of the posts in the remote database need to be changed, or is this covered by your reply above that the URL on the address bar of the remote weblog is determined by the permalink?

  • http://www.helpfuladvisor.com/ Jay Medina

    Damien, thanks so much for this tutorial. It allowed me to migrate my WordPress site in less than 10 minutes! Thanks for saving me all the hard work of trying to figure this out myself!

    Best Regards,

    -Jay

  • http://www.helpfuladvisor.com Jay Medina

    Damien, thanks so much for this tutorial. It allowed me to migrate my WordPress site in less than 10 minutes! Thanks for saving me all the hard work of trying to figure this out myself!

    Best Regards,

    -Jay

  • http://apinanakmonyet.wordpress.com/ Eman Udik

    HORE!!! This tutorial is done!!
    now i have a good blog, you can see http://www.areaofgames.wordpress.com
    i cloned it from my suck friends http://www.radioactivemonkey.wordpress.com

  • http://apinanakmonyet.wordpress.com Eman Udik

    HORE!!! This tutorial is done!!
    now i have a good blog, you can see http://www.areaofgames.wordpress.com
    i cloned it from my suck friends http://www.radioactivemonkey.wordpress.com

  • JJ Love

    Good tutorial, but lacking some key points, and thence somewhat sloppy. Why even post an article like this if you aren’t going to follow up and answer questions? I don’t get it.

    Key points left out by the hasty author:

    1. You won’t see “INSERT INTO `wp_options` VALUES (1, 0, ‘siteurl’” Instead you will see something like “INSERT INTO `wp_y6hww3_options` VALUES (1, 0, ‘http://www.yoursitename.com'

    2. There will be multiple references to your old domain in the SQL file. Just do a global search and replace.

    3. In your wp-config file, the author generalizes and says “Change the database configuration in the wp-config file in the WordPress folder that you have downloaded” Change what? You need to change the user name and password to whatever your NEW database user name and password are AND the name of the database you created.

    I will post a much better version of this tutorial on my site soon and report back.

    Nice try here, but again, in the end it is incomplete

  • JJ Love

    Good tutorial, but lacking some key points, and thence somewhat sloppy. Why even post an article like this if you aren’t going to follow up and answer questions? I don’t get it.

    Key points left out by the hasty author:

    1. You won’t see “INSERT INTO `wp_options` VALUES (1, 0, ‘siteurl’” Instead you will see something like “INSERT INTO `wp_y6hww3_options` VALUES (1, 0, ‘http://www.yoursitename.com'

    2. There will be multiple references to your old domain in the SQL file. Just do a global search and replace.

    3. In your wp-config file, the author generalizes and says “Change the database configuration in the wp-config file in the WordPress folder that you have downloaded” Change what? You need to change the user name and password to whatever your NEW database user name and password are AND the name of the database you created.

    I will post a much better version of this tutorial on my site soon and report back.

    Nice try here, but again, in the end it is incomplete

  • dave

    Many thanks for this.

    Some comments above indicate that a few points are missing or not very clearly explained, but I had no idea how to clone my site & with the article above I managed to clone & migrate my site to a new URL, so many thanks for a very informative post.

  • dave

    Many thanks for this.

    Some comments above indicate that a few points are missing or not very clearly explained, but I had no idea how to clone my site & with the article above I managed to clone & migrate my site to a new URL, so many thanks for a very informative post.

  • http://doAGreentThing.com/ Tom Harrison

    I’m with Dave on this one; if we add comments where there are issues, the “incomplete” post turns into “a good start” with some good notes! So here’s mine.

    Instead of updating the database manually to change the URL, you can change options in the wp-config.php file; there’s one for wp_siteurl and one for wp_home, documented here on the WordPress site. These don’t actually change the database values, but once the site is moved over, you can change them through the usual settings page (then take them out of wp_config.php).

  • http://doAGreentThing.com/ Tom Harrison

    I’m with Dave on this one; if we add comments where there are issues, the “incomplete” post turns into “a good start” with some good notes! So here’s mine.

    Instead of updating the database manually to change the URL, you can change options in the wp-config.php file; there’s one for wp_siteurl and one for wp_home, documented here on the WordPress site. These don’t actually change the database values, but once the site is moved over, you can change them through the usual settings page (then take them out of wp_config.php).

  • http://www.sloantech.com/ J loan

    For those of us with less time and technical experience, is there a fast and reliable 3rd party or company that can do migrations of entire site + wordpress?

    • http://maketecheasier.com/ Damien

      If you are changing web host, perhaps you can ask them for help. Some web hosts help their client to migrate to the new server for free.

  • http://www.sloantech.com J loan

    For those of us with less time and technical experience, is there a fast and reliable 3rd party or company that can do migrations of entire site + wordpress?

    • http://maketecheasier.com Damien

      If you are changing web host, perhaps you can ask them for help. Some web hosts help their client to migrate to the new server for free.

  • Rick van Vliet

    Thanks for a good tutorial.

  • Rick van Vliet

    Thanks for a good tutorial.

  • Antonella

    Hi,

    Thanks for the tutorial. After I uploaded the site and database as described, I was able to get into the wp-admin and see the homepage of the site. However, I wasn’t able to see any other page, getting an error 404.

    I did a global search and replace for the URL but that didn’t help either. Any idea if I’m missing a step?

    Thanks,
    Antonella

  • Antonella

    Hi,

    Thanks for the tutorial. After I uploaded the site and database as described, I was able to get into the wp-admin and see the homepage of the site. However, I wasn’t able to see any other page, getting an error 404.

    I did a global search and replace for the URL but that didn’t help either. Any idea if I’m missing a step?

    Thanks,
    Antonella

  • http://www.mywellofwealth.com/ Jun

    I was trying to migrate my blog to a subfolder of a new domain(www.olddomain.com to http://www.newdomain.com/abc) and got the same problem as Antonella had. The main page was all right, however, lost all those links.

    Can someone give some hink what i did wrong?

    Thanks
    Jun

    • http://maketecheasier.com/ Damien

      1) Log into your phpMyAdmin.
      2) Locate the database for the current site
      3) Click on the table wp_options
      4) Locate the fields: siteurl and home
      5) Change their value to the URL of the new site.
      6) Save and exit.

  • http://www.mywellofwealth.com Jun

    I was trying to migrate my blog to a subfolder of a new domain(www.olddomain.com to http://www.newdomain.com/abc) and got the same problem as Antonella had. The main page was all right, however, lost all those links.

    Can someone give some hink what i did wrong?

    Thanks
    Jun

    • http://maketecheasier.com Damien

      1) Log into your phpMyAdmin.
      2) Locate the database for the current site
      3) Click on the table wp_options
      4) Locate the fields: siteurl and home
      5) Change their value to the URL of the new site.
      6) Save and exit.

  • http://www.jonathangray.org/ Jonathan Gray

    Many thanks for this! Very useful indeed!

  • http://www.jonathangray.org Jonathan Gray

    Many thanks for this! Very useful indeed!

  • Keir

    Hi, great guide. It worded for us easy! However, we’re facing a issue I cant figure out.
    After the export/import, the install seems to have partially lost control over the existing directory structure (wp-content). The permissions are set correctly; media assets which were present before the exp/imp can be removed/ new ones added; plugins and themes can be added and removed. However, themes, plugins or directories present prior to the cloning process, seem to be beyond the control of the server.
    Specs:
    iis7 (I’m pretty sure)
    mysql (latest)
    wp 2.8

    Thanks for any help
    Keir

  • Keir

    Hi, great guide. It worded for us easy! However, we’re facing a issue I cant figure out.
    After the export/import, the install seems to have partially lost control over the existing directory structure (wp-content). The permissions are set correctly; media assets which were present before the exp/imp can be removed/ new ones added; plugins and themes can be added and removed. However, themes, plugins or directories present prior to the cloning process, seem to be beyond the control of the server.
    Specs:
    iis7 (I’m pretty sure)
    mysql (latest)
    wp 2.8

    Thanks for any help
    Keir

  • Keir

    Hi, great guide. It worded for us easy! However, we’re facing a issue I cant figure out.
    After the export/import, the install seems to have partially lost control over the existing directory structure (wp-content). The permissions are set correctly; media assets which were present before the exp/imp can be removed/ new ones added; plugins and themes can be added and removed. However, themes, plugins or directories present prior to the cloning process, seem to be beyond the control of the server.
    Specs:
    iis7 (I’m pretty sure)
    mysql (latest)
    wp 2.8

    Thanks for any help
    Keir

  • Pingback: wordpress?copy | Google analytics, ??????

  • Stephanie Benatar

    Be careful to configure the sql file correctly…
    They don’t mention this, but you also have to configure your uploads path, I couldn’t upload files because I hadn’t changed it.
    Look for INSERT INTO `wp_options` VALUES (59, 0, ‘upload_path’,’ yourpath ‘,’yes’)
    and modify it to your new uploading path

    • Keir

      Thnx, thats a good point. Will keep in mind.
      My problem boiled down to something much stupider:
      was giving ‘iis_user’ WRX permission rather than ‘i_user’… on the MS server…
      Daft.
      Solved.

    • Keir

      Thnx, thats a good point. Will keep in mind.
      My problem boiled down to something much stupider:
      was giving ‘iis_user’ WRX permission rather than ‘i_user’… on the MS server…
      Daft.
      Solved.

  • Stephanie Benatar

    Be careful to configure the sql file correctly…
    They don’t mention this, but you also have to configure your uploads path, I couldn’t upload files because I hadn’t changed it.
    Look for INSERT INTO `wp_options` VALUES (59, 0, ‘upload_path’,’ yourpath ‘,’yes’)
    and modify it to your new uploading path

  • Stephanie Benatar

    Be careful to configure the sql file correctly…
    They don’t mention this, but you also have to configure your uploads path, I couldn’t upload files because I hadn’t changed it.
    Look for INSERT INTO `wp_options` VALUES (59, 0, ‘upload_path’,’ yourpath ‘,’yes’)
    and modify it to your new uploading path

    • Keir

      Thnx, thats a good point. Will keep in mind.
      My problem boiled down to something much stupider:
      was giving ‘iis_user’ WRX permission rather than ‘i_user’… on the MS server…
      Daft.
      Solved.

  • http://www.timelycopy.com/ Bill Underwood

    I have run into a “Internal Server Error” when I attempt to change pages. I have checked all paths in the database and in the site folder to ensure that this is not the error. Would expect a 400 there.
    I have also checked the details in wp-config.

    I am running 2.8.6 (current).

    Any Ideas folks?

    Bill

    • http://maketecheasier.com/ Damien

      Did you check your permalink setup or your .htaccess file?

  • http://www.timelycopy.com/ Bill Underwood

    I have run into a “Internal Server Error” when I attempt to change pages. I have checked all paths in the database and in the site folder to ensure that this is not the error. Would expect a 400 there.
    I have also checked the details in wp-config.

    I am running 2.8.6 (current).

    Any Ideas folks?

    Bill

  • http://www.timelycopy.com Bill Underwood

    I have run into a “Internal Server Error” when I attempt to change pages. I have checked all paths in the database and in the site folder to ensure that this is not the error. Would expect a 400 there.
    I have also checked the details in wp-config.

    I am running 2.8.6 (current).

    Any Ideas folks?

    Bill

    • http://maketecheasier.com Damien

      Did you check your permalink setup or your .htaccess file?

  • http://timelycopy.com/ Bill Underwood

    Yes. Both correct.
    I have the old site up and running and redeveloped under a new domain name on my development server. I am xferring between hosts and back to timelycopy.com.

    I create a new wp instance & install plugins & theme – all is well.

    If I copy the database via export, mod and import I immediately get the error.
    So I start again with a clean slate and copy and paste the home page from the old wp to the new. The error immediately appears.

    If i create pages in the new wp instance there is no error. U can email me on bill at the above domain name id u wish access.

    Thanks
    Bill

  • http://timelycopy.com Bill Underwood

    Yes. Both correct.
    I have the old site up and running and redeveloped under a new domain name on my development server. I am xferring between hosts and back to timelycopy.com.

    I create a new wp instance & install plugins & theme – all is well.

    If I copy the database via export, mod and import I immediately get the error.
    So I start again with a clean slate and copy and paste the home page from the old wp to the new. The error immediately appears.

    If i create pages in the new wp instance there is no error. U can email me on bill at the above domain name id u wish access.

    Thanks
    Bill

  • Pingback: Moving Wordpress Blogs the Easy Way | Ley'ing it Out

  • Jules R

    Hi, thanks for the tutorial, I had a fairly painless migration.
    A few things to add (sorry I didn’t read all the comments to make sure they haven’t been mentioned).

    - Step 5 was outdated for my WordPress installation also, so I didn’t find those exact strings.

    - In Step 5, it’s good to search for ANY mention of the old site in the SQL file. This will make sure that you catch any references to the old site in posts (eg: as links to uploaded photos), or in other wordpress options (eg: as hardcoded file paths).

    - (I did my migrataion on a brand new server and ran into this PHP related problem:) I was getting white screens in WP after migration, because PHP did not have permission to access the wordpress files. To fix this, I changed the group (using chgrp) and also gave +x permissions on all the migrated files.

  • Jules R

    Hi, thanks for the tutorial, I had a fairly painless migration.
    A few things to add (sorry I didn’t read all the comments to make sure they haven’t been mentioned).

    - Step 5 was outdated for my WordPress installation also, so I didn’t find those exact strings.

    - In Step 5, it’s good to search for ANY mention of the old site in the SQL file. This will make sure that you catch any references to the old site in posts (eg: as links to uploaded photos), or in other wordpress options (eg: as hardcoded file paths).

    - (I did my migrataion on a brand new server and ran into this PHP related problem:) I was getting white screens in WP after migration, because PHP did not have permission to access the wordpress files. To fix this, I changed the group (using chgrp) and also gave +x permissions on all the migrated files.

  • Jules R

    Hi, thanks for the tutorial, I had a fairly painless migration.
    A few things to add (sorry I didn’t read all the comments to make sure they haven’t been mentioned).

    - Step 5 was outdated for my WordPress installation also, so I didn’t find those exact strings.

    - In Step 5, it’s good to search for ANY mention of the old site in the SQL file. This will make sure that you catch any references to the old site in posts (eg: as links to uploaded photos), or in other wordpress options (eg: as hardcoded file paths).

    - (I did my migrataion on a brand new server and ran into this PHP related problem:) I was getting white screens in WP after migration, because PHP did not have permission to access the wordpress files. To fix this, I changed the group (using chgrp) and also gave +x permissions on all the migrated files.

  • AmyPhotographer

    I am a total newbie…and it worked!! Saved me tons of time. Really appreciate it – Thanks.

  • AmyPhotographer

    I am a total newbie…and it worked!! Saved me tons of time. Really appreciate it – Thanks.

  • AmyPhotographer

    I am a total newbie…and it worked!! Saved me tons of time. Really appreciate it – Thanks.

  • Pingback: 7 WP Features That Should Be Part Of WordPress Core - Make Tech Easier

  • http://techblog.triptic.nl/ Onno Marsman

    People interested in this post, might also want to take a look at the ezMigrate plugin for WordPress:
    http://techblog.triptic.nl/ezmigrate-plugin-for…

  • Pingback: HH Graphics » Trends and Topics I’ve been following: January 12th through March 17th (as bookmarked on Delicious)

  • http://www.relicaexpo.com Relicaexpo

    Hi,
    Nations runs on import and export now. Thanks to worldwide globalization. Being a part of it, would like to make aware everyone that we are unique in our sense. We deal in ________________________________________

    Relicaexpo believes in delivering right quality delivering at right time.

    For any trade enquiry feel free to fill our enquiry form available at Relicaexpo

  • Gurdain

    hey guys

    I don't know much about web design so please forgive me if I sound stupid…but…this completely wrecked all of the websites on the hosting package I was working on.
    Somewhere after importing the SQL file using bigdump, FTP access dies and I get the error message “connection was reset” when accessing any websites on the hosting package.

    It is as if the cloned database completely ruins all of the others – even though the config.php for bigdump has the information for the new database…

    any ideas – this is very frustrating – I need an identical copy of my website for testing purposes – WPMU and WP-Hive were no use and importing wordpress and reinstalling plugins and reconfiguring did not get the identical look of the website at all.

  • Gurdain

    hey guys

    I don't know much about web design so please forgive me if I sound stupid…but…this completely wrecked all of the websites on the hosting package I was working on.
    Somewhere after importing the SQL file using bigdump, FTP access dies and I get the error message “connection was reset” when accessing any websites on the hosting package.

    It is as if the cloned database completely ruins all of the others – even though the config.php for bigdump has the information for the new database…

    any ideas – this is very frustrating – I need an identical copy of my website for testing purposes – WPMU and WP-Hive were no use and importing wordpress and reinstalling plugins and reconfiguring did not get the identical look of the website at all.

  • http://maketecheasier.com/ Damien Oh

    Gurdain, perhaps you want to check out this tutorial Clone your live wp blog to local server

  • an essay

    I find I keep coming back to this article! Thanks so much. Great post

    :)

  • academic writing
  • essay writing services

    Hi, nice post! I enjoy reading it.
    Keep it coming! http://www.completeessays.com/

  • dissertation writing

    Nice post! Thank you for writing this! http://www.dissertationsolution.com/

  • academic papers

    VERY nice resource, I hope to see more! http://www.essaysmarket.com/

  • academic essays

    that….. was…… AWESOME! http://www.onlineessayspro.com/

  • Richard Ker

    Wonderful! I spent 6 hours trying on different solutions from different websites… This one works!! Thank you!

  • Ben8789

    Hello,

    I have a database whose size is up to 2MB.
    I tryed to use bigdump but when I try to launch it, I have “Parse error: parse error in C:wampwwwwordpress_3restorebigdump.php on line 1050″. Sometimes it's because I use it on a local web server…

    Do you have and idea?
    Thank you

  • http://maketecheasier.com/ Damien Oh

    Seriously, I have tested it on a local server with Xampp and it works as well. Seems that you are using WAMP. I am not sure if that is the issue. Perhaps you want to try with Xampp?

    Alternatively, you can edit the php.ini file to change the file upload size to 8MB or more. After that, you can simply upload your sql file.

  • Ben8789

    Thanks for your reply. I'll try to modify the php.ini …
    Another question, I was certain that the size of my database was >2MB, but in fact no.
    Sometimes it is the reason that bigdump don't work… Do the backup have to be >2MB to use it?
    I'll work on a server database which size is >2MB and so I want to test it on my local server before…

    Thank you,
    BR

    Benjamin

  • Ben8789

    Hello,

    I did the entire procedure, and It seems to work, but In fact, not really.
    I clone my wordpress website, and I can acces to it.

    To help you to understand my matter, I use wamp server and I clone my website wordpress_5 to wordpress_6

    The matters are:
    -When I wan't to access to all the pages of my website, (I have two or three pages) I'm redirected to the first website, so not to the clone website… To access to my pages I clic on a menu generated by pixopoint (I don't know if it can help you).So for example when I want to go to http://127.0.0.1/wordpress_6/sport I'm redirected on http://127.0.0.1/wordpress_5/sport.

    -When I wan't to access to my clone admin page, I'm redirected to my first website admin page (http://127.0.0.1/wordpress_6/wp-admin -> http://127.0.0.1/wordpress_5/wp-admin)

    I really don't understant what appened… Can you help me?

    Thanks,

    Ben

  • http://maketecheasier.com/ Damien Oh

    You might want to check your .htaccess file. Make sure that it is not pointing to the old URL.

  • Ben8789

    Thanks for your reply!
    It's finally work quite well with your advices.
    I just can see on my home page, some post which appear 5 times and which in the “uncategorized” class…

    Does it mean something for you?
    Do you have and idea?

    Thanks ,
    Ben

  • guest

    got a client to do this
    http://tinyurl.com/239l4le

  • Kings128

    Great tutorial, thanks!.

  • Muddy_footprintz

    hello, i actually need some help here.
    im stuck at pt.5, when i open the .sql i it just appear as alien words.
    did i do sth wrong?

    and im actually try to clone the originally wordpress site, example: http://www.home.com/1 to create another http://www.home.com/2

    do i use this same method too? thanks so much!

  • http://maketecheasier.com/ Damien Oh

    your sql file could be corrupted, try to re-download the backup file again.

    Yes, the method is the same.