TiffanyBlitz

I did everything just as it said.

Only expection was not “going back to the old bog and changing the URLs to the new…”, which was moot since I transferred the domain ad the URLs are thus the same.

When I try to import the uncompressed db file, I get this:

SQL query:

— phpMyAdmin SQL Dump
— version 2.10.0.2
— https://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Nov 02, 2007 at 01:18 PM
— Server version: 4.1.22
— PHP Version: 4.4.4
SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”
MySQL said:

#1193 – Unknown system variable ‘SQL_MODE’

When I try to import the zipped version of the db, I get this:

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
—-BEGIN CUT—-
eNodjjFvgzAUhJHSofLcH/CGjPjVNiQQbwhZaVQCFCfpTApqqFxCcVIlS3925zqVbjidTvedqqqi
kpBySAVkKpcgIAAeEb1x8YSQdKclTFeNBPtlhnq07Yim2+NwGPxvEBjMQTA2e2Sxk7NSCMk5mPZz
AeoywJSsr/olkxAiQxFRe6r7ph4bao7vZKsrKLQPyVLlGx92yjFfux5WCiJkpFwn7g/OMaSDCUj5
VN4qfqFvawFyRh0a7dvBnPsGOWRdf76QLMmXEtqedvZI43i2oJz8PyifJ3cPnufde6ePfRT+/P4B
+lhA4w==
—-END CUT—-
—-BEGIN RAW—-

ERROR: C1 C2 LEN: 2 3 17
STR: 

CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
MySQL: 4.0.27-standard-log
USR OS, AGENT, VER: Win IE 7.0
PMA: 2.6.4-pl3
PHP VER,OS: 4.3.10-200.schlund.1 Linux
LANG: en-iso-8859-1
SQL: PKtjb74~?—-END RAW—-
SQL query:

PKtjb74~?
MySQL said:

#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 ‘PK’ at line 1

Hope that makes sense to someone else, because it’s all Greek to me! LOL

I was saying I thought that might be an issue because of SQL versions or something. It happens during the import of the database – I haven’t even gotten as far as looking at the blog.

I cannot go back update the blog on the old server, and try downloading the db again, because I can’t get to it now that the DNS points to the new server…

So if the WP version updates don’t effect the SQL in any way, then that is NOT the issue, and I have no idea what is…

Okay, just to let you know I got the message, I’ll go ahead and post about how silly I feel.

I had clicked the “go” button, and waited for ages, but it didn’t do anything… But unbeknownst to me it WAS still doing it.

So when I went back to look after reading your post? Naturally, my db was there. LOL

Thank you!!

— bump —

Anyone have any ideas on this?

Thank you!!

Just bumping this up to see if anyone can help.

Thank you!!

Okay, then a follow-up question…

(I did search, found mine is configured to 8 mb as well, and contacted the host about raising it).

BUT – If the PHP Memory allocation is the maximum size for a given script to run, how can it be maxed out like that? Surely the “upload a photo” routine isn’t using any more memory than it did yesterday…

Thanks for helping me get my head around this! ??

I had this problem for a while with a lot of things getting shifted in the html… And it was all solved when I switched to a different theme. (Don’t know why, really, but someone suggested that it would work, and it did, so I thought I’d pass it on…)