WordPress.org

1. Mercurialol
   Member
   Posted 1 year 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

2. jkovis
   Member
   Posted 1 year ago #

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

3. Mercurialol
   Member
   Posted 1 year 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��<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).

4. jkovis
   Member
   Posted 1 year 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.

Topic Closed

This topic has been closed to new replies.