Title: Altering links
Last modified: August 19, 2016

---

# Altering links

 *  [Mercurialol](https://wordpress.org/support/users/mercurialol/)
 * (@mercurialol)
 * [15 years ago](https://wordpress.org/support/topic/altering-links/)
 * I’ve made the entire website and I wanted to upload it to a web host. When I’ve
   done that, I only got the default page ‘New blog’. I changed the theme to the
   one I’m using and my header and footer showed up, but not the menus(actually 
   links to pages), so my guess is that I was using absolute links while working
   on my computer. It’s not a problem to change links one by one, just if I knew
   how (if using absolute links is indeed the problem here).
 * Thanks in advance
 * Edit: I just realized that pages live inside my database… So it means i should
   upload my database too, and I guess that was the problem all along. What exactly
   should I upload and where should my db reside?(I’m guessing it’s using ‘import’
   from phpMyAdmin and selecting the db on my computer)
 * Thanks

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

 *  [jkovis](https://wordpress.org/support/users/jkovis/)
 * (@jkovis)
 * [15 years ago](https://wordpress.org/support/topic/altering-links/#post-2060162)
 * See [http://codex.wordpress.org/Moving_WordPress](http://codex.wordpress.org/Moving_WordPress)
   for how to create an export using phpMyAdmin.
 *  Thread Starter [Mercurialol](https://wordpress.org/support/users/mercurialol/)
 * (@mercurialol)
 * [15 years ago](https://wordpress.org/support/topic/altering-links/#post-2060219)
 * Actually I’d like to import a database, not export, and I’m getting this:
 * —-BEGIN CUT—- eNpzDQryD7JScDZUcDZS8HH1s1IwUTBVMDQz5AoOAYpLcXEFhwEFVTxTVLh8K4MDfawUTPUM9UzN
   dHPy07lCg4MU/IN1FBzdXf1CdBTCXIFawjPzFHz9ozx9fByBSg24AnwdrRSM9Yz1LPWMuAI8AkCq 
   dPyDQeYY6Zkp+GTmlVZw+Tj6uVsppObplpak6Vpwge0JSixSlGJnOD+hmIGBiwECluwrUZhgymAF 
   ZDoCMVNj6+sJpslT1NJLrGWNBRgUgGLl+UUpBUWpxcUxKUl6+QUlDB8cvH04HX36n/Lv7t4jw/To 
   5CdPNxYRSY336zhaC+2rQ0y+1Fw02nBCw+fsJbWcEutE7iqP3zPy+PT/hH5pW5816XSG5xagpY4M 
   BowMDB8UgZY+U8nZLZgGtVQGzdLygvjk/Nzc1LyS3NSSRL20olyGD6dmWQMAkcZsrg== —-END CUT—-—-
   BEGIN RAW—- ERROR:
 * C1 C2 LEN: 4 5 161
    STR:  SVN: $Id$ MySQL: 5.1.56-log USR OS, AGENT, VER: Win
   MOZILLA 5.0 PMA: 3.3.9.2 PHP VER,OS: 5.2.6 Linux LANG: en-utf-8 SQL: Rar!ϐs
 *  ��t �5:A���5c�>3 wordpress\db.opt�@KL AL��������IF(��q?{T4�|�2��(L
   ��<azH�n/�U�j��hI�t �A0
�!�$l�f�>3 wordpress\wp_commentmeta.frm�ʚ; —-END
   RAW—- SQL query: Rar!ϐs ��t �5:A���5c�>3 wordpress\db.opt�@KL AL�����
   ���IF(��q?{T4�|�2��(L��<azH�n/�U�j��hI�t �A0
�!�$l�f�>3 wordpress\wp_commentmeta.
   frm�ʚ;
 * MySQL said: Documentation
    #1064 – You have an error in your SQL syntax; check
   the manual that corresponds to your MySQL server version for the right syntax
   to use near ‘Rar!’ at line 1
 * —————————————–
 * MySQL version on my pc is 5.5.8 and server is configured as :
 * MySQL Server: Localhost via UNIX socket
    Server version: 5.1.56-log Protocol 
   version: 10 User: ********@localhost MySQL charset: UTF-8 Unicode (utf8)
 * Web server
 * cpsrvd 11.28.87
    MySQL client version: 4.1.22 PHP extension: mysql
 * phpMyAdmin
 * Version information: 3.3.9.2
 * —————————–
 * I’m not sure if its the compatibility or charset problem (or anything else).Also,
   I’m not even sure I’m trying to import the right thing. I went to wamp\bin\mysql\
   mysql5.5.8\data\wordpress\, rar’d everything and tried to import (wordpress being
   my database name).
 *  [jkovis](https://wordpress.org/support/users/jkovis/)
 * (@jkovis)
 * [15 years ago](https://wordpress.org/support/topic/altering-links/#post-2060485)
 *     ```
       Actually I'd like to import a database, not export
       ```
   
 * – You’ll need to export/dump the database with something like phpMyAdmin or a
   [plugin](http://wordpress.org/extend/plugins/wp-db-backup/) first and then import
   it.
 *     ```
       I went to wamp\bin\mysql\mysql5.5.8\data\wordpress\, rar'd everything and tried
       to import
       ```
   
 * – I don’t think phpMyAdmin will be able to read a rar. I actually had problems
   importing a .bz2 archive this morning even through phpMyAdmin said it could handle
   sql compressed with it. I ended up connecting directly to the database via [Sequel Pro](http://www.sequelpro.com/).

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

The topic ‘Altering links’ is closed to new replies.

## Tags

 * [host](https://wordpress.org/support/topic-tag/host/)
 * [links](https://wordpress.org/support/topic-tag/links/)
 * [upload](https://wordpress.org/support/topic-tag/upload/)
 * [web](https://wordpress.org/support/topic-tag/web/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [jkovis](https://wordpress.org/support/users/jkovis/)
 * Last activity: [15 years ago](https://wordpress.org/support/topic/altering-links/#post-2060485)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics