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
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 of
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 get in with
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
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 your
mysql
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 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
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:
o
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
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,db
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\binmysqld
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?
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 have a thread
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 a place
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)
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
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
'jean' in
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]
/ /|_/ / // /\
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
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
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:
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)
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
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 wrote
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
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.
mysql -h localhost
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
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 stores
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. Thanks!
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
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
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
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
range is
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,
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
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
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 from
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
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,
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
keeper and
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 mysql
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,
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
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.
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
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
|
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
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
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)
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 the
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)
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
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 check:
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
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:
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 the
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
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
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 to
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
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]'
* 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 URL:
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
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 where all
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
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
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]
?php
/* Happy Holidays */
* 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 lt;, and you should probably put it inside a PRE
html element.
If you want to display the result
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
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
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)
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
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 result is
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 want
snip
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?
snip
Figured it out. I completely forgot about two php functions that
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 .. ?
Is it
Ahh.. I was about to reply but nevermind. The two functions you're talking
about are addslashes() and stripslashes(). Yes those are very handy. :)
snip
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
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
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 word
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
Disregard please...
database,sql,query,table
--
=
Linux rocks!!! http://www.dedserius.com/
=
-
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
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
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)
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
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,
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 upgrade in
87 matches
Mail list logo