Switched hosts....but many problems

[Mystic Stylez]

I recently changed hosts, although I haven't 'officially' done so because I haven't transferred my database successfully over to the new host yet.

My current forum is at

https://www.ffimpulse.com/forum

and the new forum is at http://ffimpulse.empyron.com/forum

I cannot login to the admin cp, it just says I logged in successfully but puts me back to the login screen....so I can't really do anything.

My database sql size was about 68 mbs.

My host (hostrocket) imported the database for me.

Here is what they said the first time I asked them

Hi Brian,

I attempted to import your ffi file into a new
database named ffi however my initial attempt
failed as the following SQL syntax error was
received:

ERROR 1064 at line 64619: 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 \'desc text NOT NULL, ability text NOT NULL,
hp int(15) NOT N

I dropped that database and made a second attempt
using the -f (force) switch which forces MySQL to
bypass errors and upload what it can. This resulted
in approximately 100MB of data being imported to
the database, however due to the error(s) you may
or may not be able to use the database as is as
some tables may not be complete.

You may want to add a database user, configure your
VBulletin script, see if it will load and if so what
if any data is missing. If the restored database is
too damaged/incomplete to be usable I\'d suggest that
you might want to contact VBulletin or post to their
support forum for additional suggestions.

If you need anything else please let me know. Thank
you for using HostRocket!

After that I decided to prune down my forums and get rid of unneccasarry stuff on the forums.....I got the database size down from 130 or so mbs down to 68. So I reuploaded to sql file to the ftp so that they could ssh it, and heres what they responded.

Hi,

I removed the database and attempted to reimport your SQL
backup file. I received the same error messages Don
reported. I removed the database and tried again with the
-f (force) option. This time it successfully created a
populated database, but many additional errors were
reported, including (but not limited to):
ERROR 1146 at line 57601: Table \'empyron_ffi.inferno_heal\'
doesn\'t exist
ERROR 1146 at line 57672: Table \'empyron_ffi.inferno_items\'
doesn\'t exist
ERROR 1146 at line 59620: Table
\'empyron_ffi.inferno_triad_card\' doesn\'t exist
ERROR 1146 at line 63859: Table \'empyron_ffi.inferno_user\'
doesn\'t exist

Each of those errors was actually repeated many times, with
only the line number different in each case.

What do you guys suggest I do. What can I do?

[Steve Machol]

How are you making the backup? It sounds like it is not complete.

[Mystic Stylez]

The first backup was made through cpanel's database backup.

The second time I did it through the admincp on vbulletin.

Is there a different way i'm supposed to do it?

[Steve Machol]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/m...nce_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/m...ce_ssh_restore

[Mystic Stylez]

Ok those steps were followed, and upon retrying...........

Hi,

Attempting to import your database backup at
public_html/ffimpulse/ffimpulse.com.sql without the \"force\"
option, I still get the following error:

ERROR 1064 at line 57951: 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 \'desc text
NOT NULL, ability text NOT NULL, hp int(15) NOT N

With the \"force\" option, I still get that error plus the
same errors I included in my last reply.

From looking through the SQL file and examining that error
message, I think that MySQL may be having an issue with the
\"inferno_heal\" table containing a row named \"desc\". It
seems that \"desc\" may be a reserved word within MySQL and as
such it is resulting in a syntax error when attempting to
import a table containing a row with that name.

I checked out the internals of the SQL file and the code
that defines the \"inferno_items\" and \"inferno_user\" tables.
\"inferno_items\" also has a row named \"desc\"; additionally,
it has rows named \"type\" and \"level\", which may be reserved
words as well. \"inferno_user\" contains a row named \"level\".

If I am correct about those being reserved words, there is
no way that the database can be imported without
modification to the underlying structure first. Be aware
that renaming rows in the database will also necessitate
modifying any program code that accesses those rows.

[Steve Machol]

What 'force' option? Which restore method are you using?

[choppers4life]

sounds like they are using mysql admin.