On 3/25/2017 10:03 AM, Hal.sz S.ndor wrote:
2017/03/24 15:19 ... william drescher:
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last
While loading a database using the mysql command 'source' I see
occasional warnings flash by on the screen.
when it finished I used the command "show warnings," but only one
warning showed (the last one).
How can I see the warnings earlier in the load ?
-bill
--
MySQL General Mailing
On 7/8/2016 9:15 AM, Johan De Meersman wrote:
As a clear example of what it is useful for, imagine a situation where you're
performing an inventory on an existing warehouse. You have the
list of all the
products they've ever sold, but you need to differentiate between
'this product is
not in
On 4/30/2016 3:22 AM, Thomas wrote:
Am Freitag, 29. April 2016, 14:49:57 schrieb william drescher:
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats
On 4/28/2016 5:20 PM, Thomas wrote:
Hi,
I have setup an master slave replication.
This works fine.
I have running an Apache webserver and some other programms accessing the
master.
Whats the standard pocedure if master fail?
I want to start up the programms on the slave by hand and then they
On 3/22/2016 7:49 AM, Lentes, Bernd wrote:
- On Mar 22, 2016, at 12:07 PM, william drescher will...@techservsys.com
wrote:
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list
sent for Bernd, and to see if it works from another sender
--
Lentes, Bernd wrote:
Hi,
i know that there is a list dedicated to replication, but when
you have a look in the archive it's nearly complete empty. Really
not busy.
So i hope it's ok if i
On 6/18/2015 1:25 PM, AZ 9901 wrote:
Hello,
I only get SPAM answers when I try to post to this list so here is a simple
message…
Sorry…
Marc.
your message came through on gmane.comp.db.mysql.general just fine.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 10/15/2014 11:30 AM, a.sm...@ukgrid.net wrote:
Quoting william drescher will...@techservsys.com:
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the in memory
table.
Is this what you are after?
http://dev.mysql.com/doc
Ubuntu 14.04 LTS, MySQL 5.5.38
I have a setup with multiple tables in one database. One is a
memory table. I have replication running to a remote computer
for a hot backup.
I read the manual forwards and backwards but I can't figure out
how to set it up to replicate everything except the
On 9/19/2014 10:59 AM, Don Wieland wrote:
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
the target folder don't matter
that is clearly a *MySQL error* that your *MYSQL user* lack the needed
permissions
Yes i figured that - so the question is, how do I give full permissions to that
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
|
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slave
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next
On 8/29/2014 5:51 AM, Johan De Meersman wrote:
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
yes.
I welcome help from anyone willing. Expertise and willingness
both are important.
--bill
--
MySQL General Mailing
Replication novice
I have a master server at the office and a replication server at
home. This setup has been working for a couple of years.
Occasionally the replication server gets out of sync (usually
following a internet problem and the vpn going down.)
I just stop the slave, make sure
On 3/29/2014 2:26 PM, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL
I am given a table: ICD9X10 which is a maping of ICD9 codes to
ICD10 codes. Unfortunately the table contains duplicate entries
that I need to remove.
CREATE TABLE `ICD9X10` (
`id` smallint(6) NOT NULL AUTO_INCREMENT,
`icd9` char(8) NOT NULL,
`icd10` char(6) NOT NULL,
PRIMARY KEY (`id`),
On 7/26/2013 6:58 PM, Chris Knipe wrote:
The issue that we have identified is caused by seek time - hundreds of
clients simultaneously searching for a single file. The only real way
to explain this is to run 100 concurrent instances of bonnie++ doing
random read/writes... Your disk utilization
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned NOT NULL,
`standing_script` mediumint(9) DEFAULT
On 3/31/2013 7:32 AM, william drescher wrote:
I have a table, schedule:
CREATE TABLE `schedule` (
`schedule_id` mediumint(9) NOT NULL AUTO_INCREMENT,
`provider` varchar(15) NOT NULL,
`apptTime` datetime NOT NULL,
`location` varchar(10) NOT NULL,
`duration` smallint(5) unsigned
of course, Group By
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On 8/20/2012 10:09 AM, Mogens Melander wrote:
On Sun, August 19, 2012 18:19, william drescher wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H' it will change and the row is shown change, but when I go to
examine the
, 2012 11:19 AM, william drescher will...@techservsys.com
wrote:
On 8/17/2012 12:13 PM, Rik Wasmus wrote:
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it does change.
To make it even more wacky, if I (using phpMyAdmin) change it to
'H
On 8/19/2012 5:56 PM, william drescher wrote:
mysql select status from tasks;
++
| status |
++
| W |
++
1 row in set (0.00 sec)
mysql update tasks set status= 'H';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed 1 Warnings: 0
mysql select status
I have a table (tasks) with:
task_id mediumint(9)
status char(1)
priority char(1)
and more fields
when I do the following (using phpMyAdmin):
update tasks
set status='H'
where task_id='1'
I get 1 row affected, but the status does not change when I look
at the row.
If I set it to 'X' it
On 4/16/2012 3:04 PM, Haluk Karamete wrote:
What's the right built in php date function formatting would be to take a
simple date, that's in a format like 05/16/1960 and turn it into a mysql
datetime datatype friendly format?
I don't mind H M S to be as 00:00:00/
wrote my own:
function
as to how I might go
about correcting this problem. Thank you in advance.
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template -|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
://www.mysql.com
DbVis Software AB is a MySQL Network Certified Partner
and have the right to distribute the Connector/J driver.
So what I can't explain is why it works for one and not the other.
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters
. :-(
Today, I got the less than helpful from the support folks at
DbVisualizer and then I contacted the MySQL community. :-)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template -|
--
MySQL General
versions?
I think that might be a next step, but even more expedient would be
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 version and retest.
This looks like an ugly one. I don't envy you.
Gee, thanks for those words of encouragement - NOT! :-)
Regards,
web...
--
William Bulley
of work to do as you suggest is greater than simply
upgrading the 5.1.58 server to 5.1.60 or 5.1.61 server
Thanks for the reply!
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template -|
--
MySQL
of these
concepts. I do, however, plan to have fun this weekend... ;^)
Regards,
web...
--
William Bulley Email: w...@umich.edu
72 characters width template -|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 2/9/2012 8:58 AM, Reindl Harald wrote:
Am 09.02.2012 14:55, schrieb william drescher:
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
so explain
I want to update a date field in a record. if the date in the
field is -00-00 I want to change it to the current date. I
would appreciate suggestions or links on how to do this.
Yup, tried reading the manual, but need a bit of help.
I will be updating another field at the same time.
bill
On 2/9/2012 8:22 AM, Johnny Withers wrote:
Update table set mydate=now() where mydate='-00-00'; should do it.
can't do that because the record is selected by other criteria.
Thanks
bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On 2/9/2012 8:18 AM, Michael Dykman wrote:
untested:
update set mydate = IF(mydate = '-00-00', now(), mydate)
- michael dykman
Thank you very much !
bill
On Thu, Feb 9, 2012 at 8:14 AM, william drescher
will...@techservsys.com wrote:
I want to update a date field in a record
On 1/27/2012 6:00 PM, Peter Brawley wrote:
On 1/27/2012 2:24 PM, william drescher wrote:
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP
On 1/27/2012 3:21 PM, Peter Brawley wrote:
On 1/27/2012 11:18 AM, william drescher wrote:
Is there a way to set the default of a date field to the date
the record is generated ?
bill
Use a TIMESTAMP. Default DATE(TIME) columns with Triggers.
PB
When I try
ALTER TABLE `ptInfo` CHANGE
I have three tables show below which I am querying in a number of ways. e.g.
I have a report which lists number of reports provided compaired to number
which were due over the duration of the project.
I am puzzling over how to select the reports which were due and were
delivered during a week
I have two tables:
PtActive
ptNum // the patient's number
user // the user who made this patient active
expires// when the patient becomes inactive again
primary index: PtNum
PtName
ptNum
sequence
lname
fname
primary index: ptNum, sequence
The table PtName may have multiple
muhammad subair wrote:
On Mon, Jul 27, 2009 at 9:25 PM, Ken D'Ambrosio k...@jots.org wrote:
Hey, all. I'm trying to get indexing -- like, when do you specify an
index name during index creation, is index use implicit or explicit, and,
honestly, how exactly does it work, anyway? I've been
I suffered the same problem, and the following worked for me:
http://www.andy.name.my/2009/03/cannot-create-windows-service-for-mysqlerror0/
Try looking in Control Panel-Administrative Tools- Services and deleting
all the MySQL services.
Well, if your particular problem has a well defined maximum minimum and minimum
maximum (Ie the max(q) 4294967296, because q is a 32 bit unsigned int, and
min(q) -1) then you can do it without any extra joins or sub selects.
select
a,
b,
min(IF(date 100, q, 4294967296)) as min_q,
I'm guessing you are adding a semi-colon (;) to the end of the statement. Its
unnecessary with the \G
- Original Message
From: Jeff Mckeon [EMAIL PROTECTED]
To: MySql mysql@lists.mysql.com
Sent: Thursday, December 6, 2007 12:19:22 PM
Subject: Error: No query specified
When I run a
Use smaller transactions that don't have 140 million rows. When attempting an
action with important data, make sure you can survive the actions failure. If
you can't, then you need to think of a different way of doing it that will
allow a recoverable failure.
- Original Message
If you are going to rely on obfuscation to protect valuable data, you might
want to consider not posting the particular method you will use on a public
mailing list.
I think any method you implement will lower the overall security of the system.
But, if you must search for encrypted text, you
TRANSACTION (2)
Can
anyone explain whats going on? Is there a limit for the number of
concurrent transactions, before looking at the lock graph becomes too
expensive? Is that documented somewhere?
Thanks,
William Newton
Does any one know whats going on? Is this expected behavior?
Thanks in advance,
William
Catch up on fall's hot new shows on Yahoo! TV. Watch previews, get listings,
and more!
http
From: Baron Schwartz [EMAIL PROTECTED]
To: William Newton [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, October 2, 2007 12:05:41 PM
Subject: Re: Full Innodb Table Locks deadlocking with AUTO_INC locks.
Hi William,
William Newton wrote:
Hello List,
I discovered an unusual problem
time mysql is restarted (for example on a reboot).
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
On Mon, March 12, 2007 8:04, Neil Tompkins said:
I've been researching the best method to store credit card numbers in a
database which are saved encrypted. My version of mysql is 3.23 therefore
I
think the only function I could use is
ENCODE() and DECODE().
I've tried these functions and
On Tue, March 6, 2007 9:40, Marcus Bointon said:
On 6 Mar 2007, at 17:12, David T. Ashley wrote:
Best practice is that all times maintained in a database (or
anywhere on the
server) are UTC, and are only converted to local timezone and/or
adjusted to
daylight savings time as required to
On Wed, February 28, 2007 14:10, Ryan Stille said:
I am on 4.1.20-1.
Maybe your OS isn't patched?
Try this: SELECT @@global.time_zone;
Won't help if you are on debian which is still on 4.0.
If you get back SYSTEM, then MySQL is looking to the OS for timezone
data. And its only loaded when
Please post to the list not to me personnally.
Original Message
Subject: RE: [PART 2/2] InnoDB - Different EXPLAINs for same query From:
John Anderson [EMAIL PROTECTED]
Date:Thu, January 18, 2007 10:24
To: William R. Mussatto
innodb_flush_method=O_DIRECT
innodb_open_files=8192
innodb_sync_spin_loops=32
innodb_thread_sleep_delay=1000
innodb_autoextend_increment=1024M
innodb_file_per_table=TRUE
[client]
socket=/tmp/mysql.sock
John Anderson
---
William R. Mussatto, Senior Systems Engineer
http
Have you looked at ubuntu distribution of linux. I think they have a
'school' variant which might be close to what you need. Also, the people
there might be able to give you more help. Good luck.
On Thu, December 7, 2006 9:39, Saqib Ali said:
Hello All,
I know this is little bit off-topic
.
... AND MATCH (title, description) AGAINST ('chev* \malibu\' IN BOOLEAN MODE)
vs
... AND MATCH (title, description) AGAINST ('chev* malibu' IN BOOLEAN MODE)
They both seem to be Ok, but I just want to make sure now, before
wierd problems come up later...
thanks
-william
--
MySQL General Mailing List
Sorry, but I haven't gotten any emails from the list and I'm trying to
determine if there is a blockages. Sorry to disturb the list.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list
hello everybody
anybody had to deal with this?
i have a windows form created on VB.net to get a report on embbeded crystal
reports develop program
im trying to customize the fields to show by using the CR form via Sql Sintax
option for the fields
but the formula editor seems does not
://www.mylasikweb.com
Boothe Lasik http://www.mylasikweb.com/
Dr William Boothe http://www.mylasikweb.com/
Dr Boothe http://www.mylasikweb.com/
Lasik Boothe http://www.mylasikweb.com/
Boothe http://www.mylasikweb.com/
Boothe Lasik http://www.mylasikweb.com/
Dr William Boothe http://www.mylasikweb.com/
Dr
Glenn Kawesch
Dr. Kawesch is the surgical director of Kawesch Lasik--one of Southern
California's most experienced refractive surgery facilities. We have been
specializing in refractive surgery since 1989 and have completed
approximately 25,000 procedures.
Dr. Kawesch attended medical school at
the time might be realistic. It depends on the hardware
you are using and what else is going on on the system.
Hope this helps.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http
hello .
anybody knows how to export from excel to mysql in order to create or fill a
database table??
tanks for your help and patience
cheers
related to each other?
Do you want all the information from each of the tables (which are NOT
related to each other) between the specified dates? If that is the case
you are looking at a UNION rather than a strait JOIN.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph
for the UNION of the
separate information from table a, where it meets its WHERE conditions,
and the information from table b where it meets its WHERE conditions. The
fact that both where conditions are the same doesn't matter. Hope this
helps.
---
William R. Mussatto, Senior Systems Engineer
http
otherwise you are looking at a table scan which is always slow.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Would it not be best to have the field with the fewest repeats (i.e., the
closest to unique) first, or is that what you meant.
Bill
On Tue, October 17, 2006 10:12, Jerry Schwartz said:
I didn't think of that (combinations). You are probably right. Due to my
background, I tend not to think a lot
hello
i'm developing a program on visual.net 2003 where i need to extract data from a
date time format column
working with mysql.net component for extract via mysqlcommands and dataadapters
im fillin datagrills but the column displayed only presents the date but not
the time
im still
Just noticed that you said partitions. I am assuming that you meat
multiple drives in a raid array.
Bill
David Lazo said:
Thanx again.
For the time being, we will keep 4 drives with Dan's suggestion. OS and
MySQL running from there.
On 8/25/06 11:03 AM, Dan Buettner [EMAIL PROTECTED]
A couple of comments:
- Simultaneous connections can be increased, but at some point the user
than runs the mysqld process will run out of file handles it can allocate
(each table takes 2 or 3).
- If we are talking about a database server and test server being the same
box then what are you trying
customers can have the same issue (row) then you will need an
intermediate table which has two columns: customerID and issueID.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
Thank you very much!
-Original Message-
From: Visolve DB TEAM [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 15, 2006 12:44 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: Incrementing using Max(Field) ?
Hello William
Try the below Query to insert next maximum value
be an issue, but I
am not able to change its schema.
Thank you.
- William
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for the right syntax to use near 'select
obj_act_id from c2iedm_dev2.act_functl_assoc where subj_
I have looked at the documentation for MySQL and this seems to be the
correct syntax for using IN.
Could someone please let me know what is wrong?
Thank you.
William DeMasi
--
MySQL General Mailing
Oops, the version numbers were 4.1.18-nt and 4.1.19-standard. I have tried
it now on the latest 4.1.20 version and still have the same problem.
Does anyone have any ideas? Is this a bug?
Cheers,
Bill
-Original Message-
From: William Bronsema
Sent: Thursday, July 20, 2006 10:18 AM
Hello,
I am encountering a strange issue when using the STD function. On my local
development machine (MYSQL version 4.18-nt) I can run the following basic
SELECT query with no problems:
SELECT STD(`LAPSETIME`),UKEY FROM 4b3f91f64a19529a84dff4982c8a6bc5 GROUP BY
UKEY
When I test this query on
. These
last 50 might be the most recent entries, for example. Can
this be done
in single query?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake
St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
---
William R
Dear Sir,
I have a database with over 80 tables. Is there an easy way to find table
names that has PERSON_ID field using SELECT query?
Thanks in advance for any help.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
romyd misc said:
Hi Everyone,
I'm developing an application using C# .NET and mysql as database. It's a
multithreaded application, we open a mysql database connection at the very
beginning when the application is started and all the database requests
use
the same connection. But under
Is it possible to setup replication so you would have another server to do
backups on? Replicate the data, do whatever you want to the spare, and then
delete the data from the production server.
On 4/19/06, balaraju mandala [EMAIL PROTECTED] wrote:
Hi Everybody,
I need a suggestion
Sample Data:
ID-Row1-Row2
1-A-B
2-A-B
Row1 and Row2 are duplicate, so you only want one. Which ID do you want?
-will
On 4/17/06, Patrick Aljord [EMAIL PROTECTED] wrote:
hey all,
I have a table mytable that looks like this:
id tinyint primary key auto_increment
row1 varchar 150
row2
If the ID doesn't represent anything, you can
CREATE TABLE new_table SELECT DISTINCT Row1, Row2 FROM old_table
And then recreate your index(es).
All your autoincrement IDs will be changed.
On 4/17/06, Patrick Aljord [EMAIL PROTECTED] wrote:
On 4/18/06, William Fong [EMAIL PROTECTED] wrote
error
number 2003 stating I can't connect to MYSQL server. Is there something
that someone can suggest?
Thanks,
Chuck
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives
need to specify that the index is UNIQUE (see changes above)
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Some more information can be found here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
On 12/31/05 7:29 PM, JJ [EMAIL PROTECTED] wrote:
I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
why MySQL Adminstrator says the table has 497 rows, while doing a
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again!
-Bill
On Dec 14, 2005, at 6:59 PM, Michael Stassen wrote:
William R. Dickson wrote:
OK, I strongly suspect I've just done something stupid here
to work properly, and it seems
to have problems if this feature is disabled.
Thanks,
-Bill
On Dec 19, 2005, at 7:34 AM, William R. Dickson wrote:
This did the trick. Many thanks. I had found that option, but
misinterpreted what I read; I thought it was only available in 4.x.
Thanks again
OK, I strongly suspect I've just done something stupid here, but I'm
having trouble figuring it out. I had a disk go bad on a MySQL server
this past weekend. I did a clean system install (FreeBSD 5.4) on a
new disk, installed the MySQL 3.23 port, and restored the mysql data
directory from
I'm trying to relocate the database files for MySQL 4.1
I've seen two primary techniques for doing this:
1) create/alter a my.cnf file with 'datadir' set to new location
2) moving the physical files and creating a symlink in the original location
Unfortunately, neither of these methods work for
this.
---
William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
William R
Gleb Paharenko said:
Hello.
In my opinion, one of the causes of the problem can be the processing of
trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
Thanks, you may be right since the results are too short.
William R. Mussatto [EMAIL
Hello,
I'm not sure if this question is more appropriate for general discussion
or the internals list.
I want to create a tokenizer/lexer for MySQL's dialect of SQL to use in
a JAVA application. I thought I could do this by creating a JAVA
wrapper on the lexer code for MySQL. I looked
1 - 100 of 415 matches
Mail list logo