New Linux Server Guide

[Dr Zauis]

Crap..I tried to source the sql from Angelox with sqlyog and I get this error.

PRIMARY KEY (`aaid`,`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Line no.:42
Error Code: 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 'DEFAULT CHARSET=utf8' at line 14

EDIT>>I should say Im tring to do this on windows if it dont seem obvious LOL..Im trying to get the db ready to just transfer to the server.

[Angelox]

Originally Posted by Dr Zauis

Crap..I tried to source the sql from Angelox with sqlyog and I get this error.

PRIMARY KEY (`aaid`,`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

Line no.:42
Error Code: 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 'DEFAULT CHARSET=utf8' at line 14

EDIT>>I should say Im tring to do this on windows if it dont seem obvious LOL..Im trying to get the db ready to just transfer to the server.

Can you try a restore with mysql-administrator? I'm using MySql 5, but I don't think that should matter.

[Angelox]

I just downloaded to my windows setup and restored it to a MySQL 4, saw the error - give me a while and i'll make a windows MySql4 back up for you.

[Dr Zauis]

Originally Posted by Angelox

I just downloaded to my windows setup and restored it to a MySQL 4, saw the error - give me a while and i'll make a windows MySql4 back up for you.

Woot! I guess Ill spend a few hours trying to DL the maps file again..All I have for a browser is lynx. And what I know about Linux so far I can count on my hand. Thats why Im doing this DB in windows I dont how to extract a .rar file. And it would be an hour or 2 just to DL in the first place.

[Angelox]

Originally Posted by Dr Zauis

Woot! I guess Ill spend a few hours trying to DL the maps file again..All I have for a browser is lynx. And what I know about Linux so far I can count on my hand. Thats why Im doing this DB in windows I dont how to extract a .rar file. And it would be an hour or 2 just to DL in the first place.

It's done and posted - I did it in rar format. but I guess you have winrar - You can get a unix version of rar here -
http://www.rarlab.com/download.htm
it's a command line rar, but works ok (took me a while to figure it out) - just dump all the files into your /bin directory
they say you have to pay, but i think since its beta, it's not active yet.

[Dr Zauis]

Crap..Same error..I DLed it right from the link that say its corrected for windows.Not from the top.(on your website)

[Angelox]

Originally Posted by Dr Zauis

Crap..Same error..I DLed it right from the link that say its corrected for windows.Not from the top.(on your website)

For some strange reason, my router gets hung up when it sends files out- and freezes. I am going to change routers ( I have a spare one) see if it gets better.

EDIT;
I swapped routers - hopefully it works better now.

[Angelox]

Originally Posted by Dr Zauis

Crap..Same error..I DLed it right from the link that say its corrected for windows.Not from the top.(on your website)

I just went out and bought a new router - the router I had has an "overheat and crash " bug - I hope I'm over this problem.

Dr Zauis; can you tell me what version MySQL you are using? I'm trying to find the "why" of this error - That second post I made on my web (for windows), was tested and even played on a Windows XP, MySQL 4 database - I can't see why it still would do this. There's someone else with this very same problem.