Shawn,
Many thanks for your very informative reply. It seems my server host will
not allow remote direct access to the databases; access is only by using
the cPanel software, which also gives access to a web interface of
something called phpMyAdmin which works just about ok for very basic
Hi,
I'm setting up MySQL databases on 'shared server' space I've rented using
cPanel's 'MySQL Database' interface. I can add 'access hosts' (it's not
limited to localhost) and it says the % wildcard is allowed. Forgive me if
this is a trivial or annoying question (I can't find the answer
Matthew Stanfield wrote:
I'm setting up MySQL databases on 'shared server' space I've rented
using cPanel's 'MySQL Database' interface. I can add 'access hosts'
(it's not limited to localhost) and it says the % wildcard is allowed.
Forgive me if this is a trivial or annoying question (I can't
Jerry Apfelbaum wrote:
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
Jerry -- See what I meant when I said:
very active mailing lists where list subscribers are helpful and quick to
respond.
I think we all deserve a
Chris Nolan wrote:
Regarding mysqldump, it handles binary data through escaping the
required characters. pg_dump is similar if memory serves me correctly.
Thanks Chris.
So dumping binary data / large objects using myslqdump is fine. I looked up
if this is ok with pg_dump as well and it is but
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a single-bit
field.
Regards,
Chris
Sure --
Hi,
I've used both PostgreSQL and MySQL on a Linux server and found both
setting up (using RPM) and maintaining them very easy (MySQL was slightly
easier to set up but I set it up after I was already proficient on
PostgreSQL, so perhaps comparing the ease of setup is unfair). Both are
well
Is there a simple way of copying a postgres database to MySQL? I was
hoping that postgres's backup 'pg_dump' utility (which dumps a
database into a text file in such a format that it can be easily
recreated) might be compatible with MySQL's backup and restore
facilities.
Zenzo wrote:
i
Hi,
I've been using postgres for a while but have today taken the plunge and
installed MySQL 4.0.16 on my Linux box. It's all now working perfectly.
Is there a simple way of copying a postgres database to MySQL? I was hoping
that postgres's backup 'pg_dump' utility (which dumps a database into