Wordpress Migration

Hi I need to migrate wordpress blog from one local computer to another for debug and I get Error Establishing a Database Connection Can someone tell me step by step where I could made mistake? what could change in wp-settings etc what to look for when exporting importing mysql database... thx.

I Know the Answer!

I have the same question
Request More Information

Current Answers

Answer #1: Posted by TechSupport101 on September 10th, 2013 2:51 AM

This answer was accepted by the poster of the original question.

TechSupport101

Member since:
May 24th, 2013

Points: 12,171,305

1,110
points

Hi, here are the steps you are looking for:

Importing and Exporting WordPress Databases
1Assign a web designer to export your database, if you have never dealt with coding before. It is important to follow exact instructions to make sure your database stays intact and uploads properly to a new website.
2Login to your local "phpMyAdmin" to export your private CMS database. Under WordPress, click the "Structure" tab and then the "Export" option. Click the box for "Add drop table/drop view" and the box to "Save as file."
3Click "Go" to download a Structured Query Language (SQL) file. Open the file in a text editor program. Select the find function to find all of the previous URL (website) addresses.
4Replace each old URL address with the new domain address. You can click "Replace All" to do this in 1 step. Check your document to make sure all the URL addresses are changed before saving the file.
5Create a new database for your new domain. Login to your server and go to "MySQL Databases." Create a new database and assign it a new user to serve as an administrator.
6Login to the "phpMyAdmin" for your new database. Under the "Import" tab, select the file you just downloaded, changed and saved. Click "Go" to upload the file to your WordPress platform.
7Find the "wp-config.php" file on your server. Change the database details, replacing them with the new server and domain settings.
For more details visit the link below:
http://www.wikihow.com/Export-and-Import-a-Wordpress-Blog

www.satechhelp.co.za

Answer #2: Posted by tanhax on September 10th, 2013 3:01 AM

tanhax

Member since:
January 28th, 2013

Points: 21,620

100
points

What I did is different?

its local xampp to local xampp

I took files from 1.pc from htdocs in folder wordpress (its named like that)

copied to 2.pc then from phpmyadmin on 1.pc I did export of wordpress database into SQL file then imported in phpmyadmin on 2.pc dunno if i should change any url when its both localhost should I change wp-settings? localhost stay same but database name and pw is different?