phpMyAdmin SQL Dump, Generation Time and TimeZone difference

[Rob_Again]

When I do an export of a database the Generation Time on the .sql file and my current is about 10 hours behind.
My time_zone is Pacific/Auckland and 10 hours behind is CEST.
When I type

SHOW VARIABLES LIKE '%zone%';

into SQL I get

system_time_zone Pacific/Auckland
time_zone SYSTEM

When I type

SELECT NOW();

I get

NOW() Full texts
2022-07-18 20:37:52

Both of which are correct.

At the top of the dump is

-- Host: 127.0.0.1
-- Generation Time: Jul 16, 2022 at 11:16 PM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

NOTE: This is taken from an eairler dump so the date etc are not current

How do I get the dump to show my SYSTEM time ... and where do I SET time_zone

[cb]

Try changing the timezone in the php.ini file

from
date.timezone=Europe/Berlin

to
date.timezone=Pacific/Auckland

[Rob_Again]

Thanks.. I was looking in the wrong file (my.ini)