🌍
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 2010-05-04 00:06:33
- duke
- Translation Team
- Vienna
- 2009-10-19
- 20
2.1.0RC3 upgrade testing feedback + db migration task
hi,
i did an update test of my prod gallery and it worked like a charm :)
now, i'd like to switch database from mysql to pgsql during the upgrade.
to do this, i have to convert the mysql to a pgsql dump.
do you already have a script for this purpose?
if not, can you give me some hints for possible pitfalls i have to take care of?
any help before i attempt the migration is very welcome :)
tia,
duke.
Offline
#2 2010-05-04 00:23:43
- plg
- Piwigo Team
- Nantes, France, Europe
- 2002-04-05
- 13791
Re: 2.1.0RC3 upgrade testing feedback + db migration task
Hi duke,
Nice to hear this feedback. I think 5 or 6 complete migrations have been reported and all of them are working "like a charm". (so that means many more silent beta testers)
There is absolutely no automatic procedure to convert from MySQL to PostgreSQL or SQLite. I've been working at Talend for 3.5 years and database engine conversion was one of the main task Talend Open Studio does. Later this year, I think I will work on this issue (I'm mainly interested in MySQL to/from SQLite conversion).
Offline
#3 2010-05-05 10:24:19
- nicolas
- Former Piwigo Team
- 2004-12-30
- 1232
Re: 2.1.0RC3 upgrade testing feedback + db migration task
duke wrote:
now, i'd like to switch database from mysql to pgsql during the upgrade.
to do this, i have to convert the mysql to a pgsql dump.
do you already have a script for this purpose?
if not, can you give me some hints for possible pitfalls i have to take care of?
any help before i attempt the migration is very welcome :)
I think it's not difficult. I made migration during database abstraction developement.
I can watch on a minimal migration script but anyway the idea is to upgrade from latest piwigo version, dump the datas (without structure) from mysql, create the postgres database (new installation) and import datas into postgres.
Same process for SQLite
Last edited by nicolas (2010-05-05 10:24:42)
Offline
#4 2010-05-05 18:53:17
- duke
- Translation Team
- Vienna
- 2009-10-19
- 20
Re: 2.1.0RC3 upgrade testing feedback + db migration task
yeah, i thought so as well. manual it is.
migration of phpBB from mysql to pgsql was a hassle, but a quick look
at piwigo's pgsql structure suggests a migration without headache :)
bye,
duke.
Offline
#5 2010-05-05 20:27:20
- nicolas
- Former Piwigo Team
- 2004-12-30
- 1232
Re: 2.1.0RC3 upgrade testing feedback + db migration task
duke wrote:
yeah, i thought so as well. manual it is.
migration of phpBB from mysql to pgsql was a hassle, but a quick look
at piwigo's pgsql structure suggests a migration without headache :)
bye,
duke.
If you can wait a little I can write a minimal migration script.
Offline
#6 2010-05-05 22:26:26
- duke
- Translation Team
- Vienna
- 2009-10-19
- 20
Re: 2.1.0RC3 upgrade testing feedback + db migration task
nicolas wrote:
If you can wait a little I can write a minimal migration script.
sure, that would be great.
i won't upgrade before 2.1 final anyway ;-)
Offline
#7 2010-05-05 22:49:36
- nicolas
- Former Piwigo Team
- 2004-12-30
- 1232
Re: 2.1.0RC3 upgrade testing feedback + db migration task
duke wrote:
nicolas wrote:
If you can wait a little I can write a minimal migration script.
sure, that would be great.
i won't upgrade before 2.1 final anyway ;-)
Ok. I will post here when I write a first version.
Offline
Notice: Undefined offset: 394 in /var/www/piwigo.org/forum/include/parser.php on line 509
Notice: Undefined offset: 394 in /var/www/piwigo.org/forum/include/parser.php on line 510
#8 2010-05-18 13:00:43
- nicolas
- Former Piwigo Team
- 2004-12-30
- 1232
Re: 2.1.0RC3 upgrade testing feedback + db migration task
I made a first release for a plugin to migrate from Mysql to others databses (SQLite or PostgreSQL).
I open a discussion on the forum : [Forum, topic 15955] Database migration
The plugin is available : [extension by ]
Edit
Update link
Last edited by ddtddt (2010-05-18 13:09:36)
Offline
#9 2010-05-19 22:49:49
- duke
- Translation Team
- Vienna
- 2009-10-19
- 20
Re: 2.1.0RC3 upgrade testing feedback + db migration task
awesome :)
i'll upgrade piwigo this weekend and will migrate to postgres with your plugin.
thx alot mate!
Last edited by duke (2010-05-19 22:50:00)
Offline
#10 2010-05-19 23:13:07
- nicolas
- Former Piwigo Team
- 2004-12-30
- 1232
Re: 2.1.0RC3 upgrade testing feedback + db migration task
duke wrote:
awesome :)
i'll upgrade piwigo this weekend and will migrate to postgres with your plugin.
thx alot mate!
Don't hesitate to tell me if you encounter any problem. Post on the dedicated topic will be easier to follow : [Forum, topic 15955] Database migration
Last edited by nicolas (2010-05-19 23:13:34)
Offline