While I haven't tested this, you might try something like...
mysqldump -h -u -p | mysql -h -u
-p
or, share out and NFS mount the new system's partition to the old system
and do a dump that way.
Just a few thoughts,
Ron
Richard Idalski wrote:
>
> I have before me what seems to be
What kind of erroneous results? How is the personal_id field defined?
The statement you have is syntacically correct so it must be something
in the data. If the personal_id is a numeric ID and you're storing it
as characters, this will sort differently than if you're sorting by
number. Rememb
Is anyone using mySQL as an LDAP database backend? I'm looking into
using LDAP as a means to keep a user directory (employee id, name, phone
#, email, etc...). Unfortunately it seems that most of what I've found
recommend using Berkeley DB or Gnu's GDBM. I don't want yet another
database to le
convert everything to pennies and use integers?
Aaron Clausen wrote:
>
> I've been having some problems with currency calculations in SQL queries.
> I've been using Double, but often get some very small rounding errors. What
> is the recommended column type for currency in MySQL?
>
> Aaron
>
I've always used the following...
mysql -h -u -p
and it's worked pretty well for me.
Ron
[EMAIL PROTECTED] wrote:
>
> My goal is to be able to connect to the MySQL server on my web server from a local
>computer. I need to do this for something I'm developing for a client. When I
No, it's not normal. You managed to create your database with a space
in front. You'll probably have to delete and recreate the database.
Chris Hallgren wrote:
>
> ok here is my problem i have redhat 7 i installed mysql via the rpm and
> i get the following error
>
> mysql> select chrishallg
Actually, I have a message filter that looks for mysql.com in the "To or
CC" portion of the header and moves any mail to my mySQL folder. Thus I
can tell which messages are from mysql list members and which messages
are from my supervisors.
Still, it might be nice to add the [MYSQL] piece in the
Hello all again.
I think I need to be a little more specific in describing my problem.
So, let me try again. I have a database of scrap records. There are
currently over 2000 records in this database. I have a web page that
queries this database and displays the records in reverse order, newest
Hello all,
I have a database with a little over 2000 records. I want to be able to
construct a query that says something like this...
select id,lot_id,lot_type from scrap_table
(part I need help with)
order by id limit 10;
which should give me records 1932 - 1942 like this...
+-
Hi,
My first recommendation would be to download one of the GCC binaries and
use pkgadd to install the product. Go to...
http://www.sunfreeware.com/
and select your version of Solaris (2.6) from the menu on the upper
right side of the form. Then scroll through the lower right window
un
Hello all,
I have a procedure that queries my database and produces a line of
output for each query. It then processes the data and performs another
query. Everything works great interactively. I get the first
processing message, wait a bit, get the next processing message, etc...
However, wh
11 matches
Mail list logo
