While I haven't tested this, you might try something like...
mysqldump -h host -u userid -p database | mysql -h newhost -u
new_userid -p database
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
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.
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
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 server -u user -p database
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
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 chrishallgren;
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
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
starting with record 1932 (part I need help with)
order by id limit 10;
which should give me records 1932 -
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,
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
10 matches
Mail list logo