Database time vs PHP time

[psy]

First time I've ever encountered this warning message and unsure how to resolve.

Scenario:

1. Customer is a long-time PW client in Australia who is moving to the UK.
2. The web host created a new account hosted in Germany and copied all the AU files and DB to the new hosting account/location, Germany being their closest hosting centre to the UK.
3. Time diff between Germany and UK is 1hr
4. Time diff between Australia and Germany is 10hrs
5. Site is working with new URL, etc
6. The new PHP time zone needs to be "Europe/London" and $config->timezone is set to same

Times are important as the client will be taking online appointment bookings.

How do I match the DB time to the new UK time zone?

 

 

[bernhard]

This is how you can set the DB timezone: https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql

If you don't have access to that talk to your hosting provider.