Hi,
im using ZenPhoto since 6 years with at least 300 000 photos. Now my Server gets to small and i want to switch from Server A to Server B . at the end adress will be the same.

Is this the right way to do:
1. Download filestructur
2. Upload on new onw
3. Import SQL
4. Change config?

or is there a better way to do or anything else?

best greets
thevaeth

Yes, that's generally the correct order. Also please see here:
https://www.zenphoto.org/news/moving-and-changing-existing-installations/

If your install is also 6 years old (what I really don't hope), you might get into trouble with the update if the new server runs a newer PHP 7+ version. If your old server is alredy running PHP 7+ you are on the save side. If not you have to upgrade the old one first and update to a newer Zenphoto version.

Hello again,
my problem is:
download database from old server is no problem
upload to new db fails
--
-- Datenbank: `dbxxxxxxxx`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `xxxxxxxxx_administrators`
--

CREATE TABLE `xxxxxxxxx_administrators` (
`id` int(11) UNSIGNED NOT NULL,
`user` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`pass` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`passhash` int(1) DEFAULT NULL,
`passupdate` datetime DEFAULT NULL,
`name` text COLLATE utf8_unicode_ci,
`email` text COLLATE utf8_unicode_ci,
`rights` int(11) DEFAULT NULL,
`custom_data` text COLLATE utf8_unicode_ci,
`valid` int(1) NOT NULL DEFAULT '1',
`group` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`date` datetime DEFAULT NULL,
`loggedin` datetime DEFAULT NULL,
`lastloggedin` datetime DEFAULT NULL,
`quota` int(11) DEFAULT NULL,
`language` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`prime_album` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`other_credentials` text COLLATE utf8_unicode_[...]

I can't really help without any actual error (It seems parts of your post are missing because you didn't escape correctly.

But try using the included database backup tool instead as the link above suggests. I did use that successfully on such moves.

Hi acrylian,

want to say thanksfor help ! It works....

best regards

Thanks for the follow up. Glad you got it working!