Title: Changing data in myPHPadmin
Last modified: August 20, 2016

---

# Changing data in myPHPadmin

 *  [bstharp](https://wordpress.org/support/users/bstharp/)
 * (@bstharp)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/)
 * I have another thread that this was posted in that was overall problems with 
   getting the local server to run. But I did succeed in doing that. The only problem
   that seems to remain is my links. When I am in Dashboard, all’s well – things
   look at localhost/xxxxwordpress for the pages/php files, etc. But if I view my
   site at localhost/xxxxwordpress, the links on those navigation tabs are to the
   live site. I think it’s related to the changes that I have attempted to make 
   in the database, per this thread’s suggestions:
    [http://wordpress.org/support/topic/how-to-copy-wordpress-site-to-local-test-server?replies=30](http://wordpress.org/support/topic/how-to-copy-wordpress-site-to-local-test-server?replies=30)
 * I have succeed in changing the site url to look at the local host which is why
   I’ve gotten this far; but when I attempt the the other two changes, this is what
   happens:
 * in the database, I clicked on sql, and pasted the code from the documentation
   link above. The site url change worked; So I went to the next step, pasting code
   into wp_posts, for ‘guid’. I hit the go button and I get a yellow bar at the 
   top of the database window with the spinning wheel, saying LOADING. But how long
   does that take? I let it run for 10 minutes and it didn’t stop….still going in
   fact! I finally clicked on another table just to get out of that ‘loop’ and went
   into wp_options table and looked at ‘guid’ and the changes are there. is this
   just a bug in phpmyadmin that it doesn’t ‘come’ back to you saying it’s done?
   or does this take a long time to update….I have about 140 rows of data in wp_posts,
   for reference. many thanks for any help here.

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

 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/#post-2898131)
 * Changing the guid won’t help much. Despite how it looks, it isn’t really the 
   URL that get used, mostly. In fact, you really shouldn’t ever change it– [http://codex.wordpress.org/Changing_The_Site_URL#Important_GUID_Note](http://codex.wordpress.org/Changing_The_Site_URL#Important_GUID_Note).
 * That should execute over 140 rows in seconds, unless your server is overloaded.
   And it should complete properly and let you know. Something went wrong. It sounds
   like a script timeout, which would indicate an overloaded server, but I can’t
   prove that.
 *  Thread Starter [bstharp](https://wordpress.org/support/users/bstharp/)
 * (@bstharp)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/#post-2898141)
 * thanks, it’s definitely not finishing by the looks of it, yet it IS when you 
   go into the columns of guid. I guess it doesn’t matter much since I’m just using
   the local server to make web design changes, not link changes…but I’d like to
   know how I can change navigational links to look at the localhost site if you
   or anyone knows how…
 * as to an overloaded server, it’s just little ole me on an iMac using a local 
   server I set up to make changes to my website offline.
 * Thank you!
 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/#post-2898147)
 * Try [Velvet Blues Update Urls](http://wordpress.org/extend/plugins/velvet-blues-update-urls/).
 *  Thread Starter [bstharp](https://wordpress.org/support/users/bstharp/)
 * (@bstharp)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/#post-2898148)
 * Thank you, I will do that.

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

The topic ‘Changing data in myPHPadmin’ is closed to new replies.

 * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/)
 * 4 replies
 * 2 participants
 * Last reply from: [bstharp](https://wordpress.org/support/users/bstharp/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/changing-data-in-myphpadmin/#post-2898148)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics