>>> MySQL 4.1 Support? <<<

[aegrant00]

I called yesterday to inquire about this, and got "uh, did we have a meeting?"

Brad-

what's the poop on the meeting, please?

[dmanvan]

MySql 4.1, any change in the status of this?

[Brangwyn]

There is currently one 4.1 server IIRC but have heard no word on upgrades to others.

[dmanvan]

How may I create a database to host an application on this server?

[Brangwyn]

No way you can guarantee you'll get a database on that server (I think it's the latest mysql server not sure which number that is .. 12 maybe?).

[dmanvan]

Created a new end user. Support informs this is the only MySql server to which new end users' databases are be assigned.

Works like a charm and so does my app (so far) :-)

[Brangwyn]

Great

[aegrant00]

what is the status on this? which servers have 4.1 or greater?

[Clayton]

We've added a mysql 4.1 server quite some time ago, and it is mySQL10.

[writing]

How do I switch a database over to the 4.1 server?

[dmanvan]

I don't know if you can "switch" a database over. You may try creating a new mysql db. The new db should automatically be created on mysql10. You may then export the old db, making sure to check save as file, and import the resultant file into the new db.

HTH

[dmanvan]

Originally Posted by dmanvan

Created a new end user. Support informs this is the only MySql server to which new end users' databases are be assigned.
Works like a charm and so does my app (so far) :-)

Ooops...looks like you must create a new end user account (hsphere control panel)

[writing]

So I have to delete the existing end user account, create a new end user account, re-upload all the previous files, and all of that?

[promitech]

the mysql version built into the php running on the webserver is only 3.23

[Brangwyn]

Originally Posted by promitech

the mysql version built into the php running on the webserver is only 3.23

it's fairly normal to see that actually and should not cause any issues, most places will have php client library 3.23 I think you'll find.