error while importing dump
-
i just upgraded to the latest nightly build (wordpress-2004-05-03.tar.gz), after running the upgrade script everithing was ok!
now, i need to move the upgraded database from a server to another, so i made a dump using:
mysqldump –user=MYDBUSER –pass=MYDBPASS MYDBASENAME > dump.sql
my mysql version is 3.23.58, my new host uses 4.0.18-standard-log + PhpMyAdmin, so i needed to upload my dump into the SQL section so that he reads it as a sql query (isn’t it?). i first bzip2ed it (phpmyadmin supports it..) and then uploaded it..
when tried to upload it the first time i got the following error:
query SQL :
—
——————————————————- —
—
—
CREATE TABLE b2categories(
cat_ID int( 4 ) NOT NULL AUTO_INCREMENT ,
cat_name tinytext NOT NULL ,
category_nicename varchar( 200 ) NOT NULL default ”,
category_description text NOT NULL ,
category_parent int( 4 ) NOT NULL default ‘0’,
KEY cat_ID( cat_ID ) ,
KEY category_nicename( category_nicename ) ,
KEY category_nicename_2( category_nicename )
) TYPE = MYISAM
Messaggio di MySQL:
#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 ‘———————————————————
—
—
what the.. ! ok, i’m not a mysql geek actually.. but, what’s wrong with this query?
then i tried again with another dump (using –add-drop-table):
mysqldump –user=MYDBUSER –pass=MYDBPASS –add-drop-table MYDBASENAME > dump.sql
now, nice start again, i got a sort of crash which forced me to logout/login, saying that apache@localhost was a jackass 🙂
the very next time i tried (with add drop table) i got this:
query SQL :
—
——————————————————- —
—
—
DROP TABLE IF EXISTS b2categories
Messaggio di MySQL:
#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 ‘———————————————————
—
—
it seems that there’s something wrong in this ‘———‘ thing..???
- The topic ‘error while importing dump’ is closed to new replies.