I can't use my mysql database dump from powweb [Archive]

View Full Version : I can't use my mysql database dump from powweb

Craptag

3-21-03, 03:19 AM

As a result of the mysql query limit on Powweb, I am moving my Invision forum v1.1 to another host.

I requested a dump but when my new host tried to help me restore my forum database, they say:

Error

SQL-query :

< html * < head * < title > Invision Power Board Database Error * / title > < style > P, BODY{font - family : arial, sans - serif

MySQL said:

You have an error in your SQL syntax near '<html><head><title>Invision Power Board Database Error</title>
<style>' at line 1

Checked with my system administrator, this induced by the beta version of MYSQL 4. Which is a trial version and caused database crash easily.

This was their latest message: The syntax error signal either a version conflict or files
corruption.

What happened to my database????? Why is it corrupted?

HELP!!!!! Need advice! Anyone facing this problem???

Jeku

3-21-03, 10:36 PM

Well for one thing you can't use HTML commands like <head> and <title> etc. in MySQL. When you normally do a dump from MySQL, erase any lines that aren't SQL commands or just stick a # symbol in front of comments (MySQL skips over lines with a # symbol.

Please tell me if this helps.

Craptag

3-23-03, 03:08 PM

That's the funny thing.. why is it there???

My forum was working perfectly fine before this issue came up.