custsql-pow13 - CAN'T EVEN EXPORT MY DB!!!

[aragorn231]

That's it, I've had it with this crappy host. I am administering an osCommerce site here and noticed a couple of days ago that one of my links is producing a SQL error (allprods page - 1054 - Unknown column 'p.manufacturers_id' in 'on clause'). So today I decided to have a look at it and fix it.

Important to know is that (A) the code is working fine on my local server, (B) the code was working fine when I uploaded it several months ago and (C) I have not made any code/DB changes the last few months.

Then I saw the "upgrade to MySQL 5" message so my assumption was that it must have something to do with this upgrade.

I've already double-checked the PHP file and the online version is exactly the same as my local one. So only the DB remains.

Unfortunately at the moment I can't even access my DB through the online phpmyadmin, all I get is empty pages when I try to access the tables (just to see if the structure has somehow changed with the error as result). Same when I try to export the DB. I'm assuming that the empty response pages are the result of a timeout.

So, I will be really happy if someone could tell me how I can get a download of my DB. I really need this if I want to switch to another host.

Ow, and I'm pissed, really. This has already cost me hours today. :(
Future customers: please do yourself a favor and consider another host if you require a database. Really.

[IanS]

Have you read the stickies? This one (http://forum.powweb.com/showthread.php?t=76496) may be of some use to you. You do have a recent backup of course, like every good webmaster has? :D

The syntax seems to have changed for a number of MySql commands between MySql v4 and MySql v5. For some issues brackets seem to be needed now where they weren't explicitly required in v4. Have you checked the syntax for v5? You are using the latest MySql v5 compatible version of osCommerce, aren't you?

[TakeIT2]

like every good webmaster has? :D
this is not helpful cute or funny but it is as9

[Cadinos]

You do have a recent backup of course, like every good webmaster has? :D
Now, if backing up a database here wouldn't be a long and painful process....

phpmyadmin does not work, powwebs own db-backupsystem does not work for me, mysqlquickadmin does not escape characters properly (on my database at least). Now I've used mysqlman (http://www.gossamer-threads.com/scripts/mysqlman/) to get to the data. of course it takes a long time to download a few KB's from a database :(

[aragorn231]

Have you read the stickies? This one (http://forum.powweb.com/showthread.php?t=76496) may be of some use to you. You do have a recent backup of course, like every good webmaster has? :D

The syntax seems to have changed for a number of MySql commands between MySql v4 and MySql v5. For some issues brackets seem to be needed now where they weren't explicitly required in v4. Have you checked the syntax for v5? You are using the latest MySql v5 compatible version of osCommerce, aren't you?

Thanks for the hint on the syntax changes IanS, that indeed triggered something in my memory. My issue was related to the higher priority of the JOIN in MySql5 - http://gcolpart.evolix.net/blog21/join-syntax-changes-in-mysql-5/. For some reason I didn't expect such huge changes but that's maybe because I'm more used to MS SQL Server...

Erm, backups, yes, they are in the same folder as the documentation :o

I did see that sticky btw, but I haven't tried it out. How exactly does that work? Does this need to be uploaded to the webserver or can it be used locally? (I read somewhere on the forum that remote connections are not allowed for the MySql DBs here at powweb.)

[YvetteKuhns]

PowWeb database backups are not complete. I tried a few yesterday and they did NOT work!

Someone else mentioned it in another thread and when I checked the file sizes, I discovered that the backups were incomplete or empty. I compared one backup with a backup from June and the new database should be the same (68 KB) or bigger in size, but it was nowhere near the size (0 to 4 KB).

I tried a few different client accounts to create backups and none were good. Phone support tried and replicated the problem, yet I got another stupid email reply saying that the downloaded file is compressed and will be smaller than the file size reported in OPS. We all know that. (See ticket #3327658)

Support and my client got a copy of my reply where I explained that I am NOT stupid and I don't think the person even bothered to look. Do they think we are stupid? Are they that lazy? What is the problem with some of the support people? I am really disappointed that problems are not taken seriously and therefore not resolved in a timely manner.

Don't make me post stupid email replies again, PowWeb. :rolleyes:

See recent announcement Backed Out: phpMyAdmin 2.11 (http://forum.powweb.com/showthread.php?p=439880#post439880) to improve slowness in phpmyadmin.

[YvetteKuhns]

Woo hoo! The change must have fixed it! I was able to create a backup for 68 KB just now which was what I expected it to be. Thanks for the announcement, Dwight! ;)