WordPress.org

1. Robin Urton
   Member
   Posted 2 years ago #

   I just completed moving an entire site (patiannestevenson.com), which included a blog (patiannestevenson.com/blog). I read that if the domain name is staying the same all I need to do is to update the wp-config files (and have done this successfully on another blog), but this time I'm getting an "error connecting to database" message. I think one of the problems might be that this new hosting server has the mysql files on a different server (the tech help instructed me to change the "localhost" setting within the wp-config to "mysql-databasename.domainname".

   I'm trying to understand documentation I'm reading on how to download the database from the old server so that I can upload it to the new, but am having trouble understanding how to do this. Any help will be appreciated!

2. S.K
   Member
   Posted 2 years ago #

   Have you the database dump from the old server?

   Or, have you used the "export" facility under "Tools" on the Admin dashboard to export the XML file so that you can import it in the new set up using the "Import" facility?

   If not done it already, have you access to the old server using the IP address if not the domain name?

   S.K

3. Robin Urton
   Member
   Posted 2 years ago #

   Hi kichu... thanks for your speedy reply.

   I just figured out how to export all the tables using phpMyAdmin within the old server's control panel. So I have a copy of all the database info, but don't know how to upload it to the new site. I've finally located the phpMyAdmin panel on the new site's control panel, but don't see any "Import" button.

4. Robin Urton
   Member
   Posted 2 years ago #

   After changing my username and password for the database (and updating the wp-config again), the blog is now showing up! It doesn't have any of the old database info (all posts are lost). I was able to find a button for "Import" within the Admin of the blog, but when I tried to upload my .sql file that I exported from the database, it gave me the following message:

   "Please upload a valid WXR (WordPress eXtended RSS) export file."

5. Samuel B
   moderator
   Posted 2 years ago #

   I was able to find a button for "Import" within the Admin of the blog, but when I tried to upload my .sql file that I exported from the database, it gave me the following message

   you are mixing apples and oranges
   the .sql file needs to be imported from within your host's phpmyadmin
   just select correct database and choose "import" from the top menu

6. Robin Urton
   Member
   Posted 2 years ago #

   That's what confuses me> There is no Import button on the phpMyAdmin, otherwise I would have tried that.

7. whooami
   Member
   Posted 2 years ago #

   > There is no Import button on the phpMyAdmin, otherwise I would have tried that.

   its a tab right across the top -- assuming you have actually created a db on the new server. you cannot import until there is a db to import into.

8. Robin Urton
   Member
   Posted 2 years ago #

   Yes, I have a database (the blog is now showing up at http://www.patiannestevenson.com/blog , which wouldn't be possible if there wasn't a database.

   When I go to phpMyAdmin, these are the tabs that show up at the top of the page: structure, SQL, Export, Search, Query, and Operations. Underneath that are the 10 tables that are included in my database. There is no Import tab anywhere on the page.

9. whooami
   Member
   Posted 2 years ago #

   ok, so then you need to do the inserts manually by copying and pasting them into the box under the sql tab.

10. Robin Urton
    Member
    Posted 2 years ago #

    Thank you! That's a big step forward because the posts are now back! Only problem is that all the pictures are missing. And she had a LOT pictures on this blog, so I hope we can get them back without her having to manually upload each one to each post. Any ideas on that??

    btw, when I clicked "SQL" tab, it said I could either "Run SQL query on the database", giving me a place to paste the text, OR browse for the file. I chose to browse for the database.sql file, then for the compression, I chose "Autodetect" (other options wer none, gzipped, and bzipped). Could it be possible that I chose the wrong compression mode?

11. Robin Urton
    Member
    Posted 2 years ago #

    I just looked within the blog posts to see an example of image location: <a href="http://patiannestevenson.com/blog/wp-content/uploads/2009/06/jalouse-page-copy.jpg"

    Then, when I look into my ftp files, I see that the remote server has only one file within the wp-content/uploads/2009/09, which is "catsrocksql.import"

    Any ideas how to get the images back?... or is it too late (she just canceled hosting on the other server, so I have no access to the database anymore).

12. whooami
    Member
    Posted 2 years ago #

    Any ideas how to get the images back?.

    upload them???? then change the path to them inside the database.

    you said you finished moving a site .. done correctly you placed those images inside /abc/wp-content/uploads/so on and so forth/.... where abc IS the blog and so on and so forth are the other dirs..

    if the new site doesnt have the blog inside the blog directory, then you obviously need to edit the urls to match the new location.

    right??

13. Robin Urton
    Member
    Posted 2 years ago #

    I guess the client has a lot of work to do. I don't have the photos. So once she uploads the photos, she still needs to create a new path? Doesn't wordpress create a path if she's uploading them within a blog post?

    Thanks for your continued support

14. whooami
    Member
    Posted 2 years ago #

    Youre suggesting she edits all her posts, and reupload those images using the image uploader inside wp-admin?

    wow.

    how did you move a whole site without including the files that would be inside wp-content/uploads/.. ?? (rhetorical question)

    So once she uploads the photos, she still needs to create a new path? Doesn't wordpress create a path if she's uploading them within a blog post?

    Yes, but that isnt what I suggested doing. Im saying to upload them using your ftp client.

    or whatever special way you have of uploading your client's files -- only this time include those images.

15. Robin Urton
    Member
    Posted 2 years ago #

    I guess I'm still confused. Maybe I didn't have a complete backup of her blog files. I did upload all of the blog files that I had, into the correct directory. I didn't have an uploads folder within the wp-content folder. I thought that by uploading the database.sql folder it created one on the server (my assumption for this is that I have a working blog on my site eyeconart.net, and I just checked all of my local files and also have no uploads folder, but there are hundreds of photos within my blog that must be within such a folder on my remote site).

16. Robin Urton
    Member
    Posted 2 years ago #

    I think I've resolved this now. Sorry to sound like a dufus before. I just realized that I have an incomplete installation of the blog on my pc, but that my most recent back-up was on my mac, which had all the upload files.... so I'm uploading them now and images are coming up!

    Thanks for your help, everyone!!

17. whooami
    Member
    Posted 2 years ago #

    
    

18. Samuel B
    moderator
    Posted 2 years ago #

    cat get your tongue?

19. whooami
    Member
    Posted 2 years ago #

    hahha nope! she(??) finished up as I was typing my last reply. :)

    all well's that ends well. right?

20. jashamichele
    Member
    Posted 1 year ago #

    Im having similar problems but Im lost:

    So basically this started because we redirected our website to a new site without changing the wordpress from being on a directory of that site to a subdomain first. This basically lost access to our wordpress blog. I still have all the data and the database is still on my mySQL and has not been changed. My next step to attempt to solve this was to reinstall the blog/wordpress onto the subdomain name and I kept the database the same and just reconnected it to the new installation. I also put all the old uploads into my wp-content and copied the themes also. Problem is that the old comments/posts/uploads are not showing up. Is there another file I need to copy over from the old blog? or some other way? I saw the import/export funtion but the problem is I dont have a wp export file to import even though I have all the data :0/

    Jasha

Topic Closed

This topic has been closed to new replies.