Member
Member
thevaeth   2021-02-08, 10:41
#1

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

Administrator
Administrator
acrylian   2021-02-08, 10:48
#2

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.

Member
Member
thevaeth   2021-02-08, 16:59
#3

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

Administrator
Administrator
acrylian   2021-02-08, 17:03
#4

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.

Member
Member
thevaeth   2021-02-09, 18:12
#5

Hi acrylian,

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

best regards

Administrator
Administrator
acrylian   2021-02-09, 18:43
#6

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

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.