Comment déplacer WordPress d’un serveur local vers un site en direct (2 méthodes)

909 commentairesLaisser une réponse

1. Syed Balkhi says

   Juin 2, 2024 à 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. Lisa says

   Avr 11, 2014 à 12:08 am

   On step 4, when I try to import the gzipped database I get this:
   Error
   SQL query:

   —
   — Database: `testbtat`
   —
   CREATE DATABASE IF NOT EXISTS `testbtat` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
   MySQL said: Documentation

   #1044 – Access denied for user ‘btatxcom’@’localhost’ to database ‘testbtat’

   Répondre

   • Bunty Gurung says

     Avr 25, 2014 à 10:58 am

     @Lisa the import could be a .zip or plain text .sql file, does not matter. You are getting the error because name of the database you are trying to upload does not match with the name that you have created.

     In this case I assume that your username on the live site is ‘btatxcom’. So generally your database would be btatxcom_yourdb. If that is the case, go to localhost. Simply export your database as a .sql file – without using custom options. Save it on desktop. Rightclick open-with notepad++ (if you do not have it on pc, just download, it is very easy in usage eg. like notepad, just a bit more fancy).

     You will find this line CREATE DATABASE IF NOT EXISTS around line number 22 or else search for the term. Now there, the name of your database occurs twice, change it to match the name of database on your live site eg. someprefix_yourdb. Save it, go to your phpmyadmin -> your database -> browse and import the saved .sql file. That should do it. Hope this helps someone.

     Répondre

3. Wanda Serros says

   Avr 6, 2014 à 7:10 pm

   Thank you for the tutorial. I followed all the steps correctly I believe. It worked like a charm until I went to look at my site. I get the following:

   Your server is running PHP version 4.4.9 but WordPress 3.8.1 requires at least 5.2.4.

   although when I go to my Cpanel it says: PHP version 5.3.26

   Also when I try to go to admin I get:

   Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /home/drser3/public_html/wp-admin/index.php on line 103

   I appreciate any help you can give me. Thanks

   Wanda

   Répondre

   • WPBeginner Support says

     Avr 6, 2014 à 8:37 pm

     Please contact your web hosting service provider. They will be able to assist you better in this matter.

     Répondre

     Administrateur

   • Wanda Serros says

     Avr 12, 2014 à 6:02 pm

     My website is now up and running although I have some issues to correct. Just thought I’d report back for other user who might be using Lunarpages for webhosting. I had to go to control panel and choose PHP5, then a phpini file had to be added under my public_html directory with

     memory=64MB

     and lastly I had to add:

     suPHP_ConfigPath /home/username/public_html

     into my htaccess file.

     Répondre

4. Wisdom says

   Avr 2, 2014 à 8:53 am

   thank you. was so helpful

   Répondre

5. David says

   Avr 2, 2014 à 6:19 am

   Hi,

   I can access the wp-admin after moving the database over but for some reason I get a whitescreen when I type my url in. It doesn’t seem to be finding the html / css for any of the pages. Its odd because It loads perfectly on the wamp localhost.

   Any ideas?

   thanks

   Répondre

   • WPBeginner Support says

     Avr 6, 2014 à 8:48 pm

     Go to Settings -> General and make sure your WordPress Site and Home urls point to your new location.

     Répondre

     Administrateur

6. Roanna says

   Avr 1, 2014 à 9:45 am

   You do not know how much this article has helped me!
   Thank you so much for taking the time to write and post this!

   Répondre

7. Sam says

   Mar 27, 2014 à 10:41 am

   Thanks for your tutorial, its very helpful.

   Répondre

8. Janeth says

   Mar 24, 2014 à 10:48 am

   Great tutorial, thank you very much.

   I guess it is the same process from a dev server to production server right?

   Répondre

   • WPBeginner Support says

     Mar 25, 2014 à 3:42 pm

     Yes it is.

     Répondre

     Administrateur

9. AM says

   Mar 22, 2014 à 3:04 pm

   Thank you so much for posting these instructions!! I could NOT have transferred my client’s site to the live site without this!! Just one note: Under Step 3, your instructions are missing the note about « hostname ». This took me a sec to figure out but I was able to add that in. In case anyone else has any problems with that part of the database creation. Thanks again!!

   Répondre

10. abel kayode says

    Mar 21, 2014 à 7:55 am

    Hi
    Thanks for the educative article.
    I followed every step but I end up getting this error

    Parse error: syntax error, unexpected ‘DB_PASSWORD’ (T_STRING) in /home/swagphot/public_html/wp-config.php on line 26

    I checked my wp-config for typo but everything seems correct I need help, I don’t know how to
    Resolve this… Thanks

    Répondre

    • WPBeginner Support says

      Mar 21, 2014 à 3:31 pm

      You are probably missing opening bracket ( just before DB_Password

      Répondre

      Administrateur

11. Miriam says

    Mar 20, 2014 à 7:50 pm

    I am brand new to this and this explanation is by far the clearest explanation I have found but I am still having problems. I have transferred my files to my host server but am stuck on the database. I have a local installation of WordPress established with Bitnami. When I go to http://localhost/phpmyadmin/, I don’t see my database; I only see information_schema and test. I checked my wp-config.php and see ‘DB_NAME’, ‘bitnami_wordpress’. I am clueless as what to do or where to look next. Any help would be greatly appreciated. Thanks.

    Répondre

    • WPBeginner Support says

      Mar 21, 2014 à 3:52 pm

      In your wp-config.php check your DB_User and DB_Password use these to log into phpMyAdmin and then you will be able to see your database bitnami_wordpress

      Répondre

      Administrateur

      • Miriam says

        Mar 21, 2014 à 6:10 pm

        THANK YOU. THANK YOU. THANK YOU!!!!!

        Répondre

12. Sisira says

    Mar 19, 2014 à 6:45 am

    Awsome Tutorial………………..Very useful for a beginner……….I just tried and made my site live……………………..This is my first website……………Thank you so much……………….

    Répondre

13. james Daly says

    Mar 18, 2014 à 4:13 pm

    Thank you so much for this article – It was easy to follow and worked out perfectly for me – thought it would be a daunting process but was pretty easy if you followed the steps correctly

    Répondre

14. Bilal Ahmad says

    Mar 15, 2014 à 6:24 pm

    i done all theme steps.. after this i cannot acces to my dashboad. when ever i go to my admin pannel and enter the username and pass which is correct. But it cannot redirect me to my dashboad. its redirect me to my admin panel again and again. pls help

    Répondre

15. Kirit Patel says

    Mar 13, 2014 à 8:40 am

    This tutorial is very important for beginner, who doesn’t know how to move local wp site to live site. it is useful for me.
    Thanks a lots.

    Répondre

16. mira says

    Mar 5, 2014 à 7:10 am

    hi,
    thanks for this useful article.
    bt i have an error like
    1044 access denied
    pls would u help me out from this database error?

    Répondre

    • jay says

      Mar 11, 2014 à 4:59 pm

      To solve the 1044 Access denied error. You should open the database file in your text editor and delete the following code.

      — Database: `XYZ`
      —
      CREATE DATABASE IF NOT EXISTS `XYZ` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
      USE `XYZ`;

      Répondre

17. Terry says

    Mar 5, 2014 à 5:54 am

    Thanks for all your help with these tutorials! I am learning a lot. I have a problem that has been mentioned before but I am not getting a solution.
    I’m stuck on step 6, I keep getting Error establishing a database connection.
    I did change one thing in your procedure, in step 6 I edited wp-config.php to include define(‘DB_HOST’, ‘www.mysite.com/my_staging_site’);
    Anyway, I still can’t connect, and if there is anything you can do to point me in the right direction I would appreciate it!

    Répondre

    • charles says

      Juin 18, 2014 à 6:27 pm

      I had this problem as well but make sure there are no small typos when entering in the database name, username, password, and host. My problem was the aposhtrophe symbol were different (‘ symbol). When I started changing the name the apostrophe changed to a different symbol and it is really hard to tell if it changed. But i fixed this and it worked

      Répondre

    • rahul says

      Déc 31, 2014 à 2:26 am

      U just needed to change the dbname and site cpanel username and password to the feild it is asked in wp-config.php

      Répondre

18. Jody Hockley says

    Mar 4, 2014 à 12:45 pm

    Thanks for such an easy to follow and simple guide. Did it all in under 20mins. Has made my life so much easier. Much appreciated…

    Répondre

19. Vivek says

    Mar 4, 2014 à 5:26 am

    Followed the same steps.

    Website got live on server but facing the following problem.

    Menus are not appearing in Admin Panel.

    The settings are not saving if try to make any changes.

    Any idea?

    Répondre

20. WawanAdie says

    Fév 25, 2014 à 11:12 pm

    Okay. it will be useful thanks

    Répondre

21. jeret says

    Fév 25, 2014 à 2:07 am

    Hi, i have successfully upload all the files to the web server. I am able to view my wordpress site.
    The problem is when i try to access the admin page. Using the username and password which i created using the cpanel, is not working. it says invalid username. I have modified the wp-config.php file. I have made sure the new username and password are updated.

    What about this line in config file what do i change it to :
    /** MySQL hostname */
    define(‘DB_HOST’, ‘localhost’);

    Thanks.

    Répondre

    • Mustafa says

      Mar 1, 2014 à 6:41 am

      Check for:

      /** MySQL hostname */
      define(‘DB_HOST’, ‘mysql.yoursite.com’);

      Répondre

22. Miroslava Donchev says

    Fév 24, 2014 à 10:40 am

    Thank you for the wonderful article! I am so grateful there’re people like you to share knowledge

    I transferred my local site to live hosted site and I got only one error so I want to share how I solved it. I got a black page on the the permalink options page and I found the following solution from DebbieV:

    « I edited wp-admin/includes/misc.php, forcing the value of $got_rewrite = true; »

    May be that can help somebody else as well.

    Cheers!
    Mira

    Répondre

23. dhani says

    Fév 23, 2014 à 1:52 am

    Hi,

    Is there any way to export from wordpress.org to wordpress.com without having to host the site and pay?

    I have my blog in wp.org but want it to go live without paying…just wondering if there are any options for this.

    Thank you.

    Répondre

24. Jay says

    Fév 20, 2014 à 2:55 am

    I followed all of the instructions except for exporting my database from localhost in gzipped because I tried importing on live server in phpMyadmin it gave me an error « #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 ‘?’ at line 1 ». But it import the database when I use zipped compression but after waiting 7 hours to upload all my files from localhost to live server it asked me to install WordPress and when I install WordPress none of my posts are in there.

    Répondre

    • Jay says

      Fév 20, 2014 à 2:56 am

      I have already changed the information for the database in wp-config and still it asks me to install WordPress

      Répondre

      • WPBeginner Support says

        Fév 21, 2014 à 7:00 pm

        Did you change database table prefix? Are you sure that the database you are connected to is not empty?

        Répondre

        Administrateur

      • Jigar says

        Mar 23, 2014 à 11:58 pm

        I had same problem but solve with database prefix, It must be same as in database on server,

        Thanks ADMIN,

        Répondre

25. soon hao ng says

    Fév 17, 2014 à 2:28 am

    Thanks for your tutorials provided. It’s very helpful. I managed to move my wordpress from local server to live site. However, when I login to my admin panel. The error message was shown:

    Internal Server Error

    The server encountered an internal error or misconfiguration and was unable to complete your request.

    Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.

    More information about this error may be available in the server error log.

    Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

    Could any experts here please advise how to fix this problem?

    Thanks

    Répondre

    • WPBeginner Support says

      Fév 17, 2014 à 9:42 pm

      See our guide on how to fix Internal Server Error in WordPress.

      Répondre

      Administrateur

26. tatiana says

    Fév 16, 2014 à 5:47 pm

    Hello,.I intend to upload a localhost to a server … I’ve done all the above steps MANY TIMES .. but this message always appears » You don’t have permission to access / on this server..

    Répondre

    • WPBeginner Support says

      Fév 17, 2014 à 9:46 pm

      Please contact your webhost this seems like a server configuration issue.

      Répondre

      Administrateur

27. Jose says

    Fév 14, 2014 à 10:05 am

    Hi. Thanks this post is more useful than all the other stuff i found on youtube.
    However, I can´t seem to get my site up and running, even after following all the steps carefully.
    I can access my admin from my live website, and everything including plugins and themes, posts and pages seems to be up there on the dashboard. However the website, even accessing it from the dashboard itself shows a blank page. Any clue where the problem might be and what I might do to solve it?
    Thanks!

    Répondre

    • WPBeginner Support says

      Fév 14, 2014 à 11:45 am

      Seems like you have successfully moved your site from localserver to live. Now you just need to fix the white screen of death. Let us know how it goes.

      Répondre

      Administrateur

      • Jose says

        Fév 24, 2014 à 9:56 am

        Thank you!

        It turned out I was using a child theme. Switching to the original theme and making changes from the theme’s settings instead of the new stylesheet solved the white screen of death. Thank you for the clear, thorough and useful blog.

        Jose

        Répondre

        • David says

          Avr 2, 2014 à 7:02 am

          Your issue was exactly the same as my issue now. Only, I am not using a child theme, its a custom theme. Just can’t get it to work even though it works on my localhost.

          Can anyone advise me on this?

          Thanks

28. Mai says

    Fév 13, 2014 à 9:34 pm

    Hi, I think I may have commented too soon. Everything works fine except for the recent comments section where it doesn’t display comments, but links to « localhost » blog entries.
    This is my blog: http://www.sugaroverkill.com/blog/
    I’ve done all the steps including #7. Is there another step I need to do for the recent comments to display correctly?

    Répondre

    • WPBeginner Support says

      Fév 14, 2014 à 12:27 pm

      It seems to be working now

      Répondre

      Administrateur

29. Mai says

    Fév 13, 2014 à 9:22 pm

    Thanks for the article. It worked like a charm!

    Répondre

30. Jack Allen says

    Fév 10, 2014 à 1:24 pm

    Hi, Was just wondering if you had to change the DB Hostname in the wp-config file as ive still got error establishing database connection. Thanks Jack

    Répondre

    • WPBeginner Support says

      Fév 10, 2014 à 10:51 pm

      Yes you will have to change your database name in wp-config file.

      Répondre

      Administrateur

31. Beth says

    Fév 10, 2014 à 1:10 pm

    Thank you for this resource! Everything appears to be working properly with the migrated site, but we are unable to access the new site’s wp-admin to log into WordPress. We did not do a new install of wordpress, we simply transferred all files of the previous site to the new directory. Is a wordpress install necessary if a site is up an running on two different URLS?

    Répondre

    • WPBeginner Support says

      Fév 10, 2014 à 10:53 pm

      You would also need to move your database. No when moving WordPress from one location to another you don’t really need to run the install script again.

      Répondre

      Administrateur

32. Verna says

    Fév 5, 2014 à 6:44 am

    Just wanted to drop you a line to say THANK YOU !!!
    Your instructions worked perfectly for a first time user and your efforts are really, really appreciated.
    Bless You !

    Répondre

33. Albert Clayton says

    Fév 2, 2014 à 12:00 pm

    I’ve been migration my WordPress sites using All in One WP Migration plugin – http://wordpress.org/plugins/all-in-one-wp-migration/

    Répondre

34. annie says

    Fév 1, 2014 à 7:28 am

    hello there,
    I’m planning to use this tutorial to transfer localhost for the first time.. (I haven’t read it all yet)

    but, I’ve noticed I need to use phpadmin and since I’ve first used WAMP I wasn’t able to use phpadmin and I’m not quite sure what’s wrong (I’m sorry if you mention this somewhere here please ignore my comment),…

    Is there any way I can transfer my site without phpadmin? i.e. by copying and pasting something?

    excuse me as I am completely new to this…

    thank you

    Répondre

    • WPBeginner Support says

      Fév 1, 2014 à 12:41 pm

      You can export your database on local host by using wp dbbackup plugin.

      Répondre

      Administrateur

      • annie says

        Fév 3, 2014 à 10:51 am

        thank you for your reply

        Répondre

      • annie says

        Fév 4, 2014 à 11:37 am

        hello again,
        I have followed every step successfully but i can’t go to step 6 because the ftp upload to public_html has stuck at 99%

        any idea what might be wrong?

        thanks.

        Répondre

35. Hitesh says

    Jan 31, 2014 à 2:34 am

    hey i did the same you mention here but still i cant change theme logo i import old site to new site

    Répondre

36. Jeff Matt says

    Jan 29, 2014 à 12:47 pm

    Thank you so much! This worked perfectly for me and I no longer worry about developing in MAMP any more. Cheers!

    Répondre

37. Ravi says

    Jan 27, 2014 à 6:20 am

    Thanks a lot..

    Répondre

38. Rajeev says

    Jan 24, 2014 à 2:09 pm

    Many Thanks for this tutorial

    Répondre

39. Jose Luis says

    Jan 24, 2014 à 3:49 am

    Thanks for all! You save my life!

    Répondre

    • ashish gupta says

      Jan 31, 2014 à 5:33 am

      I really understand what you are actually saying, first time i also hung up on that situation and i did not know how to do that.

      Répondre

40. Westy says

    Jan 21, 2014 à 2:01 pm

    Hi, thank you for a great tutorial.
    Everything seems to run smoothly for me except the appearance is completely messed up.
    I am using bp default theme with a child theme on the local server. After the import the bp default (parent) does not show in the Appearance>Themes setting which breaks my child theme. However all the folders etc for bp-default have been uploaded from local to live site, so I can not work out why the issue is occurring.
    Has anyone else had this problem and can help me fix it?
    Thank you for your time.

    Répondre

    • clare says

      Fév 5, 2014 à 5:43 pm

      Weary, just wondering if you solved your problem. And if so how?

      I’m currently having the opposite problem. My child theme worked great on the local server, but in migrating it to the live server, it’s now broken and it restored the parent theme . I’m hoping if you fixed your problem it would clue me in to what I am doing wrong.

      Répondre

41. Pomen Yala says

    Jan 17, 2014 à 1:05 pm

    Thanks for sharing this info. Life lot’s easier to switch wordpress for me now

    Répondre

42. Heidi Anderson says

    Jan 10, 2014 à 1:54 pm

    Hello, I really need some help. I get to step4 and I find my new db that I created in the SQL server, it has no tables, I click on it, I hit import and I get the following in red, « The directory you set for upload work cannot be reached ». This is before I even try to upload my file. What did I do wrong?

    Répondre

43. Venkat says

    Jan 10, 2014 à 7:40 am

    Hai.. Your tutorial teach very clear. I am so happy about your help. Thanks !

    Répondre

    • Priyanka says

      Jan 23, 2014 à 4:41 am

      hey thanks for sharing such awesome tutorial….:)

      Répondre

44. Samantha says

    Jan 9, 2014 à 7:42 am

    Hi, I exported my database from localhost and im trying to do step 4. I got the error 1044 but seen on previous comments to delete a section and change to my live database name. I tried to import again and now I get the error

    #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 ‘– phpMyAdmin SQL Dump
    — version 4.0.4
    — http://www.phpmyadmin.net
    —
    — Ho’ at line 1

    Can you help at all??

    Répondre

    • WPBeginner Support says

      Jan 10, 2014 à 4:56 am

      Undo the changes you made earlier.

      Répondre

      Administrateur

    • Mark Johnson says

      Jan 11, 2014 à 5:30 pm

      Hey I had the same problem. You have to edit the import file before you upload it. Here is a link showing you hhow to do it: http://support.hostgator.com/articles/cpanel/how-to-import-your-mysql-database

      Then you zip it with the name « yourdatabasename.sql.zip » and then upload

      Répondre

45. Quentin says

    Jan 7, 2014 à 12:24 am

    Excellent guide – very clear. And, I learned a few useful things in the process. Thank you.

    Répondre

46. Gwen says

    Jan 5, 2014 à 6:39 pm

    When I try to import my sql file into the new database, I get this error from phpMyAdmin:

    #1103 – Incorrect table name

    Any ideas on what I might be doing wrong?

    Répondre

    • WPBeginner Support says

      Jan 6, 2014 à 3:05 pm

      When creating your export file make sure that your export file has Create Tables if not exist checked.

      Répondre

      Administrateur

      • Fatima says

        Jan 7, 2014 à 9:21 am

        How to do so?

        Répondre

47. Gwen says

    Jan 5, 2014 à 6:38 pm

    Hi there! I get this error from phpMyAdmin when I try to import my sql file into the new database on the live server:

    #1103 – Incorrect table name

    Any ideas on what I might be doing wrong?

    Répondre

48. Parisa says

    Jan 2, 2014 à 12:09 pm

    Hi,

    Thank you for the article. I went through the steps but when I go to the website I see « Index of/ » and below that I see the files and folders uploaded on the website. When I click on the files I get « Error establishing a database connection » . Could you help me with it?

    tnx

    Répondre

    • Jennifer says

      Jan 15, 2014 à 5:50 pm

      I am also having that same issue. Have you found any solutions?

      Répondre

      • Jennifer says

        Jan 15, 2014 à 5:57 pm

        Actually, I don’t get the « Index of/ » message or folder, just the « Error establishing a database connection » message.

        I’m using GoDaddy for my hosting account and they had a slightly different process for setting up users for the database (it’s an all-in-one step, where your database name is also your username). I’m wondering if that’s what’s causing the disconnect.

        I’m also putting my WordPress install in a subfolder, rather than the root directory. So I added that folder after my URL when I made my table edits. Could that be an issue?

        Répondre

        • Jennifer says

          Jan 15, 2014 à 6:33 pm

          I dug deeper into your website (so awesome by the way — thank you!!!) and found my solution here: https://www.wpbeginner.com/wp-tutorials/useful-wordpress-configuration-tricks-that-you-may-not-know/

          I changed the localhost in my config file to my ip address and that solve it.

      • AWASAE says

        Jan 23, 2014 à 3:12 pm

        i think you guys have your website files not immediately inside public_html directory! i think you have the in a folder inside public_html

        go inside the folder select all files and move them a step in the root directory

        WRONG: public_html/AFolderContainingAllFiles/{allfiles}
        RIGHT: public_html/{allfiles}

        Répondre

49. Shawn says

    Jan 2, 2014 à 5:54 am

    Correction to your mysql query:

    UPDATE wp_posts SET post_content = REPLACE(post_content, ‘localhost/test/’, ‘www.yourlivesite.com’);

    should be..

    UPDATE wp_posts SET post_content = REPLACE(post_content, ‘localhost/test/’, ‘www.yourlivesite.com/’);

    (The forward slash was missing)

    Répondre

    • WPBeginner Support says

      Jan 2, 2014 à 11:30 am

      Shawn, thanks for pointing this out. We have updated the article.

      Répondre

      Administrateur

50. Anna says

    Déc 31, 2013 à 3:52 pm

    Hi,

    I created a new WP site for an existing URL where the old site is currently active. I need to test the shopping cart/payment gateway of the new WP site using an SSL, which resides on the existing site. So I created a sub-folder and migrated the new WP site to this folder from MAMP. I can access the login page, but after logging in, I get a 404 « wp-login.php was not found on the server. » I checked via ftp access and it’s there in the folder. Seems I need to update something else. Or, can I copy the SSL folder to my MAMP so testing can happen locally? Thanks for any suggestions.

    Anna

    Répondre

51. swati says

    Déc 23, 2013 à 2:12 am

    After doing same steps as per your article i am able to live only home page but with no images and slider..along with this my other pages are not live on localhost…it gives same error for all inside pages that not found on this server..plz help me…

    Répondre

    • WPBeginner Support says

      Déc 23, 2013 à 3:21 pm

      Can you access the wp-admin area? If you can then go to Settings and fix your site and home URL options. Also check out this article to set correct file permissions for WordPress.

      Répondre

      Administrateur