Migrating from Mongo to MySQL

[Tim Owens]

I suspect I know the answer to this but has anyone migrated an install from MongoDB to MySQL as the datastore? I'm thinking I may have to do a Known export and import to a clean install to make it work but wondered if there was another method I should look at or any "gotchas" I should be aware of.

-----

Tim Owens

[Ben Werdmüller]

Right now the export / import to clean install is the best way to do this, unfortunately. I'm looking to do this myself (werd.io is MongoDB, but I'd like it to be MySQL).

--
Known: https://withknown.com/
Documentation: http://docs.withknown.com/
Known stream: http://stream.withknown.com/
---
You received this message because you are subscribed to the Google Groups "Known Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to known-dev+unsubscribe@googlegroups.com.
To post to this group, send email to know...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/known-dev/CAPaV0RQSu%2B5wM5qYO8%2BE6hAPOGRjvN_RQ7E-Rbu686-ZWPUeDg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Tim Owens]

Got it, we'll give that a shot then. Thanks!

-----

Tim Owens

[Marcus Povey]

Yep, the migration plan, such as it is, is a fully robust import/export function.

As an aside, I'm 90% the way through porting mongo over to the more up to date MongoDB interface, so that it'll at least *build* in PHP7 and above...

[Tim Owens]

So I've got an export of a Known install but my import options are a WordPress XML and a Blogger XML. The export is a combination of uploads, json, and generated HTML. What am I supposed to be importing and how?

-----

Tim Owens

--

Known: https://withknown.com/
Documentation: http://docs.withknown.com/
Known stream: http://stream.withknown.com/
---
You received this message because you are subscribed to the Google Groups "Known Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to known-dev+unsubscribe@googlegroups.com.
To post to this group, send email to know...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/known-dev/833648ca-a45c-443b-8422-c8aa38d94093%40googlegroups.com.

[Tim Owens]

Just to confirm from looking at some past IRC chats and digging through this backup, there is no Known -> Known export/import option without a SQL dump (which isn't an option when moving from Mongo to MySQL)? If that's the case perhaps the wording on the export page needs to indicate that the export does *not* provide this ability as it currently says "You can then import these into other Known sites" and I see nothing that indicates that's possible.

-----

Tim Owens

[Kurtis Hanna]

Heyo Known Community,

I'd also like some clarification on this topic. If importing doesn't
currently exist, how far down the roadmap is it? Any chance we will see
it in the next update to Known Core, which I hear is being released
soonish? Should the language be changed in the mean time on the export page?

cPanel doesn't support MongoDB, so there doesn't seem to be a way to
migrate a Known website with MongoDB to a hosted server that uses
cPanel.
https://features.cpanel.net/topic/as-a-server-administrator-i-want-support-for-mongodb-or-couchdb-so-that-i-can-support-schema-free-databases

I have not explored migrating a MongoDB database to MariaDB MySQL much
yet. I'll check that out if import functionality is a current dead end
with Known.

In Solidarity,
Kurtis

Tim Owens:

>>> email to known-dev+...@googlegroups.com.

>>> To post to this group, send email to know...@googlegroups.com.
>>> To view this discussion on the web visit https://groups.google.com/d/ms
>>> gid/known-dev/833648ca-a45c-443b-8422-c8aa38d94093%40googlegroups.com

>>> <https://groups.google.com/d/msgid/known-dev/833648ca-a45c-443b-8422-c8aa38d94093%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .

[Marcus Povey]

Not speaking officially, but it is on the todo list.

Speaking for myself, I run Mongo, and would like to migrate to mysql, so
it's likely it'll get done in the fullness of time.

Known supports multiple concurrent engines, so it should be fairly easy
to write a script that dumps and imports at the object level everything
in the database, but I've not got round to writing it.

Additionally, I've written a PR that moves the existing mongo support
over to MongoDB (https://github.com/idno/Known/pull/1551), so that at
least there's a PHP 7 route for Mongo users. I encourage mongo folk to
kick the tires, standard caveats apply.

Meanwhile, pull requests welcome :)

Marcus

--
e: mar...@dushka.co.uk
w: https://www.marcus-povey.co.uk
t: @mapkyca