Wie man eine Live-WordPress-Site auf einen lokalen Server verschiebt

257 KommentareEine Antwort hinterlassen

1. Syed Balkhi says

   Mai 16, 2024 um 2:24 pm

   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. Joseph says

   Mai 7, 2015 um 1:10 pm

   Hi, just came across this tutorial today, I found out about some of the steps from other tutorials, but my problem is with the SQL Query. I get the error # MySQL returned an empty result set (i.e. zero rows). I followed all your steps about changing site names etc but cant work this one out and so obviously i cant then connect to the local site. I used the Duplicator before on another site but it wont work so good on this one because of all the images on my photo site, ie timeout issues. Kinda going around in circles here, so help would be good.
   Thanks,
   Joseph

   Antworten

   • Yarina says

     Mai 26, 2015 um 8:59 pm

     Joseph, check that the table prefix on the SQL tables you are working with are the same. I had this issue before when I didn’t realize that the theme I was copying from had a non typical prefix (wp_extra-text instead of just wp_). When you create the new db on phpMyAdmin, make sure that the prefix matches that of the old db. Hope this helps!

     Antworten

3. Alan OldStudent says

   Apr 30, 2015 um 11:44 pm

   I tried using Duplicator, and that worked with one minor glitch. So then I dropped the database and tried the manual method. All steps proceeded well until it came time to import. I recreated the database and went to import. Afterwards, I got this error message: „#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚default‘, ‚This is the default profile, used when no profile is specified.‘, ‚a:‘ at line 7“

   To me that looks like gobbledygook. Do you have any idea what went wrong and how I can do the import manually?

   Regards,
   Alan

   Antworten

   • WPBeginner Support says

     Mai 1, 2015 um 12:14 am

     This could be a syntax error or conflict caused by using different versions of MySQL. To solve this, when exporting your database choose the same MySQL version as your local install. Also make sure that you are using the same character set for both database tables.

     Antworten

     Admin

4. Em Cloney says

   Feb 16, 2015 um 3:42 am

   Just a quick thing I noticed: the Duplicator file is called „installer.php“ rather than „install.php“.

   Antworten

   • Ben says

     Apr 24, 2015 um 12:51 pm

     I noticed the same thing. Great article, though. So glad I heard about this plugin from you guys.

     Antworten

5. wpva says

   Feb 13, 2015 um 7:08 am

   Hi I decided to do it manually

   I created a database for my WordPress site on my local server and tried to import the database that I downloaded before to my computer but im getting this error message:

   SQL query:

   —
   — Database: `aguilar_jmln1`
   —
   — ——————————————————–
   —
   — Table structure for table `gm_AnythingPopup`
   —

   CREATE TABLE IF NOT EXISTS `gm_AnythingPopup` (
   `pop_id` int(11) NOT NULL,
   `pop_width` int(11) NOT NULL DEFAULT ‚380‘,
   `pop_height` int(11) NOT NULL DEFAULT ‚260‘,
   `pop_headercolor` varchar(10) NOT NULL DEFAULT ‚#4D4D4D‘,
   `pop_bordercolor` varchar(10) NOT NULL DEFAULT ‚#4D4D4D‘,
   `pop_header_fontcolor` varchar(10) NOT NULL DEFAULT ‚#FFFFFF‘,
   `pop_title` varchar(1024) NOT NULL DEFAULT ‚Anything Popup‘,
   `pop_content` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   `pop_caption` varchar(2024) NOT NULL DEFAULT ‚Click to open popup‘
   ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

   MySQL said:

   #1046 – Aucune base n’a été sélectionnée

   Antworten

   • Kin says

     Okt 22, 2015 um 4:53 pm

     It is saying that no database was selected.
     Yeah I got that as well.
     You need to make sure that you clicked on a database before hitting the ‚import“, if not the admin tool will try to import the .sql file on nothing!!

     Antworten

6. TMo says

   Feb 10, 2015 um 10:51 am

   Wonderful tutorial on how to manually go through this process. Thank you for the clear directions and photos!

   Antworten

7. Shane Levine says

   Jan 21, 2015 um 8:07 pm

   Hi, is Duplicator an acceptable method for keeping a backup website? I have been using BackWPup but it looks like Duplicator also allows you to create a backup…

   Antworten

8. Dennis Crayon says

   Jan 17, 2015 um 7:37 pm

   Hi I am not sure if I just got lucky but I was able to download and setup the local version quickly. The only problem I am having is that I have to set permalinks to default which is fine locally will I be able to set them back to post name later when I push the whole thing live? Thanks just getting this far is great

   Antworten

   • WPBeginner Staff says

     Jan 17, 2015 um 9:39 pm

     Yes, you can change permalinks after putting your site live.

     Antworten

   • Felix says

     Apr 16, 2015 um 8:14 am

     Dennis, I am new to wordpress but I have so far learnt key configuration issues. Could you lease hel on changing permalinks from default to post name?

     Antworten

9. Iftikhar Raja says

   Dez 23, 2014 um 10:26 am

   Just an observation to share.

   If you choose custom structure as permalink, it might not work. The work around is to chose default permalink and save the changes. It worked for me after several hours of head scratching

   Hope it helps

   Antworten

10. Mario says

    Dez 16, 2014 um 11:44 am

    If you’re using WAMP you need to turn on mod_rewrite to enable custom permalinks.

    Click Wamp -> Apache -> Apache Modules -> rewrite_module

    Antworten

    • WPBeginner Staff says

      Dez 16, 2014 um 7:17 pm

      It is usually enabled by default.

      Antworten

11. isboleas says

    Sep 30, 2014 um 4:59 pm

    Perfect! I did it manually just in wp-config.php must change and the line
    /** MySQL hostname */
    define(‚DB_HOST‘, ‚127.0.0.1 ‚);
    With ip appear in phpmyadmin in left up corner.

    Antworten

12. Anindyo Yudhistiro says

    Sep 22, 2014 um 12:51 am

    I’ve followed all the steps, but I still can’t see my database in my local wp. I still only have Hello World post.

    I’ve imported it, change all the url’s, and many row has already affected.

    Antworten

13. Keith Davis says

    Sep 10, 2014 um 4:25 pm

    I used the manual method but the SQL query wouldn’t work for me.
    I had to go into the wp-options and change url in siteurl and home table and then all was fine.

    Antworten

14. Keith Davis says

    Sep 7, 2014 um 2:28 pm

    Hi guys
    The Duplicator method looks good.
    Do you know how much free disc space you need to create the packages?

    Antworten

15. Nana says

    Sep 1, 2014 um 4:34 pm

    Any ideas why it gives me a „Welcome to the famous five-minute install“ screen?

    Antworten

16. WPBeginner Staff says

    Aug 28, 2014 um 7:58 pm

    It is possible that your WordPress URL and Site URL are set to localhost/xammp. If you can access the admin area go to settings and set it to your WordPress install directory.

    Antworten

    • Je says

      Aug 29, 2014 um 10:37 am

      I checked and it’s definitely not set to that. It is so strange!

      Antworten

    • Je says

      Aug 29, 2014 um 10:41 am

      I figured it out. It was the W3 cache in the htaccess file causing problems. Thanks for you help and for this awesome tutorial!

      Antworten

17. Jen says

    Aug 28, 2014 um 3:52 pm

    Great tutorial, I did everything exactly like you said….I thought it was working until I tried to change the theme and it wouldn’t change. Then I started trying to navigate to other pages and it took me to localhost/xammp. Everytime. Any ideas?

    Antworten

18. dion says

    Aug 13, 2014 um 3:17 am

    Hi. I did all of this(using the manual option, but when I click on any option, ie login or one of the menu options, I get „the requested URL … was not found on this server“

    Antworten

19. wagster says

    Aug 7, 2014 um 5:03 pm

    If you copy the SQL query straight off the screen above, you will get the line numbers as well, which will throw an error like the above. Click ‚View source‘ and copy the clean code from there.

    Antworten

20. MrDev says

    Jun 18, 2014 um 4:33 am

    Thanks for this article. I tried the manual route of moving a WordPress site to localhost, however my stylesheets are not loading. For some reason the ‚href‘ is not being set on all my stylesheets. Any idea what might be going on?

    Antworten

21. WPBeginner Staff says

    Jun 11, 2014 um 12:07 am

    We would feel more confident recommending BackupBuddy for backups.

    Antworten

22. NikkiC4lyf says

    Jun 10, 2014 um 12:13 am

    Would you recommend using the Duplicator plugin for doing backups as well as moving sites?

    Antworten

23. Kin Tatsu says

    Jun 6, 2014 um 12:44 am

    Great tutorial! The problem I’m having is when I login to to wp-admin with the same login and password I used for my live site I get „ERROR: Invalid username. Lost your password?“ The username and password are correct for the live site but incorrect for the localhost site. I tried to retrieve password with my email address but it says that my email address is not registered. Any ideas?

    Antworten

24. pbr says

    Jun 3, 2014 um 11:13 am

    I have only one word about this steps…AAWWEESSOOMMEE!!!!

    Antworten

25. StefsterNYC says

    Mai 26, 2014 um 10:40 am

    Did you check your Prefixes?

    Antworten

    • pels says

      Aug 30, 2014 um 3:01 pm

      got same error

      Antworten

      • StefsterNYC says

        Aug 30, 2014 um 6:13 pm

        You may have missed a table or something. Do a search for the old prefix. Also make sure you’re using a fresh new WP-CONFIG. I find that sometimes that messes things up.

        Antworten

26. StefsterNYC says

    Mai 26, 2014 um 10:33 am

    Sorry for the delay Mark. Not sure I understand your question. Hopefully I can answer something here.

    If you started with a config file and it originally started with the wp_ and you didn’t use a custom one you’ll be fine. Just remember the config has to match the DB. If you worked locally and are migrating everything to a live site and you use the same DB and same Config that you worked locally with everything should be fine. Just remember to change Username, Password and Hostname.

    The key here to remember here is Prefixes. So many people teach you how to do this and that but they miss the one thing that can mess it all up for you. And that is the Prefix.

    And User Roles, if missed can cause a major headache when adding Admins manually. So be careful when changing and working with prefixes. They are absolutely a great way to tighten up WP sites. I highly recommend using a custom prefix always. dbh_234_ something like that is a great way to protect your site(s).

    Antworten

27. WPBeginner Staff says

    Mai 22, 2014 um 9:05 am

    If your live site’s mysql host is not localhost, then you need to change it to localhost. You may also need to change the database name to the database on your local computer. Same goes for DB username which is usually root on local servers, and db password which is usually blank.

    Antworten

28. Mark says

    Mai 22, 2014 um 12:51 am

    Hi just to be clear the password in the config.php file should be the same as the one you use for myphpadmin? because that seems to work for me?

    Antworten

29. StefsterNYC says

    Mai 15, 2014 um 6:48 pm

    Great tutorial. I believe one thing was missed. Prefix. For those of you that use a prefix in the config, make sure when you query the db you change the wp for the query to your prefix. Otherwise your query won’t reset the urls correctly.

    Antworten

    • Mark says

      Mai 22, 2014 um 12:52 am

      If I have a local install and I move the database live, the prefix will remain the same correct? Do I need to do anything?

      Antworten

30. Cypherinfo says

    Mai 9, 2014 um 5:40 am

    Error 404: 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.
    “ I followed all of the steps you wrote.

    Antworten

31. Sophie says

    Mai 2, 2014 um 9:00 am

    These instructions are exactly what I needed. Thank you!!!

    However, I seem to have encountered a problem…

    When updating the URLs in my database for those of the local server, it returns a #1064 – error in your SQL syntax near line 3. Could you possibly suggest a solution?

    Would I need to include the port number when updating the http://localhost/ part of the code?

    Please Help!!

    Antworten

32. Vtin says

    Apr 24, 2014 um 12:59 pm

    One more newbie trouble here! Sorry for the inconvenience.
    Of course, I think I’ve done everything correctly (probably not). When I try to access the site via localhost, in the screen appears the index.php file line by line, instead of loading it.
    Any ideas?

    Antworten

33. W says

    Apr 23, 2014 um 11:03 am

    This was fantastic. Super quick and worked exactly as intended.

    Antworten

34. Paul Sahota says

    Apr 19, 2014 um 2:48 am

    Can you please show how to move a live wordpress site to local using backup buddy on mac using MAMP. I have tried multiple times but it does not work for me. I can easily do the opposite.

    thanks

    Antworten

35. Jeremy says

    Apr 13, 2014 um 12:41 am

    After transferring the live site to my local server (wamp), I navigate to the destination in browser and get a „Not Found“ wordpress error. The site’s navigation loads though and when clicked it takes me to the live site. Am I missing something rudimentary?

    Antworten

    • Kin says

      Okt 22, 2015 um 5:23 pm

      I am getting the same thing. I followed all the steps. Then came back to check again, but the error remains. I am seeing that a couple of people above had the same problem as well. Any idea guys of why this is happening?

      Antworten

36. Sinuhe says

    Apr 12, 2014 um 9:11 pm

    Thank you!!! I just finished moving my site and a subdomain to a new hosting service and it worked like a charm. I am no techie, actually I am philosopher I really appreciate you taking the time to explain this info in detail.

    Antworten

37. Sam says

    Apr 11, 2014 um 4:52 am

    Hey, I did everything the same way you said in manual method.
    after setup,

    I can see homepage of my website on local server.
    But when I try to navigate to other page, I get following error:

    „Not Found: the requested URL /test/logistics was not found on this server.“

    Please help

    Antworten

    • Bill says

      Jun 18, 2014 um 11:13 pm

      I just ran into the same issue. I went into site/wp-admin. Then went to Setting > Permalinks and just clicked Save Changes. It updated something and all of my links work.

      Look at that! My first contribution to the community.

      Antworten

      • Isabela Santos says

        Jul 26, 2014 um 2:52 am

        thank you! But I had to disable it for it to work…

        Antworten

      • Mark says

        Apr 14, 2015 um 5:54 am

        Brilliant!

        Antworten

38. John says

    Apr 5, 2014 um 3:11 pm

    Awesome. Worked great! Thanks for posting this.

    Antworten

39. Natalia says

    Mrz 13, 2014 um 1:53 pm

    Hi,

    I followed your tutorial on doing it manually to the T, but I still get an error message. I am pulling my hair, here…
    I’m pretty new to WP and I still have to figure out how to actually enter the new content and modify the files… but I can’t even get it to work locally

    This is the message I get:
    „Error establishing a database connection“
    Which I don’t understand, because I did everything as you said in your tutorial.

    Help, please!!

    Antworten

    • Natalia says

      Mrz 13, 2014 um 2:11 pm

      Tried it all over again a second time and still same error message… I’m going crazy

      Antworten

    • Natalia says

      Mrz 13, 2014 um 2:34 pm

      I even tried in a remote server and I got the same error message. I don’t know what I’m doing wrong… there must be a path somewhere that I’m forgetting about and it’s just not reading the right db…
      Someone, please, help!!

      Antworten

    • WPBeginner Support says

      Mrz 14, 2014 um 11:32 am

      Natalia, the most common cause for this error is incorrect database information. On your live site, you need to edit your wp-config.php file. Make sure that the database information in this file matches the database you have created for your live site.

      Antworten

      Admin

40. Kathi Kostiuk says

    Mrz 11, 2014 um 12:02 pm

    Thank you, your site is super helpful. New to WP, inherited a site, got it localhost so I can learn/test. When trying to ‚upload‘ a pic, get this: C:/wamp/www/testsite/wp-content/uploads. Is its parent directory writable by the server? No errors shown in phpMyAdmin, permissions on folders, users look right. Could you possibly direct me to a solution? Have looked everywhere I can think of. Thanks.

    Antworten

    • WPBeginner Support says

      Mrz 12, 2014 um 4:00 am

      When you moved the site to localhost, did you change the siteurl and homeurl options? If you didn’t then you need to add these two lines to your wp-config.php file

      define('WP_HOME','http://localhost/yoursite');
      define('WP_SITEURL','http://localhost/yoursite');
      

      Hosted with ❤️ by WPCode

      
      1-click Use in WordPress

      Antworten

      Admin

      • Kathi Kostiuk says

        Mrz 14, 2014 um 4:30 pm

        Thank you, will do that.

        Antworten

41. Julie Rondeau says

    Mrz 7, 2014 um 4:28 pm

    Hi,
    Great tutorials! Thank you, however i keep getting an „Unknown“ Error code 0 from the Duplicator Plugin when trying to create the packages. Is there any other way you could recommend? Any help would be really appreciated.

    Thank you so much,
    Best from Paris.
    J.

    Antworten

    • WPBeginner Support says

      Mrz 8, 2014 um 5:51 pm

      You can also manually backup your localhost site and restore it on live server.

      Antworten

      Admin

42. Rehan says

    Feb 24, 2014 um 5:07 am

    Best tutorial ever!!

    Antworten

43. Ashley says

    Feb 2, 2014 um 11:58 pm

    Hi! Thank you so much for your great tutorials! Everything worked out great, but I when I was supposed to „resave permalinks“ it wouldn’t let me login. I got that fixed and I am logged in now, but where do I go to resave them now that I don’t have that pop up? I’m assuming this is why when I try to click on posts it gives me a „not found page“ ? Thanks in advance!

    Antworten

    • WPBeginner Support says

      Feb 3, 2014 um 7:00 pm

      You can save permalinks from Settings » Permalinks.

      Antworten

      Admin

    • Jesse says

      Okt 8, 2014 um 11:13 am

      Can I ask how you fixed the login problem? I’m getting the same issue.

      Antworten

    • Yarina says

      Mai 26, 2015 um 9:58 pm

      Hi! This all worked great until I had to login to the wp dashboard, my login didn’t work and even after changing it manually in the users table, I couldn’t log in, any ideas…?

      Antworten

44. Angela says

    Jan 29, 2014 um 8:53 pm

    Thank You! I’ve been trying to do this for some time now. I’ve watch several YouTube videos but could not get it to work correctly. This was so easy….the best thing ever. Again thanks!

    Antworten

45. Ivan says

    Jan 2, 2014 um 3:25 pm

    Hi,

    I followed your instructions to the letter (and sing lol), but was not successful. I think it has something to do with WP installation. I have not installed it, just copied it.

    Antworten

46. Brett Golding says

    Dez 18, 2013 um 12:41 pm

    Didn’t work for me just ended up with a blank white home page after I ran the program. Re tried 3 times.

    Antworten

    • WPBeginner Support says

      Dez 18, 2013 um 1:46 pm

      Checkout how to resolve white screen of death issue.

      Antworten

      Admin

47. Jason Moore says

    Dez 14, 2013 um 12:29 pm

    Thank you! This is was too easy!

    Antworten

48. ron says

    Dez 5, 2013 um 8:08 pm

    Hi, I’m trying to do exactly this, but I get a 500 Internal Server Error right after I put the database details and hit the Run Deployment button, I get the progress animation and after about 10 or 15 seconds I get the error.

    I was looking at the error logs located at C:\wamp\logs and I could only find this line that seemed somewhat relevant: „Invalid command ‚RewriteOptions‘, perhaps misspelled or defined by a module not included in the server configuration“.

    I’ve successfully used duplicator in the past, but going from webserver to another webserver.

    Any ideas?

    Antworten

    • WPBeginner Support says

      Dez 8, 2013 um 3:02 pm

      Please take a look at our guide on how to fix 500 internal server error in WordPress.

      Antworten

      Admin

49. Usama Noman says

    Nov 13, 2013 um 1:35 pm

    Thanks, seems like this is a tutorial posted upon my request Thanks guys you are doing good.

    Antworten

    • WPBeginner Support says

      Nov 13, 2013 um 6:40 pm

      Yes it is Usama. Thank you for suggesting it to us.

      Antworten

      Admin

50. Jamie Mannion says

    Nov 11, 2013 um 2:56 am

    Good guide, but I think you missed the part where you update wp-config.php with the new database details – name is the new name, username is ‚root‘ and password is empty.

    I tried it manually and it all looks good but the links take me to the WAMP server configuration page, even though the URLs are updated – can’t figure it out. I can get the home page and admin, but that’s it. Cheers!

    Antworten

    • WPBeginner Support says

      Nov 11, 2013 um 6:48 pm

      Thanks for pointing out updating wp-config.php thing. We have updated the article.

      As for your redirection issue. Try deleting .htaccess file from wordpress installation on your localserver.

      Antworten

      Admin

      • Jamie Mannion says

        Nov 12, 2013 um 2:27 am

        Awesome, thanks! I removed the .htaccess, then visited the permalinks option page and saved and now we’re good! I should admit, the only reason I knew about the wp-config.php settings is because I’ve read your previous articles. Keep up the great work!

        Antworten

      • Kin says

        Okt 22, 2015 um 6:10 pm

        I put a question earlier today, but this worked out for me great.
        Thank you.

        Antworten

51. Shahraar Khan says

    Nov 9, 2013 um 3:35 am

    I do this manually. Just zip the files from the server and download it… export the database and replace all the links in my text editor. just a 5 min work.. But anyhow your tutorial is also a very good alternative.

    Antworten