by Linux) was
provided. (Bug #25457611)
* No context help was displayed with a view or stored
procedure in the SQL editor. (Bug #24697574)
On Behalf of Oracle/MySQL Release Engineering Team,
Daniel Horecki
server was by SSL; (b) the caching_sha2 or
sha256_password authentication plugin was used for the
user; and (c) the user password contained Unicode
characters. (Bug #25642226)
On Behalf of Oracle/MySQL Release Engineering Team,
Daniel Horecki
to see
which item is selected. (Bug #25456216)
On Behalf of Oracle/MySQL Release Engineering Team,
Daniel Horecki
8512)
References: See also: Bug #20112700.
On Behalf of Oracle/MySQL Release Engineering Team,
Daniel Horecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
)
* When out-of-range index, unique index, or primary key
values were define in the source, no warning was provided
to indicate that the code produced could not be executed
by the MySQL server. (Bug #11745588, Bug #17509)
On Behalf of Oracle/MySQL Release Engineering Team,
Daniel
ke option, which takes these values: bundled (build
using bundled yaSSL code); system (build using system
OpenSSL library, with the location as detected by CMake);
path_name (build using OpenSSL library installed at the
named location). For more information, see
http://dev.mysql.com/doc/dev/connector-cpp/8.0/building.html
Bugs Fixed
* replaceOne() and similar methods did not correctly detect
document ID mismatches. (Bug #27246854)
* Calling bind() twice on the same parameter for complex
types resulted in empty values. (Bug #26962725)
On Behalf of the MySQL/Oracle Release Engineering Team,
Daniel Horecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication
- 99.999% High
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master geographic replication
- 99.999% High
start. (Bug #86675,
Bug #26263397)
References: See also: Bug #26288247, Bug #26279522.
On Behalf of Oracle/MySQL Release Engineering
-Sreedhar S & Daniel Horecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
ssl-mode is not also specified. (Bug #26226502)
* mysqlx_get_node_session_from_options() could succeed even
when a preceding mysqlx_session_option_set() failed.
(Bug #26188740)
On Behalf of the MySQL/Oracle Release Engineering Team,
Daniel Horecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hi, Sree,
I'm taking care of the release now. Docs should be up soon.
Daniel
On 10/07/2017 6:53 AM, Sreedhar S wrote:
Dear MySQL Users,
MySQL Cluster Manager 1.4.3 has been released and can be downloaded
from the My Oracle Support (MOS) website. It will also be available
on Oracle Software
Dear MySQL Users,
MySQL Cluster is the distributed, shared-nothing variant of MySQL.
This storage engine provides:
- In-Memory storage - Real-time performance (with optional
checkpointing to disk)
- Transparent Auto-Sharding - Read & write scalability
- Active-Active/Multi-Master
Dear MySQL users,
MySQL Connector/C++ 2.0.4 is the next development milestone of the MySQL
Connector/C++ 2.0 series. Connector/C++ 2.0 can be used to access MySQL
implementing Document Store or in a traditional way, using SQL queries.
It allows writing both C++ applications using X DevAPI or
On behalf of the MySQL Workbench and the MySQL/ORACLE RE Team
Daniel Horecki
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
tion option were not performed
properly. (Bug #22931974)
* Connector/C++ failed to compile against a version of the
MySQL C API older than 5.7. (Bug #22838573, Bug #80539,
Bug #25201287)
On Behalf of the MySQL/ORACLE RE Team
Daniel Horecki
--
MySQL General Mailin
You could try MEDIUMTEXT (16mb) or LONGTEXT (4gb) for a very large text...
On Tue Nov 18 2014 at 7:39:11 AM Reindl Harald h.rei...@thelounge.net
wrote:
Am 18.11.2014 um 10:48 schrieb thufir:
I'm trying to store a web page to table pages (whether or not that's a
good idea for a separate
Helo,
Just wondering if is possible to block SELECT queries that doesnt have
a WHERE statement within.
LD
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
?
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I got a solution maybe
step 1:
mysql explain select * from users;
++-+---+--+---+--+-+--+--+---+
| id | select_type | table | type | possible_keys | key | key_len |
ref | rows | Extra |
which end to
approach from. But scanning from the end needs an ORDER BY, preferably on
the PRIMARY KEY.
etc.
-Original Message-
From: Luis Daniel Lucio Quiroz [mailto:luis.daniel.lu...@gmail.com]
Sent: Thursday, May 24, 2012 12:00 AM
To: Jan Steinman
Cc: mysql@lists.mysql.com
to have vanished again, which
makes the whole thing even more shady.
I see this morning that the site says, Pre-release field
evaluation will be conducted when licensing is arranged. The link to
download the file is no longer there.
--
/Daniel P. Brown
Network Infrastructure Manager
http
overzealous?
Here's an explanation:
http://safebrowsing.clients.google.com/safebrowsing/diagnostic?site=http%3A%2F%2Fdev.mysql.com%2Fdownloads%2Fclient=googlechromehl=en-US
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
MySQL General Mailing List
For list archives
KEY UPDATE statements where
there was a duplicated key value. (Bug #46675, Bug #11754979)
* Upgrades using an RPM package recreated the test database,
which is undesirable when the DBA had removed it. (Bug #45415,
Bug #11753896)
--
Daniel Fischer, Release Staff
as far as my readings, they claim that 5.5 is the best
my question is, shall i jump from 5.1 to 5.5.
right now i have a performance problem, would 5.5 help me in that?
Regards,
LD
, also CC'd.
This not only means you'll get more on-target help faster, but also
helps in archiving data in the proper location for future searchers.
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
, '', b.`Name`)
there is a special function IFNULL:
IFNULL(b.`Name`, '')
It has the same special type-treatment that IF has.
Wow, thanks! I wasn't aware of it, but this looks helpful in my case
(at least simplifying those expressions)!
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc
' my function this way seems to fix the
problem also in my real application.
Thanks a lot!
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 04/22/11 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
Hm... do you have an idea how to work around this bug then?
Yours,
Daniel
Clearly from the select, the Typename field is not null, as shown here.
mysql SELECT *, TypeName Is NULL, TypeName IS NOT NULL
(customers, say)
to IDs of types, which doesn't make much sense to me. Or did I get this
wrong? (As I said, I'm more of less learning-by-doing and no expert!)
Yours,
Daniel
Now your select queries will give results as follows:
mysql SELECT COUNT(*) FROM `myview2` WHERE `TypeName` LIKE
and third ones.)
What am I doing wrong here? I have no clue what's going on... Thanks a
lot!
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
column 'TypeName' in 'having clause'
What would be the difference? (I've never used HAVING before.)
Yours,
Daniel
--
http://www.pro-vegan.info/
--
Done: Arc-Bar-Cav-Kni-Ran-Rog-Sam-Tou-Val-Wiz
To go: Hea-Mon-Pri
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi Carsten,
On 04/22/11 22:11, Carsten Pedersen wrote:
On 22.04.2011 21:37, Daniel Kraft wrote:
DROP DATABASE `test`;
CREATE DATABASE `test`;
USE `test`;
CREATE TABLE `mytable`
(`ID` SERIAL,
`Type` INTEGER UNSIGNED NULL,
PRIMARY KEY (`ID`));
INSERT INTO `mytable` (`Type`) VALUES (NULL
for folks to add anything I may have forgotten).
--
/Daniel P. Brown
Network Infrastructure Manager
Documentation, Webmaster Teams
http://www.php.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
of the links to the list, but I don't have any on
hand at the moment.)
see it on the bottom of my post... thanks and sorry for noise
It's also archived in many other places, such as GMANE[1] and MARC[2].
^1: http://gmane.org/
^2: http://marc.info/
--
/Daniel P. Brown
Dedicated
On Tue, Dec 14, 2010 at 13:58, omar zorgui omarzor...@gmail.com wrote:
Hello,
How can i subscribe for this list
http://lists.mysql.com/mysql?sub=1
--
/Daniel P. Brown
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--
MySQL
...@lists.php.net.
For your convenience, both have been CC'd on this email.
--
/Daniel P. Brown
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Running this query:
SELECT *
FROM `tbl_people`
WHERE name = 'Davé'
Returns results like:
'Dave'
I've checked my column, table and database and all are set to
utf8_general_ci collation
And I'm also runnig set names 'utf8' before my select statement.
Am I missing something obvious, I've had
a WHERE...IN statement:
SELECT * FROM contacts WHERE state='CA' AND name IN ('bob','sam','sara');
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
We now offer SAME-DAY SETUP on a new line of servers!
--
MySQL General Mailing
solution to this, doing it in one query and I
have the feeling, that I can almost touch it with my fingertips in my mind,
but I can't go that final step, if you know what I mean. AND THAT DRIVES ME
CRAZY!!
I appreciate your thoughts on this.
Regards,
Jan
--
/Daniel P. Brown
the
instructions on the web page linked below. As always, we value your
feedback!
http://forge.mysql.com/wiki/CMake
Enjoy!
Daniel
Changes in MySQL 5.5.4:
InnoDB Plugin Notes:
* This release includes InnoDB Plugin 1.1.
Bugs fixed:
* The mysqld option to turn on support for large pages
have full access.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Looking for hosting or dedicated servers? Ask me how we can fit your budget!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
VC9 non-thread-safe build from http://windows.php.net
and follow the steps in
http://www.php.net/manual/en/install.windows.iis6.php.
--
Daniel Egeberg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
this? This is definitely a valid UTF-8
character. Why is MySQL rejecting it?
The same happens if I input the character directly (rather than using
the hex representation) and also if I input that character directly
from a UTF-8 text file. Any ideas?
Thanks,
Daniel
--
MySQL General Mailing List
For list
to the
attack by Elance themselves. Perhaps a bit embarrassing for them, but
it was a good move to mitigate the damage post-fact, in my opinion.
That's it. Just trying to keep everyone from getting scammed and
screwed. For more information, check Google, as always. ;-P
--
/Daniel P. Brown
be a question to ask the Joomla folks. It's not a
MySQL issue, at least on the surface.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Check out our great hosting and dedicated server deals at
http://twitter.com/pilotpig
this problem!
thanks chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Check out our great hosting and dedicated server
/20430)
* mysqld_safe would sometimes fail to remove the pid file
for the old mysql process after a crash. As a result, the
server would fail to start due to a false A mysqld
process already exists... error.
(Bug#11122: http://bugs.mysql.com/11122)
Enjoy,
Daniel
why
not to use them, but if that was your biggest issue, it's one that may
well be easy to fix.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1
--
MySQL General
.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I would consider correct for
the OP's question.
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Unadvertised dedicated server deals, too low to print - email me to find out!
--
MySQL General Mailing List
For list archives
that I'd be OK just going for the CMDBA
certification. Does anyone have any feedback regarding these tracks?
It looks very much like I'd best just go for the CMDBA, but I don't
want to leave any gaps. I'd be grateful for any advice. Cheers,
Daniel.
--
MySQL General Mailing List
and
achieved the same result.
Short answer to the question in your subject, Daevid: yes, but
it's not the Right Way[tm].
Hello, by the way. ;-P
--
/Daniel P. Brown
daniel.br...@parasane.net || danbr...@php.net
http://www.parasane.net/ || http://www.pilotpig.net/
Unadvertised dedicated
Hi all. I have a 30GB innodb-only database in mysql-5.0.54. I have
always done nightly backups with:
mysqldump --opt db_name db_name.sql -p
Recently this started failing with:
Error 2013: Lost connection to MySQL server
I have checked all tables for corruption - nothing found. Also as far as
I
For the curious: As usual select is not broken.
Lesson learned: Always watch out for warnings:
http://bugs.mysql.com/bug.php?id=41007
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Gautam
nope yours is not a bug. That's all fine. Hex numbers are 64 bit
unsigned.
So for -1 you have to insert cast(0x as signed).
Cheers,
Daniel
Hi Daniel,
I can see the problem without using update. However, I am a newbie
at
mysql,
so can't say for certain if it's
Hi everybody -
I'm experiencing some really weird update behaviour (mysql 5.0) when
or'ing results from subselects using Long.MIN_VALUE.
But before I post a bug report I wanted to ask if I'm missing something.
drop table if exists foo;
drop table if exists bar;
create table foo (fooid int,
, it's no problem. MySQL
couldn't care less if it's compiled for i586 or x86_64; that's only in
how it relates to the OS on which it's installed, not how it interacts
with sibling systems.
--
/Daniel P. Brown
http://www.parasane.net/
[EMAIL PROTECTED] || [EMAIL PROTECTED]
Ask me about our current
email.
--
/Daniel P. Brown
Better prices on dedicated servers:
Intel 2.4GHz/60GB/512MB/2TB $49.99/mo.
Intel 3.06GHz/80GB/1GB/2TB $59.99/mo.
Dedicated servers, VPS, and hosting from $2.50/mo.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
','10.0.0.1','127.0.0.1','216.37.159.240','99.99.99.99','127.0.0.2','192.168.1.1','10.0.0.0','192.168.0.1','192.168.0.150');
function get_subnet($ip) {
return substr($ip,0,strrpos($ip,'.'));
}
foreach($ips as $ip) {
echo $ip.'s Class C is .get_subnet($ip).\n;
}
?
--
/Daniel P
Hi,
I have the following problem:
080605 15:33:26 - mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning
Hi,
I have the following problem:
mysql Ver 14.12 Distrib 5.0.51a, for portbld-freebsd6.3 (i386) using 5.0
080605 15:33:26 - mysqld got signal 10;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly
On Sat, 2008-05-10 at 20:59 +0400, Velen wrote:
Hi,
I'm testing a program and I need you assistance.
Please unzip the file at http://www.biz-mu.com/PCID.zip and run the program.
Please supply a Linux version of your virus so I can test.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Hi all,
Apologies if this isn't the correct list but I couldn't see a more
suitable one.
I have 4 tables. t1 and t3 are a many to many relationship and use t2
as link table. t3 has many t4.
What I want to do is insert a new row into t3 for each row in t1. I
then want to add the
the manual entry:
http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
--
MySQL General Mailing
';
and then FLUSH PRIVILEGES; again.
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
access to EVERY
database on the server. I'm not sure that there's a way to
comma-delimit (or something of the type) a select few database.table
configurations. A quick search of the web didn't show any different
either.
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS
..
Any inputs will be appriciated.
Thanks,
Ratheesh
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
--
MySQL General Mailing List
For list archives: http
.
I'm going to submit a bug report with the project, but just wanted
to put out a heads-up here on the list in case anyone else runs into
the same problem and gives up before checking into it further.
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99
] INFILE command.
Dump out your Excel data to a CSV and import it by using the
manual entry as a guide:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting
--- and 'Record' is not a valid INT.
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo.,
and shared hosting starting @ $2.50/mo.
Unmanaged, managed, and fully-managed!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim [EMAIL PROTECTED] wrote:
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
That's because it's attempting to insert the name of the columns
from your CSV into MySQL --- and 'Record' is not a valid INT.
Replaced field name with 0 and had
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED] wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and then post back here for the MySQL archives
responses on either the MySQL list (you didn't mention which
database system you're using, but I'll blindly and ignorantly assume
that's it), or at least the PHP-DB list. I'm CC'ing both of those for
you.
--
/Daniel P. Brown
Ask me about:
Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo
-database joins considered good practice?
If separating tables into different databases makes things easier for
you, then ( at least with MySQL ), I don't see any problems.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2
On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
[EMAIL PROTECTED] wrote:
Hi
Is there a documentation on replication of MySQL Database on Gentoo
From the manual:
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
--
/Daniel P. Brown
Forensic Services, Senior Unix
On Sun, Mar 30, 2008 at 9:59 AM, Velen [EMAIL PROTECTED] wrote:
Hi,
How can i limit connections to my database?
RTFM: http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-data.html
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
://php.net/mailinglists (referred to there as
Databases and PHP). You should see a significant gain in
performance using a native client as opposed to what you're now using
(probably an ODBC DSN, MyODBC, or a JDBC hack).
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
host if you're using
password hashing, or if everything is in plain text, you should be
just fine.
Please help me!
Hey, Charlie Brown, why's everybody always pickin' on you? ;-P
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
don't know what it is.
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
wait (or don't feel like it), check out the forum at
http://www.mysqlfreaks.com/.
Best of luck, Marco!
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
, though, that's the off-the-wall
possibility. A Learn or Die ultimatum.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/usr/share/zoneinfo/America/
The -D flag selects the database `mysql`, which is where the time
zone information belongs. The redirect reads from the file
(which, in this case, is actually a redirected STDOUT) into the
database.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me
On Mon, Mar 10, 2008 at 11:36 AM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
mysql -D mysql -u xxx -p mysql_tzinfo_to_sql
/usr/share/zoneinfo/America/
The -D flag selects the database `mysql`, which is where the time
zone
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this?
The same question just received an excellent answer from Rolando
Edwards about ten minutes ago. Check the archive here:
http://marc.info/?l=mysqlm=120517563300467w=2
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
The same question just received an excellent answer from Rolando
Edwards about ten minutes ago. Check the archive here:
http://marc.info/?l=mysqlm
.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql
2.) A bunch of errors may appear, but you can ignore them.
3.) Run SELECT COUNT(*) FROM mysql.time_zone_name; again. You
should have more than 500 rows now.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list
so that the
MySQL server knows where to locate the CD databases (and then the
server will need to be restarted, as well).
So to summarize, it can be done, but don't expect it to be a
point-click-send operation; there are going to be some bumps in the
road.
--
/Dan
Daniel P. Brown
Senior Unix
BY t.serial_number ORDER
BY t.date DESC LIMIT 0,1;
That will give only the latest date.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
serial_number,date FROM theTable ORDER BY date DESC
LIMIT 0,1);
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
over to the PHP-DB list. It's
well-monitored by some very talented people, and you can get more
specific answers. http://www.php.net/mailinglists
If not, feel free to ignore this! ;-P
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL
will handle hashing the password, so
don't send it encrypted or pre-hashed.
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that it's all on the same server. Try this:
USE mysql;
UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE
User='root' AND host='dev.jss.com' LIMIT 1;
FLUSH PRIVILEGES;
--
/Dan
Daniel P. Brown
Senior Unix Geek
? while(1) { $me = $mind--; sleep(86400); } ?
--
MySQL General
tried doing a 'check tables' thing from the MySQL administrator
( the longest one ... 'changed' ). It didn't find anything.
Is it time to drop everything and restore from a backup?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61
in the
tlocations table?
1
I'd also assume that since it's named 'id' it would be
a primary key (and indexed) ?
Indexed, yes.
I'll go ahead with that restore from a backup tonight.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T
? Was it with a
package manager, or was it already installed by your distro, or did you
install it manually?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
-Message d'origine-
De : Mark Leith [mailto:[EMAIL PROTECTED]
Envoyé : dimanche, décembre 16, 2007 04:53
À : Daniel Caune
Cc : mysql@lists.mysql.com
Objet : Re: Monitoring and analysis tool
Daniel Caune wrote:
Hi,
Our MySQL server used for our development environment
1 - 100 of 1312 matches
Mail list logo