I am running mySQL database version 3.23.58, but I'm using mySQL
Administrator 1.1.9 for scheduled backups. When connecting to the database I
get a message saying that this version of database is not supported and I
might get unexpected behaviour.
Am I OK to use this version of mySQL Administr
>Your table is missing. Try this:
?>mysqldump --single-transaction -u root clientdb
--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
Yes. The tables are missing. That's because I want the backup of all the
tables in the db, and those tables that have the column FLD_CLIENT_ID, they
should be fil
Thanks Sheeri.
Regards,
Rithish.
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 11:26 PM
To: Rithish Saralaya
Cc: MySQL general mailing list
Subject: Re: create/restore database without binary logging
Rithish,
It's possible to do this b
Hi,
I found that there are 2 versions of mysql 5.0 rpm for download.
Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads
Linux x86 generic RPM (dynamically linked) downloads
What is the difference between them? How to determine what version
should I use for fedora4?
--
M
Hi,
Is there any difference between _binary'Binary' and CONVERT('Binary' USING
binary)
mysql> SELECT CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1)));
+--+
| CHARSET(CONCAT(_binary'Bianry',CONVERT('abc' USING latin1))) |
+-
Hi all,
I am building client program on MySQL 4.0.16 with C API. But I always get
error like:
make all-recursive
gcc -I. -I/usr/home/vpopmail/include -I/usr/local/include/mysql -g -O2
-c user.c
user.c: In function `delalert':
user.c:357: syntax error before `*'
user.c:358: `conn' und
You have to enable the file_permission for the user in order to create file.
On 3/3/06, Bruce Bales <[EMAIL PROTECTED]> wrote:
> I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora
> 3 and now I am unable to write to an outfile.
>
> If I have started mysql with the simpl
I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora
3 and now I am unable to write to an outfile.
If I have started mysql with the simple "mysql" I get 'access denied' even if
I am trying to put it into my home directory.
mysql> select lname,fname,mname,addr,city,stz
Hi Atle,
We are using Asianux 2.0 (RHEL 4 compatible, linux kernel 2.6.9)
MySQL is the latest one. 5.0.x
Thanks in advance,
Hiro
From: Atle Veka <[EMAIL PROTECTED]>
Subject: Re: MySQL and Hyperthreading
Date: Thu, 2 Mar 2006 10:12:09 -0800 (PST)
Message-ID: <[EMAIL PROTECTED]>
> Hi Hiro, we h
On 3/2/06, rtroiana <[EMAIL PROTECTED]> wrote:
> Thanks to all of you for replying. I'm using DATETIME instead of TIMESTAMP
> now. Although I still haven't find the answer for my second question.
>
>
>
> > > I used to use
> > > "CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" as default value for my
Thanks to all of you for replying. I'm using DATETIME instead of TIMESTAMP
now. Although I still haven't find the answer for my second question.
> > I used to use
> > "CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" as default value for my
> > TimeStamp column. Is there a way to assign default v
Jeff wrote:
Currently I backup my MyISAM tables every night by running a shell
script that does the following:
Run:
Mysqlanalyze, mysqlrepair, mysqloptimize on all the tables
Then shutdown mysql
Then tar all the .MYI, .MYD and .frm files from the database's directory
to a backup director Star
Thanks for keeping me honest! I'd
forgotten that MySQL timestamps don't keep the fractional parts of seconds
either; I mostly use DB2 which keeps the fractional parts (microseconds) and
forgot about this quirk of MySQL.
--
Rhino
- Original Message -
From:
[EMAIL PROTECTED]
Currently I backup my MyISAM tables every night by running a shell
script that does the following:
Run:
Mysqlanalyze, mysqlrepair, mysqloptimize on all the tables
Then shutdown mysql
Then tar all the .MYI, .MYD and .frm files from the database's directory
to a backup director Start MySQL again.
Sorry for the top post, just saying thanks, that's what I thought
Back to the drawing board...
Jeff
> -Original Message-
> From: David Griffiths [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 01, 2006 18:13
> To: mysql@lists.mysql.com
> Cc: [EMAIL PROTECTED]
> Subject: Re: Repli
I'm putting this back on the list where it belongs; that enables everyone to
benefit from the discussion, both now and in the future via the archives.
--
Sorry, you're right, I didn't read your entire question thoroughly. You set
the default value for a DATETIME column (or any other type for t
The query has a number of joins and it was selecting * from all the
tables, so it was not apparent where each 'id' field was from. It was
just a poorly written query all around. I've fixed the problem by
narrowing down the number of fields it selects and giving the ambiguous
fields specific names
I have a SELECT query that looks similar to the following:
SELECT
FirstName,
LastName
FROM
myTable
WHERE
LastName IN ('PRICE', 'SMITH');
What I want to do is create a stored procedure for this SELECT query
similar to the following:
CREATE PROCEDURE
In fact, no time values in MySQL are fractional (yet). All times are
stored to the nearest second regardless of which date-time-like storage
type you use. They way Rhino phrased his answer, it sounded as though
TIMSTAMP would save fractional seconds. It doesn't. He is spot on about
needing a se
If you need a broader range of dates, you could use DATETIME instead of
TIMESTAMP: DATETIME can handle the range '1000-01-01 00:00:00' through
'-12-31 23:59:59'. The only big difference is that DATETIME does not
store the fractional part of the seconds, e.g.
milliseconds/microseconds/nanons
I don't understand what you want. If you have the original query, it should
be apparent from it where each 'id' column originated. If you're not sure
how to read the query, post it and we can help you figure out which table
provided each 'id' column.
--
Rhino
- Original Message -
Fro
Hi Hiro, we have noticed severe performance loss with HT enabled under
FreeBSD but not with MySQL. However, we could be having problems with
MySQL as well without knowing as we haven't done any testing as it is
operating fine. What operating system are you running?
We now disable HT on all servers
What makes you think that temporary tables would have better
performance than LIMIT? I'm not saying they do, or don't, just
wondering what makes you say that.
Each query, yes, would make a new temporary table. However, once that
session disconnects, the temporary table goes away. Something to
t
Hi there,
I tried a few other queries:
first, confirm that what you think is a binary is indeed a binary:
mysql> SELECT CHARSET(_binary'Binary');
+--+
| CHARSET(_binary'Binary') |
+--+
| binary |
+--+
1 row
Put "SET SQL_LOG_BIN=0" at the top of your dump file. That will turn
off logging just for your session.
-Ryan
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 02, 2006 11:56 AM
> To: Rithish Saralaya
> Cc: MySQL general mailing list
> Subje
It helps if you provide the error messages.
Sincerely,
-Sheeri
On 2/26/06, Xiaobo Chen <[EMAIL PROTECTED]> wrote:
> Hi, all
>
> I have installed a portal server and which has Mysql 4.0.15-nt with it.
> Before I installed this server, I have Mysql 4.1 in my PC. But thing is
> that they will confl
Rithish,
It's possible to do this by turning off binary logging, restarting the
server, importing, turning on binary logging, and restarting.
-Sheeri
On 2/27/06, Rithish Saralaya <[EMAIL PROTECTED]> wrote:
> Hello.
>
> I was going to recreate a database of size 35 GB from sql dump file. Wanted
>
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 03/02/2006 12:42:01 PM:
> I am working with an existing compilcated query someone wrote years ago.
> When I dump the data from the query to try to figure out why I'm getting
> unexpected data, I have three fields named "id". Is there anyway to
> tell mys
Yes.
You can add on SELECT syntax the AS operation, like this:
SELECT
ads.id AS 'ads.id',
track.id AS 'track.id'
FROM .
-Original Message-
From: Ryan Stille [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 2:42 PM
To: mysql@lists.mysql.com
Subject: Want mys
2wsxdr5 <[EMAIL PROTECTED]> wrote on 03/02/2006 12:30:17 PM:
> Is there a way with mysqldump to instead of dumping the contents of a
> table dump the contents of a select so if you import that sql back in
> you will get a new table that looks like the select?
>
> --
> Chris W
> KE5GIX
>
> Gif
I am working with an existing compilcated query someone wrote years ago.
When I dump the data from the query to try to figure out why I'm getting
unexpected data, I have three fields named "id". Is there anyway to
tell mysql to name the fields with the table name when they are
returned, so they sh
mysqldump has a -w option:
-w, --where= dump only selected records; QUOTES mandatory!
--
George
> -Original Message-
> From: 2wsxdr5 [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 02, 2006 12:30 PM
> To: 'MySQL general mailing list'
> Subject: dumping results of a select
>
[snip]
Is there a way with mysqldump to instead of dumping the contents of a
table dump the contents of a select so if you import that sql back in
you will get a new table that looks like the select?
[/snip]
I don't think so, but you could use INTO OUTFILE
--
MySQL General Mailing List
For lis
Is there a way with mysqldump to instead of dumping the contents of a
table dump the contents of a select so if you import that sql back in
you will get a new table that looks like the select?
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop w
Your table is missing. Try this:
?>mysqldump --single-transaction -u root clientdb
--where="FLD_CLIENT_ID=1" > client1_dbbackup.sql
-Original Message-
From: Rithish Saralaya [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 1:23 PM
To: MySQL general mailing list
Subject: mysqldum
rtroiana wrote:
Hi All,
I have recently noticed in the MySQL 5.0 documentation in section 11.3.1.
The DATETIME, DATE, and TIMESTAMP Types, it's mentioned that
"TIMESTAMP values cannot be earlier than 1970 or later than 2037. This means
that a date such as '1968-01-01', while legal as a D
Halid,
I think this is a php/phpmyadmin problem and not really a mysql problem.
PHP has an option called "magic quotes" that may be causing this.
http://us2.php.net/manual/en/function.get-magic-quotes-gpc.php
I have run into this before - I think what happens is that magic quotes
will change
Something is double escaping the strings.
Check if GPC magic string is enabled (apache's auto escaping).
Also check if your code manually escapes the strings.
Halid Faith wrote:
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data wit
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data with phpadmin on web. it works well. But I have a
problem.
As example if I add a text to mysql table with phpadmin.
My text contains as below;
"Halid 's car is expensive"
I will see a
Hello.
We have a database driven system that serves multiple clients. We have a
single database for this purpose. The data(rows) in some of the tables are
specific to individual clients. In all such tables, we have a field
FLD_CLIENT_ID whose value depicts the client to whom that row of informatio
[EMAIL PROTECTED] wrote:
> This might be a bit odd, but here we go..
>
> I have some data in a table that has the following structure:
>
[SNIP]
> The data is logged once a second. The StartTimeAndDate will be the same
> for the particular workpiece that I am interested in.
> I pull out the da
Hi All,
I have recently noticed in the MySQL 5.0 documentation in section 11.3.1.
The DATETIME, DATE, and TIMESTAMP Types, it's mentioned that
"TIMESTAMP values cannot be earlier than 1970 or later than 2037. This means
that a date such as '1968-01-01', while legal as a DATETIME or DATE va
<[EMAIL PROTECTED]> wrote on 03/02/2006 06:55:14 AM:
> This might be a bit odd, but here we go..
>
> I have some data in a table that has the following structure:
>
> CREATE TABLE `gaugereportinglist` (
>
> `Updated` timestamp NOT NULL default
> CURRENT_TIMESTAMP on update
I'm not sure but the situation you are describing sounds like the so-called
"Bill of Materials" Problem, sometimes called BOM for short.
I'm certain that some databases provide SQL to handle BOM problems; for
example, DB2 which I know quite well, provides for BOMs. However, I just did
a search
This might be a bit odd, but here we go..
I have some data in a table that has the following structure:
CREATE TABLE `gaugereportinglist` (
`Updated` timestamp NOT NULL default
CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`StartTimeAndDate` datet
You can do with one line:
replicate-do-table = db.table1, db.table2, db.table3
- Original Message -
From: "Rob Gormley" <[EMAIL PROTECTED]>
To:
Sent: Monday, February 27, 2006 10:35 PM
Subject: Elementary replication
Hi,
Not having a lot of luck with replication.
Have 2 4.1x boxes
HI all,
This is venugopal.Being a silent member of this group.I am having a doubt
regarding writing a query.I can explain it with an example
Consider i have a table called GetParents
The table consists of two fieds called num as Integer
ParentNum
Thanks Peter,
I didn't know that MySQL has no UPDATE ... SELECT command.
I followed your advice and made the following query
UPDATE Data AS db INNER JOIN
(SELECT myKey,Year,
SUM(IF(Month= 1,Cell,Null)) AS `Jan`,
...
SUM(IF(Month=12,Cell,Null)) AS `Dec`
FROM Updates GROUP BY myKey, Year) AS
48 matches
Mail list logo
