View Single Post
  #1 (permalink)  
Old 11-16-2007, 08:58 PM
BerlinBrown
 
Posts: n/a
Default 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.
Reply With Quote