Thanks for all your help!
Ted Byrne <[EMAIL PROTECTED]> wrote:
I'm by no means an expert on this, but some things you might want to
consider...
An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use
mysql
I'm by no means an expert on this, but some things you might want to
consider...
An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use
mysqldump on the 64-bit system and specify the 32-bit host using the
Thanks Eric.
But our data is very big(about 400G), server don't have enough disk space and it will
take long time to finish the dump.
It may cause problem to floats if just copy data files to a 64 bit system?
--Alex
Eric Bergen <[EMAIL PROTECTED]> wrote:
The safest thing you can do to protec
Hi,
Thank you backup is working fine. Any one can help me how to restore the back up
database?. Not at table level. At the database level. How to run a sql file from mysql
prompt?. While restoring any more things to be taken care, regarding database?.
Thanks,
NARasimha
-
The safest thing you can do to protect floats and the like is to use
mysqldump to dump them to a .sql on the 32 bit system then import them
again on the 64 bit system.
-Eric
On Mon, 4 Oct 2004 16:38:13 -0700 (PDT), alex ye <[EMAIL PROTECTED]> wrote:
> Does anyone has the experience on migrating
Anyone have experience with installing the Dyna III electronic ignition?
I put it on my R80/7, but since it wasn't running before I did the install, and it's
not running now, I'm not sure if I installed it correctly or not.
But, after I did the install, I tried to do the static timing as per
It's a great server (the DL760 G2). They really opened up the bus and the
Xeon 3.0 is superfast.
"darren" <[EMAIL PROTECTED]>
10/03/2004 07:51 PM
To: [EMAIL PROTECTED]
cc:
Subject:[OT] HP DL760G2 vs Opteron for large DB on Linux
Hi all,
I am looking
Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit
system?
Can data files(from 32bit system) be readed properly by mysql server after copy to a
64bit system?
Thank you in advance!
--Alex
__
Do You Yahoo!?
Tired
Thanks!
-Original Message-
From: Kyle Kirkland [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 3:15 PM
To: OMalley, Brent
Cc: [EMAIL PROTECTED]
Subject: Re: Real Basic Question
Mysql> \P less
PAGER set to less
Mysql> show tables;
You can see other cool flags by typing 'help;'
Mysql> \P less
PAGER set to less
Mysql> show tables;
You can see other cool flags by typing 'help;' at the mysql prompt.
On Mon, 4 Oct 2004 14:58:29 -0700, OMalley, Brent
<[EMAIL PROTECTED]> wrote:
> I am a beginner, so forgive me.
>
> From mysql if I type:
>
> Mysql>show tables;
>
> The resu
I am a beginner, so forgive me.
>From mysql if I type:
Mysql>show tables;
The result scrolls to the last lines and then the prompt again. Is
there an argument or a variable I can set that will act like 'more' or
'less' in unix? I want it to stop scolling so I can walk through the
results.
At 04:05 PM 10/4/2004, [EMAIL PROTECTED] wrote:
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
Thanks for the quick response. It's somewhat gratifying to hear that I'm
not alone in my confusion...
Ted
--
A heads-up and a call for advice for anyone compiling from source on
Linux amd64:
The latest Debian amd64 "unstable" upgrade of libc6-dev to version
2.3.2.ds1-17 broke compiling MySQL 4.0.21 from source using gcc-3.4.
(Also breaks similarly with the default gcc for this platform,
gcc-3.3.4.)
Spec
If you aren't tired of this problem, I have one more question...
The last query worked well, except one small detail...
SELECT user, refurl, max( entry ) AS most_recent, count( user ) AS visits
FROM userlog
WHERE user != ''
GROUP BY user
ORDER BY most_recent DESC
LIMIT 10
I am now includi
Thanks for the suggestions over the weekend! I will be looking in to
this in a few days - for now I think I am just going to have to re-write
my PHP script to make 2 separate queries and array_merge() them - which
invariably seems to solve "OR" problems. But there should be a better
way, no?
-Da
Hi,
I have a process that relies on three tables. There is a "Process"
table, a Process_description table and a third table that holds some
display decoration hints that depend on the perceived nature of each
process.
The decoration table is static. It looks like
decoration
{
severity_level
>Is there a version or a product available for LINUX?
>
>On Tue, 28 Sep 2004 13:55:19 -0500, Tim Hayes <[EMAIL PROTECTED]> wrote:
>> ari
>>
>> MYdbAL which you can download at www.it-map.com is completely FREE and
>> includes data modeling, DDL generation or whatever you need to create your
>> MYS
Tables are tied together by whichever field(s) you use to store their
"parent"'s reference.
For one second, imagine I am writing an inventory control program for
somebody like Wal-Mart or Target. Those businesses have so many locations
that they are divided into regions, each region will have
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
UPDATE dp_populate_vals
INNER JOIN dp_populate_tables
ON dp_populate_tables.tgt_tbl=dp_populate_
> I'm trying to update existing records in one table so that value of a
> column winds up matching the value of a column in a second table, based on
> a match in a second column in each table.
>
> I'm not sure if I'm taking the wrong approach on this, of if I'm missing
> something simple in the SQL
I've worked through some of this but still would like
some opinions. Maybe it's not clear but I haven't
received any responses.
Basically to tie the records together I will use the
recordID (auto incrementing) in every table where the
records are written.
Then I can grab everything out of tha
Greetings,
I'm trying to update existing records in one table so that value of a
column winds up matching the value of a column in a second table, based on
a match in a second column in each table.
I'm not sure if I'm taking the wrong approach on this, of if I'm missing
something simple in the
I agree with keeping only dates or nulls in a date-type column. One other
option, you could use a NULL value for ModifyDate with the COALESCE()
function like this
SELECT, COALESCE(ModifyDate, CreationDate) as recordDate
FROM ...
WHERE ...
ORDER BY recordDate
if ModifyDate is not null, that
> > I suppose these are the ways with Databases. They don't work the way
> > we like them to.
> > So please adjust with it. For this matter I think, any RDBMS will be
> > doing their or paddings to the scripts when they are loading it in
> > memories.
>
> But that doesn't make it right.
>
> Specif
On Tue, 5 Oct 2004 00:27:45 +0530, Eldo Skaria wrote:
>
> I suppose these are the ways with Databases. They don't work the way
> we like them to.
> So please adjust with it. For this matter I think, any RDBMS will be
> doing their or paddings to the scripts when they are loading it in
> memories.
Hi Khan,
I would klike to approach ur problem in a diffrent manner.
My suggestion is that, in both the date fields u use dates only. (I
don't know the useabilty of '0' in a date field). While using this, u
have to store the creation time a the modification time, at the
creation of record. This is t
Hello Eldo,
> I suppose these are the ways with Databases. They don't work the way
> we like them to.
> So please adjust with it. For this matter I think, any RDBMS will be
> doing their or paddings to the scripts when they are loading it in
> memories.
> just the same way for oracle(where i have
Hai Martin,
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some (in)exp
On Mon, 4 Oct 2004 22:10:39 +0530, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> mysqlhotocpy supports only Linux and Netware software. Will it support windows
> operating system. Please clarify.
I have heard of people using Perl on windows, so I would guess it will
run, mysqlhotcopy being a Per
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with "\" (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
""Jay Blanchard"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
[snip]
What'
On Mon, 4 Oct 2004 [EMAIL PROTECTED] wrote:
Hi,
Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
backup. Please suggest.
Thanks,
Narasimha
Hi Narasimha,
when posting a question to a mailing list, please don't
ask it many times, or the users might say "hey, thi
mysqlhotocpy supports only Linux and Netware software. Will it support windows
operating system. Please clarify.
Thanks,
Narasimha
-Original Message-
From: Greg Donald [mailto:[EMAIL PROTECTED]
Sent: Mon 10/4/2004 10:06 PM
To: [EMAIL PROTECTED]
On Mon, 4 Oct 2004 21:55:58 +0530, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
> backup. Please suggest.
Have you looked at mysqlhotcopy ?
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
--
Greg Donald
Zend Certi
Hi,
Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
backup. Please suggest.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive use
When you don't have subselects, you have two options: temporary tables or
JOINed queries.In your case, I think the temporary table is the better way
to go.
I would also eliminate the ABS() check so that I can compare values
directly against the index. I know the math is correct your way but th
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*.*' and page_body not regexp '.*.*';
bob
==
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING III
MA, Management of Informati
Gerald Taylor wrote:
Query optimization question
I am selecting from a single table but it has a lot of rows and it
has a very involved calculation. What I really want to do is
is FIRST restrict the number of rows so that the big calculation is only
performed on the ones that are within 3 degr
Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select "\"
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'"\"' at line 1
select "/"
returns "/"
select "\\"
returns "\"
Camilla Brodén wrote:
Hi!
I am trying to do an inner join of two tables using a char(3) key. The field I am
joining by contains integers with sometimes leading zeros.
If it is a char(3) field it contains characters, not integers.
The inner join works when the field is a full 3 character field, wi
At 11:35 -0400 10/4/04, Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select "\"
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'"\"' at line 1
select "/"
returns "/"
s
[snip]
What's the deal w/ backslash?
[/snip]
It is an escape character. In order to get things with backslashes, as
you have deduced, you
SELECT "\\"
Do you have a column '\'? If so, why?
Backslashes are often used in this way...
SELECT businessName FROM table WHERE businessName = 'Doc\'s';
Query optimization question
I am selecting from a single table but it has a lot of rows and it has
a very involved calculation. What I really want to do is
is FIRST restrict the number of rows so that the big calculation is only
performed on the ones that are within 3 degrees.
Using 4.0.20
A s
Why does selecting backslash give me an error?
select "\"
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'"\"' at line 1
select "/"
returns "/"
select "\\"
returns "\"
What's the
Hi!
I am trying to do an inner join of two tables using a char(3) key. The field I am
joining by contains integers with sometimes leading zeros. The inner join works when
the field is a full 3 character field, with for example 566, but when it starts with
a 0, it does not work anymore. Why is t
I would be very surprised if this query fails as you say it does.
select user, max(time) as most_recent, count(user) as visits
from userlog where user!=''
group by user
order by most_recent desc
limit 10;
This represents the last 10 users to sign in, when they signed in last,
and many times the
Thank you for the answer! However, it doesn't seem to solve my problem. Running the
query
without modifications repeated users (because of the "group by user, HOST"). I removed
the
HOST, and ran the query over again. Now it returned unique users, but it still didn't
return
the LAST login of t
I think what will work for your case is the CONCAT() function
(http://dev.mysql.com/doc/mysql/en/String_functions.html). It will return
NULL if any field in it is null.
SELECT *
FROM qa
WHERE concat(field1, field2, field3,..., fieldn) is null
It won't break any speed records but it will find ea
I'm trying to find a null value anywhere in QA table.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 9:46 AM
To: Scott Hamm
Cc: [EMAIL PROTECTED]
Subject: Re: Looking for null values.
Are you just looking for any column is null or tha
Are you just looking for any column is null or that all columns are null
or that specific columns are null or . what exactly do you need to
determine?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Scott Hamm <[EMAIL PROTECTED]> wrote on 10/02/2004 11:21:58 AM:
> How d
Thank you very much. One more question i.e Is there any command to take the
Backup in MySQL 4.0 (windows) classic which does not support innodb.
I know 2 commands like mysqldump and mysqlhotcopy. mysqlhotcopy seems to
support myism but only in linux and netwa
You will need the RLIKE comparator.
http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
http://dev.mysql.com/doc/mysql/en/Regexp.html
I haven't tested this but this is pretty close to what you will need
WHERE page_body RLIKE '' and page_body not RLIKE ''
you will have to experime
Whenever you get an INNODB error, you can get more details by running a
SHOW INNODB STATUS.
A foreign key means that a value must exist in one table before it can be
used as a value in another table. That's probably why you couldn't add a
record to Table2 before you had a value in Table1. The c
On Monday 04 October 2004 01:18 am, Batara Kesuma wrote:
> I have a cron running this every night.
> DELETE message_inbox FROM message_inbox LEFT JOIN message ON message.id
> = message_inbox.message_id WHERE message.id IS NULL
>
> Message table also has about the same amount of rows.
>
> I notice t
What you are looking for is the MAX() of the Time column (most recent
entry)
select user, host, max(time) as time, count(user) as visits
from userlog where user!=''
group by user, host
order by time desc
limit 10;
The issue you ran into is caused by an non-standard SQL extension created
by MyS
Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
minimu
Hi,
I use MySql version 4.0.18.
We do a lot of bulk inserts and there is no need for transaction integrity.
Currently the isolation level of the database is REPEATABLE-READ.
Iam planning to change that to READ UNCOMMITTED as I dont have any
transactions.
Will this improve DB performance ?
Is ther
On Mon, 4 Oct 2004 11:03:13 +0200, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hello,
>
> > I have two date fields (1095689105) in mysql. One is Creation date and
> > other is Modify date. If news is not modified its value is 0. How can I
> > sort my news so modify date is more important (if exist
Hello,
> I have two date fields (1095689105) in mysql. One is Creation date and
> other is Modify date. If news is not modified its value is 0. How can I
> sort my news so modify date is more important (if exists) than creation
> date?
What about an ORDER BY with a CASE statement that uses
the Cr
Hello,
I have two date fields (1095689105) in mysql. One is Creation date and
other is Modify date. If news is not modified its value is 0. How can I
sort my news so modify date is more important (if exists) than creation
date?
TNX
--
MySQL General Mailing List
For list archives: http://lists.
59 matches
Mail list logo
