Dear:
I can not start mysql server.
There is an error when I start mysql using :mysqld start or safe_mysqld
The error is :
Can not connect to 'localhost' throught ~/mysql.sock
Please check is file ~/mysql.sock exist!
I checked the file, it exists, but it have zero byte. And my linux
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What are the results you expect. There are always workarounds
Adrian
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
> Sir,
>
> created the following tables as primary and secondary
>
> primary : partycode(primary key),partyname
>
> secondary
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What did you do to get the error
Adrian
On Fri, 30 Mar 2001, Lebrun Jonathan wrote:
> What's error 1062 ?
>
> Thanks.
>
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE6xYp3/f1mUN
we are having no suitable driver error. Please help us to get rid off this problem.
we are having SunOS 5.7+tomcat webserver+mysql 3.23.32.
thanks,
naveen
Hi
"!Big money" customers in the UK include
British Telcom, Lloyd-TSB Bank andd the Hurst Newspaper Group
At 14:56 30/03/2001 -0500, Anthony R. J. Ball wrote:
>Hehe, yeah, I mentioned slashdot... for some reason,
>they just weren't impressed :)
>
>You know the type... unless they are
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at th
Dear All,
Is it possible to mail only three columns from a database ? Third column
being email ID?
I need to send email to all with a valid email ID in a database.
Thanks
Regards
Prasad
-
Before posting, please check:
htt
Make sure you have installed the MySql-shared package
At the command prompt type
gcc -lmysqlclient -I/usr/include/mysql file.c
where file.c will be file that contains the C APIs
Best Of Luck
Shambhu.
_
Chat with your friends as soon as t
I am interesting in develop tools, for plataforms,like
PHP, Linux, Apache, etc...
but I have a Sistem, with Clipper, and I need know, if
MySQL supports, NTX indexs, is very important, for
me,know this, Can you help me please...
Atte: Aarón Reyes
_
At 5:56 PM -0800 3/30/01, Guo, Zhian wrote:
>Hi,
>We have been encountering a problem running mysql on sgi. We normally run
>it as a normal user, which writes the file /tmp/mysql.sock. However, when
>the machine is rebooted while the daemon is running, the mysql.sock file's
>ownership will chan
> want to know is a few examples of medium to large
> companies using mysql for mission critical stuff.
I too am in a similar situation, needing links to large organisations on
mySQL. This would help me to replace the largest-ever (proposed) deployment
of MSSQL (as per the official release of Micr
Hi,
We have been encountering a problem running mysql on sgi. We normally run
it as a normal user, which writes the file /tmp/mysql.sock. However, when
the machine is rebooted while the daemon is running, the mysql.sock file's
ownership will change to root. After that we can no longer start t
> Two things that I am sure will be answered very quickly.
>
> 1) I have a development box that I have successfully installed and
> configured 3 seperate instances. Each instances has its own port
> number.
> When playing around with mysqladmin I know I can specify the port
> number as
> an opti
On Fri, 30 Mar 2001, Kristopher Briscoe wrote:
> Two things that I am sure will be answered very quickly.
>
> 1) I have a development box that I have successfully installed and
> configured 3 seperate instances. Each instances has its own port number.
> When playing around with mysqladmin I
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port number.
When playing around with mysqladmin I know I can specify the port number as
an option, but what
How are you supposed to convince people that MySQL is a worthy
DBMS with boring testimonials about millions of dollars worth of dataflow
and incredible fault tolerance?
If you REALLY want to sell MySQL, point them to http://m4m4sex.com/, a web site
that is dedicated to helping men find men for re
Rol wrote:
>
> Hallo all,
>
> A table containing some text needs to have some of the letters changed (eg.
> letter ä to be replaced with "ä" ).
>
> Is there a way to use a replace function to search for such chararcters in a
> text and then replace it with the html tag?
Yes of course and this
Greetings Steve:
At 12:01 AM 3/31/2001 +0100, Steve Allsopp wrote:
>"Dexterus (www.dexterus.com) is a VC-funded company set up to provide
>application services to the banking industry in the City of London. While
>we are still in the pre-launch stages (we launch Tuesday!), we are aiming
>for a
Not sure how much use to you it would be, but my employers, Dexterus Ltd,
trust my judgement enough to have adopted my recommendation to use MySQL
as an "embedded" DBMS in our smallscale PC-based systems. It has been
deployed in a "farm" of PC's running Linux to co-ordinate virus scanning
of emai
Hi All,
On Tue, Mar 27, 2001 at 02:28:05PM +0100, Rafael Martinez wrote:
> I am thinking to install our DB server in a 4-way machine with
> Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql
> works OK in a 2-way machine but that in a 4-way system has to be tested.
>
In the last episode (Mar 30), Heikki Tuuri said:
> The FreeBSD bug is known. I will run tests on our FreeBSD machine in
> the next few days. Obviously there is something wrong with the
> FreeBSD port. Was it so that it hung and used 100 % of CPU? That has
> been reported also from Italy.
I have a
If he is talking about the Samples that come with Paul DuBois book MySQL
thay are at:
http://www.mysql.com/Downloads/Contrib/Examples/samp_db.tar.gz
Jason Maderios
-Original Message-
From: Mike Roberts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 5:21 PM
To: Anthony R. J. Ba
My company is using it for all database functions. We're an online
'collection' agency and have been using it for the past 6 months (versions
3.22.23 upgraded to 3.23.36). In comparison with Borland's
"Interbase" ("Ibase"), which I supported at the late "Money Store"
corporation for all 100 of
I have write a simple program in C/C++.
this program use API for Mysql (linux)
the question is :
How to compile this programs?
Tank you in advance, Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I asked for the same things awhile back. But you got more responses
then I did!
I got the yahoo address from
Jeremy D . Zawodny
http://biz.yahoo.com/ne.html
Thanks Jeremy, its a good site
At 02:48 PM 3/30/2001 -0500, you wrote:
> Now that our use of MySQL is being questioned (but
>they are
I'd like to write a simple application with API of MySql.
I see "4.4.1 A Simple Exaple" of the manual but I can't find the file
"simple1.cc" that should be in my computer... but there isn't.
How can install it?
thank you in advance, Mario.
join
__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/?.refer=text
-
Before posting, please check:
http://www.mysql.com/manual.ph
Some MySQL Users
http://www.mysql.com/documentation/mysql/bychapter/manual_Users.html#Users
Regards,
Ernesto Vargas
- Original Message -
From: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 2:48 PM
Subject: Need examples of companies using
Check this Motorola press release, it may help you...
Motorola Teams With MySQL AB to Offer Tools for Developers to Create Mobile
Database Applications
http://www.corporate-ir.net/ireye/ir_site.zhtml?ticker=MOT&script=410&layout
=-6&item_id=161725
- Original Message -
From: "Anthony R
I recently read where NASA has switched some of their systems from Oracle to
mysql and saw a performance increase.
We are use it inside Bank of America for somethings and are very pleased
with the performance.
Kris-
>From: "Peter M. Perchansky" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Sub
Greetings:
We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based
advanced monitoring service utilizes the power of mySQL.
While I don't have the institutions name, I was told by Verio Advanced they
have a financial institution running mySQL.
XOXO Clothes (http://www.xoxo.com/)
I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 12:48 PM
Subject: Need examples of companies
On Fri, Mar 30, 2001 at 02:56:53PM -0500, Anthony R. J. Ball wrote:
>
>Hehe, yeah, I mentioned slashdot... for some reason,
> they just weren't impressed :)
>
>You know the type... unless they are a big money
> company, then they can't be doing anything mission critical :)
We use My
Hehe, yeah, I mentioned slashdot... for some reason,
they just weren't impressed :)
You know the type... unless they are a big money
company, then they can't be doing anything mission critical :)
> www.livejournal.com www.slashdot.org www.everything2.com
--
___ __ ____ _ _
www.livejournal.com www.slashdot.org www.everything2.com
At 02:48 PM 3/30/2001 -0500, Anthony R. J. Ball wrote:
> Now that our use of MySQL is being questioned (but
>they are pretty much convinced). What the higher-ups
>want to know is a few examples of medium to large
>companies using mysql f
I read that SGI (sgi.com) uses all kinds of MySQL DBMS's behind the scenes.
Presumably, they're running on Irix. ;-)
HTH,
Jed
On 3/30/01 11:48 AM, you wanted me to know this:
>
> Now that our use of MySQL is being questioned (but
> they are pretty much convinced). What the higher-ups
> want to
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
If any one can provide some I would be much appreciated.
We are a financial company usi
Received the error again this morning;
I was able to copy an older copy of <>.frm file into
tbl_status.frm (via Sinisa's response), and the problems
went away; all data appears to be intact.
[Largest *.MYD files is 186 mbytes & *.MYI is 32 mbytes.
Note that all database directories & files res
join
-
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PRO
>Description:
I have installed MySQL version 3.23.36 (having previously used 3.23.34a)
After I restarted the daemon, I ran the mysql 'monitor' program to check on the
existing databases and tables. Mysql reported for each table: "Didn't find any fields
in table 'table-name'". This
I received several of these messages when I repaired a table. Can anyone
give me any insight about this message.
Should I export all data to a new table or can this message be ignored?
Found block with too small length at 3532; Skipped
--Bill
Does anyone know of a software package that can create stats from the
MySQL logs? Something similar to Analog (for HTTP logs).
Any and all help is greatly appreciated,
Bill
-
Before posting, please check:
http://www.mysql.
Hi again,
Im looking for someone that has a win 2000 mysqld compiled with --with-raid
Any one?
Need it. And dont have any possibillity to compile it myself.
/roger
Hi Seung!
Yes, you have to do some tuning to get the performance from a transactional
database. You should not use autocommit=1, because then the database
has to physically write the log segment to disk after each individual
insert. Try to insert your data in a single transaction, only a single c
If you can export all your data from any database program, using any field
and record delimiter character you like, then it can be imported into MySQL.
There is always a way.
Not being familiar with Approach97, I can't answer for sure, but
If there is absolutely no way to export your data as a t
Hi Seung!
Yes, you have to do some tuning to get the performance from a transactional
database. You should not use autocommit=1, because then the database
has to physically write the log segment to disk after each individual
insert. Try to insert your data in a single transaction, only a single c
Am 17:44 30.03.2001 schrieb Herman Pool:
>Hi out there,
>
>I'm new with MySQL.
>I have installed Linux 6.0 and MySQL 3.23.33
>
>This happens when I want to create a database:
>
>[mysql@nestorix mysql]$ mysql
>Welcome to the MySQL monitor. Commands end with ; or \g.
>Your MySQL connection id is 49
On Fri, 30 Mar 2001, Herman Pool wrote:
> Hi out there,
>
> I'm new with MySQL.
> I have installed Linux 6.0 and MySQL 3.23.33
>
> This happens when I want to create a database:
>
> [mysql@nestorix mysql]$ mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection
I tried -r
I tried -o
I tried to truncate the table and re-build the index from scratch.
I tried to create ex-novo a table, import data from scratch and it
result in a corrupted table.
None of these seems to work
Bob Hall wrote:
> Sir, I looked quickly through the mass of data supplied below,
No.
In other implementations, executing 100 stored procedures is actually LESS
taxing to the server than executing the same code 100 times. The stored
procedure can be compiled once and execute 100 times. The embedded sql
cannot.
Cal
http://www.calevans.com
-Original Message-
From: Jo
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 3.23.33
Type 'help;' or '\h' for
For the longest time, I'v ebacked up my various MySQL databases using
mysqldump. However, I hated restarting the database each night (on a few
occasions it would restart but the databases could not be accessed until it
was restarted again) Plus I think mysqlhotcopy is a more elegant solution.
O
Hi
Agreed but it still incurrs a performance penulty; more so when the server is
under heavy load
On Friday 30 March 2001 16:15, Steve Ruby wrote:
> How come nobody has mentioned that complex data manipulation can be
> performed on the server without waistuful and slow transmission of unwanted
>
How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without SPs
At 18:52 29/03/01 +0200, you wrote:
Hello again!
>Sorry but didn't see your other comments on first reading.
I thought that the key cache meant that mysqld would only hold key/indexes
in memory and that the data the indexs point to would
still be read/written from disk. It's just that it seems
Stored procedures offer several advantages over embedded SQL.
1: It is easier to write, debug and modify SQL code in a stored procedure
with a tool designed to do that. You can write PHP from the command line
also but not many people do it.
2: Placing the code in a stored procedure allows you t
Sir, try
SELECT g1.name, g1.score, g1.id
FROM grades g1, grades g2
WHERE g1.name = g2.name
GROUP BY g1.name, g1.score
HAVING Max(g1.score) = Max(g2.score);
Bob Hall
>Q: I have the following table "grades".
>
>++++
>| name | score |id |
>+
Sir, I looked quickly through the mass of data supplied below, and it
looks like you only tried myisamchk with the -r -q option
combination. Try it with just -r. If that doesn't work, try it with
-o. If that doesn't work, restore from backup.
Got backup?
Bob Hall
>Antonio gulli wrote:
>
> >
Hi
I must agree with you on this point, after what can be done in a stored
procedure can also be done with SQL. The only real advantage I can see to
provide a centralized store of commonly used SQL, but then again these can be
stored in a text file. The disadvantage is a down grade in performan
Hello,
I have a Cobalt Qube2.
I have recently compiled Apache 1.3.19, PHP4.0.3pl1 and MySQL 3.23.33.
Even though, everything compiled normally. I am unable to load PHP4 as a
DSO. When I run 'apachectl configtest', I get this error:
Syntax error on line 239 of /etc/httpd/conf/httpd.conf:
Cannot lo
THe manual says
To avoid using ROLLBACK, you can use the following strategy:
Use LOCK TABLES ... to lock all the tables you want to access.
Test conditions.
Update if everything is okay.
Use UNLOCK TABLES to release your locks.
I didn't quite understasnd the meaning of Test Conditions
Any
I don't mean to be argumentative, but what is everyones love affair with stored
procedures? I like putting my logic in the mid-tier and I'm constantly battling my
Sybase Admin at work who maligns me whenever they spot a query in my codeeven a
very simple select "oh, I can make that a store
Does somebody try to build MySQL-3.2.36 on Slackware 7.1?
I have an error trying to make test.
configuration:
[30-Mar-01][15:55]{ilya@odin} ~/Sources/mysql-3.23.36>./configure
--prefix=/usr/local/mysql --enable-assembler --with-berkeley-db
--with-charset=koi8_ru --with-extra-charsets=latin1,cp1
Frank Hennrich - Loher AG writes:
> Hi,
>
> I'm not very experienced yet with MySQL and MyODBC. So I would
> appreciate very much any help how I could start solving the following
> problem:
>
> We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and
> have exte
Hi Darius,
Just an idea: can you cut the binary data into separate small(er) chuncks
and then store it in different records? (Using some identifier to know
which chunks belong together, what is their order,...) This may make data
handling harder, but you can reduce the memory load of the server;
So, is there any support for stored procedures in MySQL or not
I don't think so, what do you think ?
thank you
Silvio Picano writes:
> Hi,
>
> Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
> Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
> Database with 40 tables.
> Biggest table has 2,131,447 rows in it.
> No problems for 6 months.
>
>
> Recently ported to mysql-3.23.35 / Linux 2.2
>command in mysql:
>How can I do?
>how can I write it?
Create a .sql file.. check the archive, same question has been asked 1 or
two days ago. Otherwise read info on websites about MySQL and other SQL
languages
Bye,
B.
-
Scott Ellsworth writes:
> Howdy, all.
>
> The following error came up when compiling under OS X release.
>
> c++ -DMYSQL_SERVER
> -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
> -DDATADIR="\"/usr/local/mysql/var\""
> -DSHAREDIR="\"/usr/local
Hubert Feyrer writes:
> On Tue, 27 Mar 2001, Sinisa Milivojevic wrote:
> > You also need fl_editor package. You will find a link on mysqlgui
> > page.
>
> OK, that indeed got me further. (Is it only me, or does putting a header
> file into one package, and the source in another one really s
Hackley, Susan writes:
> Help,
> I am trying to install the Sun Solaris 2.7 Sparc static binary of
> MySQLGUI 1.6 for the MySQLGUI the result was:
> ld.so.1:./mysqlgui-solaris-2.7-sparc-static-1.6
> :fatal:libstdc++.so.2.10.0:open fatal: no such file or directory
> 1. Trying to in
[EMAIL PROTECTED] writes:
> Hi !
>
> I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
> tables.
> The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
> The bug occurs randomly and makes MySQL restart...
> With REPLACE instead of REPLACE D
Peter Adamka writes:
> Thanks a lot, but I've make a mistake (supposing tha t I've done something
> I didn't ;-) -inserting -lfleditor switch). Sorry for it.
> Malmo
>
>
> Malmo> If I only got 20$ for evryon
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
>
> mysql> rename tables test1 to test3, test2 to test1, test3 to test2;
> Peter> ERROR 1192: Can't execute the given command because you have active locked
> Peter> tables or an active transaction
>
> I bet this happens when you
Read the archives of this list.
P
On Fri, 30 Mar 2001, Sheikh wrote:
> Respected Sir
> i want to know how i store a image in mysql.i sue perl for scripting on linux.
> please help me
> thanks
> allah hafiz
>
>
-
Before post
Hi,
I'm not very experienced yet with MySQL and MyODBC. So I would
appreciate very much any help how I could start solving the following
problem:
We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and
have extended this system by some own applications written in Fortr
Respected Sir
i want to know how i store a image in mysql.i sue perl for scripting on linux.
please help me
thanks
allah hafiz
Hi Darius,
It depends on, what client softwer do you use... For example if you would
like to fill BLOBs from a perl script via DBI, you have to use parameter
binding. Could you give me some details?
Regards,
Peter Szekszardi
PortoLogic Ltd.
Portal building, prime number generating, script hacki
Hi,
> This is my full code
>
> $www_domain="select Failed_Signups.EmailAddress.Email from
> Failed_Signups.EmailAddress left join www_domain_net.Members on
> Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
> www_domain_net.Members.EmailAddress is null";
> $www_domainR
resend!
pls reply
--
From: Sulman
Sent: Monday, March 26, 2001 9:21 PM
To: '[EMAIL PROTECTED]'
Subject:MySQL & Approach97
Hi All!
I'm new in the mailing list & just want to know about the data transfer from
Approach97 to MySQL.
In my company we are running Approach97
in UNIX derivatives,
vi a text file, and write your create/other sql into it then save and close
it.
cat your_file | ./bin/mysql -uyour_username -p your_database
you will be prompted to enter a password for your username.
then enter your password.
- Original Message -
From: <[EMAIL PR
It is easy make an error while writing SQL coimmand to create table, etc...
So I'd like to write this command (CREATE TABLE) in a file then run this
command in mysql:
How can I do?
how can I write it?
Thank you in advance.
Mario.
-
What's error 1062 ?
Thanks.
Alan Chu wrote:
>
> I am now using msql and wants to change to mysql. Is there any problem
> in install both in the same server?
>
> Regards,
> Alan
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (
84 matches
Mail list logo
