MySQL problem

Status
Not open for further replies.
P

paul_ngw

New Member
Messages
26
Reaction score
0
Points
0
yes, i am trying to switch my IPB forum from my previous host to my x10 host. when i upload the db, i get this error

PHP: 
 #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 '<html><head><title>Invision Power Board Database Error</title>

can someone help me
happysad.gif
 
B

Brandon

Guest
Hmm... What verison of MySQL where they using? Because I exported data from phpMyAdmin from my server and I got the same error when I used it on x10.
 
Corey

Corey

I Break Things
Staff member
Messages
34,551
Reaction score
205
Points
63
Is
Code: 
<html><head><title>Invision Power Board Database Error</title>
supposed to be in a table ?

-Corey
 
B

Brandon

Guest
Wait, I didn't see that. Its not supposed to be there I worked for Invision Power Services once.
 
B

Brandon

Guest
I hope your forum on the old site is still there, because what you showed me was not a MySQL database. Post it here on the forum and other people will tell you. Looks like something went wrong during the creation.
 
TheJeffsta

TheJeffsta

New Member
Messages
984
Reaction score
0
Points
0
I am also having this problem. This is my first time restoring a database, but I am getting the same error.

my other host uses sql version 4.1.11 and x10hosting uses 4.0.25. Is there anyway to get it to restore the 4.1.11 databse so it works with mysql version 4.0.25?

Update: I am now getting sick of MySQL and phpMyAdmin, could someone else try and get mine to go - im now feeling sick and have a big migraine :(

You can download the .sql.gz file from
http://www.thejeffsta.x10hosting.com/ibf_dbbackup.sql.gz
 
Last edited:
bigguy

bigguy

Retired
Messages
10,984
Reaction score
10
Points
38
If these are db backups from inside the admin panel of ipb, would there be a chance of downloading a backup from your cpanel of the old host and using it instead on x10.
 
bigguy

bigguy

Retired
Messages
10,984
Reaction score
10
Points
38
Are there or were there any errors on your board when you took the backup ? Any posts or topics that had attachments or anything that might be the cause of the problem ? Did you switch your theme or skin back to the default before you did the backup ? Just some ideas I had that might help.
 
P

paul_ngw

New Member
Messages
26
Reaction score
0
Points
0
oooh, that may be the problem. since my forum is a graphics forum, theres a psd section where the psd's are attached to the thread. but its not as easy as deleting the whole section since theres alot. and theres also an error on the staff page :S
 
Last edited:
TheJeffsta

TheJeffsta

New Member
Messages
984
Reaction score
0
Points
0
My error keeps compaining about 'ENGINE=MyISAM DEFAULT CHARSET=latin1;'

Ill try and get a backup or something from VHCS (Virtual Hosting Control Panel) Pro or phpMyAdmin.

Is there a way to import backup files using PhpMyAdmin?
 
Last edited:
TheJeffsta

TheJeffsta

New Member
Messages
984
Reaction score
0
Points
0
:( I cant restore a backup as the database name on the other hosting companies server is 'InvisionForum' and the cPanel database backup restoration thing gets stuck when creating database.

' Restoring Database

--------------
CREATE DATABASE `InvisionForum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci
-------------- '
 
bigguy

bigguy

Retired
Messages
10,984
Reaction score
10
Points
38
If you have access to phpmyadmin create a new db named the same as the old one with the same pw and try to import into that db
 
Status
Not open for further replies.
Top