Move from Server A to Server B

thevaeth

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

acrylian

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.

thevaeth

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_[...]

acrylian

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.

thevaeth

Hi acrylian,

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

best regards

acrylian

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