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
he 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
akes it easy 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
52485)
* 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,
D
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 Availab
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 Availab
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
cified could succeed, although it should fail if
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 Sof
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 g
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 pla
7.
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
onnection 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 M
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
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 thread, please). W
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
On Mon, Aug 13, 2012 at 8:25 PM, Thufir wrote:
> Looking at:
>
> Group gmane.comp.db.mysql.general
> Description The main list for general MySQL discussion
> Address mysql@...
> Status posting allowed
> http://dir.gmane.org/gmane.comp.db.mysql.general
>
> It would really be nice if
ght improvement (addressing both issues) is to decide 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..
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 |
++-+---+--+--
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman wrote:
> - Original Message -
>> From: "Singer X.J. Wang"
>>
>> Perhaps something called a VM can be use?
>
> Perhaps something called documentation can be provided?
>
> I also notice that the original poster seems to have vanished again, wh
On Mon, Sep 26, 2011 at 14:30, Michael Albert wrote:
> I don't suppose I am the first to notice this, but most of
> the pages on dev.mysql.com have been listed by google
> as "attack pages", e.g http://dev.mysql.com/downloads/.
> Has there been a problem, or is google being overzealous?
Here'
returned 3 (instead
of 2) for INSERT ... ON DUPLICATE 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,
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
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote:
> Can smbd please look at this sentence - I got an error and do not
> know how to fix it - I am still very unfamiliar with MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
> varchar(50), clock timestamp, action va
<<<<
Well, for this construct
IF(b.`Name` IS NULL, '', 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 simpli
solution before... But 'inlining' 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 archiv
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 N
ID of entries in mytable (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(*
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
x27;%';
When I try those, I get:
ERROR 1054 (42S22) at line 35: Unknown 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
7;t at least one of them match the single row?
(Preferably first 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 G
On Wed, Dec 29, 2010 at 04:57, Hajo Locke wrote:
> Hello,
>
> i want to talk from php to different mysql-servers with different versions.
> is it a recommend way to compile php always against newest libmysqlclient or
> not so important?
You should use the newest stable version so you can take
On Tue, Dec 14, 2010 at 13:58, omar zorgui wrote:
> Hello,
>
> How can i subscribe for this list
http://lists.mysql.com/mysql?sub=1
--
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--
MySQL General Mailing List
For list archiv
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson wrote:
> On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote:
>>
>> I have a question that this list solved a year ago, and I can't remember
>> what the solution was. Does this list have an archive?
>>
>> (Sorry if it is on one of the links to t
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
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
On Fri, Jun 18, 2010 at 16:30, Dave wrote:
> SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
> name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a WHERE...IN statem
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter wrote:
> Hi folks!
>
> I'm kind of ashamed to ask a question, as I haven't followed this list very
> much lately.
>
>
>
> This isn't exactly a PHP
isn't going away just yet, but if
you are so inclined, you can now alternatively use CMake as per 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
On Sat, Jan 30, 2010 at 01:49, Vikram A wrote:
> Dear Admin,
>
> I would like to share and get inputs from experts on MYSQL Db.
>
> I request you to grant access to me.
You may not have noticed, but you're already posting to the list.
All you have to do is subscribe and you have full access.
So you can download
the PHP 5.3.1 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...@jab.org
1366): Incorrect string value: '\xF0\x90\x8C\xB0' for
column 'page_title' at row 1
and results in a zero-length string being inserted instead.
Can anyone else reproduce this? This is definitely a valid UTF-8
character. Why is MySQL rejecting it?
The same happens if I input th
Just as a heads-up, in case you guys weren't yet aware (cross-posting):
Elance.com was the victim of an SQL injection attack earlier this
summer (they apparently missed our billions of threads on sanity).
According to their folks, only names, company names, phone numbers,
and email address
On Mon, Jul 20, 2009 at 15:03, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem
wrote:
> Hello, we are trying to move a Joomla Site
> and the administrator does nowrk.
>
> Using MySQL 5.1.36 on MAC OS X Server.
>
> How can I fix this?
This would be a question to ask
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If I
d fail to start due to a false A mysqld
process already exists... error.
(Bug#11122: http://bugs.mysql.com/11122)
Enjoy,
Daniel
--
Daniel Fischer, MySQL Tech Lead Build +46 18174400 ext. 4537
Sun Microsystems GmbHSonnenallee 1, DE-85551 Kirchheim-Heimstetten
Geschaeftsfuehr
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers wrote:
> Hi everyone. I am starting my first web site. I have a temporary contract
> with godaddy but know there are better options out there. The only problem
> is, I don't know reliable sources to research which hosting program to use.
> Any reco
On Mon, Mar 30, 2009 at 19:45, Dian Crayne wrote:
> Chuck Crayne (ccra...@crayne.org) has died. I am his widow.
> I cannot unsubscribe him from this list because I do not
> have his user name and password. Please remove him from your
> membership list. If you need to talk to me about this, my
On Mon, Feb 2, 2009 at 13:43, Martin Gainty wrote:
>
> select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
> NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to forget that
MySQL
rs, so it would seem 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,
Dan
On Thu, Jan 15, 2009 at 20:44, Daevid Vincent wrote:
> I've been tasked with cleaning up a bunch of 'eventum' tables that got
> accidentally dumped into several databases and then replicated.
>
> I'm wondering if I can just go through with a simple command to blow
> these all away:
>
> find /var/
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'
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,
On Wed, Nov 12, 2008 at 12:35 PM, Shain Miley <[EMAIL PROTECTED]> wrote:
> Hello all,
> I was wondering if anyone had any good insight into running the 32 bit and
> 64 bit versions of MySQL? We are going to be using a replication setup
> within my organization very shortly. We intend to a have
On Wed, Jul 23, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+
On Wed, Jul 23, 2008 at 11:45 AM, <[EMAIL PROTECTED]> wrote:
> Guys,
>
> I have been fighting with mysql trying to get it to only show every after
> the last dot(.) on a ip. for example
>
> instead geting 10.0.0.0 only get 10.0.0
As pulled from a database row? Sorry, I didn't quite understan
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 bui
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 hardwa
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 Deve
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 correspo
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal cha
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> hi all, i have an existing database (internal) with a user named 'admin',
> everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's privileges
> on test as same
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Iam having the one table name called AccessDetails and data inside that
> tables is following,
>
[snip=schema]
>
> In that , I need to calculate the number of total sites , number of
> total Accessed Sites,num
On Tue, Apr 15, 2008 at 3:11 PM, minky arora <[EMAIL PROTECTED]> wrote:
> Hi Gurus,
> I am a newbie.Please bear with me.
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
"LOAD DATA [
On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> I just posted the Spring issue of the MySQL Magazine. This issue contains
> a great group of articles that you will want to read. In addition, Sheeri
> Cabral did a fabulous job with a new layout for
Ratheesh,
There's a specific list for PHP database functions, "Databases and
PHP" (PHP-DB), which you can find at http://php.net/mailinglists .
I'm forwarding your message over to there, and recommend that you
subscribe to that list. You'll probably get more direct responses by
narrowing-
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
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'
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> I am attempting to use this command: load data infile
> '/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
> '\t' lines terminated by '\n';
[snip!]
>
> The error that I'm getting is
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have the following SQL statement;
>
> SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID
> FROM sales
> LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid
> L
d be in the *same* database anyway. But you
can try it and see.
> Is using cross-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 Con
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
--
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list
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
--
Forensic Services, Senior Unix Engineer
1+ (570
On Fri, Mar 21, 2008 at 10:04 AM, Velen <[EMAIL PROTECTED]> wrote:
> This one is alright but is there an alternative that can be run with the
> mysql> prompt?
Not to dump a file, but to import, yes. Check out the LOAD DATA
INFILE command:
http://dev.mysql.com/doc/refman/5.0/en/load-d
On Fri, Mar 21, 2008 at 9:14 AM, Velen <[EMAIL PROTECTED]> wrote:
> This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate
> pc and the only communication that can be use between the two PC is a USB
> pendrive.
>
> Is there another way of copying a table from one Database to
On Thu, Mar 20, 2008 at 1:41 PM, Velen <[EMAIL PROTECTED]> wrote:
>
> Actually I am updating TableA in DatabaseA with values from TableB in
> DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a
> .txt file containing data from TableB then using VB6 once more to
> recronstr
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database. I was told that
>
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Using mysqldump, I'm about to dump all databases and import to another
> instance - new . My question is do I need to define all security and
> users in the new mysql or the security definitions and privileges will
>
action. And with
that forced lesson, hopefully they'll learn that the prompt is the
safer way of doing this. Again, though, that's the off-the-wall
possibility. A "Learn or Die" ultimatum.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r if you're patient.
If you can't wait (or don't feel like it), check out the forum at
http://www.mysqlfreaks.com/.
Best of luck, Marco!
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ith the user information?
>
> Thanks,
> Terry
> nohup mysqldump -h -u -p
> --all-databases --routines --triggers | mysql -h Machine> -A
Yes, the --all-databases flag recursively copies all databases and
tables, including the 'mysql' database with user and time
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 h
any good programs to do this?
The same question just received an excellent answer from Rolando
Edwards about ten minutes ago. Check the archive here:
http://marc.info/?l=mysql&m=120517563300467&w=2
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list a
output file, written to the
current directory.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 t
ed
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 information belongs. The < redirect reads from the "file"
(which, in this case, is actually a redirected STDOUT) into the
database.
--
neinfo |
/usr/local/mysql/bin/mysql -p -u root 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.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailin
configuration variables modified on each end-user system 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
with that? If
so, subscribe and send a message 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
--
Daniel P. Brown
Senior Unix Geek
--
MySQL
HERE t.serial_number IN
(SELECT DISTINCT serial_number,date FROM theTable ORDER BY date DESC
LIMIT 0,1);
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
T t.pass, t.id FROM theTable t GROUP BY t.serial_number ORDER
BY t.date DESC LIMIT 0,1;
That will give only the latest date.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
gt; 4 rows in set (0.00 sec)
Okay, I wasn't aware 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;
--
Daniel
Just be sure to replace 'newpwd' with the password you want to
use. MySQL's PASSWORD() function will handle hashing the password, so
don't send it encrypted or pre-hashed.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
eign key reference. Are there lots of locations with that id 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.
-
a
minute, and MySQL has a GREAT deal of problem servicing all other
database clients.
I've 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 b
, it
included MySQL drivers ( maybe with a configure option ). I'm not sure
if it's still included or not. How did you install PHP? 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
Le
> -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,
> >
>
1 - 100 of 1341 matches
Mail list logo