Trusted WordPress tutorials, when you need them most.
Beginner’s Guide to WordPress
WPB Cup
25 Million+
Websites using our plugins
16+
Years of WordPress experience
3000+
WordPress tutorials
by experts

Så här flyttar du en Live WordPress site till en lokal server

Vill du flytta en live WordPress website till en lokal server på din dator?

Installing WordPress on your computer (local server) allows you to easily learn WordPress and test things. När du flyttar en live WordPress-webbplats till en lokal server aktiveras du att experimentera med samma data som din live site.

I den här artikeln visar vi dig hur du enkelt flyttar en live WordPress site till en lokal server utan att något går sönder.

Moving a live WordPress site to a local server on your computer

Varför och vem skulle vilja flytta en live WordPress site till en lokal server?

Om du har run WordPress website under en tid, kanske du vill prova new themes eller ett plugin. Men om du gör detta på en live website kan det leda till dålig användarupplevelse för dina användare.

För att undvika detta skapar många användare en kopia av sin WordPress website på en lokal server för att testa nya themes, tillägg eller göra utvecklingstester.

This allows you to set up your theme with all your content and test all the features without worrying about breaking your site. Många användare kopierar sin site till en lokal server för att öva sina WordPress- och kodningsfärdigheter med faktiska site-data.

Även om du kan göra all testning med dummy content i WordPress, ger riktiga site-data dig en bättre visuell representation av hur dessa ändringar kommer att visas på din live site.

Förberedelser för att flytta en lokal site till en lokal server

Först måste du se till att du alltid säkerhetskopierar din WordPress website. Det finns flera bra tillägg för backup av WordPress som du kan använda.

För det andra måste du installera en lokal servermiljö på din dator. Du kan använda WAMP för Windows och MAMP för Mac. När du har installerat miljön måste du skapa en new database med hjälp av phpMyAdmin.

Besök helt enkelt följande URL i din webbläsare för att starta phpMyAdmin.

http://localhost/phpmyadmin/
http://localhost:8080/phpmyadmin/

Härifrån måste du klicka på tabben ”Databases” och skapa en new database. Du behöver den här databasen för att senare packa upp data från din live site.

Create database

Nu är du redo att flytta din live site WordPress till en lokal server.

Metod 1. Flytta Live WordPress site till en lokal server med hjälp av plugin

Den här metoden är enklare och rekommenderas för alla användare.

Det första du behöver göra är att installera och aktivera pluginet Duplicator. För mer detaljer, se vår steg-för-steg guide om hur du installerar ett plugin för WordPress.

Duplicator allow you att enkelt skapa ett duplicerat paket av hela din website. Det kan användas för att flytta din WordPress site till en new location, och kan också användas som ett backup plugin.

Vid aktivering lägger pluginet till ett new ”Duplicator” menu item i din WordPress admin sidebar. Om du klickar på det kommer du till vyn med paket för pluginet.

Creating new package in Duplicator

För att skapa ett nytt paket måste du klicka på knappen Skapa nytt paket. Duplicator kommer att starta paketguiden och du måste klicka på knappen Nästa för att fortsätta.

Duplicator package set up

Plugin kommer sedan att sanera din webbplats och köra några bakgrundskontroller. Det kommer då att visa dig en summary av dessa kontroller. Om allt ser bra ut klickar du på knappen ”Bygg” för att fortsätta.

Duplicator scan

Duplicator kommer nu att skapa ditt website-paket.

När det är slutfört kommer du att se en archive ZIP-fil som innehåller all din webbplatsdata och en installatörsfil. You need to download both files to your computer.

Download package files

You är nu redo att packa upp och installera dessa filer på din språkversion av servern.

Först måste du skapa en new folder i rotmappen på din lokala server. Det är den folder där din lokala server lagrar all website.

Om du till exempel använder MAMP kommer det att vara /Applications/MAMP/htdocs/ folder. Alternativt om du använder WAMP, då blir det C:\wamp\www\ folder.

I den här mappen kan du skapa nya mappar för varje new website som du vill importera eller skapa på din lokala server.

Creating a website folder on your local server

Efter det måste du öppna den folder som du skapade för din lokala website och sedan copy and paste både archive ZIP-filen och skriptet för installeraren som du downloadade tidigare.

Copy and paste Duplicator package and installer files

För att köra installationen måste du öppna skriptet installer.php i din web browser.

Om du till exempel klistrade in båda filerna i /mylocalsite/ folder, så kommer du åt dem i din webbläsare genom att besöka http://localhost/mylocalsite/installer.php.

Du kommer nu att se installationsskriptet för Duplicator så här:

Duplicator installer screen

Klicka på knappen Nästa för att fortsätta.

Duplicator kommer nu att packa upp archive ZIP-filen och kommer att be dig att enter din lokala site’s database information. Detta är den Database som du skapade tidigare.

Duplicator database information

Namnet på servern är nästan alltid localhost och användarnamnet är root. I de flesta fall har din installerade lokala server inte ett password för root, så du kan lämna det tomt.

Längst ner på sidan ser du en ”Test Database” knapp som du kan använda för att se till att din databas är korrekt.

Test database connection

Om allt ser bra ut klickar du på knappen ”Next” för att fortsätta.

Duplicator kommer nu att importera din WordPress database. Efter det kommer den att be dig att dubbelkontrollera informationen om den nya website som den automatiskt har upptäckt.

Check local site information

Klicka på knappen Nästa för att fortsätta.

Duplicator kommer nu att slutför installationen och visa dig en knapp för att logga in på din lokala site. Du använder samma WordPress-användarnamn och password som du använder på din live site.

Import finished

Alltså har du utan problem flyttat din live site till en lokal server.

Metod 2. Flytta en Live WordPress-webbplats manuellt till en lokal server

Om tillägget inte fungerar för dig, kan du alltid manuellt flytta din Live site till en lokal server. Det första du behöver är att säkerhetskopiera din website manuellt från ditt WordPress webbhotell konto.

Step-by-Step 1. Exportera din live-webbplats WordPress-databas

För att exportera din live sites WordPress-databas måste du logga in på din cPanel dashboard och click på phpMyAdmin.

Note: Vi visar screenshots från Bluehosts dashboard.

cPanel phpMyAdmin

Inuti phpMyAdmin måste du välja den databas du vill exportera och sedan klicka på export tabs högst upp.

Export WordPress database manually

phpMyAdmin kommer nu att be dig att välja antingen snabb eller custom exportmetod. Vi rekommenderar att du använder customize-metoden och väljer zip som komprimeringsmetod.

Ibland kan tillägg till WordPress skapa sina egna tabeller i din WordPress-databas. Om du inte använder det pluginet längre, tillåter den anpassade metoden dig att utesluta dessa tabeller.

Lämna resten av alternativen som de är och klicka på knappen Go för att ladda ner din backup av databasen i zip-format.

Select export options

PhpMyAdmin kommer nu att downloada din database-fil. För mer detaljer, se vår tutorial om hur du gör en backup av din WordPress-databas manuellt.

Step-by-Step 2. Download all your WordPress filer

Nästa steg är att downloada dina WordPress-filer. För att göra det måste du ansluta till din WordPress site med hjälp av en FTP-klient.

När du är ansluten väljer du alla dina WordPress-filer och downloadar dem till din dator.

Download all your WordPress files

Step-by-Step 3. Importera dina WordPress-filer och din database till den lokala servern

När du har downloadat dina WordPress-filer måste du skapa en folder på din lokala server där du vill importera den lokala webbplatsen.

Om du använder WAMP vill du skapa en folder i mappen C:\wamp\www\ för din lokala site. MAMP-användare måste skapa en folder i mappen /Applications/MAMP/htdocs/.

Efter det är det bara att copy and paste dina WordPress-filer i den nya mappen.

Därefter måste du importera din WordPress database. Öppna helt enkelt phpMyAdmin på din lokala server genom att besöka följande URL:

http://localhost/phpmyadmin/

Eftersom du redan har skapat databasen tidigare måste du nu välja den och sedan klicka på Import tabs högst upp.

Import WordPress database

Klicka på knappen ”Choose File” för att selecta och uploada filen för att exportera databasen som du downloadade i första steget. Därefter klickar du på knappen ”Go” längst ner på sidan.

PhpMyAdmin kommer nu att packa upp och importera din WordPress database.

Nu när din database är all, måste du updating URL:erna i din WordPress-databas som hänvisar till din live site.

Du kan göra detta genom att runna en SQL-sökning i phpMyAdmin. Se till att du har valt din lokala sites databas och klicka sedan på SQL.

Updating URLs in database

I phpMyAdmins SQL vy copy and paste denna kod, se till att du ersätter example.com med din live-webbplats URL och http://localhost/mylocalsite med den lokala server-URL:en för din site.

UPDATE wp_options SET option_value = replace(option_value, 'https://www.example.com', 'http://localhost/mylocalsite') WHERE option_name = 'home' OR option_name = 'siteurl';
 
UPDATE wp_posts SET post_content = replace(post_content, 'https://www.example.com', 'http://localhost/mylocalsite');
 
UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://www.example.com','http://localhost/mylocalsite');

Denna sökning kommer att ersätta referenser till din live-webbplats URL från databasen och ersätta den med den lokala webbadressen.

Step-by-Step 4. Update wp-config.php-filen

Det sista steget är att update wp-config.php-filen på din lokala site. Den här filen innehåller WordPress-inställningar, bland annat hur du ansluter till din WordPress-databas.

Gå bara till den folder där du installerade WordPress på din lokala server och öppna sedan wp-config.php-filen i en textredigerare som gillar Notepad.

Byt ut namnet på databasen mot den som du skapade i phpMyAdmin på din lokala server.

Därefter ersätter du användarnamnet för databasen med ditt lokala användarnamn för MySQL, vanligtvis är det root. Om you har ställt in ett password för MySQL-användaren root på your localhost, enter då det passwordet. 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');

Du kan nu besöka din lokala site i ett fönster i webbläsaren genom att enter URL:en så här:

http://localhost/mylocalsite/

Ersätt ”mylocalsite” med namnet på den folder där du har kopierat dina WordPress-filer.

Det var all, din Live WordPress site är nu kopierad till din lokala server.

Vi hoppas att den här artikeln hjälpte dig att lära dig hur du enkelt flyttar en live WordPress site till en lokal server. Du kanske också vill läsa vår guide om hur du enkelt skapar en staging site för WordPress för testning, eller hur du flyttar en WordPress-webbplats från en lokal server till en live site.

Om du gillade den här artikeln, vänligen prenumerera på vår YouTube-kanal för WordPress video tutorials. Du kan också hitta oss på Twitter och Facebook.

Avslöjande: Vårt innehåll stöds av våra läsare. Det innebär att om du klickar på några av våra länkar, kan vi tjäna en provision. Se hur WPBeginner finansieras, varför det är viktigt, och hur du kan stödja oss. Här är vår editoriala process.

Avatar

Editorial Staff at WPBeginner is a team of WordPress experts led by Syed Balkhi with over 16 years of experience in WordPress, Web Hosting, eCommerce, SEO, and Marketing. Started in 2009, WPBeginner is now the largest free WordPress resource site in the industry and is often referred to as the Wikipedia for WordPress.

Den ultimata WordPress-verktygslådan

Få GRATIS tillgång till vår verktygslåda - en samling WordPress-relaterade produkter och resurser som varje professionell användare bör ha!

Reader Interactions

257 kommentarerLämna ett svar

  1. Syed Balkhi

    Hey WPBeginner readers,
    Did you know you can win exciting prizes by commenting on WPBeginner?
    Every month, our top blog commenters will win HUGE rewards, including premium WordPress plugin licenses and cash prizes.
    You can get more details about the contest from here.
    Start sharing your thoughts below to stand a chance to win!

  2. Aamir Khan

    I have created a backup of my website manually and setup on local machine and run the above quires, but my website is redirecting to online version.

    • WPBeginner Support

      It seems like you may have not updated the URL, you can do so using step 3 of the manual method of this article. :)

      Administratör

  3. George

    Thank you so much for this clear and useful article. I was able to follow it and migrate my WP site in less than 20 minutes – and I’m no expert. You’ve saved me a lot of pain – thank you.

    • WPBeginner Support

      Glad our guide was helpful :)

      Administratör

  4. Barry

    Doesn’t work for me. I create the package, but it installs the basic WordPress files. So when I navigate to the folder it asks me to setup wordpress

    • WPBeginner Support

      For the most common reason, you would want to ensure you are properly connected to the database, if you are not then it would show the option for creating a new site instead of showing the correct site.

      Administratör

  5. Daniel

    Nooo, its not working for me. pefrectly written tutorial and easy to follow (apart from it says hhttpps in the 3rd query)

    i get this in my browser:

    This site can’t be reachedlocalhost refused to connect.
    Try:

    Checking the connection
    Checking the proxy and the firewall
    ERR_CONNECTION_REFUSED

    • WPBeginner Support

      Thanks for pointing out that typo, it should be fixed. For that error, you would want to ensure you updated your URL in step 3 correctly for the most common reason for that issue.

      Administratör

  6. McKenzie

    Thanks for your tutorial.

    The front page is partially working but every other page is not working at all. Furthermore, it seems that front page is loading All the pages. What could be wrong?

  7. Collins

    Hi, Thank you for this super useful article.

    I don’t know why mine doesn’t just work, I have done the exact same thing and gotten all the correct feedback. Whenever I try to open the home page localhost/site/ I get a page that doesn’t exist with the headers and footers and the rest of the pages still point to the live site.

    • WPBeginner Support

      It sounds like you may have not set the URLs correctly. You would likely want to go to method 2 and try the SQL changes to update your URLs.

      Administratör

  8. Murat

    For those who are getting ”wp_options doesn’t exist” error, you may have changed your table_prefix before. Just open the wp_config.php file and check $table_prefix = ’wp_’

    if the value isn’t ”wp_” you get that error so when pasting the code edit it accordingly, for instance:
    UPDATE xx_options SET option_value………..

    • WPBeginner Support

      Thanks for sharing this should someone be running into that error :)

      Administratör

  9. Chinwe

    Thank you so much for this. It worked.

    • WPBeginner Support

      Glad our guide was helpful :)

      Administratör

  10. Ivana Spasic

    When I copy and paste the code you provided to phpMyAdmin’s SQL screen, I am getting message: #1146 – Table ’xyz.wp_options’ doesn’t exist.

    How can this be fixed?

    • WPBeginner Support

      You would want to ensure you have the correct database selected for the most common reason for that issue.

      Administratör

  11. Jill

    I used the Duplicator plugin to set up a copy of a website for a non-profit that I inherited. After reloading it so that all plugins are disabled I finally came to the conclusion that my site is attempting to use https:// to log in to the dashboard. To further confuse me, an empty site that I created on localhost does NOT use https:// for log in to the dashboard. I understand the value of https:// on the live site, but it appears there may be a way to disable it on localhost?

  12. Hazel beaver

    Is there a plugin that allows you to download a zip file from the live site then upload into a fresh install of wordpress on the local host in a simpler way?

    • WPBeginner Support

      For what it sounds like you’re wanting, the closest would be method 2 of this guide that you would want to take a look at.

      Administratör

  13. Daniel

    I successfully uploaded to localhost but when i try to use localhost/mysite_location/wp-admin, it redirects to the live site. Not the one on the localhost.
    Need help :(

  14. Bine

    Great tutorial. It’s straight forward. Unfortunately I still get redirected to the dashboard as soon as I try to enter my URL. I followed all the steps but something must be missing. Does anyone has an idea what the problem might be? Cheers

    • WPBeginner Support

      You may want to check your options table in your database to be sure that you didn’t set the site’s url to your wp-admin area

      Administratör

  15. Niaz Muhammad

    Great tutorial thanks for sharing your knowledge

    • WPBeginner Support

      Glad you liked our article :)

      Administratör

  16. alvaro hernandez

    it works great!!! i love you!

    • WPBeginner Support

      Glad our guide was helpful :)

      Administratör

  17. T_WA

    Hi, thanks for the tutorial, it’s was super helpful!!
    However, after following all your steps, I have problems ”establishing secure connection” (I guess because of the SSL) and thus it doesn’t work . I even tried and changed a line ’DB_HOST’ to ’localhost/localhost:8888’ in the wp-config.php that wasn’t mentioned in the video but didn’t help.

    Also, when changing links I tried many variations nothing worked. Has someone faced a similar issue and found a solutions to it?

    • WPBeginner Support

      Did you attempt to clear all of your caching after updating the URLs and is there the option to continue anyway under advanced on that error page?

      Administratör

  18. Said

    First of all thank you for theses clear explanations that I followed to the letter. The result is that i can access to to my site homepage locally, but links in this homepage do not seem to work because when I click on a link, for example :
    localhost.mysite.com/subject.html
    it is the following page that is displayed fir all links :
    localhost/dashboard

    Can you help me to resolve this problem
    Thanks in advance

  19. Ifthikar Hussain

    Great Working, am facing a new problem which is i can access the only home page of my word press side. how can i able to access other pages??

  20. Hannah

    Hi there,

    this is really easy to follow and helpful so thank you for that.

    I do have a very straightforward question though.

    When updating the URLs, you say to replace http:// example.com with your live site, but what if my live site uses https?

    • WPBeginner Support

      If you’re moving your site to a local server we recommend http to avoid local installation issues with not having an SSL, you would change to https if you’re moving the content back to a live site that is using SSL.

      Administratör

  21. Philip

    Thanks. You wrote this article over 5 years ago, and it’s still good. I managed to set everything up nicely without too much trouble by following your manual instructions. Thanks in particular for the SQL queries.
    Philip

    • WPBeginner Support

      Glad our guide could be helpful and still works :)

      Administratör

  22. Basem

    After finishing the installation I click Admin Login button. the browser open new window to the installation of wordpress again? and the login page is not there

    I checked the folders. all files are copied.

  23. Patrick

    Somebody find a fix for the localhost site copy (from live https) administration wanting to use https ?

  24. dowlass

    I found your instructions for the manual move of my site (from live server to localhost) worked pretty well. I had to do the permalinks thing – just click on ’save’ without changing anything – to make links work properly. But otherwise it’s mostly good.

    However, I’ve encountered a problem when trying to use new themes. If I add a new theme, then sure the theme installs ok and shows up on the theme page. However, if I try to preview or activate the new theme I just get a totally blank page – even the admin goes blank. The only recourse is to use the browser back button to get back to the admin view where I can delete the theme.

    Adding new themes and trying to use them just makes the whole thing fall over!

    Any ideas?

    (p.s. I’m using a very old version of WordPress – 2.9.2…!! Which is the reason for wanting to play with it on localhost and work out the best way to upgrade.)

  25. Michael

    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 /”

  26. Emma

    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!

    • WPBeginner Support

      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.

      Administratör

  27. andy

    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.

  28. andy

    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

    • Suhana

      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.

  29. Patrick Pogi

    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

  30. Jason

    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

    • John

      In MAMP Preferences set your Ports to – Apache 80, Nginx 443 and MySQL 3306 and see if that fixes it

  31. Steve

    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.

  32. Braun Philippe

    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

  33. Sara

    Hi

    I am also having blank screen like IDRIS D…any suggestion

  34. Idris D

    Unfortuntely when I follow this guide, all the links in my local site redirect to the live site.
    Any suggestions?

  35. Adrian Stangell

    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?

  36. Joel M

    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.

    • Aaron L

      try four ’8’s instead of 3…. localhost:8888/localwebsite

  37. Natalie Bell

    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?

    • Grant

      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

  38. Carolina

    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!!

  39. DavidA

    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!

  40. DavidA

    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

  41. Shun

    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?

    • simone

      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!

    • xasmatic

      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-site which will replace those URLs
      2) 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’);

  42. Veer Abheek Singh Manhas

    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

    • AIAI

      you don’t have to reinstall wordpress again. all files from the source wp installation is already backed up.

  43. Alex

    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.

  44. Andi

    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

  45. mc

    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?

  46. Albert Smit

    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

    • Matthew

      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.

  47. Albert Smit

    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

  48. Richard

    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

    • WPBeginner Support

      Hey Richard,

      Glad you found it useful :) Don’t forget to join us on Twitter for more WordPress tips and tutorials.

      Administratör

  49. LS

    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

    • Abraham Quilca

      Yes, same here. That should definitely be updated in the article to save future viewers some time.

  50. RF

    This website has saved my hide several times now. Keep it up!

  51. Olivia

    Thank you!!!

Lämna ett svar

Tack för att du väljer att lämna en kommentar. Tänk på att alla kommentarer modereras enligt våra policy för kommentarer, och din e-postadress kommer INTE att publiceras. Vänligen använd INTE nyckelord i namnfältet. Låt oss ha en personlig och meningsfull konversation.