All,

I need help. I have to pick the brains around here. Here is my situation.

I was hosted with Linksky. They are a decent company, but when they did a server upgrade, it seems like I went back to the stone ages. Dealing with them is the constant battle of "That is a horrible software" speaking of ubbthreads. "You should use something more compatible with our servers." Well, after being down 4 times this year for random crap, I bit the bullet and moved everything to Godaddy.com. While this isn't the best choice, it is the one we made.

I have both the domain and site hosted with them, and we are now live. I am ready to try and redo the damage here.

1. My database is not coming over properly. After rebuilding it at godaddy, I am getting the following error:

ERROR 1064 (42000) at line 1: 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 '‹
 úDê£E2…"Á¡HSS úD:”³g7ª?ùèï•Ã:ž†ˆUìHÔû`G¶ÀŽ4üö%ÀŽ$°#
v¤;ýÉðïGö,÷' at line 1

I realize that the server versions are probably different, but I thought as long as they both were running MYSQL 5.0, we should be good. What can I do to correct this issue? I did a search through here, and I couldn't find anything that might help.

2. With the problem above, I have not gotten to begin an install of UBB on the new site. I am confident in the installation, but would it be better to go with an older version and then upgrade to 7.5.4.2 or just to put on 7.5.3, which is what was on the site and what the database was, and then upgrade?

I am sure I will have more questions along the way, but these two seem to be the most pressing right now. Thanks in advance.

That error message looks like the database file that you're tring to bring over is still compressed, maybe zipped, or gz'd. I'd check that first and see if it needs to be uncompressed first. The file should just be a standard text file that you could read normally.

Once you an get that sorted out then it should just be a matter of moving over the files and editing the includes/config.inc.php to match the new server settings.

I can see, and undertsnad, the text portion when I am trying to import this onto the new database. On my local computer, I can view the text file of the backup, but it is undecipherable. Is there anything I can do to uncompress this on a XP box?

It really depends on what format it's in. Did the host give you the backup, or did you get it through something like phpmyadmin. Does the file have any type of extension on it?

I pulled this down from phpmyadmin, or a bastardized version of it from my former hosting.

The file's name is OPHA.sql.gz (I assume that this is the compressed version) When I upload this to the new host, the .gz extension is removed. If I try to restore the database through the new hosting company, I receive the error message from above.

Ok, so it's definitely compressed and it sounds like the new server is trying to decompress it but might not be doing it properly. If you do decompress it locally then it might end up being too large to actually upload it.

Does your new hosting come with SSH access or is it FTP only. If it's FTP only what you might do is get in touch with them and tell them you have a compressed sql dump that you're having some issues getting moved to their server and see if they can assist. Many hosts will have you ftp it to the server and they'll import it for you.

If your hosting happens to have SSH access as well, then we could give some assistance on importing it through SSH.

Is there anyway to decompress it locally and remove part of it? I know there is stuff in there that is not part of UBBThreads, as I had a chatroom program that ran in part of this too. THANKS old host, at least now, we can build this back the way it needs to be built.

I can import plain text, I think through the import feature of the myphpadmin.

So, I guess, I will try to decompress the file into a text file, and weed out the crap about states, robots, and personal questions that seem to be present from the chat room crap.

Any suggestions on a free decompressing software?

You can use 7zip.

I don't know much about godaddy.
But if your host control panel is cpanel.
It usually has a option for backups. In the menu is a restore option also. That will create a Mysql database from a gzip file.
This option is not in phpmyadmin but a separate option for making backups of the whole site.
It works quite well in cpanel at least.
I think you are looking for trouble to try and delete some of the data.