<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:"Ubuntu Medium";}
@font-face
{font-family:"Ubuntu Light";}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;}
span.v1w
{mso-style-name:v1w;}
p.v1v1msonormal1, li.v1v1msonormal1, div.v1v1msonormal1
{mso-style-name:v1v1msonormal1;
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="DE" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US">Hallo Gaby,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US">nur zur Ergänzung, es gibt auch Möglichkeiten, aus MySQL bzw. einem Dump aus MySQL direkt in Postgres zu importieren/konvertieren, s.
<a href="https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL">
PostgreSQL-Wiki</a>. Beispielsweise mit dem Tool „pgloader“, welches sich laut <a href="https://github.com/dimitri/pgloader">
Github-Repo</a> offenbar leicht installieren und nutzen lässt. Dabei handelt es sich natürlich meist um Third-Party-Tools und man sollte wissen, was man tut.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US">Eine weitere Möglichkeit wäre, die neue Postgres-DB komplett anhand der Mapbender-Doku einzurichten und die Daten aus dem alten System in das neue
zu übertragen. Das setzt natürlich voraus, dass für beide Datenbanken (MySQL und PostgreSQL) je eine Mapbender-Instanz betrieben werden kann und die zu übertragende Datenmenge überschaubar ist.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;mso-fareast-language:EN-US">Ansonsten kann man den von Astrid beschriebenen Weg gehen.<o:p></o:p></span></p>
<div>
<p><span style="font-size:11.0pt;font-family:"Arial",sans-serif">Viele Grüße,</span><span style="font-size:11.0pt;font-family:"Arial",sans-serif"><br>
</span><span style="font-size:11.0pt;font-family:"Arial",sans-serif">Connor<b> </b>Härtel</span><span style="font-size:8.0pt;font-family:"Arial",sans-serif;color:#646363;background:white"> </span><o:p></o:p></p>
</div>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">Von:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Mapbender_users <mapbender_users-bounces@lists.osgeo.org>
<b>Im Auftrag von </b>Astrid Emde (WhereGroup GmbH) via Mapbender_users<br>
<b>Gesendet:</b> Mittwoch, 18. Februar 2026 13:44<br>
<b>An:</b> Mapbender User List <mapbender_users@lists.osgeo.org><br>
<b>Cc:</b> Astrid Emde (WhereGroup GmbH) <astrid.emde@wheregroup.com><br>
<b>Betreff:</b> Re: [Mapbender-users] Umstieg von MySQL auf postgres<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#FFB900;padding:5.0pt 2.0pt 5.0pt 2.0pt"></td>
<td width="100%" style="width:100.0%;background:#FFF8E5;padding:5.0pt 4.0pt 5.0pt 12.0pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<b><span style="color:#222222">Sicherheitshinweis:</span></b><span style="color:#222222"> Diese E-Mail kommt von einem Absender außerhalb der ITEBO Unternehmensgruppe. Klicken Sie nur auf Links oder Dateianhänge, wenn Sie den Absender für vertrauenswürdig halten.
<o:p></o:p></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<div>
<div>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Hallo Gaby,<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">du baust die Struktur in PostgreSQL am besten auf via <o:p></o:p></span></p>
<pre id="v1codecell13">bin/console<span class="v1w"> </span>doctrine:schema:create<o:p></o:p></pre>
<pre style="margin-bottom:12.0pt"><br>siehe <a href="https://doc.mapbender.org/de/installation/installation_ubuntu.html#mapbender-einrichtung-auf-postgresql" target="_blank">https://doc.mapbender.org/de/installation/installation_ubuntu.html#mapbender-einrichtung-auf-postgresql</a><o:p></o:p></pre>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Dann spielst du nur die Daten aus MYSQL aus (ohne Tabellenstruktur) und überträgst sie nach PostgreSQL.<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Viele Grüße Astrid<o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<p id="v1reply-intro"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">Am 2026-02-18 11:54, schrieb Bender, Gaby via Mapbender_users:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 5.0pt;margin-left:0cm;margin-right:0cm">
<div id="v1replybody1">
<div>
<p class="v1v1msonormal1">Guten Tag,<o:p></o:p></p>
<p class="v1v1msonormal1">wir möchten von einer MySQL Sammelinstanz auf postgres umsteigen.
<br>
Unser Problem liegt nun bei der Übernahme der Daten aus der MySQL Instanz in die unter Linux laufende Postgres DB.<br>
Kann hier jemand helfen?<o:p></o:p></p>
<p class="v1v1msonormal1"> <o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Mit freundlichen Grüßen
</span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Gaby Bender</span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:DE"> </span><o:p></o:p></p>
<p class="v1v1msonormal1" style="margin-bottom:12.0pt;text-autospace:none"><span style="color:#1F497D;mso-fareast-language:DE"><a href="https://teamnet.lvr.de/pages/viewpage.action?pageId=20779395" target="_blank"><span style="color:#0563C1">Kultur und Straßenbau</span></a></span><o:p></o:p></p>
<p class="v1v1msonormal1"><strong><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">LVR-InfoKom</span></strong><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Hermann-Pünder-Str. 1, 50679 Köln</span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE"> </span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Tel 0221 809-2146
</span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;mso-fareast-language:DE">Mobil 0174 6168653
</span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:DE"><a href="mailto:gaby.bender@lvr.de"><span style="color:#0563C1">gaby.bender@lvr.de</span></a></span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="color:#1F497D;mso-fareast-language:DE"> </span><o:p></o:p></p>
<p class="v1v1msonormal1"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#0563C1;mso-fareast-language:DE">infokom.lvr.de</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D;mso-fareast-language:DE"><br>
<a href="http://www.lvr.de/" target="_blank"><span style="color:#005EA8">www.lvr.de</span></a></span><o:p></o:p></p>
<p class="v1v1msonormal1"> <o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif">_______________________________________________<br>
Mapbender_users mailing list<br>
<a href="mailto:Mapbender_users@lists.osgeo.org">Mapbender_users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a><o:p></o:p></span></p>
</div>
</blockquote>
<p><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<div id="v1_rc_sig">
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellpadding="0">
<tbody>
<tr style="height:27.75pt">
<td width="192" valign="top" style="width:144.0pt;padding:.75pt 4.5pt .75pt .75pt;height:27.75pt">
<p style="margin:0cm"><span style="font-size:9.0pt;font-family:"Ubuntu Medium",sans-serif;color:black">Mit freundlichen Grüßen<o:p></o:p></span></p>
<p style="margin:0cm"><span style="font-size:9.0pt;font-family:"Ubuntu Medium",sans-serif;color:black"> <o:p></o:p></span></p>
<p style="margin:0cm"><span style="font-size:9.0pt;font-family:"Ubuntu Medium",sans-serif;color:black">Astrid Emde<o:p></o:p></span></p>
<p style="margin:0cm"><span style="font-size:8.0pt;font-family:"Ubuntu Light",sans-serif;color:black">GIS-Consultant<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:29.25pt">
<td width="192" style="width:144.0pt;padding:0cm 0cm 0cm 0cm;height:29.25pt;overflow:visible">
<div>
<p class="MsoNormal"><span style="color:black"><img border="0" width="300" height="60" style="width:3.125in;height:.625in" id="Bild_x0020_1" src="cid:image003.png@01DCA0DF.692780E0"></span><span style="color:black"><o:p></o:p></span></p>
</div>
</td>
</tr>
<tr style="height:48.75pt">
<td width="192" style="width:144.0pt;padding:4.5pt 4.5pt 4.5pt 0cm;height:48.75pt">
<p style="margin:0cm"><span style="font-size:8.0pt;font-family:"Ubuntu Light",sans-serif;color:#747577"><br>
WhereGroup GmbH<br>
Eifelstraße 7<br>
53119 Bonn<br>
Germany<br>
<br>
Tel: +49 (0)228 / 90 90 38 - 22<br>
<br>
<a href="mailto:astrid.emde@wheregroup.com">astrid.emde@wheregroup.com</a><br>
<a href="http://www.wheregroup.com">www.wheregroup.com</a><br>
<br>
Geschäftsführer:<br>
Olaf Knopp, Peter Stamm<br>
Amtsgericht Bonn, HRB 9885<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>