Altering links

  • Mercurialol

    (@mercurialol)


    15 years ago

    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

    (@jkovis)

    15 years ago

    See http://codex.wordpress.org/Moving_WordPress for how to create an export using phpMyAdmin.

    Thread Starter Mercurialol

    (@mercurialol)

    15 years ago

    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��<a zH�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��<a zH�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

    (@jkovis)

    15 years ago

    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 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.

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

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