on 8/11/04 9:48 PM, Michael Stassen at [EMAIL PROTECTED] wrote:
With parens:
SELECT id, name FROM listmail
WHERE date_time DATE_SUB(NOW(), INTERVAL 30 DAY)
AND (subject = 'semaphore'
OR subject = 'Re: semaphore'
OR subject = 'Re:semaphore')
ORDER BY id ASC LIMIT 60
Mysql 4, this has been bothering me for some time now...
I made a mailing list archiver, I thread discussions by subject. I chose
to not use message-id's since so many people hijack threads. In most cases,
I ORDER BY id, which is simply a auto-inc that is set as they come in, in
order via
mysqldump --no-data --all-databases
SNIP
Eamon Daly
Yeap Eamon, as mentioned MyRun is not the only utility on earth with the
functionality. The difference between mysqldump and MyRun is that while MyRun
includes all the mysqldump
Great, MyCon produces SQL statements ready to recreate just your schema and/or all
data as well, now did I miss something, or does MyCon actually write the SQL one
needs to create and populate a set of system tables for the schema?
PB
.
Nope Peter, you didn't miss a beat ;)
Just to be
What if a company hires me to build an application for them. They already
have MySQL downloaded and installed. Do I/they need a license?
What if the software is open-source, but not free?
- Original Message -
From: Lachlan Mulcahy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi,
I have been running 4.1.3 on redhat9,
installed from the mysql rpm package. It has been running great until the
server crashed for an unknown reason 2 days ago.
now when ever i try to start mysql i get the
following error in log
040812 09:52:34 mysqld
started040812 9:52:34 Warning:
SciBit MySQL Team [EMAIL PROTECTED] wrote:
select * from accounts; -- as an example
but because you can customize the source sql script for MyRun, you can go like:
select * from accounts where AccountDateYEAR(CURDATE()); --
i.e. limit the inserts you going to get to that which is really
Egor Egorov wrote:
Paul McNeil [EMAIL PROTECTED] wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
Except if you are ready to make a User-defined function to make a simple
group_concat...
Feedback [EMAIL PROTECTED] wrote:
Besides that, the server has also a lot of trouble with the fact that =
sometimes the MySQLd just stops functionizing somehow, and the only way =
to kill the (all child processes broke down, so i mean the parent) =
process is 'killall -9 mysqld'. 'kill pid'
Chris Blackwell [EMAIL PROTECTED] wrote:
now when ever i try to start mysql i get the following error in log
040812 09:52:34 mysqld started
040812 9:52:34 Warning: Asked for 196608 thread stack, but got 126976
040812 9:52:34 InnoDB: Error: unable to create temporary file
040812
Philippe Poelvoorde [EMAIL PROTECTED] wrote:
If I am not running 4, is there another way to achieve the same result as
GROUP_CONCAT(myField)
?
I don't think so. :(
Except if you are ready to make a User-defined function to make a simple
group_concat...
On Aug 12, 2004, at 2:38, Issac Goldstand wrote:
What if a company hires me to build an application for them. They
already
have MySQL downloaded and installed. Do I/they need a license?
What if the software is open-source, but not free?
Hi Issac,
We always recommend that proprietary
-w, --where=nameDump only selected records; QUOTES mandatory!
:)
The more options the merrier for MySQL and the end-users :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello
Please help me. Im newbie in the database and I got one crash after outage.
Now my mysql.server cant start. Im my log is nothing . And in err log in
database directory is:
**
040811 20:26:59 mysqld started
InnoDB: The first
Hi,
Does anyone know how to extract only the Auto_Increment column from the
command results of SHOW TABLE STATUS
Regards
Naresh
--
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have
Well.. I had the same issue 2 weeks ago with another server from my
DC. I told them it was their hardware, they didnt believe it, so i had to
order a new
server, and ... The same problem occurs...
Thats like one on a million that its the hardware...
- Original Message -
From: Egor
Hi list
environment:
host:/ # uname -a
Linux host 2.4.19-4GB #1 Fri Sep 13 13:14:56 UTC 2002 i686 unknown
host:/ #
host:/ # /usr/local/mysql/bin/mysqld -v
/usr/local/mysql/bin/mysqld Ver 4.0.12-max for pc-linux on i686
host:/ #
an php application of ours prepares customer data on the screen in a
| Subject: Auto Increment Column
|
| Hi,
|
| Does anyone know how to extract only the Auto_Increment column from the
| command results of SHOW TABLE STATUS
Do you mean that you want a command that will run on the command line that
will show the value of the Auto_Increment column? Or are you
Well actually I want it in a stored procedure. However due to a bug in
version 5.0.0 alpha (posted on the bugs database by me ID 5017) I cannot
get the LAST_INSERT_ID() in the stored procedures. So I want an
alternate way of getting LAST_INSERT_ID(). I thought auto_increment
column of SHOW table
Hmmm... looks like it may be impossible to do fulltext searching on 3 million rows as
few have chimed in on this one.
Just to add some background to my setup, I am currently running on MySQL 4.0.17 (plan
to upgrade soon.. will this help??) and I created the index that took 9 minutes to
process
Encontré qué aparece ser una buena clase particular de MySQL de los
novatos en http://www.programatium.com/. Navega con Manuales - Bases de
Datos - MySQL y usted lo verá.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Yusdaniel Rodriguez Espinosa [EMAIL PROTECTED] wrote
We Fulltext index multi million rows with very good response time. The
cardinality of `1` is okay. Did you fulltext index the rows as is or did you
create some sort of combined field?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 7:43 AM
Subject: RE:
Keep in mind that it is not a ood idea to get (not sure how to get the last
value for auto_increment column) last id with a statement like SHOW TABLE
STATUS. Because this will return allways the some for different connections
which might create problems for you. My point is. last_insert_id()
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy. The Tables are read only and the data is to
be only accessed via login password. The login will give a limited view of
records based on a master/detail table relationship. I need to be aware
Philippe, If he is pre-4 (I assume that as he does not seem to have the
GROUP_CONCAT() function) and UDFs aren't available until 5+, how exactly
would he do this as a UDF? :-D
Paul, I believe you are going to have to combine those fields during some
form of post-query processing (macro,
Welling Thomson is terrific.
- Original Message -
From: Kerry Frater
To: MySQL List
Sent: Thursday, August 12, 2004 8:09 AM
Subject: recommended books for web app.
I am looking to port an app from an existing web environment to MySQL. The
requirement is relatively easy.
Are you using InnoDB tables? If so, have you properly configured the
directories?
-Original Message-
From: Jevos, Peter
To: '[EMAIL PROTECTED]'
Sent: 8/12/04 6:02 AM
Subject: Problem after crash
Hello
Please help me. Im newbie in the database and I got one crash after
outage.
Now my
Missed your original message. What do you mean you concatenated the
columns you wanted to search on and placed them in a table? You should
just create the full text index on multiple columns. For instance, in a
contacts table, you may have firstname, lastname. So you would create a
full text
Hi Victor,
The fulltext index was created on 1 column only that is of type text.
The benchmarks I get are very inconsistant...
SELECT product_id FROM product_fulltext WHERE MATCH ( search_text ) AGAINST ('China')
Query took 20.17 seconds
SELECT product_id FROM product_fulltext WHERE MATCH (
Thanks for your recommendation Peter
Kerry
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: 12 August 2004 14:23
To: Kerry Frater; MySQL List
Subject: Re: recommended books for web app.
Welling Thomson is terrific.
- Original Message -
It's not one from your list but I can recommend you this one:
http://www.oreilly.com/catalog/webdbapps2/index.html
Gives you a nice overview about PHP/MySQL and a nice case study which
explains how to create a Online Winestore.
Regards
Olivier
-Ursprüngliche Nachricht-
Von: Peter Brawley
On your two word plus searches, `New York` for example, have you tried using
`IN BOOLEAN MODE` to reduce the number of false positives?
AGAINST(New York IN BOOLEAN MODE)
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 8:33 AM
Subject: RE: Fulltext Search
I have resolved this issue now, it was actually the permission on /tmp that
had become corrupted as a result of the crash I can only assume
chmod 777 /tmp
chmod +t /tmp
this fixed the problem
but could have been fixed within minutes not days if the error message had
told me which directory was
Hi Brent,
Oops, sorry about forgetting to post the key buffer size, its:
key_buffer_size 262144000
As far as the combined column I'm using, I did it to make the fulltext as simple as
possible and keep the index at only 1 column. I am aware that I can create an index
for multiple columns but
The problem you point out is one of the reasons this isn't the best way to
organize your data. A better way would be to keep your events table:
events
event_id
event_name
event_description
but properly normalize the sequences table by putting one event per row like
this:
table
It would probably be better to post this to the Lasso
discussion list at Blueworld.com as for Lasso, this
will require you to use tags but it's been ages since
I coded with Lasso (3.6 and FileMaker. :) and I
can't recall/never knew, the tag modifications.
Good luck
--- maggie chloe [EMAIL
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity of putting a password in the my.cnf
file.
This line probably should have been a good hint:
InnoDB: File operation call: 'tmpfile'.
Any idea why the server crashed in the first place? That's not the sort
of thing you want just randomly happening, I'd imagine. Although it
might make life a bit more interesting...
Cheers.
--V
Chris
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
Jeroen,
One minor caveat here. You are grouping by gene_name, but selecting
non-aggregate values from the chr and strand columns. Since they aren't
part of the list of grouped columns, you'll get effectively randomly chosen
values (probably the first found per group) for each from among the
I'd go along with that recommendation.
Terry
- Original Message -
Welling Thomson is terrific.
- Original Message -
From: Kerry Frater
To: MySQL List
Sent: Thursday, August 12, 2004 8:09 AM
Subject: recommended books for web app.
I am looking to port an
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
-Original Message-
From: matt ryan
To: [EMAIL PROTECTED]
Sent: 8/12/04 10:22 AM
Subject: Help, slave wont stay running!
I cant keep the slave up
Nope, no idea why it crashed, and I don't know enough about redhat to bother
investigating.
It seemed to hang so it got a kick, when it came backup was bit screwy... so
far this has been only problem. It's only a dev box so I'll keep my fingers
crossed it's a freak occurrence :)
chris
Victor Pendleton wrote:
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
I can start slave, and it runs a little while, then stops again.
I can refresh the data from the master, iv'e done it 25 times
If you really want to test the raw query speed, then do a SELECT
COUNT(*). That will return just a count of the number of records found,
eliminating any speed issues caused by display processing or transfer
speeds from the database to the interface. Adding a limit usually
speeds things up
El Jueves, 12 de Agosto de 2004 09:22, matt ryan escribió:
I cant keep the slave up for more than 10 minutes
constantly getting these errors
040812 10:32:25 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040812 10:32:25 Got fatal error 1236:
I have some large tables (hundreds of millions of rows) that are extremely
active. They have heavy read and heavy modify activity. But, all
modifications are only on recent records (data added within the last month
is very volatile, but data earlier than that never changes).
We use the InnoDB
Thanks for all your help guys,
Using COUNT(*) I get the following:
mysql SELECT COUNT(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('blue
jeans');
+--+
| COUNT(*) |
+--+
|51513 |
+--+
1 row in set (48.58 sec)
The EXPLAIN for the fulltext queries look like
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The index file has an `.MYI'
Anyone know how to use access as front end for accessing blobs in mysql.
I have found some sample code for storing blobs in mysql, but for
whatever reason when I export the tables to mysql and link them it stops
working. Even though the blobs remain and can be accessed without
corruption from
I deleted every table off the slave, and reloaded them, I do this twice
a week because it wont replicate
The master server has a check optimize every sunday
I had a similar situation one week ago. Found one of the tables (MyISAM) had a
corrupt index. After fixing it, everything was fine again.
Hello,
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt; the data
some of the characters are of ascii
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests are
locked and the pages time out.
Is there any way to get this to run without
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a way to do this (in either native MySQL or Perl)?
Thanks as always!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Check it out
mysql start slave;
Query OK, 0 rows affected (0.00 sec)
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql start slave;
ERROR 1198: This operation cannot be performed with a running slave, run
SLAVE S
TOP first
mysql
Hi,
I'm running into troubles trying to connect to MySQL (version 4.0.18) via
TCP/IP. Connecting on the actual machine via Unix sockets works just
fine--it's solid as a rock. But as soon as I attempt to connect via TCP
(from either the local machine or a remote machine), mysqld crashes and I
get
As is the case for all things Perl, CPAN is your answer:
http://search.cpan.org/~alancitt/Text-CSV-0.01/CSV.pm
NAME
Text::CSV - comma-separated values manipulation routines
SYNOPSIS
use Text::CSV;
$version = Text::CSV-version(); # get the module version
You can use mysqldump with the --fields-terminated by= option.
-Original Message-
From: David Perron
To: [EMAIL PROTECTED]
Sent: 8/12/04 1:07 PM
Subject: CSV Output
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a
Those times shouldn't be that far apart. What is the hardware (RAM,
CPU, etc.) and OS you are running this on? Is there anything else
running on it that might be causing memory to page out?
If you are running Unix, try running: vm_stat 1
That will show you memory stats every second. Watch the
At 11:07 AM 8/12/2004, David Perron wrote:
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a way to do this (in either native MySQL or Perl)?
Thanks as always!
You could try DBD::CSV
This is my first attempt to design and test MySQL. I have used MS SQL for
number of years. I do appreciate if members of this list can recommend a
good GUI application for MySQL. I want the GUI application to design DB,
design Quiries, etc.
Thanks.
Kirti
--
MySQL General Mailing List
For
Kirti
Have a look at the free DBManager Pro from DBTools :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
-Ursprüngliche Nachricht-
Von: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 12. August 2004 20:09
An: '[EMAIL PROTECTED]'
Betreff: GUI for MySQL
I would suggest DBDesigner available on
http://www.fabforce.net/
-Mensaje original-
De: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 12 de Agosto de 2004 12:09 p.m.
Para: '[EMAIL PROTECTED]'
Asunto: GUI for MySQL
This is my first attempt to design and test MySQL. I
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 | 2 |
|
Thanks for the vmstat tip. I ran vmstat 1 on the query on a slightly quicker query so
I wouldn't have a ton of numbers to post from the vmstat.
mysql SELECT COUNT(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('Pink');
+--+
| COUNT(*) |
+--+
|12231 |
+--+
1
hi all. In my struggles to buildl MySQL 4.1.3deta, i read a lot of online
documentation, and in the process i found a lot of info about various
configure flags in writeups all over the web. One problem i encountered, that
i finally figured out was that some documentation names the flag
Jeff Meyer wrote:
I have the following table:
+-+-+
| ID_AGE | ID_ENTRY |
+-+-+
| 1 | 1 |
| 1 | 4 |
| 1 | 5 |
| 2 | 1 |
| 2 |
matt ryan wrote:
SQL is, replace delayed into table c1, c1, c3 select c1, c2, c3 from
temp table.
This takes 2 hours to comlete, the temp table is rather large.
The table being updated is locked, the whole time, all web requests
are locked and the pages time out.
Is there any way to get this
Mayuran Yogarajah wrote:
From the MySQL docs:
Each |MyISAM| table is stored on disk in three files. The files have
names that
begin with the table name and have an extension to indicate the file
type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension.
What hardware and OS?
How did you get and install mysql? MySQL supplied binary? 3rd party binary?
Built from source? If the answer is not MySQL supplied binary, my first
suggestion would be to try that to see if the problem goes away.
Michael
Matt Winckler wrote:
Hi,
I'm running into troubles
Michael Stassen wrote:
What hardware and OS?
Pentium II 300, 192 MB RAM, almost-brand-new 80GB hard drive, running Gentoo
Linux (kernel 2.4.25-gentoo).
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not MySQL supplied
binary,
Karam Chand wrote:
i have a table with a LONGBLOB column. We store some
small images in it. I want to export them in XML
format with schema like:
cdata/c
cdata/c
...
...
Now the problem is even if I mysql_real_escape() and
changing entities like , to lt; gt; the data
some of the characters are of
Hi all:
I am running MySQL 4.1.3 under Debian. I have the problem that my
options in my.cnf are not going into effect. I want to increase
max_heap_table_size from the default of 16M to 400M (I have 4GB of
memory), but putting that line into my.cnf doesn't do anything. (Yes
it is in the
If you are using a MyISAM table type, the entire table is either locked or
it isn't. Normally this isn't a problem most statements happen quickly.
However, yours takes a couple of hours to finish so the entire table has
to stay locked until your statement completes.
The way I see it, you have
Grumble, grumble. I was hoping vmstat would tell us more. In a
nutshell, every system has a bottleneck and the bottleneck is always
CPU, RAM, I/O or Network. Nutshells are great since they make things
seem so simple. You've got a 1 in 4 chance sf picking the right piece
that is your bottleneck
INTERSECT sound very much like UNION DISTINCT
(http://dev.mysql.com/doc/mysql/en/UNION.html) because this query should
give you what you asked for and is very similar to yours:
(SELECT ID_ENTRY FROM table WHERE ID_AGE = 1)
UNION DISTINCT
(SELECT ID_ENTRY FROM table WHERE ID_AGE=2)
However, I
Wow, thanks Brent, nice to learn something new (I'm not much of a 'server' guy)
Tried the iostat and got some results while performing a general query:
mysql SELECT count(*) FROM product_fulltext WHERE MATCH(search_text) AGAINST('DISK');
+--+
| count(*) |
+--+
| 4975 |
Are you sure that the server is using the my.cnf file which you are
changing? After making the change, what is the output of
--print-defaults for mysqld? If it's not as expected, odds are good
that the server is getting its defaults from a different location.
--V
[EMAIL PROTECTED] wrote:
Hi
What else is in the my.cnf file? For instance, when I run `mysqld
--print-defaults` on my system I see this:
mysqld would have been started with the following arguments:
--basedir=/path/to/mysql-4.0 --datadir=/path/to/mysql-4.0/data
--port=1032 --socket=/path/to/mysql-4.0/mysql.sock
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for now the insecurity
Paul DuBois wrote:
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
password=apppwd
host=my.host.com
Ignore for
At 14:40 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 8:06 -0700 8/12/04, V. M. Brasseur wrote:
Paul DuBois wrote:
At 13:03 -0700 8/11/04, V. M. Brasseur wrote:
Assuming a my.cnf file which looks like this:
[client]
port=3306
socket=/path/to/mysql.sock
[app]
user=appuser
Hi,
I am having trouble trying to figure out the reason of this. The query (explained) is:
EXPLAIN SELECT * FROM news,users WHERE news.user_id=users.user_id ORDER BY date DESC
I divided the result table in two parts to improve readability:
I am trying to run two different MySQL server versions on the same solaris
machine. I already have a 4.0.2 running, and i have successfully installed
4.1.3 beta. I ran mysql_install_db successfully (after setting
LD_LIBRARY_PATH), but when i try to run
mysqld_safe --user=mysql
I get the
Hi Sean,
Have you checked the pid file? Have you given it a unique path for this
server?
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
I am 100% convinced that mysql 4.1.3 beta is not properly reading the my.cnf
configuration files. If i remove the /etc/my.cnf file and try to start mysql
4.1.3 with (im working from /usr/local/mysql-4.1.3/bin)
./mysqld_safe
i get the following output: (mccoy is the name of the machine im on)
Bump
Mysql 4, this has been bothering me for some time now...
I made a mailing list archiver, I thread discussions by subject. I chose
to not use message-id's since so many people hijack threads. In most cases,
I ORDER BY id, which is simply a auto-inc that is set as they come in, in
order
Michael Stassen wrote:
What hardware and OS?
How did you get and install mysql? MySQL supplied binary? 3rd party
binary? Built from source? If the answer is not MySQL supplied
binary, my first suggestion would be to try that to see if the problem
goes away.
Michael
That did end up being the
Hello,
You can try SQLyog at http://www.webyog.com/ .
Its not free but it has got some really powerful
features.
Regards,
Karam
--- Kirti S. Bajwa [EMAIL PROTECTED] wrote:
This is my first attempt to design and test MySQL. I
have used MS SQL for
number of years. I do appreciate if
On Wed, 11 Aug 2004, Jeremy Rice wrote:
./configure --prefix=/usr/local --sysconfdir=/etc/mysql
--localstatedir=/var --enable-shared --enable-static --with-libwrap
--with-berkeley-db --enable-thread-safe-client --with-mysqld-user=mysql
--with-openssl
Hello,
Hmmm. I was figuring that out. mysql_escape_string()
only escapes characters like \r, \n, \\, 0 etc. it
still keep other non-character data same like it keep
ascii 15 to ascii 15 that no parser is able to handle.
Isnt there any better way then base64 to handle this.
Just like replacin to
This leads me to another question. What are the valid
ASCII characters that XML parser understands.
Are they only a-1,A-Z,0-9,., etc or some other
characters.
Regards,
Karam
--- Karam Chand [EMAIL PROTECTED] wrote:
Hello,
Hmmm. I was figuring that out. mysql_escape_string()
only escapes
Hi,
I have 2 DB server, running as master and slave. I just add an index to
one of my table on master, it took about 12 minutes. During adding the
index, I have insert/update queries to other tables. On master this has
no problem at all. The problem is, on slave these queries were blocked
by the
93 matches
Mail list logo