Sommai Fongnamthip writes:
> Hi,
> I was read recommendation from MySQL download page to upgrade Linux Kernel
> for latest MySQL version. I have problem because I must still with Linux
> Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat
> has many task to upgrad
I have been assigned the fun little job of porting a (very badly
designed) database from Access97 to MySQL so that we'd finally get
rid of that pesky Win2000-server.
The database contains a list of magazines currently in our basement
waiting for someone to borrow them. There are, at the moment, j
This just happened to me tonight. I am running Windows98, Apache, MySQL
3.23.38.
Running mysql as a CLI I was always able to \T to a file. Now whenever I
try that, I get an error message that MySQL has performed an illegal
operation. I have to shut it down.
I've rebooted, and restarted Apache an
On Tue, 18 Dec 2001 09:53:32 +0700, Sommai Fongnamthip
used a few recycled electrons to form:
| Hi,
| I was read recommendation from MySQL download page to upgrade Linux Kernel
| for latest MySQL version. I have problem because I must still with Linux
| Red Hat 6.2 (kernel 2.2.16-3) beca
Is there any upcoming fix for this recurring problem? The table
handler is just giving poor data to the optimizer and the optimizer
is making bad decisions because of it. It appears to come and go,
depending on data that is in the table, what's been done, etc.
To give one example, with one of o
Hi,
I was read recommendation from MySQL download page to upgrade Linux Kernel
for latest MySQL version. I have problem because I must still with Linux
Red Hat 6.2 (kernel 2.2.16-3) because it's my production server and Red Hat
has many task to upgrade in newer kernel. What will effec
Disregard please...
database,sql,query,table
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
B
Dumb question, but why is that?
I have stripslashes on everything that goes into the database, (i also
addslashes on everything, so people can't break the database, too), why is
it unecessary? and what might it break?
Thanks,
James Cox
-
A better question is why hasn't this host `From:' been banned yet? This
is the second time in a month that this guy has spammed the lists with
his garbage.
Shankar Unni wrote:
>
> rc wrote:
>
> > anyone know why i'm getting these spam emails over this list
>
> Because it had the magic w
except there's no need to stripslashes(), in fact it could even break things..
unless you have magic_quotes_runtime enabled (default is off in the latest php)
bvr.
On Mon, 17 Dec 2001 16:33:24 -0700, Kevin Stone wrote:
>Ahh.. I was about to reply but nevermind. The two functions you're talk
Ahh.. I was about to reply but nevermind. The two functions you're talking
about are addslashes() and stripslashes(). Yes those are very handy. :)
>
>
> > Does anyone know of an easy way to store html code in a mysql database,
> and
> > then retreive it, in such a way that it can display the
> >
> > Does anyone know why it is that the MyODBC authors prefer not to allow
> > that to be distributed in the unixODBC package, or with distros (eg the
> > SuSE CDs don't contain it)?
>
> Peter will answer this, why MyODBC is not included in
> unixODBC distribution :)
>
> Peter, any comments ..
> Does anyone know of an easy way to store html code in a mysql database,
and
> then retreive it, in such a way that it can display the page as if it were
a
> standard html page? Would using php be of benefit to me?
Figured it out. I completely forgot about two php functions that escape
prob
> Does anyone know of an easy way to store html code in a mysql
> database, and then retreive it, in such a way that it can
> display the page as if it were a standard html page?
You store and retrieve html in a mysql database like you store/retrieve any
other string values. You would probably wa
Sinisa Milivojevic wrote:
>Jean.Maupertuis writes:
>
>>I try to use the ?var?'s to create a menu for inserting new rows in a table.
>>for example:
>>insert into personnel(first_name, last_name) values(?first_name?,
>>?last_name?)
>>if i type jean in first_name and maupertuis in last_name the re
rc wrote:
> anyone know why i'm getting these spam emails over this list
Because it had the magic word "sql", which the filter checks..
--
Shankar.
-
Before posting, please check:
http://www.mysql.com/manual.php (
iv'e done it before.
store the html as a varchar,text field in database.
using php would help if only certain sections are stored as html.
Good Luck,
Rick
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 3:38 PM
To: MySQL (E-mail)
Subject:
anyone know why i'm getting these spam emails over this list
-- Forwarded message --
Date: Mon, 17 Dec 2001 17:36:59 -0500
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: "SOFTWARE TESTERS & DEVELOPERS CONTRACT TO HIRE"
From:-
Gani Pola
If you want to use PHP, here's a nifty utility that posts your query and displays the
results.
"Give me back my MySQL Command Line!"
http://www.webmasterbase.com/article.php/627
Doug
On Mon, 17 Dec 2001 14:27:11 -0800 (PST), John Kurkiewicz Jr. wrote:
>I cannot figure out how to parse SELECT
* John Kurkiewicz Jr.
> I cannot figure out how to parse SELECT query into
> html pages.
Please be more specific.
If you want to display a select statement on a web page, you need to
transform "<" into "<", and you should probably put it inside a
html element.
If you want to display the result
Does anyone know of an easy way to store html code in a mysql database, and
then retreive it, in such a way that it can display the page as if it were a
standard html page? Would using php be of benefit to me?
Steve Osborne
[EMAIL PROTECTED]
*
*(borrowed from Paul)
--
What is the best way to do a search & replace on a MySQL database? I just
want to wipe a particular character from each field it occurs in; the
REPLACE command, at least in the documentation on www.mysql.com, doesn't
appear to be the best bet for doing this.
Thanks,
Alex Kirk
---
I am very green when it comes to MySQL and i am having some problems
connecting via a web interface. I keep getting.
-snip-
Warning: MySQL Connection Failed: Host '' is not allowed to connect to this
MySQL server in /home/sites/site105/web/forums/install.php on line 39
-snip-
I am not sure if my
> Hi,
>
> I willing to build and host a free mySQL discussion
> forum/newsgroup for the mySQL community. I have web
> space available and can easily build a discussion
> forum using vbulletin and mySQL in a couple of days.
>
> Does the mySQL community think that we need a
> discussion forum wher
From:-
Gani Pola
SP*
PCI Data Consulting
Marketing Division
434 Ridgedale Avenue, PMB # 11-108
East Hanover NJ 07936
Tel: 1-888-248-3443 OR 1-888-713-7201
Fax:1-603-297-5644
mailto:[EMAIL PROT
* John Kurkiewicz Jr.
> I am using perl 5 and linux 6. I am currently capable
> of retrieving information from my databases, but am at
> a complete loss as to how to parse the results into 20
> results per page.
Take a look at the LIMIT part of the SELECT statement.
>From the manual http://www.m
try phpgen
It gives a nice web interface that then you can mess around with.
Requires php however.
http://www.byggsoft.se/~mikaelu/phpgen.html
Rick
-Original Message-
From: Langfeldt, Jeanne [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 2:04 PM
To: '[EMAIL PROTECTED]'
Subje
please help:
I cannot figure out how to parse SELECT query into
html pages.
__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com
Hi Luis,
Did you compile PHP to include MySQL?
At 13:46 -0800 2001/12/17, Luis A wrote:
>I have just installed the current version of php and mysql server plus
>the client.
>
>I had apache running already, so that means that I did not have to
>install it again.
>
>When I did a test on mysql
I am using perl 5 and linux 6. I am currently capable
of retrieving information from my databases, but am at
a complete loss as to how to parse the results into 20
results per page.
Can / will you help?
__
Do You Yahoo!?
Check out Yahoo! Shopping a
Hi,
I wish to set up a MySQL DB, but due to time constraints need to get
something up and running quickly. I would like to do set it up in something
like Access, then later convert it to MySQL.. I need to run it on the
Solaris platform, so Access is out, but I need something like it - quick and
On Mon, 17 Dec 2001, Alex Kirk wrote:
> I've got a 700-question multiple choice quiz that I've got imported into
> MySQL, with one small problem: the answers to the quiz are not a separate
> column. I have three columns for each of the possible answers; the correct
> answer is denoted by a "*" in
I have just installed the current version of php and mysql server plus
the client.
I had apache running already, so that means that I did not have to
install it again.
When I did a test on mysql to connect i get this error
Fatal error: Call to undefined function: mysql_connect() in
/var/ww
You need to have some sort of unique identifier, like a primary key.
And all the tables should agree upon that
Defryn, Guy wrote:
DG: Date: Tue, 18 Dec 2001 10:37:41 +1300
DG: From: "Defryn, Guy" <[EMAIL PROTECTED]>
DG: To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
DG: Subject:
Hi John,
Just listing the files and directories in your data directory won't
tell you (or anyone else here) if you're out of disk space.
Try:
$ df -k
to show your disk free space in K.
or, if you're in a directory, try
$ du -sk *
to show you a disk usage summary, in K, of the things in the dir
Venu <[EMAIL PROTECTED]> writes:
> No such, as long as it is GPL distribution.
Actually, it's Public Domain, not GPL. It's included in Red Hat
Linux 7.2.
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please chec
This is my first post to the list
What is the best way of making a relationship between tables in Mysql.
Do you set it up when you are creating the tables or is it done with the
insert statement
I am a newbie to Mysql, BTW
Guy
-
Installed mysql on suse 7.3 on intel, server does not run, error message
is attached
Please help thanks
Mysql version 3.23.41
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
Hi Kevin,
> -Original Message-
> From: Kevin Donnelly [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 17, 2001 12:47 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC availability
>
>
> Does anyone know why it is that the MyODBC authors prefer not to allow that
> to be distributed in t
Hi,
I try to install MysQL-4.0.0, but when I 'make' I receive the following:
make[2] ***[ctype_extra_sources.c] error 132
make[2] Leaving.
make[1] *** [all recursives]error 1
make[2] Leaving.
make *** [all recursives-am]error 1
somebody an id ?
Greets Piet
Vlissingen (Holland)
---
Does anyone know why it is that the MyODBC authors prefer not to allow that
to be distributed in the unixODBC package, or with distros (eg the SuSE CDs
don't contain it)?
Is it a licensing issue, something to do with the ODBC spec, or just plain
"don't want to do that, so there" (which, I hast
I don't think I'm out of room on the volume. Below is the directory
listing:
-rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001
-rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002
-rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003
On Mon, 17 Dec 2001 14:20:11 -0600, John Lepone
<[EMAIL PROTECTED]> wrote:
| I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to
| the DB as root. When I try to create a new DB, I get the following error:
|
| [jlepone@mandrake jlepone]$ su
| P
Error code 28: No space left on device
You're out of disk space on the drive where your databases are stored.
Chris Schreiber
-Original Message-
From: John Lepone [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 3:20 PM
To: '[EMAIL PROTECTED]'
Subject: ERROR 1006: Can't crea
> mysql> CREATE DATABASE mynewdb;
> ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
> mysql>
[carsten@tsort carsten]$ perror 28
Error code 28: No space left on device
- Maybe clearing up some disk space would help???
/ Carsten
--
Carsten H. Ped
I have recently installed MYSQL on my Mandrake 7.1 Linux box. I connect to
the DB as root. When I try to create a new DB, I get the following error:
[jlepone@mandrake jlepone]$ su
Password:
[root@mandrake jlepone]# mysql -p
Enter p
At 08:06 PM 12/17/01 +, Kevin Donnelly wrote:
>On Monday 17 December 2001 15:04, David VanHorn wrote:
> > I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> > grep mysql)
> > Then I restart with safe_mysqld --skip-grant-tables
> > Trying to log in to mysql in any way
On Monday 17 December 2001 15:04, David VanHorn wrote:
> I killed all Mysql processes, and confirmed that they are killed (ps -ef |
> grep mysql)
> Then I restart with safe_mysqld --skip-grant-tables
> Trying to log in to mysql in any way, including mysql -h localhost mysql
> or mysql root or my
> It simply won't connect. It just says 'Can't connect to local MySQL
> server through socket '' (111)'
>
> I can connect via terminal so I know MySQL is (at least semi) correctly
> setup.
>
> Any ideas?
http://www.bitbybit.dk/mysqlfaq/faq.html#ch10_0_0
/ Carsten
--
Carsten H. Pedersen
keep
It simply won't connect. It just says 'Can't connect to local MySQL
server through socket '' (111)'
I can connect via terminal so I know MySQL is (at least semi) correctly
setup.
Any ideas?
Kenny
-
Before posting, please
> Hello,
> I am interested in knowing :-
> 1) The maximum number of tables possible in MYSQL Database
> 2) The maximum number of columns that are in a table.
http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_0_0
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http
> I have been scouring the MySQL site and manual for a couple of days
> trying to find a place to have a listing of MySQL error messages
> what they
> mean and what should correct them. Does such a beast exist anywhere?
> Specifically I am getting the error
>
> ERROR 1030: Got error 1 fr
At 11:46 -0500 2001/12/17, Roger Karnouk wrote:
>Is there a way to alter an index on a table without dropping it and
>recreating it?
I don't think so.
See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html
HTH,
/Rob
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW
At 12:10 -0500 2001/12/17, Etienne Marcotte wrote:
>Netscrap 4.78
>oops sorry mispelled that one.. Netscape :)
Hmmm. I see you're using Netscape on NT. [X-Mailer: Mozilla 4.78
[en]C-CCK-MCD (WinNT; U)]
Haven't tested with that -- I don't have a BillWare OS here -- but
friends have accessed t
Netscrap 4.78
oops sorry mispelled that one.. Netscape :)
I do loads of html and I hate Netscape with a passion, I think 6.2
renders pages like IE4, but I'm not even sure, and only .2% of websurfer
use it. www.technodium.net/kira/kira.htm check this out with IE =
perfect.. chek it out with NS, di
At 09:33 -0500 2001/12/17, Etienne Marcotte wrote:
>This is a very very good search engine for the mailing list!!! Great
>work
Thank you!
>Two things:
>2- Put the "Any Date" checked by default so we don'T have to always
>click it:-) (I'm lay) You could add some javascript so that the
>rang
At 17.12.2001 17:50, A. Bacon wrote:
>Help? I cannot get access to anything in mysql through my php scripts.
>I have a good connection (with a user and password set up by inserting
>into the user db) and can work with mysql from dos with no problem, but
>when I issue any command to mysql through
Help? I cannot get access to anything in mysql through my php scripts.
I have a good connection (with a user and password set up by inserting
into the user db) and can work with mysql from dos with no problem, but
when I issue any command to mysql through php, I get an 'access denied
for 'tonloc@
Is there a way to alter an index on a table without dropping it and
recreating it?
I have a table containing 4 columns
(col1, col2, col3, col4)
and an index that currently uses 3 of them (not the primary key)
idx = (col1, col2, col3)
I want to change the index to
idx = (col2, col3)
I need to d
At 20:18 -1000 2001/12/15, Peter Reck wrote:
>Rob,
>
>THANK YOU for putting this together.
You're welcome. Glad you like it. :>
>I am a complete newbie to MySQL, and have a VERY BASIC question:
In the future, Peter, please direct questions to the MySQL list, and not to me
personally. Than
> Is there a way to delete records in a table by specifying row numbers.
for
> example:
>
> delete from tbl1 where row > 900 and row <1000;
How do you get hold of the row numbers? The rows in the database are NOT
the same as the rows in
any particular SELECT you may have done. How the database s
Hello,
I am interested in knowing :-
1) The maximum number of tables possible in MYSQL Database
2) The maximum number of columns that are in a table.
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
At 09:20 AM 12/17/01 +, Carl Troein wrote:
>David VanHorn writes:
>
> > At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
> > >This should help:
> > >
> > >A.4.2 How to Reset a Forgotten Password
> > >http://www.mysql.com/doc/R/e/Resetting_permissions.html
> >
> > Works ok up through step 2.
>
Hello,
I did not find anywhere the description of how MySQL processes multiple join.
I'am attaching data for my actual db but those are not nesseesary for the question.
I have a db which holds the data about CD Titles. The tables are:
o - info about people
su - info about persons associated w
That would be nice. I have been hoping for it since Nov 23 when there
was a post saying that it would be out in the next week.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?2:mss:118:200111:nmfbdddincnalmjpnhng
"Fournier Jocelyn [Presence-PC]" wrote:
>
> Hi,
>
> It should be really soon, Monty wr
This is a very very good search engine for the mailing list!!! Great
work
Two things:
1- Is it possible to remove our full email adresses?
To put like emarcott@... or emarcott at itl dot ca (like the
mysqldeveloper archive.
2- Put the "Any Date" checked by default so we don'T have to always
Is there a way to delete records in a table by specifying row numbers. for
example:
delete from tbl1 where row > 900 and row <1000;
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
Robert,
You need to provide alot more data. How about platform and MySQL
version to start, a copy of your config (my.cnf) file, and provide exactly
what you're typing and the response.
Scott Helms
- Original Message -
From: "robertix" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
Hi all!
Cold anyone tell me how to downgrade the gcc 2.96 compiler
under linux red hat 7.2 to 2.95 ?
I ended up messing my C libraries..
Anybody could tell me exactly what C related
(cpp, gcc, gcc-c++, libstdc++, etc.. ??!!!) programs and
libraries do I need in order to make it to work (compi
David Sheeks writes:
> Is this where I would get some help using the mysql++ api for linux c++?
>
> dave
>
>
It would be better if you would subscrube to mysql-plusplus mailing
list.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROT
Just ignore automake warnings.
Regarding /opt/sfw/bin/ginstall problems, configure probably
erred. Make a symlink so that the above ginstall points to the real
one.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /
Jean.Maupertuis writes:
> I try to use the ?var?'s to create a menu for inserting new rows in a table.
> for example:
> insert into personnel(first_name, last_name) values(?first_name?,
> ?last_name?)
> if i type jean in first_name and maupertuis in last_name the result is
> "unknow column
> 'j
Gitta,
in Windows the error number 32 means:
32
The process cannot access the file because it is being used by another
process.
ERROR_SHARING_VIOLATION
Maybe the installation left the MySQL server mysqld running in your system?
When you try to start another mysqld instance, it rightfully c
Michael T. Babcock writes:
> Is there an upper bound on how many items may be listed in an 'IN' clause?
>
> SELECT a,b,c from d where a in (1,2,3,4,5,6 ... 1123,1124); ...??
>
> Thanks
> --
> Michael T. Babcock
> CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc)
Mike Gleason Jr Couturier writes:
> Hello all !
>
> I've got 2 questions :
>
> Can we insert ASCII characters in an INSERT statement... like
> INSERT INTO guy(name) VALUES('ascii codes here'); so that the
> ascii code of a ';' will display a ';' in the database... understand !?
>
> And is there
Hi Jeremy:
Thank you.
At 02:05 AM 12/16/2001 -0800, you wrote:
>On Fri, Dec 14, 2001 at 06:36:19PM -0500, Peter M. Perchansky wrote:
> > Greetings everyone:
> >
> > RE: http://www.mysql.com/doc/R/e/Replication.html
> >
> > How frequently does each slave get data from the master?
>
>The slaves h
Jean.Maupertuis writes:
> hi
> in the help file of mysqlgui we find that it has the functions for:
> - Generating a menu with table fields based on tables that the user has
> choosen
> - Parametrized queries, where the user can put any number of ?var?
> strings and getting a dialog with all ?var
Hello,
may I ask for help concerning the following problem:
I just installed mysql, created a my.cnf under c:/, containing
the information
[mysqld]
innodb_data_file_path = ibdata1:50M.
IBdata1 was created.
But trying to start the server there is the following message:
C:\mysql\bin>mysqld
InnoD
Nissim Lugasy writes:
> How do I retrieve the count for multiple tables with one sql command?
>
> Thanks
Hi!
Depends what is it exactly that you need.
>From mysql database, you can :
select count(*) from user,db where user.user=db.user;
or
select count(user.user), count(db.user) from user,d
When I try to do anything with MySQL, I always see
"Ignoring query to other database" on my screen. When I type "status", the
computer prints:
"All updates ignored to this database".
after "Current user".
Could anybody help me ? Does anybody know how can I unblock MySQL ?
robertix
-
Jack A Fobel wrote:
>I remember seeing a program awhile back that acts like pcanywhere or
>terminal services, to connect to a linux or windows box. Anyone remember
the
>name?
Depends what you mean:
a. Terminal services, or b. pcanywhere(tm)
If it's (a), then you've got a wide choice of:
oco
Hi Frankie.
Where did you created a db ? Which data will you add to your
database ? A dump ? Be more specific.
Greetz
- Daniel Backhausen
---
N2MEDIA web- & multimediadesign
http://www.n2media.de - mailto:[EMAIL PROTECTED]
-Ursprüngliche Nachricht-
Von: Frankie Cooke [mailto:[EMAIL
Hello all
I have created a database and now wish to make this available on the web,
does anyone know what I need to upload and how I go about this processs. Is
it a normal ftp process etc
Please help & thanks for any help given
Frankie
>> Hi,
>> I am having problems loading data into a table and have 2 questions.
>>
>> 1)
>> I want to load some data from a text file in to a table by using the
>> following line:
>> LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio;
With this you have to save your text file inside the bin folder of
Hi,
i encountered some problem with table:
ERROR 1030: got error 1030 from table handler
i found many solutions, how to temporarily fix it (myisamchk), but it
appears again and again and makes our server unusable.
so, the question is 'what can CAUSE it' and how to repair it forever?
the machine
David VanHorn writes:
> At 08:58 PM 12/16/01 -0700, Doug Thompson wrote:
> >This should help:
> >
> >A.4.2 How to Reset a Forgotten Password
> >http://www.mysql.com/doc/R/e/Resetting_permissions.html
>
> Works ok up through step 2.
> mysql -h localhost mysql gives me error 1045 again.
> Can't g
Mike(mickalo)Blezien wrote:
>Hello,
>
>Sorry for the OT,.. but I was hoping someone may suggest a script that can
>monitor multiple mysql servers. We have two running and I would like to setup a
>cron to check the servers once an hour or so to make sure it running and if not,
>it would be capable
Subject: A random occur problem. Error message: Couldn't fix table with
quick recovery: Found wrong number of deleted records. is reported when
trying to execute DELETE/DROP TABLE and then INSERT... SELECT statement
with thoursands of reocrds.
>Description:
Problem occurs w
88 matches
Mail list logo
