I’ve to get a little MySql database running on a local test system and import a “dump” file of a database to verify, if the file is valid. Sounds easy, but first you have to find out, how you get the dump file into the database. For that you must know, that MySql doesn’t write a “normal” dump file as default, but a simple SQL-file including all the statements to get the status from the database back. Ok, also not very hard. Then you import the file, but not with @ like in Sql*Plus. The correct syntax is ‘source <sourcefile>;’. While executing this you get pissed on with “value bigger than max_allowed_packet”. You spend 1 hour to get yourself throw the documentation, found 4 ways to set this damn variable but – just one way works. Ok, you throw away the database, recreate it, set the variable and get sure that it is set and before you reexecute the file you would like to spool the result. But, MySql doesn’t know “spool” like Sql*Plus. No it doesn’t know anything like that as I saw on spending some minutes on the documentation and Google. The only thing you have is a .mysql_history file, but it also didn’t protocol the echo from the database, no just the commands you typed in. Ok, well no spooling, you have the shell open and will some critical error. So restart the import from the file and see: Same max_allowed_packet error again though the variable is set to the highest value. I’m really pissed on MySql at the moment. Sure I know, if I would know it better, it would not be a problem, but my Dad has his birthday today and it’s already 6:30 PM. I don’t want to spent more time on it in the office!
5 September 2007
Why I like Oracle much more than MySql
Leave a Comment »
No comments yet.