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
point, you're needing 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.mysq
the replace 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.
achieve? Would replication 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 t
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
ould write 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
x27;W13 %' to return 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 l
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 "W
tterns ?
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.
Does that help?
Gary
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
, if the back end was an MS SQL server then
the first query 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 Maili
.
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" wrote in message
news:4da87902.9030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
dat
I'm sorry, I am unfamliar with an asc file, so I have not opened them.
GAry
"Reindl Harald" wrote in message
news:4da87554.8030...@thelounge.net...
__ Information from ESET Smart Security, version of virus signature
database 6044 (20110415) __
The mess
this field.
if ($_POST['address'] != '' ) {
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, c
_db($database_assess, $assess_remote);
$Result1 = mysql_query($insertSQL, $assess_remote) or die(mysql_error());
"Michael Dykman" wrote in message
news:BANLkTi=+fpW=-qbmb6tcfffhr1gb32w...@mail.gmail.com...
I presume you are inserting to both tables always at the same time
inside a
meone 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 Lis
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
Hi Anand,
Just try 'load data local infile',it maybe work.
Eric
2010/12/20 Anand :
> 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 DATA INFILE in
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" wrote in message
news:aanlktik3nhjqkc00iw-nv1qqpdeaj1_5xtwbf7skd...@mail.gmail.com...
> Your very
27;type'] . '';
echo '' . $row['singles'] . '';
echo '' . $row['six'] . '';
echo '' . $row['can'] . '';
echo '' . $row['bottles'] . '';
echo '' . $row[
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
GRANT OPTION;
ERROR 1064 (42000): You 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
Leavi
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"" wrote in message
news:20100426233621.10789.qm...@lists.mysql.com...
I
im.image_id' at line 1
Anyone see where I am going 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 Mail
;' . $row['description'] . '';
if (is_file($row['image_file'])) {
echo 'height="100px"/>';
}
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
.
So 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
will try to apply your solutions to the original problem.
Thanks again for your reply.
Gary
"Colin Streicher" wrote in message
news:201004122103.15609.co...@obviouslymalicious.com...
>
> Normally I would avoid getting into this sort of argument ( The 'OMG
> someone on t
$result=mysqli_query($dbc, $query)
or die('Error querying database.');
mysqli_close($dbc);
?>
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
"
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" wrote in message
news:201004112310.16594.co...@obviouslymal
). 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
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml";>
U
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 into outfile '/path/to/output/file'
fields terminated by '|'" ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
sier way to do this? I've got into some bad
habits over 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
ts, so it'll do 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
d create 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
ltset, 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?
find all of the distinct 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
oing on
behind the scenes?
I recently 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.
* 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
(id) would be wrong 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
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 af
s SQL 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
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...@sitehe
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 downstr
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
.
I think as others have mentioned, 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 serv
thing, 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"" wrote in messag
atabase did it come from and what version of the database is it
going to?
Anyway, 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.
Ga
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
>> s
ail.com...
>
> Take a look 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
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 of the
8 (but not activated 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
> -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 ignore
> -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:
>
> ...
&
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 which
> -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
specified, even 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 probl
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 wit
top using IDBConnection and go with MySqlConnection 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
state was real time, 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
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
tables
On 07/08/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 downl
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
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
O
can accept 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
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
From: 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
eceiving 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
boxe
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.
_
ns of rows?
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.c
From: mos [mo...@fastmail.fm]
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 e
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 b
ireless.com
>
>
>
> > -Original Message-
> > From: Gary Smith [mailto:g...@primeexalia.com]
> > Sent: Friday, March 27, 2009 12:59 PM
> > To: mysql@lists.mysql.com
> > Subject: [MySQL] Search based where claused and stored proc
> >
> > I&#x
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 sin
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 c
> 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
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 val
some lib issues 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
ll 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 e
).
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: '
g the attempted user 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
--
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/[
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. That
x27;t 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
n 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
table has 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
).
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 t
ion 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
> 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
ow to
change the engine (which isn't explained in the sample articles I've read).
Any help would be greatly appreciated.
Gary Wayne Smith
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 ide
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 dea
For future reference. The files do actually continue to be written to. I
experience this all the time when people delete logs files and space
keeps filling up.
Daniel Kasak wrote:
On Tue, 2007-09-25 at 23:11 -0400, Gary Josack wrote:
Well if you can stop all instances of writes to the
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
1 - 100 of 399 matches
Mail list logo
