Hi John,
Starting over….
What is the "error message"?
Terry
___
Terry J Fundak
Systems Engineer
Network Design and Security Solutions for SMBs
Tech Support - Client and Server Systems
TJSoftworks
1834 Chadwick Court
Santa Rosa, CA 95401
(707) 849
Hi, All,
I am having trouble to transfer email user account which is saved in
MySQL to another server. Here is the detail:
I have an old email server which using MySQL to store user account
information. The password field uses MySQL ENCRYPT function to save the
users password. So if I want c
sorry.. im using 5.1
On Wed, Jul 11, 2012 at 10:09 AM, J M wrote:
> hi all,
>
> our DB crashed for some reason... any inputs would be greatly appreciated..
>
> 120711 8:12:21 - mysqld got signal 11 ;
> This could be because you hit a bug. It is also possible that this bina
hi all,
our DB crashed for some reason... any inputs would be greatly appreciated..
120711 8:12:21 - mysqld got signal 11 ;
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. Th
Thank Baron,
i want to see if there is something i can do from the DB end.
and BTW, i've been using the plugin already.
On Thu, May 31, 2012 at 1:01 PM, Baron Schwartz wrote:
> In this case the solution is much easier outside of MySQL than inside.
> http://ocaoimh.ie/wp-super-cache/ i
hi all,
i have an issue with our db which hangs and the only way to
recover from it is to restart mysql if you had console access or
restart the box itself ( only if i can't wait )
show processlist result can be found here: http://pastebin.com/BYvZ5ZFR
listed below are info about
On Mon, 09 Apr 2012 13:17:55 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 13:05, schrieb J. Bakshi:
> > I have reset these two now
> >
> > ` ` ` `
> > key_buffer_size=200M
> > innodb_buffer_pool_size=4G
>
> [!!] InnoDB data size / buffe
On Mon, 09 Apr 2012 12:06:42 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 11:56, schrieb J. Bakshi:
> > On Mon, 09 Apr 2012 11:47:01 +0200
> > Reindl Harald wrote:
> >
> >>
> >>
> >> Am 09.04.2012 10:57, schrieb J. Bakshi:
> >>
On Mon, 09 Apr 2012 11:47:01 +0200
Reindl Harald wrote:
>
>
> Am 09.04.2012 10:57, schrieb J. Bakshi:
> >
> > Hello,
> >
> > I have been provided a muscular linux server to use as a Mysql server
> > in our organization. The server is located just be
Hello,
I have been provided a muscular linux server to use as a Mysql server
in our organization. The server is located just beside the web server
and within the same network. This dedicated server has 8GB RAM, i5 processors
and running mysql as service. No apache, php . nothing. All re
>Jan Steinman wrote
>If not, how 'bout the best of both worlds: create a UNIX (or perl) script that
>loops
>through the country names and creates an SQL script? That would be fast
>entering AND fast
>performing!
Good suggestion. But I am a perl/unix illiterate. However I may learn
in them future
ange. Probably I could convert empty cells to NULL
and then use 'IS NOT NULL' condition as an alternative (this works
now).
Yes, I've now removed back ticks now, but it seems I need to use
single quotes for '${x}'-without the single quotes I get error
messages.
On Thu, Apr 5
Thanks to Rick I would go for a single table. I tried the following,
but hasn't been successful yet. First I created one 'master' table for
one country, with a country column (ctry) as Rick suggested, then I
tried to use the loop suggested by Johan to insert the records for
each of the remaining co
Thanks. I was looking for a loop--not to gain speed but to reduce the
length of my script file:) I'll try and hopefully it will work!
J
On Wed, Apr 4, 2012 at 12:16 PM, Johan De Meersman wrote:
> - Original Message -
>> From: "joe j"
>>
>> So what
I was wondering if any one could point out potential problems with the
following query or if there was a better alternative
>From a list of users I want to return all who don't have all the specified
user_profile options or those who do not have at least one preference set to
1. The following quer
ok. here's what I am trying now. First create a table with the code
below with a list of countries that have the two person names I want.
CREATE TABLE `table_new` SELECT t1.country
FROM `table_old` as t1
JOIN
`table_old` as t2
USING(country)
JOIN
`table_old` as t3
USING(country)
WHERE (t2.`person_n
Thanks, but I don't see how it will work. Am I missing something?
On Tue, Jun 7, 2011 at 5:24 PM, Willy Mularto wrote:
> Why not GROUP BY?
>
>
>
> On Jun 7, 2011, at 10:06 PM, joe j wrote:
>
>> Dear all,
>>
>> I wish to create a new table from a tabl
Dear all,
I wish to create a new table from a table that has two columns
"country" and "person_name". Thus from the table below, I'd like to
select all the records of those countries that have person names 'Tom'
and 'Kevin'.
"country" "person name"
US Antony
US
ase stats are useless without
> knowing the configuration and without knowing your hardware (memory!)
> nobody can say what buffers are making sense
>
> i would use "mysqltuner.pl" because it shows in the most cases good
> advises
>
> Am 05.05.2011 20:42, schrieb
Hi,
I have this stats: I have tuned some of it but I was wondering if someone
can give inputs regarding it:
*
__ Key _
Buffer used54.63M of 384.00M %Used: 14.23
Current 123.21M%Usage: 32.09
Write hit
ose entries are no
longer relevant, or are overblown, or whatever, i'd appreciate it.
again, i'm not taking sides, i just want to make sure the information
is as accurate as possible. thanks.
rday
--
==
i just want to verify
that, if that's all i have access to and some of the tables still
appear to be missing, there's not much i can do. or is there?
rday
--
====
Robert P. J. Day Wate
I have been looking high and low but am having trouble finding good
info. I need to try to lock down mysql with strong passwords
password expiry yadda yadda. I've looked at securich and am not sure
I want to use it.
All I really want is to prevent users from be able to change their
pa
A simple way to do this is to truncate the date and then GROUP BY it. So if
you have 2009-08-08, and you want a subset on month, then just truncate the
day-part: 2009-08-00 on the whole column, and SELECT DISTINCT so you have a
subset. You can use this subset then to join the dates, GROUP BY and
mo...@fastmail.fm (mos) writes:
> At 08:06 PM 7/12/2009, Morten wrote:
>
> If you can get rid of the DateTime and switch to just Date it may
> speed up the indexes.
While not as pretty it's more compact to convert timestamp values into
an bigint. For example: seconds since epoch. If you know th
russbucket wrote:
>
> I agree with you, but phpMyAdmin is not available for Windows that I'm aware
> of. The person I'm helping today is a windows user and except for a little
> Access Experience does not do databases well. I have the database set up in
> mysql so thats what I am hoping to get h
g...@primeexalia.com (Gary Smith) writes:
...
> In database G we have 150+ stored procedures.
150k stored procedures? Sounds "rather large". Do you really need this?
> What's the best approach to fix this problem? Is it as simple as adding the
> appropriate USE statement inside of the stored
mo...@fastmail.fm (mos) writes:
> At 12:37 AM 6/25/2009, you wrote:
...
> >my.cnf based on my-huge.cnf, expanding key_buffer to 8G,
> >myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
> >disk.
>
> You mean "key_buffer_size" don't you and not "key_buffer"? If you
> a
I'm looking to engage a developer with php / mysql experience in
Adelaide, Australia for full time employment or contract basis.
Please email me if you are interested.
Regards,
Frank
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.
per...@elem.com (Perrin Harkins) writes:
> On Wed, May 27, 2009 at 6:43 AM, Simon J Mudd wrote:
> > So is the format of the DELETE FROM .. WHERE ... IN ( ... ) clause I
> > propose valid and SHOULD the optimiser recognise this and be expected
> > to just find the 2 row
This is in 5.0.68 and 5.1.34.
I'm trying to cleanup some old data in a table which looks like the following:
CREATE TABLE `transaction_history` (
`customer_id` int(10) unsigned NOT NULL default '0',
`transaction_id` int(10) unsigned NOT NULL default '0',
`first_timestamp` datetime NOT NULL def
On Fri, May 15, 2009 at 12:48:18AM -0700, Scott Haneda wrote:
>
> Also, how do I set the slave to be read only? I set read-only in
> my.cnf and it made all databases read only.
SET GLOBAL read_only = true;
and as you've done in the my.cnf file.
Unless the user has SUPER rights he can't chang
On Thu, May 14, 2009 at 04:45:44PM -0700, Scott Haneda wrote:
> >It's true that initial mysql replication setup is a bit fiddly, but
> >once you've done it once or twice it's not so hard.
>
> I have it set up and working in test. I will redo it again once I get
> a better handle on it. I am
replying only to the list...
On Wed, May 13, 2009 at 10:19:21AM -0700, Scott Haneda wrote:
> >3. Configure on the slave the replication (which databases need to
> >be replicated)
>
> This is where I need a little clarification, is the only thing I need
> to do is adjust my.cnf to have in the
talkli...@newgeo.com (Scott Haneda) writes:
> Hello, I am confused about repliction setup. Reading a config file,
> and the docs, leads me to believe this is an either code choice, pick
> #1 or #2. If that is the case, why would I want to use #1 over #2?
>
> My confusion comes from several onli
kimky...@fhda.edu ("Kyong Kim") writes:
> I don't have all the details of the schema and workload. Just an
> interesting idea that was presented to me.
> I think the idea is to split a lengthy secondary key lookup into 2 primary
> key lookups and reduce the cost of clustering secondary key with pr
compu...@videotron.ca (michel) writes:
> I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld
> and I would get
>
> /home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
>
> 090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade
compu...@videotron.ca (michel) writes:
> I set up MySQL and when I try to start it it fails telling me that I
> need to run 'mysql_upgrade'.
Show us the full error output and provide information on the version
of MySQL you are using.
> When I run 'mysql_upgrade' it runs
> 'mysqlcheck' which is s
kimky...@fhda.edu ("Kyong Kim") writes:
> I was wondering about a scale out problem.
> Lets say you have a large table with 3 cols and 500+ million rows.
>
> Would there be much benefit in splitting the columns into different tables
> based on INT type primary keys across the tables?
To answer y
abhishek@gmail.com (Abhishek Pratap) writes:
> I am kind of stuck with this query , cant expand my thinking. May this is a
> limitation. Here it is
>
> I have a database with many cols two of which are start and end position for
> an event.
>
> Now I have a list of event time stamps, I wan
nik...@doppelganger.com (Nikita Tovstoles) writes:
> We have a java-based webapp that talks to MySQL 5.1 INNODB in READ_COMMITTED.
> We use Hibernate and optimistic concurrency, so periodically concurrent write
> attempts cause app-level Exceptions that trigger rollbacks (and then we retry
> tx
On Wed, 2009-03-18 at 13:54 +0100, Claudio Nanni wrote:
> This is not a list for job posting, there are specific sites for that.
> If we consider useful a 'private' list for job postings we can ask a new
> one.
> I understand every thing about the need of a job but it can be done in a
> better way
On Tue, 2009-03-17 at 17:10 +0100, Jon Stephens wrote:
> Please don't post off-topic mails to the MySQL Cluster list.
Jon hi, I couldn't see anything that read such posts were not permitted.
That said, I have tried to present the post as clearly and informative
as possible. Hope people agree.
I
Hi Everyone
I am interested in how to get an XML request to query a database. I'm working
on generating the XML requests OK, I just need to know how XML meets database.
Are there any generalised pointers to begin with?
Thanks in advance
Jonathan Trahair
LTER TABLE `jobsearchtwodb`.`jobposts` ADD CONSTRAINT `adsourcefk`
FOREIGN KEY `adsourcefk` (`adsource_id`)
REFERENCES `adsource` (`adsource_id`)
ON DELETE RESTRICT
ON UPDATE NO ACTION;
ON DELETE RESTRICT having the behavior like ON DELETE CONSTRAIN?
--
Lola J. Lee Beno - ColdFusion
happen. I can't use triggers because for some reason I
can't get the triggers working properly. Is there any way I can do this
on the database side without having to write code in the application
code I'm working on?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer f
prajapat...@gmail.com ("Krishna Chandra Prajapati") writes:
> You are running three mysql instance on single server. You can have three
> my.cnf say my.cnf, my1.cnf, my2.cnf with different port and socket and other
> information in them. In this way you can set the prompt for different
> instance.
SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use near 'if @counted >= 1 then SET dummy = 'Cannot
delete this record' end if' at line 1
Query = if @counted
>= 1 then SET dummy = 'Cannot delete this record' end i
h a JOIN clause and to put your
strings inside single quotes as per SQL standard, double quotes are
really for object names.
Right . . . I'll get the JOIN clause figured out after I figure out
what's causing the above error message.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designe
and adsource tables BEFORE proceeding to delete the
record. If so, what's the best way to do this?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
"In rivers, the water that you touch is the last of
"id"? Maybe
Yes. Jobpost_id. No, not a typo. It's primary key,
jobposts.adsource_id is foreign key while adsource.adsource_id is
primary key.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/b
eting jobpost record -
that's what I'm trying to do and thus is what this trigger is supposed
to do.
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http://www.lolajl.net/blog/
"In rivers, the water that you touch is the las
t delete this record" end if;
end //
delimiter ;
When I run the set query without the "and old.jobpost_id" line, it runs
correctly. So the syntax problem is elsewhere, but where?
--
Lola J. Lee Beno - ColdFusion Programmer/Web Designer for Hire
http://www.lolajl.net/resume | Blog at http:/
[EMAIL PROTECTED] (Shain Miley) writes:
> I am trying to plan we in advance our methods for backup and recovery
> of our new MySQL replication cluster. After doing some research it
> looks like a lot of people are using LVM snapshots as their backup
> solution. We currently have two MySQL serve
[EMAIL PROTECTED] (Shain Miley) writes:
> I am looking into the idea of setting up 10 - 15 virtualized instances
> of MySQL. The reason for this is as follows...we are going to be
> setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2
> slaves-ro)...each having 16 to 32 GB of RAM
[EMAIL PROTECTED] (Shain Miley) writes:
> 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 at least one master (writable)
[EMAIL PROTECTED] (hezjing) writes:
> When and why we create tables in different storage engines within a same
> database?
>
> Take for example a normal inventory application that provides CRUD operation
> to
> - USER table (e.g. create new user)
> - STOCK table (e.g. when there is new stock arri
[EMAIL PROTECTED] ("Carl") writes:
> I am running 5.0.24a on Slackware Linux. I would like to set up a
> master-master replication process so that I can use both servers as master as
> add/delete/update records on both servers from different application servers
> (Tomcat.) I suspect the inser
[EMAIL PROTECTED] (Mike Aubury) writes:
> I'm probably being a bit stupid - but I'm trying to determine (in code) the
> length of the string in the schema for a given table.
>
> So - for example :
>
>
> create table a (
> blah char(20)
> )
>
>
> I want to return '2
Hi All,
On OS X, I have some Obj-C that creates NSTasks to execute some sql
statements.
What do I deploy on the client to make this work for them? I want to
make it park of my package installer, but I dont know what pieces.
Thoughts?
-Jason
--
MySQL General Mailing List
For list archiv
[EMAIL PROTECTED] (Database System) writes:
> There were no any error message on console or in error log.
>
> The symptoms are
> 1) the binary log file goes to /data/mysql/data/ dir, not as defined in
> /data/mysql/log/
> 2) the binary log files name start with "mysql-bin", not as I defined in
enome-mysql.cse.ucsc.edu
db.user=genomep
db.password=password
But I really don't think the people I'm trying to teach here know much
about Genome Bioinformatics (and ah consequently I don't know anything
about that either...)
Thank you,
Andrew J. Leer
--
MySQL General M
[EMAIL PROTECTED] (Josh Miller) writes:
> I have recently become responsible for a LAMP site which has a decent
> MySQL install (v5.0.24a). The database is around 40GB with a single
> master to single slave replication scheme, although all activity goes
> to the master at this time, with the exce
[EMAIL PROTECTED] (Pawel Eljasz) writes:
> there is a user with following grants:
> GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD
> 'x'
> is it possible to:
> revoke all on *.* from $above_user OR revoke usage on *.* from $above_user
> ?
DROP USER [EMAIL PROTECTED];
Simo
I think you'll find that's BIGINT, max INT is 11
Moon's Father wrote:
The maximum width is int(20).
On Thu, May 22, 2008 at 5:15 PM, Saravanan <[EMAIL PROTECTED]> wrote:
what kind of datatype it is int(50)
parent_id| int(50)
is that big int?
Saravanan
--- On Thu, 5/22/08, Norb
> I would have thought your not = though is matching a lot more rows every
> time..
The field is UNIQUE PRIMARY KEY in both tables, so there
should be 0 or 1 matches.
> I would look into using where not exists as a subselect
My MySQL book (O'Reilly second edition) does not mention
subqueries or
I have two MyISAM tables; each uses 'phone' as a primary key. Finding
rows where the primary keys match is efficient:
mysql> explain select bar.phone from foo,bar where foo.phone=bar.phone;
++-+---++---+-
+-+---+---+--
Hello folks,
Any way to retrieve the error code/error number from a stored proc.
Scenario
--
calling a stored proc from PHP - using mysqli_multi_query()
The stored proc has multiple queries. Lets say one of the queries generates
an exception.
How do I retrieve the error message w
to create a table containing only
> that column and a PK that is equal to the PK in the original table. You
> might also keep a portion of the text field (say 50 characters) in the
> original table, for head-first indexing.
>
> Arthur
>
>
>
> On Tue, Mar 25, 2008 at 9:56
size to about 2 GB. My question is: When mysql adds
indexes to the keycache, does it add each index individually or does
it dump the entire .MYI file to the keycache. If it is the latter, I
should move the fulltext index to another table.
Thanks in advance,
Christian
--
J. Christian Hesketh M.Sc
Hi All,
I have a client that wants to insert data into a VarChar field that contains
commas. These are property addresses.
Example:
2966 Moorpark Ave, San Jose, CA, 95128
1 Infinite Loop, Cupertino, CA, 95
How can I allow this?
Thanks!
-Jason
:
- SQL Server doesn't support LIMIT clause;
- Don't use quotes for numerical values as it works on MySQL only;
- In GROUP BY clause, list all not aggregated columns you are selecting;
- Use single quotes for strings;
Hope it helps.
On 1/23/08, J Trahair <[EMAIL PROTECTED]> wrote:
Hi Everyone
I am now familiar with connecting with MySQL using Visual Basic 6 and ADO. I am
about to start a new project which must connect to a customer's MS SQL Server
2005 installation.
How safe/unsafe is my assumption that as far as SQL strings and ADO connections
are concerned 'if it work
In my experience, having a limit of a particular number of anythings per
something, eg. components per compound word is always a mistake, whether it's
the number of payments allowed to pay an invoice, the number of children per
parent, the number of cars per family, pets per owner, etc. There's
This is a question I want to know the answer to, as well! Is there any way of
avoiding looking up a specific record in a table to see if it exists, before
deciding whether to INSERT INTO or UPDATE, eg:
mstrSQL = "SELECT * FROM Shops WHERE ShopReference = '" &
grd1.TextMatrix(numRowNo, 1) &
Hi Everyone
I have a database with an OrderItems table, containing (at least) 3 fields,
namely ExtendedPurchasePrice, CurrencyConversion and
ExtendedPurchasePriceSterling, all fields as doubles.
I want to update ExtendedPurchasePriceSterling for each row with the result of
the calculation
Ext
Hello All,
I set up replication between 2 servers recently. I just need one db to be
replicated and the SHOW SLAVE STATUS shows this:
Relay_Master_Log_File: gyana01-bin.02
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: tallydb,tallydb
Now the problem is that there is anoth
What about the MySQL Administration backup routine, which can be scheduled for
a convenient time? No-one has mentioned this one. We use it but perhaps there
is something I should know...?
Thanks
Jonathan Trahair
- Original Message -
From: B. Keith Murphy
To: Dan Buettner
Cc:
Hello All,
I need to add a couple of more tables to the list of tables to be replicated
from a particular db in the salve my.cnf.
Can this be done without restarting the mysql server on the slave?
Thanks & regards,
Ratheesh
Hello all,
I cannot afford to stop my slave server. I have list of tables of the master
that are being replicated on the slave.
Now I want to remove a couple of tables from this list without affecting the
master and slave. How is this possible?
Thanks & regards,
Ratheesh
@all,
Currently we run all our complex reporting queries on a different server. We
are not using replication though.
What we are doing is to restore the backup of the live data every night onto
the reporting server. So we are running reports on data that is not real time.
And we are OK with tha
Hello all,
What is the best possible values in my.cnf for a 8 processor (Quad core-2 cpu)
8 GB RAM machine dedicated for MySQL server only. No other application will run
on this machine.
the innodb_buffer_pool_size cannot accept values above 2000 MB due to 32 bit
machine constraint. So what ot
and has been skipped from the relay log?
4.. How do I know immediately that replication has failed? ( have heard that
the enterprise edition has some technique for this )?
Thanks & regards,
Ratheesh
- Original Message -
From: "Jan Kirchhoff" <[EMAIL PROTECTED]>
To: &q
Hello all,
I issued a create table statement on the master for a table which was not
present on the master but present on the slave.
I did this purposely to see the error on slave.
I am a newbie to replication. Now when i see SLave status on the slave machine
it shows that the SQL Thread has st
Hello All,
I just wanted to know whether there are any known issues in defining and using
Foreign key constraints in MySQL 4 and MySQL 5.
To be specific, are there any issues on using ON DELETE CASCADE and ON UPDATE
CASCADE?
Would there be any performance issues when we define Foreign key const
On Wednesday 11 July 2007 00:34, Anders Karlsson wrote:
> UNION will only return distinct rows. This is according to spec and to
> the SQL Standard.
And of course, to no one's surprise, this also matches the mathematical
definition of union:
j
--
Joshua Kugler
Hello,
I've got a strange issue and was curious if anyone might be able to
shed some light on the issue. About 2-3 times an hour (not
predictable) we see huge bursts of syscall behavior (150,000-200,000
over a 2 second interval). This is on MySQL-5.1.14 on a Solaris 10
AMD64 box.
Using DTrace we
Hello All,
I want a clarification. Whe run a forum wherein people send messages
with/without attachments. Attachments may contain images, documents etc.. We
are actually storing the attachment in a blob column. Sometimes the attachments
are big. And today the table size has grown to 40 GB. This
Hello,
I've got a table that originally was using UTF8 charset and collation.
However, I upgraded one of my applications which is hardcoded to
Latin1_General_CI collation in its queries. As a result, I altered the
table and any specifically set columns to use Latin1 as the charset
and Latin1_Gene
Hi Everyone
Is there a way of replicating or cloning the structure of an existing table and
giving it a different name? I have a table of items on sale in the shops, I
want to create a table of items not yet in the shops but due to be introduced
very soon.
MySQL 5.0.37 Windows XP.
Thanks in a
?
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Ratheesh K J" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, May 15, 2007 2:42 PM
Subject: Re: Data security - help required
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret i
Hi Everyone
I have set up a scheduled backup using MySQL Administrator. Stored connection,
database, dates and time, even the Windows user password (in fact, blank). It
doesn't start at the correct time, or indeed any time.
Have I missed something?
Thanks for your help.
Jonathan Trahair
This is our problem:
http://bugs.mysql.com/bug.php?id=27210
Thanks,
Paul
Baron Schwartz wrote:
Hi,
Paul J. Boyes wrote:
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly
inserting/updating data. However
Hello,
I am hoping to get pointed in the right direction/save some time...
I have a db in which some web services are constantly inserting/updating
data. However, when I run selects from the command line mysql app, I do
not see the changes that these services have made unless I do a flush
ta
Thanks Baron, that hit the spot.
Thanks again.
Jonathan
- Original Message -
From: J Trahair
To: MySQL General
Sent: Saturday, May 05, 2007 9:00 PM
Subject: Error message on trying to start service
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
re
Hi Everyone
I had to re-install everything after Norton crashed my hard disk. I
re-formatted.
I am trying to install MySQL using the same installation files and method as
before.
MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed
OK.
However, I cannot complete t
Great. That is the assumption under which I have been working. I was
really hoping for confirmation. I appreciate it! Thanks for
responding.
Thanks,
Paul
Chris Comparini wrote:
On Wednesday 21 March 2007 16:31, Paul J. Boyes wrote:
Hello,
I have a fairly sizeable aggregate
large number of reads? Will it work? What are the drawbacks?
Having never done this with MySQL, I am hoping to get some advice from
others who may have attempted this, are in the know, etcAny info you
can provide would be greatly appreciated.
Thanks,
Paul J. Boyes
--
MySQL General
onference, I usually go for the
conference, and couldn't care less if there is other stuff to do in the area
during the off hours.
j
--
Joshua Kugler
Lead System Admin -- Senior Programmer
http://www.eeinternet.com
PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE
PO
Hello,
I have a master that's been running since the 13th of January. Since
the same date I've had a slave running against it, without any errors
or serious lag. Suddenly, this morning replication broke with
duplicate entry errors. My master claimed to be on mysql-bin.14
with a significant LO
1 - 100 of 893 matches
Mail list logo
