mysql vs postgresql -- is this list accurate?

[Robert P. J. Day]

  no, i don't want to start a flame war, i just want some feedback on
a current list of mysql drawbacks WRT postgresql.

  in the context of a fully open-source, java based ECM product, there
is a FAQ entry that summarizes why the developers would prefer their
users to use postgresql as opposed to mysql:

http://www.nuxeo.org/xwiki/bin/view/FAQ/WhyAvoidMySQL

  i'm not advocating one way or the other, i just want to make sure
that list is accurate and i'm not enough of an expert to be able to
judge the entire list.

  if anyone wants to tell me whether any of those entries are no
longer relevant, or are overblown, or whatever, i'd appreciate it.
again, i'm not taking sides, i just want to make sure the information
is as accurate as possible.  thanks.

rday

-- 


Robert P. J. Day   Waterloo, Ontario, CANADA

Top-notch, inexpensive online Linux/OSS/kernel courses
http://crashcourse.ca

Twitter:   http://twitter.com/rpjday
LinkedIn:   http://ca.linkedin.com/in/rpjday


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

might need some help recovering tables from trashed DB

[Robert P. J. Day]

  i asked about this once upon a time, and might need a little more
help here.  a friend's mysql hosting provider lost an entire DB, but
has managed to recover and hand over the ibdata1 file (or at least
some portion of it).

  when my friend popped into mysql, what he's seeing is that some of
the tables appear to be back, but others generate a does not exist
diagnostic.  by way of trying to help last time, i literally copied
the underlying mysql files onto my linux system, then fired up mysql
to see what magically appeared, but that was before i even had the
ibdata1 file so i wasn't surprised to get very little in the way of
recovered data.

  now, though, with this ibdata1 file, i can try that again -- fire up
a new linux box, and manually install the files under /var/lib/mysql.
i'm guessing i'll see much of what he's seeing.  i just want to verify
that, if that's all i have access to and some of the tables still
appear to be missing, there's not much i can do.  or is there?

rday

-- 


Robert P. J. Day   Waterloo, Ontario, CANADA

Top-notch, inexpensive online Linux/OSS/kernel courses
http://crashcourse.ca

Twitter:   http://twitter.com/rpjday
LinkedIn:   http://ca.linkedin.com/in/rpjday


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org