<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /></head><body style='font-size: 10pt; font-family: Verdana,Geneva,sans-serif'>
<div style="font-size: 10pt; font-family: Verdana,Geneva,sans-serif;">
<p>Hallo Gaby,</p>
<p>du baust die Struktur in PostgreSQL am besten auf via </p>
<pre id="v1codecell13">bin/console<span class="v1w"> </span>doctrine:schema:create</pre>
<pre><br />siehe <a href="https://doc.mapbender.org/de/installation/installation_ubuntu.html#mapbender-einrichtung-auf-postgresql" target="_blank" rel="noopener noreferrer">https://doc.mapbender.org/de/installation/installation_ubuntu.html#mapbender-einrichtung-auf-postgresql</a><br /><br /></pre>
<p>Dann spielst du nur die Daten aus MYSQL aus (ohne Tabellenstruktur) und überträgst sie nach PostgreSQL.</p>
<p>Viele Grüße Astrid</p>
<p><br /></p>
<p id="v1reply-intro">Am 2026-02-18 11:54, schrieb Bender, Gaby via Mapbender_users:</p>
<blockquote type="cite" style="padding: 0 0.4em; border-left: #1010ff 2px solid; margin: 0">
<style type="text/css">@font-face
{ font-family: "Cambria Math"; }
@font-face
{ font-family: Calibri; }
#v1replybody1 p.v1v1MsoNormal, #v1replybody1 li.v1v1MsoNormal, #v1replybody1 div.v1v1MsoNormal
{ margin: 0cm; font-size: 11.0pt; font-family: "Calibri",sans-serif; mso-fareast-language: EN-US; }
#v1replybody1 .v1v1MsoChpDefault
{ mso-style-type: export-only; font-family: "Calibri",sans-serif; mso-fareast-language: EN-US; }
@page WordSection1
{ size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 2.0cm 70.85pt; }
#v1replybody1 div.v1v1WordSection1
{}</style>
<div id="v1replybody1" lang="DE" style="word-wrap: break-word;">
<div class="v1v1WordSection1">
<p class="v1v1MsoNormal">Guten Tag,</p>
<p class="v1v1MsoNormal">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?</p>
<p class="v1v1MsoNormal"> </p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">Mit freundlichen Grüßen </span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">Gaby Bender</span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; color: #1f497d; mso-fareast-language: DE;"> </span></p>
<p class="v1v1MsoNormal" 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" rel="noopener noreferrer"><span style="color: #0563c1;">Kultur und Straßenbau</span></a></span><span style="color: #1f497d; mso-fareast-language: DE;"></span></p>
<p class="v1v1MsoNormal"><strong><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">LVR-InfoKom</span></strong><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif;"></span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">Hermann-Pünder-Str. 1, 50679 Köln</span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;"> </span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">Tel 0221 809-2146 </span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; mso-fareast-language: DE;">Mobil 0174 6168653 </span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; color: #1f497d; mso-fareast-language: DE;"><a href="mailto:gaby.bender@lvr.de" rel="noreferrer"><span style="color: #0563c1;">gaby.bender@lvr.de</span></a></span><span style="color: #0563c1; mso-fareast-language: DE;"></span></p>
<p class="v1v1MsoNormal"><span style="color: #1f497d; mso-fareast-language: DE;"> </span></p>
<p class="v1v1MsoNormal"><span style="font-size: 10.0pt; font-family: 'Arial',sans-serif; color: #1f497d; mso-fareast-language: DE;"><a><span style="color: #0563c1;">infokom.lvr.de</span></a><br /><a href="http://www.lvr.de/" target="_blank" rel="noopener noreferrer"><span style="color: #005ea8;">www.lvr.de</span></a></span><span style="mso-fareast-language: DE;"></span></p>
<p class="v1v1MsoNormal"> </p>
</div>
</div>
<br />
<div class="v1pre">_______________________________________________<br />Mapbender_users mailing list<br /><a href="mailto:Mapbender_users@lists.osgeo.org" rel="noreferrer">Mapbender_users@lists.osgeo.org</a><br /><a href="https://lists.osgeo.org/mailman/listinfo/mapbender_users" target="_blank" rel="noopener noreferrer">https://lists.osgeo.org/mailman/listinfo/mapbender_users</a></div>
</blockquote>
<p><br /></p>
<div id="v1_rc_sig">
<div><br />
<table style="direction: ltr; color: #000000;">
<tbody>
<tr>
<td style="padding-right: 4.5pt; vertical-align: top; width: 192px; height: 37px;">
<p style="margin: 0; font-family: 'Ubuntu Medium', Ubuntu, sans-serif; font-size: 9pt; color: black; font-weight: 500;">Mit freundlichen Grüßen</p>
<p style="margin: 0; font-family: 'Ubuntu Medium', Ubuntu, sans-serif; font-size: 9pt; color: black; font-weight: 500;"> </p>
<p style="margin: 0; font-family: 'Ubuntu Medium', Ubuntu, sans-serif; font-size: 9pt; color: black; font-weight: 500;">Astrid Emde</p>
<p style="margin: 0; font-family: 'Ubuntu Light', Ubuntu, sans-serif; font-weight: 300; font-size: 8pt; color: black;">GIS-Consultant</p>
</td>
</tr>
<tr>
<td style="width: 192px; height: 39px; text-align: left; padding: 0; margin: 0; overflow: visible;">
<div style="width: 140%; height: 140%;"><img src="cid:17714186426995b4128edfa227399082@wheregroup.com" width="300" height="60" /></div>
</td>
</tr>
<tr>
<td style="padding: 4.5pt 4.5pt 4.5pt 0; width: 192px; height: 65px;">
<p style="margin: 0; font-family: 'Ubuntu Light', Ubuntu, sans-serif; font-size: 8pt; 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 />astrid.emde@wheregroup.com<br />www.wheregroup.com<br /><br />Geschäftsführer:<br />Olaf Knopp, Peter Stamm<br />Amtsgericht Bonn, HRB 9885</p>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</body></html>