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.

BerlinBrown wrote:
> 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.

Why are you asking us whether it is covered in the docs. In the time it took
for you to type this, you could have searched the MySQL Manual for the word
postgres and found the answer for yourself.