Announcement

#1 2020-06-26 18:19:22

guzmanldn
Member
2020-06-26
3

database migration

Hello

Can you explain how to do a database migration ?

I need to move all the content from a hosting to another one. So I need to repeat the installation of Piwigo of course, but about the content (images, albums, etc) how to move / migrate all the stuff from web hosting A to web hosting B ?

Please let me know asap it is important and urgent, thank you

guzmanldn


Piwigo version: latest
PHP version: latest
MySQL version: latest

Offline

 

#2 2020-06-26 20:00:37

executive
Member
2017-08-16
1099

Re: database migration

move files
move database
update database config file

for more details, search the forum.

Offline

 

#3 2020-06-26 20:23:54

guzmanldn
Member
2020-06-26
3

Re: database migration

thanks for the reply.

so the solution is internal, inside Piwigo ?

or do I need to manage from hosting side ? I mean SQLdatabase ?

please let me know, thank you

Offline

 

#4 2020-06-28 02:14:07

kc27
Member
2014-02-25
75

Re: database migration

Many web hosts included free website migration. I recently moved a Piwigo gallery. In my case, both hosts included CPanel hosting. I made a backup of the site in CPanel, then provided the backup file to the new host's support team, who then loaded it on to their server.

Offline

 

#5 2020-06-28 11:07:10

erAck
Only trying to help
2015-09-06
1138

Re: database migration

guzmanldn wrote:

so the solution is internal, inside Piwigo ?

No.

You
1. backup your entire Piwigo folder (you may exclude the _data/ subdirectory as cached templates and thumbnails will be recreated)
2. dump the database using phpMyAdmin or Adminer or whatever database tool your hoster provides
3. recreate the database on the new server from that dump, again using one of those tools
4. recreate the Piwigo installation and file data from the backup
5. edit local/config/database.inc.php to adapt the $conf['db_...'] variables' values to the new reality

Depending on your new hoster's setup (as which user/group the web server runs) you may have to change permissions on all Piwigo's subdirectories from 755 to 775 and on files from 644 to 664.

If any of those sound like mumbo-jumbo to you then ask your hosting provider(s) for help.


Running Piwigo at https://erack.net/gallery/

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2021 · Contact