SQL import missing wp_users. Just want to retrieve posts from SQL DUMP

  • delakev

    (@delakev)


    15 years, 2 months ago

    Hello I use to run a blog @ http://delakev.freehostia.com. It was free hosting and my blog got taken down due to some text words that I couldn’t even find? They told me to put it back up but I was too lazy. I was unable to login so I just did a SQL dump backup.

    4 months later, here I am, I have finally purchased a domain and hosting and would like to start a new blog but retrieve some posts from my sql dump. I have read couple of guides online and still unable to get it running maybe due to the fact that I maybe did not do a complete backup (directories, etc.) I do not even remember my old wordpress version haha. Some problems I have stumbled upon are

    -the links redirect to my old blog? doesn’t really matter but it might affect my login?
    -when i go to wp-login.php i can’t login, says wp_users does not exist (try it out http://www.delakev.com/test/wp-login.php)
    -I looked at my .sql dump and i don’t even have the wp_users table lol

    Basically I just want to retrieve my old posts, any solutions? I can successfully import the sql dump.

Viewing 4 replies - 1 through 4 (of 4 total)
  • WordPress Hosting

    (@lzjimmy)

    15 years, 2 months ago

    You may try to re export your sql file from databae using this command:

    C:\mysql\bin mysqldump -uuserid-ppassword DBname > db_xx.sql

    If you’re not able to login after import to new db, you may refer to this url to reset pwd:
    [spam link moderated]

    MichaelH

    (@michaelh)

    15 years, 2 months ago

    Look at Moving WordPress or use the Tools->Export at your old blog and use Tools->Import->WordPress at your new blog.

    Thread Starter delakev

    (@delakev)

    15 years, 2 months ago

    lzjimmy- you mean re export from old host? I can’t anymore, the DB has been deleted =(

    MichaelH – I was unable to log into WordPress to do the Tools>Export (could not even get to wp-login.php) so all i did was do a sql dump backup and copied a bunch of files off FTP

    I am going to try to put it back up on the old blog but I am very limited as I am a free user.

    Thread Starter delakev

    (@delakev)

    15 years, 2 months ago

    unforunately i am unable to put it back on the old free host. Everything is gone from there as well. I still have the old sql dump though. Any suggestions?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL import missing wp_users. Just want to retrieve posts from SQL DUMP’ is closed to new replies.