/doc/en/Mathematical_functions.html
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
o why doesn't the grant command
above work, do I need to append it with the -uroot -p command so
what?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list
his is true. If there is overlap, removing
the old installation will remove part of your new installation. (In
which case, you might want to re-install 4.0.16 after removing 4.0.4.)
Make sure you generate a backup of your databases first, whatever you do.
Thanks again!
Mark
--
Paul DuBois
At 8:53 -0600 11/22/03, Dan Wilterding wrote:
I can't seem to locate a manual for the Control Center -- is such a
thing available and if so, where?
There is not.
Thanks,
Dan Wilterding
[EMAIL PROTECTED]
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.co
At 23:34 -0800 11/21/03, Chris wrote:
Wouldn't this also work?:
mysql -u root -p -e "CREATE TABLE t$date(...)" yourdatabase
Sure.
-Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mys
to quote it with backticks every time you refer
to it.
Julian
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
table name is after
the LIKE statment.
Slow? How many tables are we talking about?
Thanks
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list arch
e not written to the binary log on the master until they
are committed, so that's already taken care of. (Rolled back transactions
never appear in the binary log.)
-Matt-
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certif
e MySQL Reference Manual:
http://www.mysql.com/doc/en/Upgrading-from-4.0.html
http://www.mysql.com/doc/en/Upgrading-grant-tables.html
http://www.mysql.com/doc/en/Password_hashing.html
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? htt
ts.mysql.com/faq.php#subjectprefix
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
I can just
drop the database and recreate.
Any help would be appreciated.
This is described in the MySQL Reference Manual:
http://www.mysql.com/doc/en/Batch_mode.html
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysq
At 13:55 -0500 11/19/03, Denis Mercier wrote:
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote:
At 11:03 -0500 11/19/03, Denis Mercier wrote:
> > >> >i also tried:
>> >> >use my_db;
>> >> >select * from my_table;
>> >> >
y blob I get a well formatted tar file,
>I'm thinking that maybe tar cannot handle a stream as it's input?
That may be. In that case, you should invoke tar as
tar xf -
I have tried tar xf but tar gives me an error, it wants a file
specified.
But I didn't say to use "tar xf&
knowing why you'd want to or what problems you're
encountering, it's difficult to say whether or not that's something
you should consider.
Thanks a lot.
Fernando Bernardino
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you My
7; IDENTIFIED BY
'password'
-Original Message-
From: Nikos Gatsis [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] TABLE_PRIV
Hello List.
Does anybody knows how to configure table_priv table of Mysql?
I didn't
D = 129 AND
t160.FieldValue = 4 AND t1.UserID=t161.UserID AND t161.FieldID = 129 AND
t161.FieldValue = 2 AND mp.UserID = t.UserID AND mp.FieldID = 1 AND
mp.FieldValue = 0
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Please reply to the list, not to me personally, so that
others can follow this discussion.
At 17:05 -0500 11/18/03, Denis Mercier wrote:
On Tue, 2003-11-18 at 16:40, Paul DuBois wrote:
At 16:21 -0500 11/18/03, Denis Mercier wrote:
>here's what im trying to do, i have a tar file in a bl
output from mysql isn't suitable. Couple of things to try:
1) --pager should be omitted. It serves no function here.
2) You might want to add --raw to the mysql command
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL A
B, www.mysql.com
Are you MySQL certified? http://
At 14:05 -0600 11/18/03, Paul DuBois wrote:
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with "system".
I forgot to mention: The system
At 4:47 PM -0300 11/18/03, adburne wrote:
There is a command or function to call a shell script through mysql?
Invoke mysql, then issue a \h command and look in the output for
the line that begins with "system".
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, US
ql
or this:
source E:\Apache\apache2\htdocs\public_html\weather\stations.sql
The semicolon at the end can be given, but need not.
Is there a ; at the end or I do not need one.
Thanks a lot for your response
Ola
Paul DuBois <[EMAIL PROTECTED]> 11/17/03 02:08PM >>>
At 10:28 A
on Redhat Linux 8.
Subqueries are not implemented until MySQL 4.1.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
At 6:45 PM + 11/17/03, Bruno Mustone wrote:
Hmmm they seem to work in version 3.23.57.
Given that they were introduced in 3.23.6 (as stated below), that
is not surprising.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 17 November 2003 18:38
To: Bruno Mustone
hat was successful, but I just cannot
accomplish the following...Please Help
Using mysql - connect as your root or other privileged user
connect to your geeklog database
Using "source" read in and execute the SQL file
o mysql# source stations.sql;
Best regards
Ola
--
Paul Du
>>> replace. The table is
>>>
>>> items and the field is description. I would like to
replace the existing
>>> text within this filed with some new text.
>>>
>>> I did this before and it was successful but I have lost
the query to do
At 12:05 PM + 11/17/03, Bruno Mustone wrote:
Hi Guys,
Do you know what version user variables were introduced? I can't seem to
get them working in 3.22 and yet they work in 3.23.
They were introduced in 3.23.6.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MyS
ble.
2. Use only the second SQL
- GRANT SELECT (id, jobid) ON DATABASE.CHECK_SBIN TO testuser >> OK
Comments:
An error occured 'Access denied for testuser'.
Note: The grant tables are all checked correctly.
System:
MySQL 4.0.13
Solaris 8
I checked the manual and maili
oc/en/Indexes.html
Herb
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
At 10:49 -0800 11/7/03, William R. Mussatto wrote:
Paul DuBois said:
At 15:29 -0800 11/6/03, Herb Rubin wrote:
Paul,
I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT
NULL column.
The encrypted string seems to be equivalent to the NULL value even
though it visually looks like
re field(" + i +") < " + j;
QUERY,
RESULT SET
etc.,
}
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
the Rows output field.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--+ |
AES_ENCRYPT('551850040', '0bf251c9aaf007deaf1143ca1492b561') |
+------+ |
>>> k\ÎúVÀàÿxû÷Ò |
+--+
What version are you usi
--+
| k\ÎúVÀàÿxû÷Ò |
+--+
What version are you using?
Help!
>>Herb
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---+
What version are you using?
Help!
Herb
--
Herb Rubinwww.pfinders.com
Pathfinders Software phone: 650-692-9220
[EMAIL PROTECTED]fax: 650-692-9250
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
Any ideas on what is wrong or missing?
"cannot find -lreadline"
The readline library is missing.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list ar
---+-+--+++
| campaign_t | ALL | datestamp | NULL |NULL | NULL | 438166
| where used |
++--+---+--+-+--+++
1 row in set (0.00 sec)
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.m
InnoDB: Starting shutdown...
031106 7:23:11 InnoDB: Shutdown completed
031106 7:23:11 /usr/libexec/mysqld: Shutdown Complete
031106 07:23:11 mysqld ended
*--
Any other ideas?
perror 13
Error code 13: Permission denied
MySQL should be owner of the data dir.
--
Paul DuB
At 2:13 PM + 10/28/03, Raiko Gonzales wrote:
Hello,
perhaps this questions is not directly MySql related but MySql is
very related with my question. I'm learning Paul Dubois MySql and
Perl for the web and I have a lot of problems make working the
Mail::Sendmail module.
Here&
At 4:41 PM -0800 10/27/03, bluejack wrote:
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old
ation, but a DATE column won't quite do the job, because year,
month, and day are all required.
No, they're not. Use '00' for the missing parts, e..g., '1970-03-00'
or '1948-00-00'.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB,
WHERE Db='mysql' show anything?
Cheers,
Clive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:04 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How do I restrict a mysql user only can work on a database
At 12:48 PM +1100 10/
| N
| N | N | N| N| N
| N| || | |
0 | 0 | 0 |
any clue?
What does SELECT * FROM mysql.db WHERE User='testuser' show?
Cheers,
Clive
--
r original
message closely enough. Your first grant statement should says
"ON testdb.*" rather than "ON testdb". The latter syntax grants
privileges to "the testdb table in the current database", which isn't
what you want.
-Original Message-
From: Paul D
ot;the testdb table in the current database", which isn't
what you want.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:10 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: How do I restrict a mysql user only can work on a databa
eally
want. I just want testuser can select and update testdb. But not others.
How can I restrict testuser only work on testdb?
Thanks.
Cheers,
Clive
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Pa
r
own abstraction that allows you to use the same API for MySQL or Oracle.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE your_dump_file;
On the other hand, the MySQL manual says
(4.8.7 mysqlhotcopy) that mysqlhotcopy can
only be used with MyISAM and ISAM tables.
Thanks in advance
Martín
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www
ng.
Any insght??
Look in the slave's error log.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
.8.7 mysqlhotcopy) that mysqlhotcopy can
only be used with MyISAM and ISAM tables.
Thanks in advance
Martín
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For l
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oreign key checking. Invoke
mysql, then issue these statements:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE your_dump_file;
On the other hand, the MySQL manual says (4.8.7
mysqlhotcopy) that mysqlhotcopy can only be used
with MyISAM and ISAM tables.
Thanks in advance
Martín
--
Pau
ours without luck.
There will be a function for this in 4.1.1, called ... uh, STR_TO_DATE(),
I think.
It'll return a DATETIME, not a TIMESTAMP, though. As has already been
pointed out, your date cannot be a TIMESTAMP, which has a range beginning
in 1970.
Regards
Kim G. Pedersen
macaos/e
n the daemon starts - in that case, I'm assuming that
it's logging everything for every database.
Correct. Per-db logging is not available.
Your help is appreciated!
James
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL c
or -upwd mydb < myfile.sql
I did not think that the spaces after the '-u' and the '-p' matter
It doesn't for other options. -p is special, because if you leave
out the password value, that's how mysql knows you want to be prompted
interactively for the password.
T
but there
is another phase implicit in what you're doing: the transfer of the file
from one machine to another.
How are you transferring the file, and are you sure that process is not
changing the file contents?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql
ould not be used for your own applications.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
MySQL, Second Edition, is now available in Czech.
Information is available at:
http://www.kitebird.com/mysql-book/
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
er a crash.
I had a problem whith those files and now all my InnoDB stopped working,
only the MyISAM tables are working, how can I recovery data from them ?
I hope you didn't remove them. What do you mean by "InnoDB stopped
working?
--
Paul DuBois, Senior Technical Writer
Madison, Wis
ework.
Is it OK if I pilfer parts of the code and extend it for use in my app?
Sure. There's no restriction on how you use any of it.
Would be much appreciated...
Cheers,
Andrew
-Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday 14 October 2003 19:19
xps if it's
not absolutely necessary!! :)
Cheers,
Andrew
SQL, Query
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Jeff
Hmmm...
% perror 143
Error code 143: Unknown error: 143
143 = Conflicting table definitions in sub-tables of MERGE table
Can you post the results for SHOW CREATE TABLE for the tables
you're trying to merge?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.co
t is working properly. It's not the host
either, I tried with % as hosts, and it didn't work.
Any hints ?
Nicolas
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to include every field from the two tables I'm
merging or can I just grab the ones I want?
The former.
http://www.mysql.com/doc/en/MERGE.html
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certific
nging the
limit requires a recompile.
Thanks
Jaroslav
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
ta to PHP web page.
I know in ver 4.x there is table called a "merge" table for this type of
thing but we're stuck with 3.23 for now.
Jeff
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certificat
ion_files.html
IMHO the problem is that you have put timezone variable into [mysqld]
section,
but you need to put it into [mysqld_safe] section. But I am not sure. Check
it, please.
That's correct. --timezone is a mysqld_safe option, not a mysqld
option.
Best regards,
Mikhail.
--
Paul
ould
be a legal statement in any API.
Thanks,
Adam Clauss
[EMAIL PROTECTED]
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mys
h the mysql client, invoke it with the
--force option.
Not sure if that's "graceful", though. :-)
dan
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For
]
http://www.nefacomp.net/
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql
ut how to continue ?
The Windows equivalent goes by various names:
- The DOS prompt
- A console Window
- CMD.EXE
So, you don't type "shell>" literally. That stands for "the prompt
printed by your command interpreter", such as C:\> on Windows.
--
Paul DuBois, Senior
ver status until we see that its on the new
relay log
3. at that point stop the slave server again
4. delete the extra logs and edit the relay log index by hand.
5. start the slave server.
You don't need to stop and restart the server to make it start
a new relay log. Just issue a FLUSH LOGS state
* FROM t;
And then what happens with this code, after you wait a few seconds:
UPDATE t SET i = i + 1;
SELECT * FROM t;
Finally, what's the output from this statement:
SELECT @@sql_mode;
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL cert
explicit value to any of your foreign
keys. Apparently the default value (0) is not present in one or
the other of the referenced keys in the parent table?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certificat
to the relevant part of
mysqld.server to kill mysqld_safe's shell if I knew the right shell to kill.
Any ideas here?
Best Regards, Bruce
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this thread.
At 18:55 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> >Perhaps I misunderstood the doc but I thought by using _use_result
> >I was asking for the server not to send the next t
At 18:09 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> At 17:26 -0700 10/6/03, Don Cohen wrote:
> >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
> >says
> >
> > you must retrieve all the rows even if you determine in
> >
ree_result(), it will take care of
retrieving and discarding and unfetched rows.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
At 17:09 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 05:04 PM, Paul DuBois wrote:
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this discussion.
At 16:56 -0400 10/6/03, Patrick Larkin wrote:
On Monday, October 6, 2003, at 04:37 PM, Paul DuBois wrote:
Does the PATH setting for jobs run by cron include the directory where
mysqldump is
he command is running from root's
cron file. The file has rw privs for root and the enclosing
directory is owned by root. It doesn't have a problem running
manually...
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified
DATE will fix the problem. :-)
--- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 12:55 -0400 10/6/03,
Franck Babin wrote:
>I have made some changed but it still doesn't work:
>
>UDPATE activity SET activity_date = '2003-10-06 11:00:00',
type_no = 1 WHERE
>DATE
chives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http
mean by the statement not working.
It doesn't find any rows to update? Do you get any results from
the following statement, which simply tests the comparison?
SELECT activity_date FROM activity
WHERE activity_date = '2003-06-10 11:15:00';
--- Paul DuBois <[EMAIL PROTECTED]> wr
--+
|56 |181 |
|57 |181 |
|79 |181 |
+---++
You can see above that id(79)
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification
f ORDER by
commentid DESC;
However, the results are NOT showing me the stories in order
from most
active comments onward... Maybe too much soda and sugar -
> but any thoughts?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?
es in it using '-MM-DD hh:mm:ss' format, not in the format
you store above.
If activity_date is *not* really a DATETIME column, but is stored using
values in 'DD.MM.YYYY hh:ss' format, then DATE_FORMAT() will not work
correctly.
--
Paul DuBois, Senior Technical Writer
Mad
works perfectly without issuing the FLUSH PRIVILEGES statement.)
cheers,
feng
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysq
27;s *actual* password characters('alan') in WinMySQLadmin
or the my.conf file, not the user table; but I DO see Brian's *actual*
password ('brian') from the user table.
BTW, I can't find any thing in the my.conf or WinMySQLadmin related to the
*brian* --- e.g. in the m
read about leftmost prefixes in the MySQL Reference
Manual.
http://www.mysql.com/doc/en/MySQL_indexes.html
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list arc
-> FROM dog
-> GROUP BY breed
-> ORDER BY minage;
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
id it say?
i've compiled the SRPM package - everything ok.
bye, thomas
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
have anything to do with whether it's safe
to point two servers at the same database?
dose anyone know for sure if this will work
Thanks a bunch
Kenneth W Lichtenberger
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www
-tmpdir=/whatever because I don't want to have to change the startup
scripts.
Thanks for the help,
dan
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For
on domain.com is not running. Or perhaps
domain.com is firewalled and doesn't allow connections to the MySQL
port.
and this is disabled in my.cfg
#
#skip-networking
whats wrong and how do i allow remote connections?
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, ww
privileges
that you'll no longer be able to administer your server without starting
it with the --skip-grant-tables option...
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Cookbook (O'Reilly & Associates) is now available in German
(translated by Lars Schulten, Stefan Hinz & Peter Klicman).
Information is available at:
http://www.kitebird.com/mysql-cookbook/
http://www.oreilly.de/catalog/mysqlckbkger/
--
Paul DuBois, Senior Technical Writer
Madis
MySQL, Second Edition, is now available in French.
Information is available at:
http://www.kitebird.com/mysql-book/
http://www.pearsoneducation.fr/espace/livre.asp?idEspace=73&idLivre=1771
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you M
-+
| foo | ALL | stn,stn_2 | NULL |NULL | NULL | 90 | Using where;
Using temporary; Using filesort |
+---+--+---+--+-+--+--+-
-----+
1 row in set (0.05 sec)
--
Paul Du
_Account_Management.html
thank you
---
Leader University
Wenjung Wang
Tel:06-2559000 ext. 51100
E-mail:[EMAIL PROTECTED]
-------
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql
n Setup and Testing. This section does not
talk about steps after running rpm -i on the server and client package. I
can't figure out what occurred. Has anyone experienced this before, or have
ideas on how to troubleshoot?
Thanks,
Roger
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsi
801 - 900 of 2906 matches
Mail list logo
