Mangos syntax error in SQL

[ninjalicious]

I'm trying to import realmd.sql in to the realmd database, but it keeps giving me this error:

Query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

Error occured at:2006-11-12 15:26:57
Line no.:8
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 'SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */' at line 1

Query:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *//*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */

It's probably right in front of me but I have no idea what's causing the problem, please help! :punch:

This is the line of code it's talking about I guess:

-- MySQL dump 10.10
--
-- Host: localhost Database: realmd
-- ------------------------------------------------------
-- Server version 5.0.22-Debian_0ubuntu6.06.2-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS

[MentaL]

[anatem]

reinstall/configure mysql server

[ninjalicious]

Thanks, I just did but it made no difference. I'm using SQLyog for this, and it just keeps giving me the same error. I have no idea what's wrong with it.

I'm now trying Navicat but it says 0 queries but 0 errors when I try, so I don't know if that means it's done it.

[[lexx]]

0 queries = no action.
do you use mysql >=5?

[anatem]

use mysql 5.0 and after reinstalling it ALSO reinstall databases and navicat connection it will work this happened to me too

backup ur databases first on another connection if u have info u don't wanna lose

[ast3rik]

It's about character set for mysql (i use utf8).

Try to delete that lines, so that only creating tables and so stays. I think it'll work.

[anatem]

i only got this error when the db didn't recognize the fact that i had standard character set set in mysql