Title: SQL import missing wp_users. Just want to retrieve posts from SQL DUMP
Last modified: August 19, 2016

---

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

 *  [delakev](https://wordpress.org/support/users/delakev/)
 * (@delakev)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/)
 * Hello I use to run a blog @ [http://delakev.freehostia.com](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](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](https://wordpress.org/support/users/lzjimmy/)
 * (@lzjimmy)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/#post-986091)
 * 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](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/#post-986159)
 * Look at [Moving WordPress](http://codex.wordpress.org/Moving_WordPress) or use
   the Tools->Export at your old blog and use Tools->Import->WordPress at your new
   blog.
 *  Thread Starter [delakev](https://wordpress.org/support/users/delakev/)
 * (@delakev)
 * [17 years, 4 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/#post-986214)
 * 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](https://wordpress.org/support/users/delakev/)
 * (@delakev)
 * [17 years, 3 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/#post-986376)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [delakev](https://wordpress.org/support/users/delakev/)
 * Last activity: [17 years, 3 months ago](https://wordpress.org/support/topic/sql-import-missing-wp_users-just-want-to-retrieve-posts-from-sql-dump/#post-986376)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics