Is this a MySQL problem?

yes, you do have to move your mysql database info. Thats where all your pages/posts go.
(aside from your theme, any images you’ve uploaded to your localhost also need to be uploaded to your server)

https://www.revolution-media.net/index.php/2009/07/how-to-move-wordpress-website-from-localhost-to-the-destination-server/

I’m not sure how helpful this will be, as I’ve never done what you need to do, I just know it is, in fact, what needs to occur…..good luck!

I have done this only once, so this may be incomplete, but here goes.

I assume you have already edited your wp-config file to point to the corredt DB, and that you have phpAdmin, or equivalent.

I used WordPress Database Backup plugin to dump a SQL backup of my DB. I then edited the SQL to replace all the occurrences of the localhost URL with the URL of the hosted site.

Once that was done, I ftp’d the SQL to the host and used the Import function of phpAdmin to load it into the database.

I think that was all I had to do.

Good Luck!

OK.. this information is pretty straightforward and I’ve followed all the steps very carefully.

Upon uploading the database file it tells me that there’s a problem and then essentially lists the entire database with a comment at the end about line 1.

I’m no guru when it comes to reading code so I’ll paste below what the server is responding with:

This is at the top of the report:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: ==
SQL: == Database proph006_wordpress1

|——
|Field|Type|Null|Default
|——
|//**comment_ID**//|bigint(20) |No|
|comment_post_ID|bigint(20) |No|0

This is at the bottom of the report:

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 ‘== Database proph006_wordpress1

|——
|Field|Type|Null|Default
|——
|//|’ at line 1

Any help will be greatly appreciated.

If I’m reading that right, there is a pipe symbol instead of a pound/hash symbol for the comments. My output looks like this:

# WordPress MySQL database backup
#
# Generated: Sunday 29. November 2009 15:22 CST
# Hostname: localhost
# Database: <code>bluegras_miataclub</code>
# --------------------------------------------------------
# --------------------------------------------------------
# Table: <code>wp_comments</code>
# --------------------------------------------------------

#
# Delete any existing table <code>wp_comments</code>
#

DROP TABLE IF EXISTS <code>wp_comments</code>;

#
# Table structure of table <code>wp_comments</code>
#

CREATE TABLE <code>wp_comments</code> (
  <code>comment_ID</code> bigint(20) unsigned NOT NULL AUTO_INCREMENT,

I don’t know if the output is different on a Mac or not, but I believe that MySQL needs the # symbol for comments.

Yeah… that’s kinda what I thought as well. I’m gonna copy my file to a new name and try that.

I’ve got some people at my host service working on the issue. Funny thing is that when I exported the database FROM my hosting service they file I got from them was the same way. Maybe it’s the MAC text editor dropping that in there… don’t see why though. I’ll replacing the character and post what I find out.

OK! I figured out what was going on.
In my case the database wouldn’t update for two reasons.

The first issue was that the database I was exporting from my local machine was in the wrong format. When exporting a database from PHPMYADMIN you need to have the format set to SQL.

The second issue I ran into after THAT was that the database that was created on the hosting server would not allow me to upload my information to it. Still investigating why.
I ended up deleting all the tables from in the DB on my host. Then I imported the custom tables and the site started running immediately. YEAH! Thanks everyone for your help.