Title: database restoration problem
Last modified: August 18, 2016

---

# database restoration problem

 *  Resolved [madhuri](https://wordpress.org/support/users/madhuri/)
 * (@madhuri)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/)
 * In the process of upgrading my wp, to wp2.1, I am unable to restore my database.
   I have tried to follow the tutorial in the linl : / [http://www.tamba2.org.uk/wordpress/restore](http://www.tamba2.org.uk/wordpress/restore)
   but could not get through the final step of restoration.
    i.e. executing sql 
   query & inserting the content of my file.
 * I have a safe copy of saved database .sql file with me.
 * Could someone suggest me, how should i overcome this problem?

Viewing 7 replies - 1 through 7 (of 7 total)

 *  [vkaryl](https://wordpress.org/support/users/vkaryl/)
 * (@vkaryl)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521070)
 * You probably need to list what errors you’re getting.
 *  Thread Starter [madhuri](https://wordpress.org/support/users/madhuri/)
 * (@madhuri)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521073)
 * sql query has now successfully executed & file content has also been insterted.
   but…
    when i tried to see my blog [http://www.medinmark.com/careerdestination/](http://www.medinmark.com/careerdestination/)
   it reads… WordPress database error: [Unknown column ‘link_count’ in ‘where clause’]
   SELECT * FROM wp_categories WHERE cat_ID > 0 AND link_count > 0 ORDER BY cat_name
   ASC
 * Kindly explain, what has to be done…
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521074)
 * Well, if you restored a pre WordPress 2.1 database to 2.1 install, you might 
   have to run wp-admin/upgrade.php again…
 *  Thread Starter [madhuri](https://wordpress.org/support/users/madhuri/)
 * (@madhuri)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521077)
 * how am i supposed to do that, Sir?
 * I am new to the wordpress environment. Kindly explain.
 * Thanks
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521080)
 * And I’m new to reading minds. 🙂 Was this a working/functioning blog before you
   started the upgrade?
 * Assuming that you are indeed doing what I asked about, you’d run the upgrade 
   script just like you did when you first upgraded… per the [Upgrading_WordPress](http://codex.wordpress.org/Upgrading_WordPress)
   directions.
 * Namely, point your browser to
 *     ```
       http://yoursite.com/blog/wp-admin/upgrade.php
       ```
   
 * _(where yoursite.com/blog represent wherever it is you’ve put WordPress, of course)_
 *  Thread Starter [madhuri](https://wordpress.org/support/users/madhuri/)
 * (@madhuri)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521084)
 * Thanks a lot sir! I have been able to get over my problem with your help.
    No
   doubt, this was vfery much a functional blog earlier, but was still in nascent
   stages & i knew very little about its administration.
 * Anyway,
 * Thanks & Regards
    Madhuri
 *  [Chris_K](https://wordpress.org/support/users/handysolo/)
 * (@handysolo)
 * [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521098)
 * Awesome, glad to hear it.
 * Happy blogging!

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘database restoration problem’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [sql-query](https://wordpress.org/support/topic-tag/sql-query/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 7 replies
 * 3 participants
 * Last reply from: [Chris_K](https://wordpress.org/support/users/handysolo/)
 * Last activity: [19 years, 3 months ago](https://wordpress.org/support/topic/database-restoration-problem/#post-521098)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics