🌍
English
Announcement
- [2024-04-17] Piwigo 14.4.0
- [2024-04-01] Piwigo in Hobbit runes
- [2024-03-01] Piwigo 14.3.0
- [2024-01-30] Piwigo 14.2.0
- [2023-12-29] Piwigo 14.1.0
#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
- 1214
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
- 77
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
- 2032
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/
Online