Forums

UPDATE MySQL version

Hi, could you please upgrade my mysql version to 5.7+. The MySQL version below 5.7 is not supporting the JSON fields as my project have few json fields in the db structure, Can you do it as soon as possible please. Thank you.

Sure, no problem -- that's done now.

Please upgrade my MySQL version I was unable to use JSON data type in my current MySQL version, please upgrade it to 5.7.8 +. Thank you.

We could move you to a new MySQL server (v5.7), but it would involve downtime. Email us to schedule a time that would work for us and you to do the move.

Hi, could i have my MySQL bumped to 5.7+? I need to use the JSON field. Thanks!

MINDFIT, Why don't you try importing JSON fields as TEXT datatype and use it in your python script with json.loads()

@deejaynof Do you care about downtime? (migration of the database from server to server takes a moment)

Not at all :)

it's done for you.

Thanks!

Hello, could I ask for an upgrade to v5.7+?

Sure! Just drop us a line at support@pythonanywhere.com so that we can arrange timing -- or if the timing doesn't matter to you, let us know that and we'll do the upgrade as soon as we can.

It doesn't really matter, so please do it anytime you can. Thanks in advance.

OK, no problem -- that's done now.

cool, thanks!

Hi!, I need the same, could you upgrade my MySQL to 5.7+ please?

No problem. I have migrated your database.

Great, thanks!

Hi!, I need the same, could you upgrade my MySQL to 5.7+ please?

Ok. I have migrated your databases.

Could you please do the same for me please.

Sure! That's done now.

Hi, Can you please upgrade my MySQL database. It shows an error while i am trying to make a backup of my database. The error is : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use

I think we spoke about this over email too -- if you're trying to make a backup using mysqldump, you should run that command in a Bash console, not a MySQL one. Despite the name, mysqldump is a Bash command.

Hi Giles, Please upgrade my MySQL to the newest one too. I would like to have JSON field. Thanks!

Your MySQL server is already at the most recent that we offer.

Thank you! (and sorry for my not checking this)

Hi!, I need the same, could you upgrade my MySQL to 5.7+ please?

No problem. I have migrated your database to a server that runs MySQL 5.7.

Hi!, (I edited this post) could you upgrade my MySQL to 5.7+ please?

Hi, we can certainly do that for you. It will however take down your database for approximately 20 minutes plus some time on top of that depending how much data you store.

We can do that from Monday to Friday between 12 noon and 6 pm UTC, please let us know which time is most suitable for you. If you don't care for the timing, let us know likewise and we will do that ASAP.

Go ahead, no problem

OK, that's running now -- we'll post back here when it has completed.

...and that's done now.

Thanks Giles!

Hello, could I also get the migrate? I don't have problems about downtime.

I see that we're talking about this over email too, so we'll reply there.

Hi, could I get upgraded too. Don't worry about downtime, fire away.

@aidodo No problem, it's done for you.

Hello, please can i have MySQL upgraded to 5.7+ too? I need it to work with Jsonfield. Thanks in advance.

Sure @acerimallas, it's done for you.

Hello, please can i have MySQL upgraded to 5.7+ too? I need it to work with Jsonfield. Thanks.

No problem, that's done now.

Hi, could I get upgraded too. Don't worry about downtime. Thanks in advance.

@wisebuy It's done for you

Thank you

Could I also get a MySQL upgrade to 5.7+ please? I need JSON fields. Thank you :-)

@hrishikeshrt we can certainly do that for you. It will however take down your database for approximately 20 minutes plus some time on top of that depending how much data you store.

We can do that from Monday to Friday between 12 noon and 6 pm UTC, please let us know which time is most suitable for you. If you don't care for the timing, let us know likewise and we will do that ASAP.

Thank you! I do not have any data at all in my database at the moment, I was just trying to setup the database afresh. I do not care about the timings.

@hrishikeshrt It's done for you

Hi,

Can I have a MySQL upgrade too please? downtime is not an issue for me

Your MySQL server is already at the most recent version of MySQL available on PythonAnywhere.

My database has went weird. Its version 5.6.48. I was quite happy with it until this morning when it stopped updating itself. It won't allow me to INSERT or DELETE. It shows me the same visitor number in the counter although the website updates the number a few times before resetting to the earlier number it shows on the console.

Oh - never mind. I got it. I was missing the db.commit() command.

Oh, OK, thanks for letting us know.

Hi, Could you please upgrade my SQL to 8.0.22? I have a recursive query, worked in my local, not supported by server. Thanks in advance.

5.7 is the newest available on pythonanywhere at the moment. We will let you know here when we can upgrade you to 8.0

Hello, I would also require an update to MySQL 8.0.16+. I'm trying to use CHECK constraints. Thank you in advance;

Unfortunately we only support MySQL up to 5.7 right now. We will let you know here when we can upgrade you to 8.0.

Is an update to MySQL 8.0 planned? If so, could we get a rough estimate of when?

We would do not estimate, Sorry.

hello, could you please upgrade my sql version to my sql v8, or the latest one please.

Your MySQL database is already on the most recent version that we support.

UPDATE MySQL version Hi, could you please upgrade my mysql version to 5.7+.Can you do it as soon as possible please. Thank you.

@Lin1668 Your MySQL database is running on 5.7.33 server.

UPDATE MySQL version Hi, could you please upgrade my sql version to the latest one. Thank you.

Your MySQL database server is already running 5.7.28.

Hi, What is the latest mysql version that you could, currently, upgrade my website to? Are you planning to have version 8.0 available any time soon?

5.7.28 is the most recent version that we currently support, but we're working on adding on MySQL 8 -- no exact timeline yet, but it should be within the next few months.

Hi, could you update my version of mysql to 5.7.8 +? Thanks

Your MySQL server is already a more recent version than that. What problems are you having that suggest to you that it is an older one?

In my database console show version server 5.7.34, and I use django with JSON fields that require MySQL 5.7.8+

5.7.34 is higher than 5.7.8, so Django JSON field should work for you.

Of course, excuse my confusion. Thanks for your attention.

No problem, glad it's sorted out.