How to export database, in readable format? I couldn't really tell if this is covered or not. But when I export a
database, I always feel I can't import it into another database
engine. Eg. there are times when I just want the data. Not the
MySQL specific, innodb, whatever keywords.
My question; how can I export just the schema without mysql specific
extensions. Eg. I created the database using ansi sql. "create
table...", can I export with just that simple format.
Also, I would like to export the data such that I can import into
another db, postgres. etc, etc.
Is this covered in the docs. |