On 29/02/2016 19:54, Gary Smith wrote:
However, if TDE is employed, then you've got another significant
obstacle to overcome: The data is only encrypted (aiui) once it's in
memory.
Apologies, that should read "unencrypted (aiui) once it's in memory"
Gary
--
MySQL General Ma
to do attacks on RAM to get access
to the data - and even then, you're unlikely to get 3 bars for a jackpot
payout of the whole database schema, assuming a decent sized database.
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
ce command will cause the data to poo all over
the original dataset. As you mentioned in your (snipped) reply, this can
go badly wrong in a short space of time without the correct controls in
place. Even if they are in place, I'd have trouble sleeping at night if
this were my circus.
Gary
--
MyS
tion be the magic
word you're after?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
update_time column works for MyISAM, not for InnoDB.
On Mon, May 4, 2015 at 10:19 PM, Martin Mueller
martinmuel...@northwestern.edu wrote:
So, if you want to have a permanent record of when a table was
created‹never mind subsequent adjustments, you should personally enter the
data as a table
and cat 5, I want their name only to show up once. Here's what I have so far,
but it shows a member listed more than once.
select distinct ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Thanks, Shawn; I knew there was a better way to go about that.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
a java or C++
program to do this, but it seems like overkill for what should be a trivial
task.
Thanks for any pointers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Specifically, replace % with _ as this means match one character not
match any number of characters. So, you can do:
like W1 %
like W1_ %
etc.
Does that help?
Gary
--
MySQL General Mailing List
For list archives: http
On 24/04/2012 17:16, Gary Smith wrote:
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Specifically, replace % with _ as this means match one character not
match any number of characters. So, you can do:
like W1 %
like W1_ %
etc.
Oh, and you can also get really dirty
anything starting W13.
like 'W1U %' to return anything starting W1U.
It's the location of the space before the wildcard that's important
here. The space is taken as part of the known element of the string.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On 13/02/2012 22:09, Haluk Karamete wrote:
Gary,
you've mentioned that the user would have had access to the sysobjects
No, there's a difference. *If* they had access to sysobjects then it
could've caused issues.
Ideally, you should have some level of segregation within your database
would prove that the user had access to the sysobjects
table (ie wasn't constrained within a view, etc).
The second is - the char(124) evaluates to |user|=0. I'm not sure what
this one does, tbh.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
could direct me to what to
post I would be appreciative.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing List
property on your second table, and just use the value
derived from the first as the joining key in the second. Then there
is only one sequence to worry about with nothing to sync against
- michael dykman
On Fri, Apr 15, 2011 at 10:33 AM, Gary gp...@paulgdesigns.com wrote:
I have a innodb
'] != '' ) {
die(Changed field);
}
Again, I see no reason you could not call last_insert_id() after the
first insert and use that value explicitly in the second.
I'm not sure I undertand this, could you explain a little further for me.
Again, thank you for your help.
Gary
Michael Dykman
I'm sorry, I am unfamliar with an asc file, so I have not opened them.
GAry
Reindl Harald h.rei...@thelounge.net wrote in message
news:4da87554.8030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415
.
I also took the advice to moved the honey pot code out of the middle of that
code and moved it up.
Again, thank you.
Gary
Reindl Harald h.rei...@thelounge.net wrote in message
news:4da87902.9030...@thelounge.net...
__ Information from ESET Smart Security, version of virus
of practice and fourth for articles?
I would enjoy hearing opinions on this.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 5868 (20110212) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General
'] . '/td';
'/tr';
}
echo '/tablebr /';
}
All but the first row in alphabetical order are displayed properly.
Can anyone tell me where I am going wrong?
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 5715 (20101219) __
The message
recall why I had it in the first place.
if (mysql_num_rows($result) == !'0') {
$row = mysql_fetch_array($result);
Again, thank you for your help.
Gary
Johnny Withers joh...@pixelated.net wrote in message
news:aanlktik3nhjqkc00iw-nv1qqpdeaj1_5xtwbf7skd...@mail.gmail.com...
Your very first
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand anand@gmail.com:
Hi guys,
i am facing a serious issue with my replication , i tried so many things but
no luck.
my replication is running with mysql 5.0.51a in master and 5.0.90 in slave.
we run LOAD
? Is this something to worry about? I had
(or so I assumed) plenty of protections on the files, including one of the
more popular anit-spam/injection attack systems.
Any guidance on this would be appriciated.
--
Gary
__ Information from ESET Smart Security, version of virus signature
have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'PRIVILAGES ON *.* TO 'g...@supercrunch' IDENTIFIED
BY 'qatip' WITH GRANT OPTION' at line 1
Leaving out the quotes makes no difference.
Gary R
--
MySQL General
wrong?
Thank you.
Gary
__ Information from ESET Smart Security, version of virus signature
database 5063 (20100426) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thanks for the replies. It was my understanding that whitespace is ignored,
and I did not think that not having space, in particular with . would
result in an error message.
Gary
Gary gp...@paulgdesigns.com wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I cant seem
';
if (is_file($row['image_file'])) {
echo 'tdimg src='.$row['image_file'].' width=100px
height=100px//td';
}
As a bonus question, does anyone have any idea why the image would show up
in IE9, and not FF?
Thanks for your help.
Gary
__ Information from ESET NOD32 Antivirus, version
will try to apply your solutions to the original problem.
Thanks again for your reply.
Gary
Colin Streicher co...@obviouslymalicious.com wrote in message
news:201004122103.15609.co...@obviouslymalicious.com...
Normally I would avoid getting into this sort of argument ( The 'OMG
someone
hopefully I will learn from my mistakes.
Thanks for your help.
Gary
Chris W 4rfv...@cox.net wrote in message
news:4bc47b0b.7020...@cox.net...
I have no idea how you got here but there is no reason to do it that way.
This will work just fine and I do it every day in php.
However I don't use mysqli
Seriously
You should read your answers before you post, the SA link did not provide
the answer. Had you read the page you sent, you would notice it does not
apply to mulitple tables...
Gary
Colin Streicher co...@obviouslymalicious.com wrote in message
news:201004112310.16594.co
);
?
It seems a bit redundant for php, but it seems to work.
If by the way anyone sees a problem with this solution, I would love to read
it.
Again, thank you for your response.
Gary
Michael Dykman mdyk...@gmail.com wrote in message
news:s2p814b9a821004121404ge4415a07tbb2ab1bbba1fd...@mail.gmail.com
). I also tried writing the $query as an array, which got me an
error message (saying it was expecting a string and I offered an array).
Someone point me in the right direction?
Gary
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd
Krishna Chandra Prajapati wrote:
Hi guys,
Is the information is true.
http://planet.mysql.com/
http://tokutek.com/2010/04/tokutek-acquires-oracle/
Might want to check the date.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e select * from table into outfile '/path/to/output/file'
fields terminated by '|' ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
hospital codes by doing
select distinct code from hospital.
Apologies if this isn't possible.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, but as a
single column. Essentially, hospital1code, hospital2code and
hospital3code need to be merged to a single column, deduped, and then
returned.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
a new one as it was when it
was exported. Is this what you're after?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
what you're wanting to do.
Do you have any primary keys/auto increment columns that are going to
overlap or anything like that?
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
the years, but I'm not aware of another way to do what
Patrice is trying to do.
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
attended Sun's MySQL DBA course
(http://www.mysql.com/training/schedule.php?class=5200) which I can
heartily recommend. The course covers the kind of things you're after,
including indexing, how the engines work (ie pros and cons), backups, etc.
Cheers,
Gary
--
MySQL General Mailing List
for however long it takes for
auto_increment to get to that figure, which could potentially be a long
time.
Cheers,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
* need.
Aah... I'd mis-remembered on this. Is there an SQL mode or somesuch
which changes this behaviour, or is my mind dribbling out of my ears?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
column_name,data_type from columns where data_type='YOUR DATA
TYPE HERE';
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
,table as t2,table as t3 where
t1.column1='blah' and t2.column2='blah' and t3.column3='blah'
does the same thing as
select * from table where column1='blah' and column2='blah' and
column3='blah'
Does that do what you're after?
Gary
--
MySQL General Mailing List
For list archives: http
injection. Pop that into Google and
you'll get a shedload of stuff.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
-Original Message-
From: Gavin Towey [mailto:gto...@ffn.com]
Sent: Friday, July 17, 2009 2:02 PM
To: Gary Smith; Todd Lyons
Cc: mysql@lists.mysql.com
Subject: RE: Slave log files going nuts...
The binlogs are closed and reopened every time you do a FLUSH LOGS;
command, or when
I have a new slave I setup against a new master server. The master server has
4 log files in it, the most current being updated on the 16th. The slave
server on the other hand has several files, many which seem to be blank. This
slave is set to slave the master and act as a master for
I'll have to look into that. We have a single cronjob that just does a
mysqldump daily but not during the time of the log file generation, but that's
all I can think of off the top of my head.
Gary
From: tly...@sitehelp.org [tly...@sitehelp.org
, but a very good lesson. I did find
a file that had all of the databases in it, I wonder if I copy all of those
if I would be able to save whatever DB's I had.
Thanks again and if anyone thinks of anything new, I would love to hear it.
Gary
Gary gwp...@ptd.net wrote in message
news
, the startup recovery flags might be your best
bet.
From: Daevid Vincent [dae...@daevid.com]
Sent: Tuesday, July 14, 2009 12:23 PM
To: mysql@lists.mysql.com
Cc: Gary Smith
Subject: RE: Copy 70GB ibdata, etc. and server won't start now
-Original Message
? If this were a hot backup, I could see
this problem happening. If it were a could backup, it should work.
From: Johnny Withers [joh...@pixelated.net]
Sent: Tuesday, July 14, 2009 1:40 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com; Gary Smith
Subject: Re: Copy 70GB
, if the original server is still up, I'd just copy from one store to the
other. It might be slow to do a 4 day export, but if you are two days into
this the savings of USB copy has already been lost.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-Original Message-
From: sjm...@pobox.com [mailto:sjm...@pobox.com]
Sent: Saturday, July 11, 2009 1:02 AM
To: mysql@lists.mysql.com
Subject: Re: Replication, Stored Proceedures and Databases
g...@primeexalia.com (Gary Smith) writes:
...
In database G we have 150+ stored
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Saturday, July 11, 2009 2:44 AM
To: Simon J Mudd
Cc: mysql@lists.mysql.com
Subject: R: Re: Replication, Stored Proceedures and Databases
You dont have changes coming from db G since it is ignored from
in the php.ini)
Anyone have an idea to where I should start to look?
Thanks
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest entry that has a date.
Thanks for your help.
Gary
090617 21:50:45 - mysqld got exception 0xc005 ;
This could be because you hit a bug. It is also possible that this binary
or one
on the my.ini to see if there is something wrong (maybe a path
pointing to a missing place or memory setting bigger than your actual RAM)
Carlos
On 7/11/2009 12:17 PM, Gary wrote:
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest entry
place or memory setting bigger than your actual RAM)
Carlos
On 7/11/2009 12:17 PM, Gary wrote:
Not sure if this is it, it was the only .err file that I have. Also this
seems to be the latest entry that has a date.
Thanks for your help.
Gary
090617 21:50:45 - mysqld got exception
Here is steps take to get to the problem. Version is 5.1.35
To be on the safe side, I did this prior to executing the scripts. I deleted
the mysql directory and the mysql-log directory, recreated them, chowned them,
ran mysql_install_db, chowned them again. So, I know at least I'm working
though the tables are qualified.
Can anyone confirm this?
Gary
From: Gary Smith [g...@primeexalia.com]
Sent: Friday, July 10, 2009 5:12 PM
To: mysql@lists.mysql.com
Subject: Crazy replication problem
Here is steps take to get to the problem. Version
-Original Message-
From: Gary Smith
Sent: Friday, July 10, 2009 5:26 PM
To: Gary Smith; mysql@lists.mysql.com
Subject: RE: Crazy replication problem
One quick follow up note:
In the top of the big script, I'm doing:
CREATE DATABASE x;
CREATE TABLE x.whatever
After getting table replication to work by including the USE database on the
creation scripts, I have run into a rather large problem. We have 5 databases
on the server which get replicated to another server. We call them databases,
A, B, C, D, and E. we have two other databases F and G
using the client and changes their password using SET
PASSWORD= PASSWORD('their new password'), it breaks the single signon.
Thanks,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, which is now known to be false.
Any ideas/assistance would be greatly appreciated.
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
there is a Ping()
that doesn't exactly that. I guess I've been spending too much time on the MS
and Oracle providers...
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Off the top of my head, try this.
SELECT
MONTHNAME(s.created) AS month,
sum(if(ifnull(s.id,0) 0, 1, 0)) AS num_logins,
sim(if(ifnull(d.id, 0) 0, 1, 0)) AS num_downloads
FROM sessions AS s LEFT JOIN downloads AS d
ON d.session_id = s.id GROUP BY month
/2009 03:33 PM, Gary Smith wrote:
Off the top of my head, try this.
SELECT
MONTHNAME(s.created) AS month,
sum(if(ifnull(s.id,0) 0, 1, 0)) AS num_logins,
sim(if(ifnull(d.id, 0) 0, 1, 0)) AS num_downloads
FROM sessions AS s LEFT JOIN downloads AS d
ON d.session_id = s.id GROUP BY month
Nope
large inserts of this size?
Thanks,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Michael,
Thanks. Thats what I was looking for, I just couldn't remember what it was.
Gary
From: Michael Dykman [mdyk...@gmail.com]
Sent: Wednesday, May 20, 2009 9:17 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Large insert question
On Wed
: joerg.bru...@sun.com [joerg.bru...@sun.com]
Sent: Thursday, May 07, 2009 2:40 AM
To: Gary Smith
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Hi Gary, all,
Gary Smith wrote:
Johnny,
Welcome to the hell that is php + apache + mysql. If you upgrade your MySql
(especially major
You are right. I misspoke regarding mysql - php - apache hell. It happens
anytime an interface changes.
From: Mark [ad...@asarian-host.net]
Sent: Thursday, May 07, 2009 5:57 AM
To: mysql@lists.mysql.com
Subject: RE: Problems After MySql 5.1.34
Gary
the error through PHP.
Of course, I could be wrong, in which case I know people will probably jump me
for it. If this is the case, please do as I would like to be wrong here as it
would make my compiling life easier every time I update MySql on all of my
boxes.
Gary
Oracle owns the mess now. I assume the next release will be 5.11, followed by
5.11i, and then finally dropping of the 5 to be in line with how they manager
their os, leave it to just be 11i. To ensure it is smooth they will change the
license and add $5k in suport costs.
?
Give you more information and we can probably give you a better answer. Maybe
a table structure and numbers behind it would be nice.
Gary
From: Lin Chun [franks1...@gmail.com]
Sent: Wednesday, April 29, 2009 7:49 AM
To: mysql@lists.mysql.com
Subject
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve them
(connectivity and load issue on the client). The question is, how can I tweak
mysql to tolerate a higher level than normal of bad connections
]
Sent: Tuesday, April 07, 2009 9:18 AM
To: mysql@lists.mysql.com
Subject: Re: flush-host problem
At 10:39 AM 4/7/2009, Gary Smith wrote:
I have system that is generating a larger than normal number of connection
errors. We know why the errors are occuring and are working to resolve
them (connectivity
I'm working on a small project of re-implementing all of the sql for a web
site. The task is pretty trivial but overall there are some minor things that
I'm trying to code through.
We've moved much of the logic over to stored procs and call them with
parameterized queries. This works well
: Search based where claused and stored proc
Date: Fri, 27 Mar 2009 13:43:51 -0500
Ben Wiechman
Network Administrator
Wisper High Speed Internet
Office: 866.394.7737
Direct: 320.256.0184
Cell: 320.247.3224
b...@wisper-wireless.com
-Original Message-
From: Gary Smith [mailto:g
Velentin,
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
Note the section for the droping of foreign keys used the contraint name, not
the key name. Try this and see if it solves the first problem (of removing the
constraint). Then you should be able to drop the
Being rather new to all this, I understood from the MySql manual that
the auto_increment is to b e used immediately after an insertion not
intermittently. My application is for administrators (the site owner
designates) to update the database from and administration directory,
accessed by
with the older CentOS.
Gary
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Wed 2/25/2009 12:50 PM
To: Jerry Schwartz
Cc: MySql
Subject: Re: Upgrade story / request for insight
Hi Jerry,
probably does not help you very much and excuse me in advance
Not sure that this is the problem BUT you should probably qualify the name of
the variable such that SELECT MAX(id) AS id FROM book. But you don't want
max(id) as id but rather max(id) + 1 as id. With that you can then just
return the final value. Also, if you don't want to alias the value
will be less than 50gb so we are looking at more ram
to hope that it will support both application and os level caching.
Any advice would be greatly appreciated.
Gary
Truncate the time part of the datetime field when doing the compare
AND DATE_FORMAT(customer.created_dt, '%Y-%m-%d 00:00:00') BETWEEN '2008-12-30'
AND '2008-12-30'
Should work. Probably not the most efficient. The other options would be to
use take end date + 1 day, minue 1 second. That's
).
As a fast workaround, increase the connections but for a long term solution you
really need to find out what the problem is, now how to work around it.
Gary
From: Kinney, Gail [mailto:[EMAIL PROTECTED]
Sent: Fri 9/19/2008 8:33 AM
To: 'mysql
name, host, date/time. Is there anything
like this already in MySQL?
Gary
shed any light on it (except for the obvious difference
in the above queries!)
Thanks,
Andy
Both are valid syntax where 1 is returned if the expression is equal to
any of the values in the list. I can't see the optimizer treating these
any differently.
Thanks,
Gary M. Josack
--
MySQL
for the whole day and did not make
much of a progress. If someone has any idea how to resolve this problem,
I'll appreciate a tip greatly.
Thank you,
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I've built several datamarts using perl and MySQL. The largest ones
have been up to about 30GB, so I'm not quite on your scale.
for #1, I have an etl_id in the fact table so I can track back any
particular ETL job. I typically make it a dimension and include date,
time, software version, etc.
expect.
Gary
From: Michael Dykman [mailto:[EMAIL PROTECTED]
Sent: Thu 2/21/2008 8:06 AM
To: mysql@lists.mysql.com
Cc: Gary W. Smith; Baron Schwartz
Subject: Re: Column level replication q?
On Wed, Feb 20, 2008 at 10:48 AM, Gary W. Smith [EMAIL PROTECTED] wrote
millions of rows, but the primary data
in the table that I really care about is relationship keys, which should be
small if we put just that data into a intermediate table.
Thanks,
Gary Wayne Smith
From: Nanni Claudio [mailto:[EMAIL PROTECTED]
Sent: Wed 2/20/2008
, on the other end, we don't even need to have the same table names. So
we can replicate it just like this with no problem.
Thanks for the links,
Gary
From: Nanni Claudio [mailto:[EMAIL PROTECTED]
Sent: Wed 2/20/2008 1:19 AM
To: Gary W. Smith; mysql@lists.mysql.com
in testing works for what we want to do, we just have a
problem with a single field.
Any ideas on how to make this work?
Gary Wayne Smith
).
From: [EMAIL PROTECTED] on behalf of Baron Schwartz
Sent: Tue 2/19/2008 5:15 PM
To: Gary W. Smith
Cc: mysql@lists.mysql.com
Subject: Re: Column level replication q?
Hi,
This isn't natively supported. You can hack it with replication to
a table that has a trigger
to
change the engine (which isn't explained in the sample articles I've read).
Any help would be greatly appreciated.
Gary Wayne Smith
You can set the default storage engine on each of the servers and then
don't declare it explicitly in any CREATE TABLE statements.
This seems like the most viable option. Since almost all of the remote
tables are created with INNODB it should work fine. I do have one table
that isn't but we
Sign up for dyndns.com or some other similiar service. Create
permissions to the domain and run a script that updates you IP with
dyndns whenever it changes. (such scripts already exist).
As far as 'username'@'%' with no password with SELECT, INSERT, UPDATE
and DELETE privileges... worst idea
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
Jay Blanchard wrote:
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking about with some queries;
mysql select
Did the space become available when deleted?
try:
lsof | grep deleted
see if they're still running in memory. if so you might be able to save
them.
Daniel Kasak wrote:
Greetings.
I've just returned from holidays, and it seems that all but 1 ibdata
file ( there were 10! ) have been deleted
immediately. As soon
as you restart mysql those files are gone forever.
Daniel Kasak wrote:
On Tue, 2007-09-25 at 19:27 -0400, Gary Josack wrote:
Did the space become available when deleted?
try:
lsof | grep deleted
see if they're still running in memory. if so you might be able to save
1 - 100 of 385 matches
Mail list logo