#Mamp wordpress local to live zip file#
#Mamp wordpress local to live update#
#Mamp wordpress local to live download#
#Mamp wordpress local to live windows#

** Database Charset to use in creating database tables. ** The name of the database for WordPress */ ** MySQL settings - You can get this info from your web host ** // Open your wp-config.php file, located at the wordpress site root directory and change the following contents accordingly. In this step, we will connect the wordpress local site with the database we created on our localhost. Step 6 :Configure database changes in wp-config.php Please see this detailed guide to Setup wordpress on XAMPP, if you are having trouble in this step. Open /etc/hosts file and add following entry into it 127.0.0.1 5balloons.local ĭocumentRoot '/opt/lampp/htdocs/5balloons' Open nf file located at /opt/lampp/etc/extra directory, and add the following virtual host entry in it. Rename the directory name from public_html to the name of your project, I am renaming mine to 5balloons. Copy and Paste it into htdocs directory of your XAMPP server located at /opt/lampp/htdocs Unzip the public_html.zip file, and copy public_html folder. With this you can have multiple websites in the single server. I will demonstrate this step, so that you can access the wordpress website on your local machine with a virtual host.

#Mamp wordpress local to live windows#

If you are working on Windows or MAC, or are using MAMP or some other server. The step will be mostly similar. Note: This step is as per setting up files in XAMPP on my linux machine. In this step we will host our live wordpress site files on our local server. Step 5 : Host WordPress Files to Local Server

Localhost URL should be or Well done ! We are almost there.

Make sure to use https instead of http, if you are using SSL on your live wordpress site.

#Mamp wordpress local to live update#

UPDATE wp_posts SET post_content = replace(post_content, '', ' UPDATE wp_postmeta SET meta_value = replace(meta_value,'',' Go to your localhost database and select SQL from top navigation option. UPDATE wp_options SET option_value = replace(option_value, '', ' WHERE option_name = 'home' OR option_name = 'siteurl' If you are not using virtualhost and are looking to access your local wordpress site directly via You need to replace the reference of live site domain with Following are the queries which you need to run to make these changes.

I have to change all the references to in the database to. Since I am using virtualhost entry for my localhost as 5balloons.local. We have to change all the references of live site domain in the database to local site domain. There is still one task pending in this database to make it work on localhost. Step 4 : Replace Live Site Url with Local Site URL in databaseĪs we have uploaded our WordPress Live site database into localhost. Once the importing is completed you will be redirected to the database page which shows all the tables migrated into your localhost mysql.

It will take a few seconds for importing, depending upon the size of your live wordpress database. Leave all the default option as it is and Click Go on the bottom of the page. Ĭlick Choose File and Select the Exported sql file, which we exported in our last step. You should see an option of selecting a file to import from ( Choose File). Go to your new database in localhost and choose Import from top Navigation option. Now it’s time to import the exported sql file from the last step, into this newly created database. Once you click create, a new blank database will be created in your local mysql database. Enter your desired database name and hit create You should see a text box to create a new database. Go to your localhost phpmyadmin ( and choose Database option from top Navigation option.

Keep this sql file handy, we will use this in the next step.

#Mamp wordpress local to live download#

In the export screen, leave the default option as they areĬlick Go, This will download the sql file of entire wordpress live site database on your local system. Once you are into phpMyAdmin, select your wordpress live site database from the left navigation.Ĭhoose the Export option from top Navigation menu. Login to your hosting cPanel, and select phpMyAdmin Open your FTP Client (FileZilla or any other), Enter your FTP Credentials and download the public_html folder from it. If you don’t have access to File Manager, You can choose to download the files through FTP.

#Mamp wordpress local to live zip file#

Right click on the zip file and select Download This will create a new compressed file public_html.zip in the same directory.