clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want to
be sure... do I need to strip the slashes and special characters out and
add them when they're called... or..? I'm just trying to get a clear
picture of exactly what needs to be done with this particu
David and Jasper - thank you both! I will play around with this more now
that you have explained my biggest questions!
Thanks guys,
Clint
:-)
On 9/9/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote:
>
> clint lenard wrote:
> > Thanks Jasper for the info! This may sound stupid - but I just w
Hi Clint,
Another possibility is to actually run the mysql client with a --html
option and let mysql do the work for you
eg : prompt $ echo "SELECT some_stuff FROM table" | mysql -u xyz -pxxx
--html
This generates a block of html for a table with the data encapsulated
within, then it is just a
Thanks Jasper for the info! This may sound stupid - but I just want to be
sure... do I need to strip the slashes and special characters out and add
them when they're called... or..? I'm just trying to get a clear picture
of exactly what needs to be done with this particular job...
thanks!
clint lenard wrote:
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told
hmmm... let me ask the guys how they have it all set up.
Jenifer
- Original Message -
How is your MySQL installation set up? At my company, we have a
master server and several slaves replicating off that master. All
inserts/updates go to the master, and all selects go to the slave
> So now my question... is it possible that MySQL didn't execute that first
> UPDATE query on that first page until after the rest of the process completed?
>
> - The customer page is a basic form that posts the information to itself
> with a simple UPDATE command and then goes to the next page
> >Isn't this what the --hex-blob option to mysqldump is for?
>
> There is no such option to mysqldump in version 4.1.11.
>
>From the manual:
--hex-blob
Dump binary string columns using hexadecimal notation (for example,
'abc' becomes 0x616263). The affected columns are BINARY, VARBINARY,
and B
Hi,
Does somebody point me out where I should refer to understand what is
"row level replication" implemented in 5.1?
I should have read the source comments in the source tree, but the bk
port is closed at my environment.
Regards,
Kenji
--
MySQL General Mailing List
For list archives: http://lis
Hi all,
I'll give you a little background so that my question is put into context.
I've already posted this question to my local programmers message group and
they said to post it here. So, here it goes:
I have a phone order system that I wrote in PHP. It has a series of pages
starting with
Dan Baker wrote:
"Eric Bergen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
When you add that index are more than 30% of the rows in the table
DateTimeNext>1126215680?
There are currently 28.53% of the rows that have "DateTimeNext>1126215680"
Does this mean something of inter
"Eric Bergen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> When you add that index are more than 30% of the rows in the table
> DateTimeNext>1126215680?
There are currently 28.53% of the rows that have "DateTimeNext>1126215680"
Does this mean something of interest? If so, what?
Rick,
I will be glad to join you
Nestor :-)
-Original Message-
From: Rick Schulze <[EMAIL PROTECTED]>
Sent: Sep 8, 2005 1:21 PM
To: mysql@lists.mysql.com
Subject: San Diego mySQL usergroup
I would like to form a San Diego mySQL user group, I notice we don't
have one down here that I can
"packet too big" errors in replication are often a sign of corrupt
binary logs. If it's on a slave reading the relay log
often times flushing it will temporarily solve the problem. The easiest
way to flush the relay logs is to do a slave stop; change master to back
to the current file name and p
It appears that mysqld is not listening on /tmp/mysql.sock.
Log into mysql and run show variables like 'socket';
This will tell you where mysqld is actually listening for socket
connections.
Then update your my.cnf files so they all have the same sock file
location as the
one that mysqld is li
When you add that index are more than 30% of the rows in the table
DateTimeNext>1126215680?
Dan Baker wrote:
I have lots of tables that are similar in nature:
id int(11) PRI NULL auto_increment
Name varchar(30)
DateTimeNext int(11)
The "DateTimeNext" field represents when this records needs
I have lots of tables that are similar in nature:
id int(11) PRI NULL auto_increment
Name varchar(30)
DateTimeNext int(11)
The "DateTimeNext" field represents when this records needs attention. A
value of zero indicates it is being ignored. There are times when *lots* of
records DateTimeNext
>> We did a mysqldump to produce a transport file
>> from version 3 of mysql to insert the data into version 4 of mysql.
>> The encoded numbers were munged, presumably because they were
>> binary data in the dump.
>Isn't this what the --hex-blob option to mysqldump is for?
There is no such opti
I would like to form
a San Diego mySQL user group, I notice we don't have one down here that I can
see. I do not want to take the burden of putting the group together but I do
have the building, large meeting room, access at night/evening, PA system if
needed, projectors if needed etc.
Hello.
A few months ago you've been writing about issues with InnoDB
when using a similar recipe. Please, share your experience of
how you've solved that problems.
"James G. Sack (jim)" <[EMAIL PROTECTED]> wrote:
> This recipe is intended to minimize the impact on ongoing database
> ope
Hi,
Like advised I posted the problem in the win32.mysql.com list as well.
Still though, I'm not convinced that this is an ASP.NET problem. I say
because I tested this problem without ASP.NET too, in the program
MySQL-Front. The results there were the same as in ASP.NET, meaning the type
was
Hello.
This is not a step by step instructions. But taking into an account
that you're a MySQL beginner, in my opinion, you should read some
parts of the manual:
http://dev.mysql.com/doc/mysql/en/string-functions.html
http://dev.mysql.com/doc/mysql/en/insert-select.html
ht
Hello.
Have a look here:
http://dev.mysql.com/doc/mysql/en/limit-optimization.html
'Yemi Obembe <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 8bit, charset: iso-8859-1, 7 lines --]
>
> Talking limit (in select query), does it "limit" the search result after
> ordering accord
Hello.
In my opinion (it is based on looking through the source code, but I
can be wrong) - the max_allowed_packet should be at least more than
any event in the master's binary log. The tool for researching
binary logs is mysqlbinlog utility. See:
http://dev.mysql.com/doc/mysql/en/mysqlbi
Instead of your cron job, I suggest http://codenode.com/mysqlreport
The mysqlreport documentation (http://codenode.com/mysqlreportdoc)
is a pretty baseline introduction to comprehending server performance
via a mysqlreport report, and a little bit about what you can do for
certain issues.
-Dani
This recipe is intended to minimize the impact on ongoing database
operations by inhibiting writes only during a relatively speedy
operation (creating a snapshot). The long dump operation can then be
performed on the (stable) snapshot, without interfering with ongoing use
of the live database.
1.
Thank you. This is a very promising answer. I don't know that we want to
drop the table if we don't have to, but knowing that we can restart the DB
without the rollback operation is a boon! We could certainly do a mysqldump
of just that table (which works fine, we continue to run nightly backups
> We did a mysqldump to produce a transport file
> from version 3 of mysql to insert the data into version 4 of mysql.
> The encoded numbers were munged, presumably because they were
> binary data in the dump.
Isn't this what the --hex-blob option to mysqldump is for?
--
MySQL General Mailing L
hi all, here is the suituation
i've installed mysql4.1.14 under the /usr/local directory. the problem
is, the server can work properly, however, mysqladmin doesn't. i
posted it yesterday, and someone suggested me to issue the following
command, however the same error 111 occured.
#mysqladmin -uroo
We found, to our chagrin, that a dump of an encoded field does not
restore properly in all cases.
Specifically, we use encode() to code credit card numbers before inserting
them in the database. We did a mysqldump to produce a transport file
from version 3 of mysql to insert the data into version
Problem solved, at least for the most and major distributions and packages.
Diana Soares wrote:
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Congratulations for this fantastic project,
Diana Soares
Hello all,
It seems that you can't change the status from closed (or can't repeat)
to another. The only hope you have is someone in the developing teem
test your bug with the combination you used: MySQL + ASP.NET + MyODBC.
But I continue to say that the problem is not in MySQL Server, maybe in
Hi!
mathias brandt wrote:
[[...]]
the statement
SELECT id FROM table1 WHERE cityname = 'bla' (cityname has been indexed)
takes 0.0002 seconds and returns 0 rows, which was expected.
the statement:
SELECT id from table1 WHERE id IN ( SELECT id FROM table1 WHERE cityname = 'bla
)
still retur
please help!
i have a fairly large innoDB table with 800mb (index 500 mb, data 300mb) and
1.8 million data sets.
the server has 8 gig ram.
the statement
SELECT id FROM table1 WHERE cityname = 'bla' (cityname has been indexed)
takes 0.0002 seconds and returns 0 rows, which was expected.
t
Hi Diana, all,
Diana Soares wrote:
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Yes, that was my fault, I sent the mail too early - sorry about it.
Glad you could work around this!
This is now fixe
Is there any way I can find out how big I should set max_allowed_packet?
I have changed it from the default 1M to 32M, but I still get that error.
Or is it a bug? We use MySQL 4.0.12 on the slave and 4.0.15-max on the master.
How big should I set max_allowed_packet? The servers are dual Pentium
wi
Hello.
In my opinion - yes it is, however, trust only the benchmarks :)
Jason Pyeron <[EMAIL PROTECTED]> wrote:
>
> Am I correct in the statment second query is faster? This query gets
> executed several million times.
>
> mysql> explain select A.* from files as A where A.pathre
Hello.
MySQL team verified this issue, but they've said that this is rather
a feature request, not really a bug. See:
http://bugs.mysql.com/bug.php?id=13032
Jason Pyeron <[EMAIL PROTECTED]> wrote:
> Thanks Michael,
>
> but it now seems that on prepared selects, the values are still
Hello.
> I can tell, I have no my.cnf file in place, so there must be some default
Create your own and the appropriate value for the table_cache. See:
http://dev.mysql.com/doc/mysql/en/option-files.html
http://dev.mysql.com/doc/mysql/en/program-variables.html
Hello.
Here is described the possible way of how to force the rollback
(you can kill the mysqld process and set innodb_force_recovery to 3 to
bring the database up without the rollback, then DROP the table that is
causing the runaway rollback):
http://dev.mysql.com/doc/mysql/en/forci
Just a note: the main site still reports version 4.0.25-0.
I dowloaded version 4.0.26 from a mirror, but it was necessary to tweak the URL.
Congratulations for this fantastic project,
Diana Soares
On 9/8/05, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> MySQL 4.0.26, a new version of the po
Hi,
MySQL locks work only until a session expries, so they will not be of much use
in your case. The best solution will be to implement this logic in your
application - the simplest method is to add a field to the table which will
keep the information about whether the specific record is locked
"'Yemi Obembe" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:33:25:
> Talking limit (in select query), does it "limit" the search result
> after ordering according to relevancy and the likes, or before?
> thanks
LIMIT operates after ORDER BY.
Alec
--
MySQL General Mailing List
For l
Talking limit (in select query), does it "limit" the search result after
ordering according to relevancy and the likes, or before?
thanks
-
Click here to donate to the Hurricane Katrina relief effort.
Talking limit, does it "limit" the search result after ordering according to
relevancy and the likes, or before?
thanks
-
Click here to donate to the Hurricane Katrina relief effort.
MySQL General List,
Server specifications:
MySQL 4.1.3-beta, phpMyAdmin 2.5.7-pl1, PHP 4.3.8
My specifications:
MySQL beginner, PHP intermediate, HTML and CSS advanced.
The situation:
I have recently installed a forum ( http://www.simplemachines.org/ )
on my web site. I alread
Hi,
MySQL 4.0.26, a new version of the popular Open Source/Free Software
Database Management System, has been released. It is now available in
source and binary form for a number of platforms from our download pages
at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all mirror si
I tried changing the status, but it seems only MySQL staff can do it (so the
message says), so I can't do that. Any idea how it's possible to do so?
From: Nuno Pereira <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: AES_DECRYPT output
Date: Wed, 07 Sep 2005 12:19:01 +0100
I suppose
49 matches
Mail list logo
