After learning how easy it is to install WordPress on local server in Windows or Mac, some of our beginner level readers asked us how they can move their live WordPress site to local server. We have previously showed you how to move a a WordPress site from local server to live site. This article is an exact opposite of that. In this article, we will show you how to move a live WordPress site to local server.
Why and Who Would Want to Move a live WordPress Site to Local Server?
A lot of people create a copy of their live site on local server to test new themes, plugins, or do development testing. This allows you to set up your theme with all your content and test all the features without worrying about breaking your site. Many users copy their site to local server to practice their WordPress and coding skills with actual site data.
Even though you can do all the testing with dummy content in WordPress, real site data gives you a better visual representation of how these changes will appear on your live site.
Important: Whether you are moving your WordPress site to a new domain, or from WordPress.com to self hosted WordPress, or to your localhost, it is highly recommended that you backup your entire website first. We recommend using BackupBuddy to create backups. You can also backup your site using BackWPUp, or create a manual backup.
Moving Live WordPress Site to Local Server using Plugin
First thing you need to do is install and activate the Duplicator plugin on your live site. Duplicator plugin allows you to create duplicate package of your entire WordPress site. It can be used to move your WordPress site to a new location, and can also be used as a backup plugin. Upon activation, the plugin adds a new “Duplicator” menu item in your WordPress admin sidebar. Clicking on it will take you to the packages screen of the plugin.
To create a new package, you need to click on the create new package button. Duplicator will start creating a package of your entire WordPress site. This may take a while, depending on how much data you have on your live site. Once finished it will redirect you to the packages screen, showing newly created package with a installer file. To move your site you need to download both, the zip package, as well as the installer file to your computer.
Your local server site will need a new database, so you need to create a database on your local server using phpMyAdmin. Once you have created the database you need to copy paste the package and install file to an empty folder in your local server’s web directory. To run the installation script, you need to open the install file in your web browser. For example if you pasted both files in /test-site/ folder you will access them in your browser by visiting http://localhost/test-site/install.php. You will now see the Duplicator installation script like this:
On this screen, you need to provide your local server’s database information. The host is usually the localhost. If you have not created a new user for MySQL on your site, then your username would be root. If you are using a password for the root user then enter that password, otherwise leave it blank. Lastly, you need to enter the database name you just created.
The installer will now extract your database and WordPress files from the zip package and import them. Depending on the size of package, this may take a while. Once the installer has extracted the files and imported database, it will redirect you to the update page.
On the update page, you need to provide the URL of your live site and the URL of the site on your local server. The plugin will automatically detect these values make sure they are correct and then click on the update button. Duplicator plugin will now update URLs in your database.
That’s all, you have successfully moved your live site to local server. The installer will show you a success page. You would also need to update permalinks on your local server site and delete the installer file and package.
Manually Move a Live WordPress Site to Local Server
In case the plugin does not work for you, then you can always manually move your live site to local server. The first thing you would need is to back up your website manually. We have a tutorial on how to backup your WordPress database manually. We recommend using phpMyAdmin to export your WordPress database.
To export your live site’s WordPress database, you need to log into your cPanel dashboard and click on phpMyAdmin. Inside phpMyAdmin you need to select the database you want to export and then click on the export tab on the top.
phpMyAdmin will now ask you to choose either quick or custom export method. We recommend using custom method and choosing zip as the compression method. Sometimes WordPress plugins can create their own tables inside your WordPress database. If you are not using that plugin anymore, then the custom method allows you to exclude those tables. Leave rest of the options as they are and click on the Go button to download your database backup in zip format.
Once you have downloaded your database backup, the next step is to download your WordPress files. To do that you need to connect to your WordPress site using an FTP client like Filezilla. Download all your WordPress files and folder to your computer. Downloading all your files may take a while depending on how much data you have on your website.
After downloading your WordPress files, if you downloaded all your files and not just the wp-content directory then simply copy paste these files in your local server folder where you want to install WordPress.
On your local server, you need to create a database for your WordPress site. To do that you need to open http://localhost/phpmyadmin/ in your web browser and create a new database. After creating the database click on the Import tab on top. On the next screen you need to click on the Choose File button to select the WordPress database export file you downloaded earlier, and then click on the Go button. phpMyAdmin will now import your database and will show you a success message when it is done.
Now that your database is all set up, you need to update the URLs inside your WordPress database referencing to your live site. You can do this by running an SQL query in phpMyAdmin. Make sure you have selected your local site’s database and then click on SQL. In phpMyAdmin’s SQL screen copy and paste this code, make sure that you replace example.com with your live site’s URL and localhost/test-site with the local server URL of your site.
UPDATE wp_options SET option_value = replace(option_value, 'http://www.example.com', 'http://localhost/test-site') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET post_content = replace(post_content, 'http://www.example.com', 'http://localhost/test-site'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.example.com','http://localhost/test-site');
This query will replace refences to your live site’s URL from database and replace it with the localhost URL.
The final step is to update your local site’s wp-config.php file. You need to go to the folder where you installed WordPress on your local server and open wp-config.php file in a text editor like Notepad. Replace database name with the one you created in phpMyAdmin on your localhost. Replace the username with your local mysql username, usually it is root. If you have set password for mySQL user root on your localhost, then enter that password. Otherwise leave it empty and save your changes.
/** The name of the database for WordPress */
define('DB_NAME', 'database_name_here');
/** MySQL database username */
define('DB_USER', 'username_here');
/** MySQL database password */
define('DB_PASSWORD', 'password_here');
That’s all your live site is now copied to your local server, and you are ready to test drive it. We hope that you found this tutorial helpful. If you have any questions or feedback, then please leave a comment below.
Tutorial worked pretty good but I had “internal Server Error”. I was downloading an entire network installation. I recopied the wp-config.php file because it had become compressed, all spacing removed. Then replaced the .htaccess with a fresh network version and that “RewriteBase /sitename/” was to the folder of the installation, instead of “RewriteBase /”
The instructions are clear and straightfoward but unfortunately I am having a total nightmare getting my site to work on the local server. After much trial and I’ve managed to get connect to the database and get some of the site content displayed but links aren’t working (they’re not found, apparently). I’m using MAMP Pro for Windows. Maybe I’ll try XAMMP – or using a Mac – instead. I think alot of the problem is to do with permissions but don’t really know where to start there seem to be so many fixes needed!
Hi Emma,
If you can access the WordPress admin area, then try visiting Settings » Permalinks and then click on the save changes button without changing anything.
I solve my problem. If you manually moved wordpress to localhost, and you install w3 total cache in your wordpress, you have to clear the browser cache after change database and wp-config. Or just open your localhost site with different browser.
I have changed wp-config and all database url to localhost, but localhost still redirect me to live site. Why? I cannot install any plugin like duplicator anymore because the site already deleted
Hi Andy
Have u tried changing the settings from wp dashboard?
Settings-> General->WordPress Address (URL),Site Address (URL)
Even if it shows the localhost address just save it and check. Hope it helps.
Hi wpbeginner,
Thank you for the tutorial, it helps me a lot. I tried the manual install and but in the end it keeps redirecting me into wordpress installation page. Pls help me, i think i’m almost done. Im using xampp.
Thank you
Hi,
Im having issues while moving my site, it says LOCALHOST REFUSED TO CONNECT.
But my other local sites are okay.
Im moving it to local because something gone terribly wrong and my page woun’t load on the server’s.
Please any suggestion or advise is appriciated
In MAMP Preferences set your Ports to – Apache 80, Nginx 443 and MySQL 3306 and see if that fixes it
Thanks for this article, I found it very useful but would like to add to it if I may.
I used the manual method successfully with one exception, I could not navigate to any of the pages or posts from my sites menu. I would get a page not found error. I tried everything here, saving the premalinks, but nothing worked. I finally found a post elsewhere that gave me the solution. I had to modify a line in Apache’s httpd.conf file. Open the file and search for ‘AllowOverride’. If it looks like this: ‘AllowOverride None’, change it to ‘AllowOverride All’. I could not get to every page and post and see all the content!. FYI, there are several ‘AllowOverride’ options but the one you are looking for resides on a line by itself. I know this is a WordPress and not an Apache config forum but others may be experiencing the same issue. Hope this helps.
Hello Guys,
I’m running into a serious problem. When I click on my local site forler with servers ON on MAMP, it redirects to live site
I’ve done everything this tutorial says, do you know where is the problem ?
Thanks for your help
Hi
I am also having blank screen like IDRIS D…any suggestion
Unfortuntely when I follow this guide, all the links in my local site redirect to the live site.
Any suggestions?
Hi,
after following the instructions for the manual migration I end up with a blank screen when I try to access my website on the localhost. Any ideas?
After running the SQL Query to replace links I receive a 1064 error – it seems there is a problem with the code syntax. I’m guessing it’s the (:) in my localhost url : ‘http://localhost:888/localwebsite’ – any ideas how I can work around this? I am using MAMP to run the local server.
try four ‘8’s instead of 3…. localhost:8888/localwebsite
Hi there!
I’ve had a successful migration to local site except for my Media Library, every picture is there (lots of files), url’s are correct, but when they don’t show up in the actual blog. When I go to media library it just shows the grid of the pics – all blank, but in description, url etc everything is correct.
Any idea what to do next?
Try going to your wordpress dashboard, click on the settings menu near the bottom of the sidebar on the left. Then click on the reading menu in the settings submenu, scroll down to the site visibility options and select the ‘allow search engines to index’ option and click save changes at the bottom of the page. See if that works, if not you may have to go to your terminal and manually pull media files from your old site recursively – I had to go this route and can walk you through it if you have any questions. Hope this helps
Hi there, Thanks for the post, it’s a huge success for me.
So far, I’ve been able to get to the wp-login page.
and I’m sorry if this is a very silly question. but I’m really newbie with wp
my problem is I can’t login :$
I’ve tried the same logins as the live details = don’t work
as I haven’t set up the dashboard and it’s a local. no email will work.
what should I do?
btw, it’s on a mac.
Many thanks in advanced. Help is appreciated!!
Hi Carolina,
You can change password using PHPMyAdmin.
Hi again,
My sincere apologies! Posted a comment yesterday (July 24) re difficulty running the Duplicator program from my browser. Went back to check today and realised that I had made a mistake with the placement of the “test-site” folder which contained the installer.php and the zip archive database.
Once I truly placed this folder in the htdocs folder then everything worked fine and I was able to install the website data locally as per your instructions.
Thank you again for all your help!
Hi — thank you again for another great article! All very helpful!
I am at the step of opening the Duplicator installer on my local computer. However when I put “http://localhost/test-site/installer.php” into my browser I get a “404 error message” saying “object not found”.
Interestingly if I use “localhost” alone or “localhost/phpmyadmin” they both work. I have moved the “test-site” folder to the “htdocs” folder but still does not work.
Any suggestions??
Thank you
Thanks for this guide, but what if you’re migrating from a live site with an SSL cert down to a dev site without SSL (https to http?)
I got the front-end working fine, however, HTTPS is still added to my wp-login URL, preventing me from accessing the login page into the admin.
Any additional steps required to eliminating https on a local/dev site’s WP login page?
I am having a similar issue. I migrated a live site to MAMP using WP Migrate DB plug in and FTP. I get the following error – due to the live sites SSL Certificate. It has something to do with the database prefixes not matching. But – I cannot change the prefix on the live site, I called Go Daddy to see if I edited the live site prefix to match my local install database prefix if it would break the site, they said no guarantees, I tried it and it broke the site.
error message I get when entering localhost:8888 url.
An error occurred during a connection to localhost:8888. The client has encountered bad data from the server. Error code: SSL_ERROR_BAD_SERVER
The page you are trying to view cannot be shown because the authenticity of the received data could not be verified.
Please contact the website owners to inform them of this problem.
Thank you in advance for any help!
Well, i used SSL certificate and that is what I did:
At the step where you have to update the URLs inside your WordPress database referencing to your live site, you write the SQL query 4 times to change every URL that may exist.
First time write code like above “http://www.example.com”, then “http://example.com”, after that “https://www.example.com” and finally “https://example.com”.
Make sure: 1) that you write all four times the URL
http://localhost/test-sitewhich will replace those URLs2) change wp_options, wp_posts and wp_postmeta to your right ones (mine for example were cagwp_options etc.)
And a last reminder: Finally (if you’re moving on localhost), on the last step you have also to change the host name to localhost (wp_config.php file)
/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);
I am tried using this article but I am not sure at which point of time i am supposed to install wordpress. Can anyone help me here?
Thanks
you don’t have to reinstall wordpress again. all files from the source wp installation is already backed up.
I have used these instruction before and they worked fine, however i now have an updated version of mamp and wordpress and i continually get errors. betwen playing around i get the white blank screen or the index.php file. as text.
Both similar problems to users below.
it might be time to update this.
I gave up on moving my site to local and decided to just have a dev url too however, when i run the sql query above i always end up with a token missmatch, despite making all the necessary changes.
Thank’S a lot for your work.
But it doesn’t work. If I run local installer.php I see blank screen.
Best regards
Andi
hey
I did everything as it is described and when I get to the last phase and put the url: localhost/mysite it automatically downloads a file that has this information:
<?php
/**
* Front to the WordPress application. This file doesn't do anything, but loads
* wp-blog-header.php which does and tells WordPress to load the theme.
*
* @package WordPress
*/
/**
* Tells WordPress to load the WordPress theme and output it.
*
* @var bool
*/
define('WP_USE_THEMES', true);
/** Loads the WordPress Environment and Template */
require( dirname( __FILE__ ) . '/wp-blog-header.php' );
is it something wrong that i did in the process?
I wasn’t successful with the Duplicator plugin but managed to get my site sort of working the manual way.
I now have another problem. My site opens up correctly but I am unable to do anything. I keep getting 404 Page not Found errors. This happens with my menu items, search bar, login button etc. I can go nowhere on my site. What do I do?
Albert
404 means the page is not found, sounds like you haven’t updated your database urls, be sure to follow that step. all your anchors are pointing to links that arn’t available on your server.
I have done the entire process from the zip file and install.php. In step 3, when I click on Save Permalinks, it takes me to the WP login screen. No matter what I type in, the result is always the same: Invalid Username. I have run this Duplicator twice now, still no luck. Please help.
Albert
Just wanted to say thanks for such a great and straightfoward description.
I’d tried this a couple of times before using the info on wordpress.org but it never worked.
Followed your article step by step (manual method, non-plugin) and it worked perfectly!!
Thanks
Hey Richard,
Glad you found it useful
Don’t forget to join us on Twitter for more WordPress tips and tutorials.
Thank you very much for this tutorial!
I did the manual install, although it didn’t quite do the trick at first. I got a Database Connection Error. Maybe most of you already know this, but i only saw it upon later glance:
In my wp-config.php file, underneath the DB_NAME, DB_USER and DB_PASSWORD there was this line:
/** MySQL hostname */
define(‘DB_HOST’, ‘host.example.de’);
I had to replace ‘host.example.de’ with ‘localhost’ to fix the issue. Now it works like a charm.
Thank you again and i hope you have a fantastic day!
Regards LS
Yes, same here. That should definitely be updated in the article to save future viewers some time.
This website has saved my hide several times now. Keep it up!
Thank you!!!
Hello,
I am receiving an error when reaching this step:
“Now that your database is all set up, you need to update the URLs inside your WordPress database referencing to your live site. You can do this by running an SQL query in phpMyAdmin. Make sure you have selected your local site’s database and then click on SQL. In phpMyAdmin’s SQL screen copy and paste this code, make sure that you replace example.com with your live site’s URL and localhost/test-site with the local server URL of your site. ”
The error is:
#1146 – Table ‘rpd.wp_options’ doesn’t exist
Please advise, thank you!
Thanks for all of your hard work. I’m a beginning web developer and your site is incredibly helpful.
I have looked at both of your articles about migrating from local to live and vice versa. I built a WordPress site locally and used it to replace an existing HTML site. I then made changes to the live site, and I’m not quite sure how to go about “syncing” them again. What would you suggest?
Hi Martin,
Please take a look at our guide on setting up a staging environment.
Thank you for the article, however i have still been having problems.
One thing i don’t understand, is that you start of by recommending using backupbuddy (which i have been using to backup my sites) but then suddenly say to use this duplicator plugin.
I have my full backup (with db) zip of my wordpress site which i created with backupbuddy and have unzipped it into its own folder in the “www” folder in wamp.
I successfully create a new DB in PhpMyAdmin and then successfully imported my website db into it. I have also changed the config.php db name and password.
However on the next step, trying to change the urls it comes back with:
#1146 – Table ‘zexico.wp_options’ doesn’t exist
#1146 – Table ‘zexico.wp_posts’ doesn’t exist
#1146 – Table ‘zexico.wp_postmeta’ doesn’t exist
What have i done wrong?
thank you
Hi. I’m getting the same error. Were you able to fix it ? Than you !
Following on from my earlier comment – I fixed the problem! For some reason the duplicator plugin wasn’t copying across all of my database tables, which was causing the first round of issues – I sorted that by switching to the manual method. Then when I was running the queries in mysql I didn’t realise at first that I had to amend the names of the database tables as well (i.e. was just pasting wp_options when I needed to adapt that) – I’m not sure if this is normal as your lines of code only highlight the urls as needing to be corrected? THEN I had to deal with my strange wp-config.php file that had all the ‘database’, ‘host’, ‘username’ fields already filled in – after trying both options it only worked when I deleted the data that wordpress had already filled in and replaced it with the localhost data as directed. I don’t understand why my wp-config file had its fields already populated but then I’m a complete newbie to all this so I’m bound to have missed/misunderstood lots. Anyway – thanks again for the tutorial as it did FINALLY get me there!
Hi there,
Thanks for the tutorial. I’ve attempted to migrate my site with duplicator and it seems to work except I then can’t log-in to my locally hosted site – it doesn’t recognise my username at all. After the duplicator installed my files I had two config.php files – one config-sample.php and one config.php, and also two htaccess files – one .htaccess and one ORIG – could these doubled-up files have something to do with my login issues? I’ve tried every variation of deleting one of each pair, and I’ve also tried replacing my wp-login file and deleting plugins as I read elsewhere this might help, but nothing has worked. I redid the entire process from packaging and still no luck! I’ve also tried manually but got stuck at the mysql query updates. Do you have any idea where I’ve gone wrong??
Many thanks!
Nina
I can’t tell you how grateful I am for this info. I have put an unbelievable amount of time into trying to get a live site onto my local server to no avail — and then I found your post today. Used the Duplicator and it WORKED!
THANK YOU!!!!!!!!! :-))
You’re very welcome Susan
I have copied website from hosting domain to local host. everything is fine but all links of menu and all are redirected to
how to solve it
hi ,
I had the same problem and just found the solution. I’m sure you’ve solved it by now but this might help others down the track.
in WordPress admin area go to settings-> permalinks. Choose Post name.
Your problems should be solved.
Thanks for all the excellent advice you give- it’s a wonderful service to the WordPress community.
I’ve begun using the All-in-1 WP Migration plugin to easily backup my site , and later migrate it if necessary.
It would also be good to be able to make changes to the sites on my own computer, checking them out before uploading updated files.
I’, installing XAMPP on my computer. Is there an easy way I can use my All-in-1 WP Migration backup files with this?
Any advice will be much appreciated.
Hi John,
Sorry but we haven’t tested this plugin. Please try contacting the plugin developers.
Great tutorial. Its important to mention that you need to delete the HTACCESS File in order to this to work.
Thanks
From local site?
Yes from the local site folder. I did that, and my site started working. However there are many other problems that I am facing even now. Like my category links are not working at all.
cool super clean tutorial, got mine to work without any issues.
Hi WPbeginner,
I have followed all the instructions for manual moving. But I’m getting a “Oops! That page can’t be found.” error on the mainpage, none of the content can be viewed. And all the links in my localhost site direct to my online website.
It seems only the the main structure of my site(theme, menus etc.) has been moved but all the rest is lost.
Is this error shown with your WordPress theme or on a blank white page? If it is shown on a blank white page, then this probably means that your WordPress site is not installed on the URL you are trying.
It shows on my WordPress theme. It also shows all my menus and content categories. But all the links take to the original websites address. Here is a screenshot if it’s gonna help:
Try refreshing your site’s permalink structure. Go to Settings » Permalinks page and click on the save changes button without making any changes.
I have the exact same issue, but I can not log-in into my localhost using wp-admin or wp-login as it takes me to the live-site domain.
Is there another way to login to my localhost/dev-site area to make this change? thanks in advance!
Dear WPBeginner,
First of all, Thank you for all you do in the WP community, my question is hopefully a pretty simple one. (Famous last words huh?) Currently I use CLEF to log in to my “Live Site”. When I move my Live site to my Local server, will this create any issues when attempting to log in to the local site once the move has been completed? Or do I need to create a new log in PW for my site via the Dashboard in my Live site before making the move to a Local environment or will CLEF still continue to work on my “Local Server”?
Also, do you all have any thoughts on using CLEF to log in? I’ve been using WP on and off for about 2 years and just want to get your opinion on CLEF.
Thank you very much in advance! You guys rock! After I get my site up and running you can bet I’ll promote your site to everyone I know. I’ve learned so much already from your site and I’ve only been a member for 2 almost 3 months now.
Have a great Day,
Jason Hess
You can disable Clef at anytime once you have transferred your site to local server.
I forgot the password of filezilla, so I couldn’t download all the file of live site. I have backup of live site wp_content only. What can I do now for local server.
Hi,
Thank You for Your helpful directions.After a long while, I finally got the live page to my localhost with the plugin BUT for some reason, the content pages are not found on the server-all the information, texts etc is there in the back-office but aren’t shown in the front office except for the front page.
Do You have any idea where/why the problem might occur?
Thank You in advance,
Maarja
Try following the steps in our beginner’s guide to troubleshooting WordPress errors.
Thank you very much
I have done it manually… from a live server to localhost. With your instructions I have managed this for the first time. And I even know now how to do a SQL query in phpMyAdmin. I feel like a real pro!
Hi,
i followed all the steps but i am getting internal server error .
I am confused in one step , after downloading the live site through filezill from godaddy host. i replace the wordpress folder with my live site folder i.e.
C:/users/amna/wamp/www/wordpress/old folders
with C:/users/amna/wamp/www/wordpress/mywebsite new folders
please help i am a beginner
Hi WEBBIGINNER SUPPORT, I followed the instruction for manual, it works very fine. Thanks for such intructions, I’ve been looking for this. Thanks again.
Hey Debenkumar, you are welcome. Don’t forget to join us Facebook for more WordPress tips and tutorials.
Hey! Thanks for the post.
I followed manual instruction and replaced my site URL with localhost/name of blog . The problem I am facing is, no images are being loaded in my blog. All the uploaded images are there in upload folder. The text is absolutely fine. The images url have changed to localhost but they are not showing up.
Could you please help me out in this?
hi, i followed the manual procedure to check my wordpress website in localhost using xampp, i hav changed the site URL, home and the wp-posts and wp-postmeta. the problem is my home page loading fine in localhost. but when i go the pages in the menu the following error is coming.
Object not found!
The requested URL was not found on this server. The link on the referring page seems to be wrong or outdated. Please inform the author of that page about the error.
If you think this is a server error, please contact the webmaster.
Error 404
localhost
Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.5.15
i logged into dashboard and can see all of the page content in the editing section, but from there also, when i try to view the page its reporting the same error.
the url path it is taking is my updatedURL only,
please reply with the solution
Go to Settings » Permalinks page and click on the ‘Save Changes’ button to update your permalinks.
Can I hug you? Can I love you forever?
I was having the same issue. I did everything correct, except the homepage would load , but all the other page links seemed to be broken (it just displayed an unstyled layout of my localhost information).
But going into Settings>Permalinks>Save Changes reset my links and now I can access my different pages, even the new pages that I create since moving my site to the local host.
LIKE!
Thanks Joshua, we are glad you found it helpful. You may also want to subscribe to our YouTube Channel for WordPress video tutorials.
After following the instructions to manually move the site, the home page displayed fine on localhost but none of the links worked. The page below said to “Go to settings/permalinks in the wordpress dashboard and update permalinks by clicking twice on save changes.” That fixed it.
I followed your steps , but only home page works fine and none of the links are working . Give The requested URL /akhdir3/category/health/ was not found on this server.
Dear Author,
I tried your step. But problem is when loading a page the localhost refer online site and the Menu links point to the online web site. How it can solve ?
Please advise.
Thanks
Anes
I have manually done all the above mentioned steps . But I am not getting the actual site which I want.There comes all uninstalled plugins in admin panel and the theme is also uncustomized. Where I am going wrong?
I’m trying to follow your instructions for a manual move.
When trying to find/replace the live site’s address with my local host, SQL tells me there’s a syntax error.
#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1
Are you sure the code is correct?
Fixed my own problem….sort of.
For some reason all my tables begin with wplm instead of just wp (wp_options = wplm_options for example). So updating the code to look for the correct table name allowed the script to run without errors.
But….SQL reports “# MySQL returned an empty result set (i.e. zero rows)” and the values in the table didn’t get updated. I had to go in and update the links by hand. In my case this was only 2 values in wplm_options, but I could imagine some people will have a lot more links to check.
Still, I do have my site imported now, and dealing with local hosting is a notoriously confusing process.
Thanks for the clear and simple instructions!