Announcement

#1 2017-11-14 00:07:28

tomsmig
Member
2014-08-01
12

Moving Piwigo.

Hi,
Some time I have set up a piwigo gallery(I think it was v2.8) on VPS server (deb7u1) with MySQL DB (5.5.47) hosted along with that server in some "cloud"

After that I had to move out from this hosting.
Befor moving out I created physical backup of:
/.../piwigo/upload/ folder (all images are here)
/.../piwigo/galleries folder (this one is empty as only www form was used to import images)
MySQL database with mysqldump --all-databases option.

Now I am trying to revitalize gallery with newest piwigo, and mysql version hosted on local server.

Problem with old gallery is that, all piwigo configuration and data were kept in "mysql" database.
"piwigo" database existed, but is empty, as I can see in dump file.
New piwigo gallery is installed correctly - with its own db named "piwigo".

Is there a way to import correctly album data from this old DB into new installation?
I am looking for best way to recreate album structures and content in new gallery.

Piwigo version: 2.9.2
PHP version: 7.0.19-1
MySQL version:  (mariadb-server-10.1     10.1.26-0+deb9u1)

--
Best regards,
Tom

Offline

 

#2 2017-11-14 11:22:11

flop25
Piwigo Team
2006-07-06
6961

Re: Moving Piwigo.

Hello
when you import the .sql file it may contain the USE DATABASE statement http://beginner-sql-tutorial.com/sql-use-database.htm . If that's the case just delete it: without it, the tables will go to the database you selected in your Mysql manager


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2017-11-15 01:06:40

tomsmig
Member
2014-08-01
12

Re: Moving Piwigo.

Hi, of course I can import tables that way to my database of choice, but how can I be sure that database created for piwigo over a year ago has all required tables for current version?
I do not want to mess up fresh install of piwigo by manually overwriting tables.

--
Best regards,
Tom

Offline

 

#4 2017-11-15 01:08:54

flop25
Piwigo Team
2006-07-06
6961

Re: Moving Piwigo.

well just use the files from the version of your database then update
BUT Php 7 will be an issue, so use a Php<7 environment


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2017-11-15 23:50:34

tomsmig
Member
2014-08-01
12

Re: Moving Piwigo.

Thanks.
PHP 7 is not recommended for piwigo 2.9.2 (or newer)?

--
Best regards,
Tom

Offline

 

#6 2017-11-15 23:52:59

flop25
Piwigo Team
2006-07-06
6961

Re: Moving Piwigo.

Not for your 2.8


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#7 2017-11-15 23:55:07

tomsmig
Member
2014-08-01
12

Re: Moving Piwigo.

Ok, thank you.

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact