View Single Post
  #29  
Old 23rd May 2006, 12:13
Ovidiu Ovidiu is offline
Senior Member
 
Join Date: Sep 2005
Posts: 1,262
Thanks: 78
Thanked 24 Times in 20 Posts
Default

some more problems:

in your post further up you give a link to how to dump and restore mysql database.

you should mention that one needs to create a db by that name before one can import. at least iti did not work for me.

next one ist this, I get an error whe ntrying to import:

Quote:
h898552:~/exports# mysql -h localhost -u root -p****** web3_db1 <
web3_db1.sql
ERROR 1064 at line 12: 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 'NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM'
h898552:~/exports#
what could this be? this is my most important database...

###edit###

how can I do this:
Quote:
have a look at the users and db table and add the user /db lines that don't exist on the new server but on the old server.

Last edited by Ovidiu; 23rd May 2006 at 12:26.
Reply With Quote