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
admin
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
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 anywher
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 deserv
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 -
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 yo
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 doc
> 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
