The MySQL server keeps crashing together with half the tables
(MySQL-3.23.38). The server is tight-loaded, but not enough for a
possible lack of resources. It all acts on a Dell server,
Linux-2.2.18.
Sincerely yours
Maxim A Belushkin
System Administrator
Hosting Unit
RUNET.COM
Hi Guys,
I am running MySQL on windows 2000 and I have just noticed something
very strange! I have been setting up a network over the last few weeks and
managed to install MySQL ok when I wasn't logged on to our domain (I could
just run a command prompt, change directory to c:/mysql/bin
Hi Guys,
I am running MySQL on windows 2000 and I have just noticed something
very strange! I have been setting up a network over the last few weeks and
managed to install MySQL ok when I wasn't logged on to our domain (I could
just run a command prompt, change directory to c:/mysql/bin
Well, my server is running on Mandrake 8.0. We're trying to implement
database hosting at our site, therefore people should probably have
database spaces between 10-50 MB.
In Microsoft SQL server you can limit the size of a database when
creating it. Is it possible in MySQL ?
VVM
Bonjour Heikki,
In fact this morning Mysql is ... crashed on this server :(
It never crashed with 3.23.38 :(
I don't yet know if this is really a 3.23.39 problem or something
else.
If I'm able to restart Mysql, I will downgrade to 3.23.38 in order
to see if it's back to
Hi Ladies and Gents,
does anybody has experience with mysql + nfs, or mysql + Nettapp Storage?
thx for feedback,
Stepan
Stepan Havel
Nextra Telekom GmbH
Kirchberggasse 33
1070 Vienna
Tel: +43-1-52533-837
Fax: +43-1-52533-100
Mobile: +43-699-15253-837
hallo!
With reference to Terrell Johnson on 18.06 06:10:
how to setup passwords for mysql
mysql use mysql;
mysql replace into user values ('localhost', 'root', password('testadmin'),
'Y', 'Y', );
mysql quit
Bye
user01@tunix:~ mysqladmin -u root reload
try it with this
On Mon, 18
On Tue, Jun 19, 2001 at 09:27:15AM +0200, Stepan Havel wrote:
Hi Ladies and Gents,
does anybody has experience with mysql + nfs, or mysql + Nettapp
Storage?
Several folks on this list (or who *were* on this list) do, yes. Check
the list archives and see if you find the answers you seek.
On Tue, Jun 19, 2001 at 04:49:58AM +0200, Tonu Samuel wrote:
On Mon, 18 Jun 2001, Jeremy Zawodny wrote:
I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or
entries) woudl list the available directories, like others have
suggested. Then, using SQL, you could:
*
The answers I find are on the one hand: Yes, it works perfectly, I run mysql
on a Netapp filer for hunderts of years! , or on the other hand: It simply
does not work with nfs and locking it core dumps inconsistent isam files and
so on!
Do you feel my problem? :-)
Stepan
-Ursprungliche
On Tue, Jun 19, 2001 at 09:47:27AM +0200, Stepan Havel wrote:
The answers I find are on the one hand: Yes, it works perfectly, I
run mysql on a Netapp filer for hunderts of years! , or on the other
hand: It simply does not work with nfs and locking it core dumps
inconsistent isam files and
Hi,
I wanted only to know, if there is a possibility in
mysql for cascading delete's? Because in databases
with a lot of tables, it s really difficult to pay
attention to all of the dependencies and it would be
nice, if there is a possibility for automatically
deleting the dependent records.
Thx, that helped! We plan it in the sipler scenario (1 mysqld at time) Of
cource we will test it first, before taking it into production. My last
question would be: Does it also work if the lockd and statd is not running
on the machine where mysqld is running?
Stepan
On Tue, Jun 19, 2001 at
mysqladmin --help will provide you with a list of switches you can use.
If you add -u root to the shell command , perhaps you'll have more
success.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 16:37
Subject: create database problem
That requires the use of foreign keys and that's not supported.
- Original Message -
From: Sibel Toprakkiran [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 16:23
Subject: cascade delete's
Hi,
I wanted only to know, if there is a possibility in
mysql for
hallo terrell!
what if i can't get into mysql anymore at all, not even as root, :(
is there file somewhere i can edit so i can get in again?
have you try it with this?
mysql -u root mysql
Gruß bye
Michael Ott
-
- Siemens AG - IS IT PS 51 ERL -
-
hai
Can anybody help me? I'am query out data(country name) from database,total
count of country if 100.Now i want to arrange the country's name by 3
column() not long list.It should be
example:
trtdAntigua/tdtdAustralia/tdtdAustria/td/tr
trtdBarbados/tdtdBelgium/tdtdBrazil/td/tr
Hi,
I have several problems to do with tuning mysql to run on a Sun E450.
Firstly, I cannot get the mysql to read the my.cnf file. If it is
installed in the data directory, mysql boots OK but ignores it, while if
I copy it into the /etc directory I get the following error
Starting mysqld daemon
Hi,
Do someone maybe know, if it is possible to transfer a
mysql database?
Is it enough, that I copy the
/mysql/data/$databasename to another computer to have
there the same database with the same tables and
records?
thanks regards,
Sibel.
__
Hi,
I am wondering why I am unable to use the SELECT statement to access
data in a MySQL (3.22.32) database I have created using phpMyAdmin
(2.1.0). Everything else about it is a delight to use (I am migrating
from SQLAnywhere) and I have managed to create tables and insert data
into them no
Dave FitzPatrick writes:
I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f
Alpha box from 3.22.25 to 3.23.38.
As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with
appropriate flags set. I do not have the GNU binutils installed, so it
is the
Hi!
Thanks for the nice test case!
Next time you have as nice a test case, please send it to
[EMAIL PROTECTED] for fast treatment!
tommie == tommie [EMAIL PROTECTED] writes:
tommie count() gives 0 but count(distinct) gives 1. is this correct or
tommie a bug or is there something wrong
hi!
Steven == Steven Roussey [EMAIL PROTECTED] writes:
Steven Now I have a question: Does this also apply to automatic
repair inside
Steven mysqld? I'd finally use the feature if its true...
If you just run CHECK TABLE, it will repair the open count (it should
always have done that).
r When begining and commiting a transaction using perl and DBI, does the
r commit need to come from the same statement handle as the begin or does it
r just need to be from the same database connection handle?
If you are using DBI for transactions you should have something like:
Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump',
remove the 'redirect to' after the mysql command. This also assumes you are
logged into the localhost using the command line interface.
Your command would appear similar to the following:
mysql -u jjames -psd342
Rolf Hopkins writes:
That requires the use of foreign keys and that's not supported.
The above is true, but in a near future beta version of multi-table
delete will be ready for testing in 4.0 branch.
Syntax will be :
delete t1,t2,t3 from join_of_any_type_involving_at_least_t1_t2_t3
On Tue, 19 Jun 2001, Patrizio Bruno wrote:
BTW, why did you change the chunksize? By default it is 256000 and I
tested it for speed with many different values. 256000 seemed to be best
value. If you have any experience showing that I was wrong, please share
it with me.
I was testing
Hi,
For most of the platforms Mysql has reasonably enough
space for each table itself(in GB).Database wise, also
there should not be any problem for the database size
you are mentioning.For sure,I can say that I have not
worked on Mandrake.But, I feel the size you have
mentioned should not be a
Woyou,
you should use mysql-max.exe on Win 9x an Win ME because
mysqld.exe in 3.23.38 was accidentally compiled with __NT__
defined.
But I recommend downloading the new 3.23.39. It does not have
the above problem.
Regards,
Heikki Tuuri
http://www.innodb.com
Copied message:
Sehr geehrte Damen und Herren,
ich bin dabei eine Homepage (Futureworld3000.de) mit php und mysql zu erstellen. Ich
konnte aber bis her keine Informationen über ADO finden.
Über Informationen währe ich ihnen sehr Dankbar!
Mit freundlichen Grüßen
Volker Menten
I use the MD5 command in mysql...I think PHP also has this...
refer to the manual
Hasan
- Original Message -
From: Mike [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 9:50 AM
Subject: RE: assign auto password
Using PHP you can. PHP Nuke has this, I use it
Hi Mark,
I had the same problem too.
I downloaded the gcc 2.95.3 and compiled it myself.
Using thatt gcc to compile MySQL, and everything worked fine.
kind regrads
Peter Bethke
-
Before posting, please check:
Alex,
this mysql/innobase/trx/trx0undo.c prints trace information
on what it finds at database startup.
Could you try compiling a new mysqld and try starting the database
with the new mysqld. Obviously the recovery goes into an infinite loop,
and this helps to find out why.
Regards,
Heikki
please,
does mysql support unicode?
thanks in advance
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Thanks for catching this - I had an extremely long merge union, and had a
table missing - no error, so I've been trying to track down a configuration
issue for two days.
- Scott Russell
-
Before posting, please check:
Make sure my.cnf is mode 744.
David Allen wrote:
Hi,
I have several problems to do with tuning mysql to run on a Sun E450.
Firstly, I cannot get the mysql to read the my.cnf file. If it is
installed in the data directory, mysql boots OK but ignores it, while if
I copy it into the /etc
host.ism is in the var/mysql/mysql directory.
chown -R mysql /var/mysql
Subistitute the real path for /var/mysql.
[EMAIL PROTECTED] wrote:
Description:
Upgraded from 3.22.27 to 3.23.32. Built from source.
When attempting to start the daemon, it immediately terminates. Log file shows
This isn't so much of a MySQL question as it is a PHP (or ASP or whatever)
question.
At any rate, probably the best way to do this is with nested FOR loops. In
PHP, it would look something like this:
mysql_select_db(database_name);
$qry = select country_name from table_name where
Hi,
I am using mySQL 3.22.23 on a Linux platform. How can I copy or move Tables between
different Databases? Is there a simple command for that? We do not have the
mysqlhotcopy command; is it safe to download and use for our mySQL version, and can it
do what I want it to do? I cannot find
Is it better to have very small tables with a max of 3 rows, slightly larger
tables with several indexed columns. I am designing a database for a medium
size company. I certainly plan to expand the business and the database. I
want to make sure that I plan the DB correctly from the beginning.
It would seem that there is a bug, and it's that create table
accepts an 'illegal' definition. It should either convert the integer
to a literal (making the definition legal and dumpable), or it should
barf on it.
IMO, of course.
--Pete
[Charset iso-8859-1 unsupported, filtering to ASCII...]
Hi All,
The new Mascon version 2.2 was released recently. For more detail and a
complete list of features see http://www.scibit.com/mascon.
Some of the new features:
* Server side result sets
* Support for fulltext index creation in the visual table designer
* Support for sub-part indexes
At 10:23 am +0100 19/6/01, Tommy Beavitt wrote:
I am wondering why I am unable to use the SELECT statement to access
data in a MySQL (3.22.32) database I have created using phpMyAdmin
(2.1.0). Everything else about it is a delight to use (I am
migrating from SQLAnywhere) and I have managed to
Hi all,
... running this query
alter table item_dettagli
add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua)
I get this error:
1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140)
Query:
alter table item_dettagli
add
Drop the semi-colon off the end of the SQL Statement you wish to run. You
don't need them in the phpMyAdmin SQL Window.
Enjoy,
Tyrone
- Original Message -
From: Tommy Beavitt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 8:31 AM
Subject: Re: phpMyAdmin newbie
I am new to mysql. I am attempting to place images in one of my columns. As
for my table structure, I have gotten as far as:
image blob NOT NULL,
How should I proceed?
Thanks a bunch
Get free email and a permanent address
I'm generating a pulldown menu using PHP and MySQL. Originally I had the
list order by model where it put everything in alphabetical order. I need to
order them by year of model which luckily coincides with the order that I
dumped them into the database so I would like to ORDER by id which was an
hi,
I'm trying to automate the back up of my databases,
and before I perform my backup I check my tables using
myisamchk and isamchk.
When myisamchk and isamchk report errors I would like to catch that
and maybe perform a restore operation.
hence my question: what could go wrong when running
Hi,
No problem in my case, i´m using varchar inorder to get url and image paths and works
well, and they are indexed in some cases.
Blob fiels make tables work slower? Does they use much disk? I´m meking a database
with descriptions of buildings usin blob for descriptions. Is there another
On Tue, Jun 19, 2001 at 08:48:56AM -0700, Brian Warn wrote:
Hello,
I want to use two text columns as my primary key. From the DuBois
book, I see that I cannot do this since my v. 3.22.32 tables are
ISAM, and BLOB and TEXT columns cannot be indexed. Besides
upgrading to v. 3.23+, is there
you should probably just store the images on your server, and provide the
location to the image in the table...much quicker.
Tyler
- Original Message -
From: Felicia [EMAIL PROTECTED]
To: mysql post [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 11:03 AM
Subject: inserting images in
IMHO, (take it for what it is worth)
You shouldn't. Store a reference to the image in the database.(either a file
system reference, or if you are doing HTML, store the URL) I've yet to see
a good reason for stuffing an image in a database. In most cases the OS/file
system will handle the image
I copy the 3 MYD MYI frm of a database to another directory as a way of backup.
Is this the right way to do it. It appears to be not function correctly.
Any help appreciate.
Thanks.
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at
Hi,
I want to embed MySql in my application.
Please help me in doing this.
Ankur
Hi,
Maybe someone could take a moment to explain this behavior?
I am using IFNULL() in an order by statement to push null values to the
end of a table for sorting.
For example:
mysql select distinct s.some_pk as myid, queryid from data_table s,
userdata.queryinfo q where s.some_pk=q.myid order
Alot of it would depend on what exactly you are doing. If you have alot of small
tables with only 3 columns(I'm assuming thats what you meant) that can make for a
messy server when it starts getting hit by a demand. Also, there are lots of good
books on database design. Que generally has made
If you drop the order by, does the second query work?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: BCC [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 12:18 PM
Subject: IFNULL issues??
Hi,
Maybe someone could
Yep. In fact, if I replace 'myid' by s.some_pk the query works as well.
This is what make me think it was a feature (bug?) with IFNULL in that it
would not recognize aliases. But then theres the query that does work :P
Bryan
-Original Message-
From: Cal Evans [mailto:[EMAIL
I can't reproduce the error using a different database configuration and
I can't use the same database schema to make my test (the machine is now in
production state), so I attached to this mail te sql file used to create
the tables, this database is used by ASPseek 1.2.0, you can download it
at
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
- Original
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
The single
Olá, instalei o mysql no Win98 porém o mesmo não está OK. Alguém tem um
passo a passo, porque estou com pressa para procurar na web, mas me parece
que tem que ter o perl instalado, isto confere?
Marcos
P.S.: estou usando Win98 e PWS.
OS: RedHat 6.2 on master and slave
mySQL:3.23.32 on master and slave
Problem: Replication is not working. Symptoms include:
* Connecting OK. 'Show slave status' reports nominally.
* Position on the log file increments correctly when updates occur on the
master.
* The tables do
Is it possible to observe Handler_read_next and Handler_read_key on a per
table basis? If not, could this feature be added?
I'm not subscribed to this list, please cc all replies back to this email
address.
- Pat Wendorf
-
On Fri, 15 Jun 2001, Jeremy Zawodny wrote:
On Fri, Jun 15, 2001 at 12:53:04PM -0600, Chris Bolt wrote:
Is this machine basically dedicated to MySQL? If so, I'd try bumping
up the record_buffer to 16 or 32MB and see what that does. I've got it
set at 32MB on a server with 1GB of RAM.
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
Hello all,
I'm a newbie to the list and mySQL. So please forgive me. I have no
idea what I am doing running a server but i'm doing it!
I have a client who needs mySQL and have no idea how to do this. I
have a cobalt raq4i.
Is there a resource for a real beginner like me to go to with
I need some advice on how to export a tables data to import later into
Access.
This export HAS to be automated (and I'm using VC++ API for MySQL)
The problems I'm faced with are
(1) Before I can import this data into access I have to create the table
in access; I'm familiar with ADO and
Dear all!
Thanks a lot for attention.
I solve my problem using an alias to COUNT.
Regards for all!
***Paulino Michelazzo Reply***
Hi all!
I need to get the count field in a select instruction like this:
(from My-SQL help)
SELECT owner, COUNT(*) FROM pet GROUP BY owner
Not sure I'll be helpful, but I ran into something similar yesterday. Not
exactly sure how I fixed it, but this is what I believe.
1) You should create a virgin data directory per the standard procedures on
the production machine (install_db and safe_mysqld).
2) Then, if you have existing
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
On 19 Jun 2001, at 13:36, Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Dave FitzPatrick writes:
I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f
Alpha box from 3.22.25 to 3.23.38.
[snip]
I edited sql/Makefile and replaced the two occurrences of:
- Original Message -
From: [EMAIL PROTECTED]
To: Mario Kent [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log no -log ?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
- Original Message -
From: [EMAIL PROTECTED]
To: Mario Kent [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 1:40 PM
Subject: Re: Version question: -log no -log ?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the
I installed 3.23.38 from source on a linux server, a status simply says:
Server version: 3.23.38
Now, I just installed 3.23.39 from source on another linux server and it
displays:
Server version: 3.23.39-log
I want to know what the -log means and how it got in there.
[In order to get this
I'm by no means an authority on this kind of stuff but you could write a
portable C program that generates a big ol' SQL script containing INSERT
INTO statements :)
I can't really think of a fast way to do it since you want to go between
MySQL and Access without ODBC and other utilities (I'm not
At 7:27 PM -0400 6/19/01, Mario Kent wrote:
I installed 3.23.38 from source on a linux server, a status simply says:
Server version: 3.23.38
Now, I just installed 3.23.39 from source on another linux server and it
displays:
Server version: 3.23.39-log
I want to know what the -log means and how
Hello, MySQL users/hackers:
As some of you know, we are currently actively working on MySQL 4.0, and are
making some progress. Those who are subscribed to the internals lists get
notified of all of our commits and can monitor the progress.
If you would like to do a pull from our repository
Can someone please confirm that there isn't a problem with the
configuration files for MyODBC 2.50.37?
When I run make after configure, I get the error:
Makefile, line 315: Need an operator
make: fatal errors encountered -- cannot continue
Line 315 contains:
-include $(DEP_FILES)
If I comment
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
or BUILD/compile-pentium-debug - it will build a binary for you.
We run all our MySQLs on the fast SPARCs and PPCs
is pentium the only supported hardware right now?
-RG
On Tue, 19 Jun 2001, Sasha Pachev wrote:
At 11:04 PM +0200 6/19/01, Attila Soki wrote:
| Paul DuBois [mailto:[EMAIL PROTECTED]]
| When UNIX_TIMESTAMP is used on a TIMESTAMP column, the function will
| receive the value directly, with no implicit
| ``string-to-unix-timestamp'' conversion. If you give UNIX_TIMESTAMP() a
| wrong or
Hi,
I try to install mysql-3.22.32-sun-solaris2.7-sparc on our department's SUN machine
and I failed several times. Is it possible to install this database on general user(
since I am not the root)? I followed the steps to install( ater I got the directory
for
On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
or BUILD/compile-pentium-debug - it will build a binary for you.
We run all our MySQLs on the fast SPARCs and PPCs
is pentium the only supported hardware right
Someone else asked this question last week, and it turned out that she had downloaded
the Sun/SPARC version (as you did) and tried to install it on a Sun/Intel system...
If you type uname -a, what does the display tell you ??
zhiheng_huang wrote:
Hi,
I try to install
You can start with the mysql manual. Then there is Paul DuBois book, people
say it's supposed to be good.
- Original Message -
From: WebNomad Inc. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 20, 2001 4:39
Subject: Setting mySQL for a user
Hello all,
I'm a newbie
Hello!
I've did an big mistake.
I've deleted the mysql-db folder at \var\lib\mysql on my new empty webserver.
Then I copied an mysql-db from my local Computer (Win2000) to the webserver.
Afterwarts MySQL starts an I could make queries on this internal mysql-db.
But I can't make any changes an
I counldn't agree more with this email that was sent by Jay.
I really don't see how tables with only three columns would be an advantage
to any systems. On the contrary, I think it would be complicate to select,
insert, update and delete information.
The ecommerce example that I posted in my
hi
Can anyone please help with regards to long blob data insert.
I have a data which more than 1mb which MySQL long blob field refuse to insert.
However if my data is less than 1mb there if no problem with insert.
What parameter do i need to set up..
Please help
thanks in advance
regards
Nothing of any use ... Sometime between 6/4 and 6/12, it stopped
listening... It says it starts, but if you try and connect from the mysql
client, it just hangs.
...
010604 22:25:55 /usr/local/mysql/libexec/mysqld: Shutdown Complete
010604 22:25:55 mysqld ended
010604 22:26:58 mysqld
Hello,
although i am not a newbie to mysql and rdbms i am new to the list and
have a problem connecting an application to MySQL. The application is
written in OpenScript which was the language of the Toolbook IDE from
Assymetrix. Now: although we are able to link the ODBC dll, when we try
to
Hi all,
I'm new to this list, fairly new to PHP and mySQL and I have a question
about syncing two databases. I search all over the web for this, including a
win32 version of rsync, but that's not suitable in my case, so here it goes:
I have a MySQL database A running on my local machine
92 matches
Mail list logo