hi ,
when i try to get mysql data to the web browser via
php , always it is showing
Parse error: parse error, unexpected T_LNUMBER, expecting
',' or ';' in /var/www/html/smsc/test1.php on line 14
error message. but i tried to rectify the essage ,
i couldn't.
can some body help me to solve
Hi,
I want to add better support for Unicode in our application.
Currently we use the default charset of the application, but code our data
to UTF8 (It's a Delphi-Application with a native Component to connect to
MySQL). This works fine also for MySQL 3.23 with some limitations (No
sorting-suppor
On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote:
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT AL
hi,
I am new in PHP, and I would like to create some user interface with PHP.
Could anyone tell me what is the easiest way to do this?
thanks a lot,
Enhebatu
_
Store more e-mails with MSN Hotmail Extra Storage 4 plans to choose
Hello
I would like to ask how to migrate my table in database SQL Server to MYSQL.
The field name and data type mostly are different from the one I've prepared
in MYSQL. Could somebody show me the way or any recommended website which
discussing about this? For additional information, I am using M
Hello
I have a number of servers.
I have one running RH7.3 with mysql-3.23.56-1.73
one running RH9 with mysql-3.23.58-1.9
My question is when i do a ps -ef
on RH7.3 a get a number of /usr/libexec/mysqld
on RH9 i only get one.
can someone please explain why. does RH9 display thread differe
Kevin,
As I mentioned earlier, set this in you're my.cnf and restart mysql. It has
helped me on many occasions.
open-files-limit=36864
Donny
> -Original Message-
> From: Kevin Marks [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 23, 2004 6:27 PM
> To: [EMAIL PROTECTED]
> Subject: Re
Chris,
We run a large data warehouse with tables similar to yours. We basically gave up on
indexing and the overhead involved and just tablescan. The key is to partition the
data using a concept called Merge Tables. However, since we currently use Oracle,
eager to migrate to MySQL - I don't hav
I saw something like this as well. Using 4.1.2 made it go away. Try doing a
bk pull of the dev version of 4.1.2 and give it a go.
-steve--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Feb 23, 2004, at 10:36 AM, Sasha Pachev wrote:
Christof Egner wrote:
Hello James,
thanks for your answer, but max_connections is set high enough
(double the number of the currently used threads). I think the error
would be "Too many connections", wouldn't it?
This error comes from LinuxThread
Hi Mark,
- Original Message -
From: "Mark Maunder"
Sent: Monday, February 23, 2004 4:17 PM
Subject: Re: HEAP tables vs MYISAM on ramdisk
> 411 is packed with features I'm dying to have on my production server,
> but I had it on my dev box, and I got some table corruption which,
> admitte
Hi Mike,
- Original Message -
From: "Mike Mapsnac"
Sent: Monday, February 23, 2004 5:49 PM
Subject: run query second time
> Hello
>
> Today I run large query. It took more than 1 minute to start printing
the
> results. The output was about 5 rows. However, when I run the
query
> sec
Hello
Today I run large query. It took more than 1 minute to start printing the
results. The output was about 5 rows. However, when I run the query
second time it took a couple of seconds before printing the results. Why is
that? Because data still in the RAM?
Thanks
On Mon, Jan 05, 2004 at 09:12:24AM +1300, Sam Vilain wrote:
> No-one out there doing step-by-step replay of binary logs ?
mysqlbinlog
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.15-Yahoo-SMP: up 162 days, proce
At 17:17 -0500 2/23/04, David Perron wrote:
Thanks Garth. Actually Im trying to change the delimiter in the context of
running a sql file from the command line - so in this case, I would want to
change from tab to csv
mysql -h db#-reports.adz -u readonly -p < script.sql > output.csv ads12
You can
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT ALL on *.* to
root IDENTIFIED BY 'password';
which is great, b
At 17:20 -0600 2/23/04, Paul DuBois wrote:
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing so
At 12:50 -0600 2/23/04, Paul DuBois wrote:
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || '
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a
GRANT ALL on *.* to root IDENTIFIED BY 'password';
which is great, but if I run mysql so
mysql -u [EMAIL PROTEC
At 04:40 PM 2/23/2004, you wrote:
Hello List:
This is the basic of the basic question. I have recently installed and
tested MySQL and am happy with it. Now I want to setup a production server.
I notice that there are two MySQL products listed on the MySQL org site (1)
MySQL & (2) MaxDB MySQL.
My q
There are some excellent tutorials for PHP at www.codewalkers.com under the
tutorials/basics section. You can sort the fields with SQL or with PHP (see
"Sorting Database Results with PHP") and in the Display section of the
tutorials are "Alternating row colors with PHP and MySQL" and "Multicolumn
Hello Folks,
Am trying to upgrade MySQL with rpms. rpm -Uvh
MySQL-shared-compat-4.0.17-0i386.rpm worked fine. When I try to upgrade
the client or server I get warnings that the files conflict with the
older versions that are currently installed. I've tried to erase the
older versions with rp
version 4.1 and up are the versions to be unicode enabled.
Ligaya Turmelle
""Beau Hartshorne"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are there any issues that I should
Oh we are using Red Hat Enterprise Linux WS ver 3.0
Thanks
Matt
Thomas Taylor wrote:
what platform are you on?
On Feb 23, 2004, at 4:27 PM, Matt Silva wrote:
I am using the ~new~ MySQL Administrator and i'm trying to load the
Startup Variables and i'm receiving a "Could
not find my.cnf" error.
Hi,
I am about to start using UTF-8 for my internal data storage and display
for a CMS that I'm building. Are there any issues that I should be aware
of related to mysql and storing UTF-8 encoded characters? What versions
of mysql offer full UTF-8 support, and are there any weird caveats with
the
Hello List:
This is the basic of the basic question. I have recently installed and
tested MySQL and am happy with it. Now I want to setup a production server.
I notice that there are two MySQL products listed on the MySQL org site (1)
MySQL & (2) MaxDB MySQL.
My question is; which of these two pr
I am using the ~new~ MySQL Administrator and i'm trying to load the
Startup Variables and i'm receiving a "Could
not find my.cnf" error. my.cnf is located in the /etc directory and I
have temporarily relaxed the permissions to
777. Is there something that i'm missing here? Or is there a bug in
Thanks Garth. Actually Im trying to change the delimiter in the context of
running a sql file from the command line - so in this case, I would want to
change from tab to csv
mysql -h db#-reports.adz -u readonly -p < script.sql > output.csv ads12
-Original Message-
From: Garth Webb [mai
411 is packed with features I'm dying to have on my production server,
but I had it on my dev box, and I got some table corruption which,
admittedly, I was too lazy to try to reproduce. So I've downgraded to
production 4 again. I have a heavily updated fulltext index which may be
the root of the ev
Hi,
I'm bundling MySQL with a Java app, and it is currently working on Windows
and Mac OS X. Right now I'm porting it to Solaris.
The problem I'm having is when I try to create a database ("CREATE DATABASE
mydb") I get the error: "ERROR 1006: Can't create database 'mydb'. (errno:
2)"
Using perro
I'm not sure in what context you want to change the delimiter, but
here's the doc page on the LOAD DATA command which shows how to
terminate (a.k.a. delimit) fields with different characters:
http://www.mysql.com/doc/en/LOAD_DATA.html
On Mon, 2004-02-23 at 13:53, David Perron wrote:
> Greetin
Greetings -
Been scouring the docs for this all day and I come up with nothing for
'delimiter' - Id like to change the default delimiter in mysql to something
other than tab.
Is there a command to do this, and what are the options?
Thank you!
David
I wrote a cold fusion script to migrate data from an access 2000 db to a
mysql 4.0.18 db and when I display the data with cold fusion I see these
little box characters in different spots.
I'm assuming that it's an issue with the encoding. How do I correct this?
Thanks.
Mitchell S. McKenzi
Thanks!
One question though - in the Index Preloading section, it says:
"If there are enough blocks in a key cache to hold blocks of an entire
index, or at least the blocks corresponding to its non-leaf nodes...".
How can I determine the number of blocks in an index, or the number of
blocks for t
Index caches are new to 4.1.x, but key caches have been around for a while.
Definitely in 4.0, can't remember about 3.x. Either way though, I don't see
either helping with inserts or updates. Only with queries.
MySQL does suggest using a seperate key cache for temporary tables though:
http://www
Victoria Reznichenko wrote:
[snip]
Could you create repeatable test case (table structure (output of SHOW CREATE TABLE) and text file with data that will be enough to reproduce the above behavior)?
I'll see if I can get something generic to error out. there's pretty
much no way I'll be able to se
Bruce Dembecki wrote:
Help, I seem to be running into a problem with replication which up until
now has served us well.
We run mysql servers in pairs, with each server in a pair mastering off the
other. So for example mysql1 masters off mysql2, which masters off mysql1.
Friday morning one server st
hi ,
i have a problem with Mysql Vs php . Can somebody
help me to sort out this problem ?
I wrote a php script to connet mysql data base and
get some data from some table of the database. It works well ..
1 data1
data2
5 ccc
xcx
3 aaa
123
2 klkl
opop
4 o
Chris Fossenier writes:
... Query 1
> a1.phone_pander_flag <> 'Y'
> AND state.state = 'PA'
> AND ( h1.homeowner = 'Y'
> OR h2.probable_homeowner IN ('8','9')
> OR h2.homeowner_probability_model BETWEEN '080' AND '102' )
> AND ( p1c.exact_age BETWEEN '40' AND '60'
> OR estimated_age BETW
Try this...works on 4.1.2
UPDATE ControlTable SET NextID= 1 + (select @prevval := NextID)
Ed
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 11:19 AM
To: Matt Fagan
Cc: [EMAIL PROTECTED]
Subject: Re: Setting variables on update
Matt Fag
The table I'm using is non-critical data, so it's not really an issue
for me. But I was browsing through the mysql manual looking for a way to
rebuild an MYI file from the .frm and MYD file (is there a way?) when I
came across this:
http://www.mysql.com/doc/en/CACHE_INDEX.html
Index caches are on
Bernd Jagla wrote:
Hi,
we have a big problem with inserting large amounts of data (2GB) into our MyISAM databank (version 4.0.12).
The dataset is loaded in using
LOAD DATA infile 'bla' ignore into table tab fields terminated by ' ' optionally enclosed by '' (int1, int2, int3, date);
The format
Bernard Clement <[EMAIL PROTECTED]> writes:
>Your problem is too much experiences not the lack of skills.
>
>I am in the same situation...it is very frustating.
Bernard,
It appears I'm not the only one :( Though such an observation
makes me wonder if it may be a case of age discrimination be
At 13:35 -0500 2/23/04, Eric B. wrote:
Hi,
I know this question has been posed in the past, but I haven't been able to
find an answer for it yet.
Is there any way in MySQL to pre-load a table's index file into the key
cache at startup?
Yes, this is something that was implemented recently:
http://
At 15:59 +0200 2/23/04, Victoria Reznichenko wrote:
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || ' test string';
+---
On Mon, 2004-02-23 at 08:56, Tim Hayes wrote:
> OK
>
> There is still the possibility of an in-compatability between the 2
> platforms.
>
> However - in both Linux and Windows (MySQL 4.0.17) the variable is not
> recognized / updateable using the set command!
>
>
> I get - Unknown system variab
Hi,
I know this question has been posed in the past, but I haven't been able to
find an answer for it yet.
Is there any way in MySQL to pre-load a table's index file into the key
cache at startup? I know the key cache will build itself while exectuing
queries, but this will obviously slow down t
Christof Egner wrote:
Hello James,
thanks for your answer, but max_connections is set high enough (double
the number of the currently used threads). I think the error would be
"Too many connections", wouldn't it?
This error comes from LinuxThreads when pthread_create() fails for one reason or
At 9:31 + 2/23/04, [EMAIL PROTECTED] wrote:
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
I am new to most aspects of MySQL administration so I was wondering
if someone can help me figure out what GRANTs I need for a
particular situation.
I have a user who needs to be able to r
At 16:56 + 2/23/04, Tim Hayes wrote:
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
Correct. You must set it using an option at server start
Matt Fagan wrote:
Hello,
I'm trying to run an SQL update statement like:
UPDATE ControlTable SET @prevval := NextID, NextID = NextID
+ 1
I've tried using a range of different syntax, but nothing
seems to work. This is something that does work in another
SQL server I used to use.
Does anybody know
Eric B. wrote:
Sure! Here it is:
CREATE TABLE `index2` (
`id` varchar(50) NOT NULL default '',
`recordid` varchar(20) NOT NULL default '',
`transid` varchar(20) NOT NULL default '',
`formid` varchar(20) NOT NULL default '',
`groupid` varchar(20) NOT NULL default '',
`clientid` varchar(20) NOT NUL
Matt W wrote:
Hi Ted,
Heh. :-) This could be many GBs. There's no problem reading rows that
are in RAM (cached by the OS) -- can read over 10,000/second. If
there's enough RAM, the OS will take care of it (you could cat table.MYD
to /dev/null). No ramdisk necessary. :-)
BTW, this is for MySQL's
I saw the same that ms sql is faster but I think it's because of the ms
sql makes better use of index's
I had a table with almos 300mil records on ms sql query with index'es it
was no problem (in about 5 min I got the result) and with a much smaller
db on mysql (with 80 mil records it took almost
I specifically wrote my import script to parse out the fields that we need
and add NULLs. I was told that having NULL values was faster than using ' '.
If this isn't the case, I'd like to know.
Thanks.
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]
Sent: Monday, February
hi,
I have the same problem with executing mysql_install_db in mysql 4.1 after
compiling it on debian 3.0, lust like Bug #2915 installation of grant tables
failed!
after sucessfully configure (./configure --prefix=/usr/local/mysql
--with-innodb) & make & make install and executing mysql_install_
Hi Chris,
Chris Fossenier wrote:
This is a long post, my apologies.
Speaking for myself, I found the detail most helpful. Thanks!
See response at bottom.
...snip...
QUERY1
~~~
Indexed Fields (link, phone_pander,state, exact_age, estimated_age, phone,
first, last, address)
MS SQL QUERY (
Hello,
This is a long post, my apologies.
I have been working on migrating a database from MS SQL to MySQL for about 1
month now and am at a point where I can start running some tests to see how
they compare. I'll provide a little background to help you out.
The MS SQL database is 120million
Hi!
Please observe the following about InnoDB table names on Windows:
http://www.innodb.com/ibman.php#Moving
"
On Windows InnoDB stores the database names and table names internally
always in lower case. To move databases in a binary format from Unix to
Windows or from Windows to Unix you should
Dear Brad,
Your problem is too much experiences not the lack of skills.
I am in the same situation...it is very frustating.
Regards,
Bernard
On Monday 23 February 2004 11:14, Brad Eacker wrote:
> Donny Simonton <[EMAIL PROTECTED]> writes:
> >But as a manager, the first thing I do is ask for co
OK
There is still the possibility of an in-compatability between the 2
platforms.
However - in both Linux and Windows (MySQL 4.0.17) the variable is not
recognized / updateable using the set command!
I get - Unknown system variable 'lower_case_table_names'
Tim Hayes
- Original Message
"Tim Hayes" <[EMAIL PROTECTED]> wrote on 23/02/2004 16:15:36:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
>
Hi,
we have a big problem with inserting large amounts of data (2GB) into our MyISAM
databank (version 4.0.12).
The dataset is loaded in using
LOAD DATA infile 'bla' ignore into table tab fields terminated by ' ' optionally
enclosed by '' (int1, int2, int3, date);
The format of the text file
Tim Hayes said:
> Can anyone offer advice?
>
> I have come across a MySQL database on Linux with duplicate table
> names - "Accounts" and "accounts". This seems fine on Linux, but
> does not transfer to the Windows environment - it is rejected
> because of the duplicate name. However I do see that
Set this in you're my.cnf and restart and see if that solves your problem.
open-files-limit=36864
*** Don't ask me what that number is, it's just a random number.
Donny
> -Original Message-
> From: Ken Menzel [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 23, 2004 10:20 AM
> To: Chr
Hi Christof,
You don't mention the OS version you are using (So I will assume
Linux) is there a sysctl for the max number of threads on your OS?
Ken
- Original Message -
From: "Christof Egner" <[EMAIL PROTECTED]>
To: "James Kelty" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturd
Can anyone offer advice?
I have come across a MySQL database on Linux with duplicate table names - "Accounts"
and "accounts". This seems fine on Linux, but does not transfer to the Windows
environment - it is rejected because of the duplicate name. However I do see that
Column Names have to be
Donny Simonton <[EMAIL PROTECTED]> writes:
>But as a manager, the first thing I do is ask for code examples, as well as
>table structures. I don't even need to see a resume once I look at
>somebody's code and table structures.
Unfortunately I will have to disagree with you on this one. Havi
How are you ensuring syncronization between the ram disk and the HD? Is
there a writeback / writethrough mechanism for ram disks? Are you not
risking major data loss if ever you have a power failure or PC failure?
Thanks for the info!
Eric
"Mark Maunder" <[EMAIL PROTECTED]> wrote in message
ne
Hi, Sasha:
I got replication working now. Thanks veryyy much for your suggestion.
Liying
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have written in intermediate, on the appropriate position in this
discussion, please go thru in full.
--- Michael Widenius <[EMAIL PROTECTED]> wrote: >
> hi!
>
> > "A" == Arunachalam <[EMAIL PROTECTED]> writes:
> A> As per my searching I have found the right C API in libmysql.lib
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
>
> I am running MySQL in ANSI standard mode. However the following
> statement is giving unexpected result. Am I missing something?
>
>mysql> select 'This is a' || ' test string';
>+---+
>| 'This is a' || ' test st
I get the same thing on our system (MySQL 4.0.15 running on Linux Mandrake
9.1).
According to the manual, section 1.8.4:
"MySQL Server understands the || and && operators to mean logical OR and
AND, as in the C programming language. In MySQL Server, || and OR are
synonyms, as are && and AND. Beca
Title: Bug on MYSQL-5.0 in statement "OPTIMIZE TABLE"
Hi,
TABLE CREATE DESCRIPTION :
CREATE TABLE T1(IDAP INT(16),TVAL INT(2),CH_VAL_SEC INT(16),INDEX(IDAP),INDEX(TVAL),INDEX(CH_VAL_SEC));
RUNNING CONDITIONS:
-use persistent connection.
RUNNING SEQUENCE:
1-Open 1-st connection.
2-ins
Hi All,
I am running MySQL in ANSI standard mode. However the following
statement is giving unexpected result. Am I missing something?
mysql> select 'This is a' || ' test string';
+---+
| 'This is a' || ' test string' |
+---+
mark warren bracher <[EMAIL PROTECTED]> wrote:
> heh, sometimes the obvious is right in front of you...
>
> I still can't get the full dataset to load with indexes on the table,
> but I _can_ apply indexes after the load. the indexes apply cleanly, so
> it doesn't seem to have been a data issue
Karam,
> I am CS student. I want to understand the architecture
> and code of MySQL (guess the subjects says it
> all)...What do you think will be the best place to
> start off?
> Any docs on the architecture of MySQL?
You may want to have a look at internals.texi. As its name implies,
this is a
Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello
>
> I am CS student. I want to understand the architecture
> and code of MySQL (guess the subjects says it
> all)...What do you think will be the best place to
> start off?
>
Download and install BitKeeper. Then clone MySQL manual with command:
"Rhino" <[EMAIL PROTECTED]> wrote on 21/02/2004 16:59:27:
> I am new to most aspects of MySQL administration so I was wondering
> if someone can help me figure out what GRANTs I need for a
> particular situation.
>
> I have a user who needs to be able to run some MySQL scripts that
> create
79 matches
Mail list logo
