Importing .sql file to WordPress.com blog

• 

  cindyli · Member · Jul 3, 2012 at 7:35 am

  • Copy link
  • Add topic to favorites

  Hi everyone,

  I’m trying to restore an old WP backup, which is an .sql file, to my blog on WordPress.com. Since WP now only accepts .XML backups, I tried to locally install WP, import the .sql file, then run WP and export as .XML to obtain the useable backup. I used these instructions and am now stuck on “Run WordPress:”

  Here is the only way to do that here:

  Windows: install Xampp
  Mac: install Mamp
  Linux: no idea but something will exist

  Install WP

  Import your file into the database.

  Change the ‘Home’ url in wp_options in the database

  Run WordPress

  From that blog Tools > Export to get the file.

  Sounds complex, it’s pretty straightforward and lots of guides exist.

  NOTE: I changed both “Home” and “Siteurl” to “http://localhost/wordpress” (which is my locally hosted wordpress).

  At this point, when I go to http://localhost/wordpress, WordPress does not load; the page is blank. I’m assuming that I’m still missing something here. Could anyone please give me a hand? I would greatly appreciate it.

  The blog I need help with is: (visible only to logged in users)

• 

  auxclass · Member · Jul 3, 2012 at 7:41 am

  • Copy link

  Did you start Xampp? you need to do something like below before trying to start WordPress if my memory is correct – I have a local install but it has been over a year since I last ran it

  C:xampplitexampplitexampp_start.exe

• 

  auxclass · Member · Jul 3, 2012 at 7:42 am

  • Copy link

  PS – the folks at WordPress.ORG are better at this stuff – if you still have trouble you should make friends over there

• 

  cindyli · Member · Jul 4, 2012 at 8:15 am

  • Copy link

  Yes. I did start Xampp.