View Single Post
Old 23rd May 2006, 13:13
Ovidiu Ovidiu is offline
Senior Member
Join Date: Sep 2005
Posts: 1,269
Thanks: 84
Thanked 25 Times in 21 Posts

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:

h898552:~/exports# mysql -h localhost -u root -p****** web3_db1 <
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,
KEY ip (ip(15))
what could this be? this is my most important database...


how can I do this:
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 13:26.
Reply With Quote