Moving blog to new server w.o access to old blog

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

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.

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

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

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

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

Yes, I have a database (the blog is now showing up at https://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.

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

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?

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

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).

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

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

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.

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).

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