That's a least what I found out - other new users have the same problem
too. The ptoblem resides on WinNT/2K only (at least what I read), so
probably you are right, it might be a WinNT/2K specific problem.
Anyway, MySQL is a good product - that's what all say.
For me, I am happy to be able to use
Hi,
I just installed the MySQL max 4.0.1 and created a database with two
INNODB and FOREIGN KEY tables as described in the Docs.
When I run the mysqldump -a -B -c test I don't get the foreign key
information.
Any hint?
Adib.
Hello all,
Can i use rsync instead of replicating two servers for mysql( particular
database db).
If yes
Then just clear off my doubt whether it will lead to any data loss as
while doing rsync.
Thanx in advance.
Regards,
Charitha. C.
--
Regards,
CC
Hi
Is that possible to query the database from a bash
script?
I need some informations from a table, and it looks
the easiest way.
How can I connect, use a database, and query
a table?
Thanks in advance!
Regards;
Istvan
Hi!
cut
I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP Perl. Apache
reports that PHP Perl are running OK. When I try to start MySQL, or let it
start on boot, or try to use the WinMySqladmin program, I get a Windows
error from MYSQLD-OPT.exe, with the usual Win98 close and
To Dear Sirs 19/03/02
I am pankaj from Bombay India
I have downloaded Version mysql -3.23.49,my question is why dosent mysql
support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc
From Pankaj
Takacs,
I think you can use
mysql --execute=select * from whatever databasename
you should be able to execute mysql command thru bash that way.
chad
On Tue, 19 Mar 2002 10:20:08 +0100
Takacs Istvan [EMAIL PROTECTED] wrote:
Hi
Is that possible to query the database from a bash
I hope what I am going to say does not appear short or rude. It is not
meant to be. Having said that -
Why do you think MySQL doesn't support transactions? Have you read the
documentation?
You really should read all of the available documentation before posting a
question like that. You
Hi Pankaj,
It does support transactions...download MySQL Max:
http://www.mysql.com/downloads/mysql-max-3.23.html
You have the option of either innodb or BDB based tables for
transactions..support for both of these is compiled into MySQL max.
regards,
Simon
On 19 Mar 2002 at 15:23, pankaj
Alex,
the assertion means that when InnoDB looks for a father node pointer to a
page in the B-tree, it ends up on a pointer which does not point to the
child page. In other words, the B-tree is corrupt.
I see that the lsn of your database is rather small. Did you do anything
special before the
Hi,
If you can't read that output, try the
select * from mytable INTO OUTFILE absolutepath/myfile.txt FIELDS
TERMINATED BY , LINES TERMINATED BY \r\n
statement.
I do somthing with this :-)
Adib.
chad kellerman wrote:
Takacs,
I think you can use
mysql --execute=select * from
Alex,
since you are French, I assume you have accent characters in the strings you
have stored into your database.
The ordering of accent characters changed in 3.23.44!
You must dump and reimport your tables to 3.23.49 so that the index trees
are sorted in the right order.
Regards,
Heikki
Patrick,
Tuesday, March 19, 2002, 5:33:31 AM, you wrote:
PH When I periodically do myisamchk -s *.MYI,
PH it sometimes complains that some tables are corrupt.
PH Is there any way to keep mysql tables healthy? What are the reasons to
PH cause the table corruption?
There are different causes of
RBRoa,
Tuesday, March 19, 2002, 1:22:22 AM, you wrote:
R Everyone,
R What's the differences with MySQLD and MySQL-max?
MySQL-max is the MySQL server that support InnoDB and BDB table types.
You can read about mysqld-max in the manual:
http://www.mysql.com/doc/m/y/mysqld-max.html
R R.B.Roa
pankaj,
Tuesday, March 19, 2002, 11:53:33 AM, you wrote:
p I am pankaj from Bombay India
p I have downloaded Version mysql -3.23.49,my question is why dosent mysql
p support Transactions (Rollback ,Commit) lie Oracle or Ms Sql Server Etc
MySQL supports transactions in InnoDB and BDB tables.
If
Hello,
I would like to know how the 'jobs by email' service provided by employment
sites works and whether it is simple to develop or better to buy the
software. I need to set up scheduled automated email to users detailing
news headlines based on the email addresses and associated interests,
Hello,
I've got one last issue removing user accounts.
I notice I have a usera number nobody.
However when I look at the grants I get an error;
mysql show grants for nobody@localhost;
ERROR 1141: There is no such grant defined for user 'nobody' on host
'localhost'
mysql show grants for '
Hello all,
I am new to the list and have a quick question (I'm sure it won't be my
last).
I am running Mac OSX and I have PHP and MySQL running.
My question is this. I provide web hosting, and I want to offer my clients
access to MySQL. How do I set up Mysql so that every virtual host has
Hi pankaj..
You can compile mysql with innodb option..then you can have all the transactions
you ever want to have.
regards
Kannan
pankaj [EMAIL PROTECTED] on 03/19/2002 03:23:33 PM
hi,
I am also using the Innodb table type for my database. when I am using
the mysqldump for dumping the tables it really doesn't shows the
foreign key in the table structure.
but if after deleting my previous database I again create my database
using the same dumped file and executes the
matt,
Tuesday, March 19, 2002, 8:31:08 AM, you wrote:
Try to install the official MySQL binary distribution (3.23.49a) from
www.mysql.com and check timestamp there. There was some bugs about
timezones in old version of MySQL/glibc.
mDescription:
m A timestamp value selected back is 38
Vernon,
Tuesday, March 19, 2002, 3:19:35 AM, you wrote:
V I'm having trouble with Apache dying after log rotation and have tracked
V it down to the mssqladmin. When I try the:
V /usr/sbin/logrotate -f /etc/logrotate.conf
V I get the following error:
V /usr/bin/mysqladmin: connect to server
Amrita,
Monday, March 18, 2002, 9:19:33 PM, you wrote:
AB Hi,
AB I wanted to know what the error poosibly could be.
AB I am using RedHat 6.0 Kernel 2.2.20 on i686 and
AB installed mysql 3.23.47-sgi-irix6.5. I m running sh
AB ./bin/safe_mysqld from the root directory and am
AB getting the error
vthang,
Tuesday, March 19, 2002, 7:50:52 AM, you wrote:
v I'm a new MySQL user.
v Does MySQL database support Unicode (UTF-8)?
MySQL doesn't currently support Unicode. It will be supported
in 4.1 version of MySQL. You can read about it at:
Hello,
This is a newbie question for a reason...I am. I've installed the lastest
RPM for mysql on a brand new redhat 7.2 installation. When I try to run
mysqladmin to set my new password (or for any reason actually, even to see
the version number) I get the following error.
I am not able to
Mike Gahan writes:
Description:
mysql binaries from AIX binary distribution will not run.
1 % cd /tmp/mysql/bin
2 % ./mysql
Could not load program ./mysql:
Dependent module /usr/lib/libz.a(shr.o) could not be loaded.
Member shr.o is not found in archive
Hi!
hello mike,
i've got a similar set-up on my g4 - only i'm not quite at the hosting point
yet.
the way i think i would go about it is create a database per domain and use
phpmyadmin (saves using the command line!) to grant 'user' permissions to
each domain name. this 'user' would be able to do
I typed SELECT SYSTEM_USER() ..The output is
++
| system_user() |
++
| ODBC@localhost |
++
1 row in set (0.00 sec)
I then tried mysql -h localhost -u ODBC
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Rick Runowski writes:
All,
I am having difficulty converting the results of a query to a character.
Here is A snippit of code.
You can not get chars from [] operator.
You have to first convert ColData to string, e.g. like this :
string xx(row[j]), or use row_data() method
Hello list,
I need to write a small perl skript to insert a record (email, timestamp)
into a table. Two problems:
1. Since email is unique I don't want to get the duplicate record message.
If email already exist, the perl program should continue silent.
2. How do I create a datetime-compatible
Heikki,
HT since you are French, I assume you have accent characters in the strings you
HT have stored into your database.
HT The ordering of accent characters changed in 3.23.44!
No accents.
InnoDB tables on this server are mainly used for statistics,
counters etc ...
HT You
Hendrik,
Monday, March 18, 2002, 10:04:44 AM, you wrote:
HN We have problem with moving data to new server. We dumped
HN database with mysqldump on old server and used
HN mysql dbname db.sql syntax for database import.
HN When mysql imports one of our biggest table, then the import fails and
Hi,
I don't about your special problem ...
I also run MySQL on Win32 (WIN2000).
It seems to me that someone made a GRANT and denied everyone from
localhost to your database. You can try from an other PC or use GRANT to
give everyone from localhost access to the database.
Adib.
alan4100
The folowing is a query I tried to do, to view reports that were
between two dates, the problem is that the reports that are made
on the second date, are not being display, if anyone can help me, please reply.
thanks
select ticket.t_id, t_summary, t_category, e_status, t_department,
Alex,
616e647265747469 andretti
616e6472e9737069 andr.spi
there is a character e9 in your string. It is not an ordinary character and
can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49.
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki
On Tue, 19 Mar 2002, Horacio Lam wrote:
The folowing is a query I tried to do, to view reports that were
between two dates, the problem is that the reports that are made
on the second date, are not being display, if anyone can help me, please reply.
thanks
select ticket.t_id,
I have a very large mysql table (1.5G) and so will need to implement the
table
RAID option soon.
How do I pick the CHUNKSIZE and number of chunks values?
Howard
-
Before posting, please check:
You have written the following:
I have a mysql database table that is currently 1.5G in size with well over
a
million records. It is running on a twin pentium 3 1G processor machine with
SuSE Linux version 1.4.
Recently inserts have become VERY slow (several seconds). As I am adding
around
Correct me if I'm wrong, but a timestamp field is not meant to be human
updateable (ie. it's solely to record the last change to the record).
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:31 AM
To: [EMAIL PROTECTED]
Subject: Leap
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
mysql does not let me enter german umlauts, though. I tried to start it with
mysql --default-character-set=latin_de, but it complained about the
character sets not being installed. Then I installed the mysql server, which
I need help from the administrator of this MySQL list.
I am receiving multiple(about 8-13) same mails from the same issue on the list.
I successfully unsubscribed to MySQL list but the mails still coming in.
I tried to unsubscribe a second time but it says that I am not a subscriber.
Can the
alan4100,
Tuesday, March 19, 2002, 3:15:39 PM, you wrote:
a I typed SELECT SYSTEM_USER() ..The output is
a ++
a | system_user() |
a ++
a | ODBC@localhost |
a ++
a 1 row in set (0.00 sec)
a I then tried mysql -h localhost -u ODBC
a Welcome to
HT 616e647265747469 andretti
HT 616e6472e9737069 andr.spi
HT there is a character e9 in your string. It is not an ordinary character and
HT can cause an error in the sorting order between InnoDB-.41 and InnoDB-.49.
ok :)
mysql insert into popup select * from popup2;
ERROR 1213: Deadlock
I need help from the administrator of this MySQL list.
I am receiving multiple(about 8-13) same mails from the same issue on the list.
I successfully unsubscribed to MySQL list but the mails still coming in.
I tried to unsubscribe a second time but it says that I am not a subscriber.
Can the
mysql,
Tuesday, March 19, 2002, 4:27:40 PM, you wrote:
mmlu I have a very large mysql table (1.5G) and so will need to implement the
mmlu table
mmlu RAID option soon.
mmlu How do I pick the CHUNKSIZE and number of chunks values?
You can read about RAID_TYPE option, RAID_CHUNKSIZE and
Uma,
Tuesday, March 19, 2002, 4:06:41 AM, you wrote:
VRUma,
VRMonday, March 18, 2002, 11:34:07 AM, you wrote:
VR
VRUSTTo get German sorting order, you should start mysqld with
VRUST--default-character-set=latin_de. This will give you the following
VRUSTcharacteristics.
VR
VRUST To
Alex,
-Original Message-
From: BAUMEISTER Alexandre [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Michael Widenius [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL PROTECTED]
Date: Tuesday, March 19, 2002 5:14 PM
Subject: Re[4]: InnoDB: Assertion failure in thread 10 in file
Hey, you know what? You're right! I'm an idiot.
Thanks. :)
BD wrote:
Gabriel,
I have a sneaky suspicion your primary key is a CHAR or
VARCHAR, right? If so, your select statement is using an integer which
means it has to convert it for each record. If you put quotes around
the
Hi!
We are ineterested in the possibility of using MySQL on Netware
plataform.
After visit MySQL website, we've found that you are interested in
someone to do this port.
Our questions are: What are the requeriments to do this? You need
someone to compile the source in a netware platform?
Hello,
I need some details on the EXACT type of Unicode that MySQL will use
4.1.
Ideally I'm looking for information on which type of Unicode MySQL will
use internally, and which type it will return data to the user in; and
is the MySQL Unicode implementation going to be phased in or with v4.1
Thank you for the reply. However, unfortunately the documentation that
you refer to -- while instructive in respect to DBI usage -- does not
answer my question, which is simply:
Must I install MySQL on a client workstation/PC in order to run perl/DBI
scripts that query a local MySQL server?
Hi !
Is it possible to log mysql queries into a fifo created by :
# mkfifo -m660 queries.log
I've search with google but i found only one thread of one email where
somebody is getting an error 29. That's my case too.
Thanks a lot !
Must I install MySQL on a client workstation/PC in order to run
perl/DBI scripts that query a local MySQL server?
I know I do need to install DBI, DBD:MySQL, however, I'm not sure what,
if anything else I need to install on the client?
You only need the DBI and DBD modules AFAIK :)
Art,
Monday, March 18, 2002, 5:51:46 PM, you wrote:
AF I done the chown, now using MySQL Navigator, I get Access denied for user:
AF afore@localhost (using passowrd: YES). I get the same for user mysql and
AF root using both my password and root password.
Is your MySQL server running?
Looks
Rykov,
Monday, March 18, 2002, 4:54:50 PM, you wrote:
R My question is - are the MySQL query parsing source codes available?
For sure! Take the source code distribution and go with it.
R Vladimir Rykov
--
For technical support contracts, goto https://order.mysql.com/
This email is
At 16:32 2002-03-19, Victoria Reznichenko wrote:
MySQL doesn't look at bits when sorting data and MySQL doesn't support Tamila
scripting.
Then what does MySQL look at?
Are you aware Tamil is a human language? How would MySQL support Tamil - is there a
character set that supports it for
Adolfo Amo writes:
Hi!
We are ineterested in the possibility of using MySQL on Netware
plataform.
After visit MySQL website, we've found that you are interested in
someone to do this port.
Our questions are: What are the requeriments to do this? You need
someone to compile the source in a
I just rmdir/s the old mysql and downloaded from Wisconsin mirror site...
Then I tried C:\mysql\binmysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Any idea?
I know that I have mysql in NU-SPHERE directory from previous installation
about a month ago...
Is this the correct file to have in your class path?
addpath /home/launi/JBuilder6/lib/mm.mysql-2.0.11/mm.mysql-2.0.11-bin.jar
--
Lonnie Wormley
[EMAIL PROTECTED] [Linux and Java]
[EMAIL PROTECTED] [Window$ and graphics]
Hi,
Thanks I DID read the documentation.
BUT there documentation gives no information about how to choose values
for these settings. There are no clues at all. What are good values, and/or
what is the effect on performance etc. of the values?
Howard
Egor Egorov writes:
mysql,
I asked this the other day but didn't get any responses. Is there anyone
out there with experience running mysql 4 with ssl connections?. I would
like to get this setup but can't find any good documentation on how to do
it. In particular, it seems that one has to specify a key and certificate
i am running mysql version 3.22.32. yes i am planning an upgrade. in the
meantime, i need to check (and possibly) repair my tables without bringing
down the mysql daemon.
thanks,
Shon Stephens
540.942.7292 office
540.649.3508 mobile
shon8work aim
On Mon, 18 Mar 2002, Aaron D. Turner wrote:
I've read the docs on mysql.com about the BDB and InnoDB table formats, as
well as their pro's con's and I was wondering if anyone could give their
opinion on the matter. I don't need row-level locking or other fancy
features other than
On Tue, 2002-03-19 at 10:02, David Ayliffe wrote:
Hello,
I need some details on the EXACT type of Unicode that MySQL will use
4.1.
Ideally I'm looking for information on which type of Unicode MySQL will
use internally, and which type it will return data to the user in; and
is the MySQL
UPDATE sequence_table
SET sequence = LAST_INSERT_ID(sequence + 1)
Further calls to LAST_INSERT_ID on the same connection will return the value
sequence + 1. It's connection specific, so multiple connections can update
your sequence table without interfering with each other.
There's a great
Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???
Kathy Reyes
Live Technology International
2975 Westchester Avenue
Suite 103
Purchase, NY 10577
Tel: (914) 490-7096
[EMAIL PROTECTED]
www.LiveTechnology.com
Have you looked at:
http://www.mysql.com/information/benchmarks.html
On Tuesday 19 March 2002 11:50 am, Kathy Reyes wrote:
Hello all its me again
Does any one now of any database benchmarking utility that I can use on
mysql database???
http://www.mysql.com/doc/M/y/MySQL_Benchmarks.html
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
-Original Message-
From: Kathy Reyes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 1:51 PM
Howdy, I'm about to put together a book on MySQL (in Peachpit Press'
Visual QuickStart Guide series) and am looking for a tech reviewer. The
book itself will be a step by step beginner's text to the world's best
open source database. Running about 300 pages it will not be as
comprehensive or
Hi Sasha,
I assume it not a mistake (as you typed 'mysql' twice), but mysql
is the name of the client program, you must start the server program
(safe_mysqld) with the --default-character-set=latin_de. First use
mysqladmin to shutdown the server, then restart it with safe_mysqld.
Also I
hello ken,
thanks for the reply, but when I typed mysql I meant it without the d.
I'm using the client for lots of batch i/o, little utilities and quick
maintenance. I'm using it on quite a couple of systems (linux in all flavors
and FreeBSD), but only on one of this systems it shows this
Hi Howard,
I am trying to think of ideas. I have several databases with
tables over 1.4G and rows still add quickly. How about available
descriptors, what are these values:
| Open_tables | 2738 |
| Open_files | 5013 |
| Open_streams | 0
Just a quick question, if I am going to make a database using MYSQL and have
front end applications, is it better to give each user a username/pass and
have them enter it into the front end to be passed to the server, or should
I give the app a password, hardcode it into the app for database
thanks for the reply, but when I typed mysql I meant it without
the d.
Yes, I understand, and I see that it is in the help, but it was my
understanding the the character set (at this time) MUST be selected on
the server and cannot be selected on the client, but perhaps I am
wrong. This is
At 20:02 18/03/02 -0600, Gerald R. Jensen wrote:
Hi,
For to avoid the install of the service in local account I will
add code for to verify if the user that is making the install
process has administrator rights and display the error message
if he/she doesn't have.
Regards,
Miguel
Alex:
I
Try
mysql -uODBC -p
(-p assuming you have a password on the account)
the formula is -optVAL
alan4100 wrote:
I typed SELECT SYSTEM_USER() ..The output is
++
| system_user() |
++
| ODBC@localhost |
++
1 row in set (0.00 sec)
I then
Hello all.
I have an application that does a lot of table creation and writing for
a FreeBSD 4.4 SMP machine. Over time, I begin to see the following
errors.
DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at
/var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE
All,
I can't seem to perform an update on my database with MySQL++. The
execution of the query always throws an exception. Here's a snippet of what
I did.
Query query(conn);
query update employee set children = 3 where id = 9;
query.execute();
The above code throws an exception everytime.
I'll bet there are several people in Provo, Utah that could be convinced to
do the port.
Curtis
Sinisa Milivojevic said:
Adolfo Amo writes:
Hi!
We are ineterested in the possibility of using MySQL on Netware
plataform.
After visit MySQL website, we've found that you are interested in
Hi,
When i try to access the database which is on my Linux
machine i get the following error:
ERROR 2002; Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (111)
There is nothing in this file, although i dont know
how to edit it.
I have gone through the Manual pages and the
Hi all:
I am having a huge problem setting up replication between 2 mysql
databases on the same server. The reason for doing this is to use the
slave database for backups thus avoiding the need to down the master
database.
I am consistently getting Error 1200: The server is not configured as a
With out knowing your system configuration it sounds to me like you've
got some problems with locking.
I suggest looking into that.
Brad Phinney wrote:
Hello all.
I have an application that does a lot of table creation and writing for
a FreeBSD 4.4 SMP machine. Over time, I begin to see
this file is created when MYSQL starts
check the directory to ensure it has the correct read-write permissions
check the list archives; this question has been asked almost every day
-Original Message-
From: colin o [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 3:05 PM
To:
probably something wrong with the permissions in the mysql database.
as a workaround, try to connect not via the local socket, but via a
tcp/ip-connection:
# mysql -h 127.0.0.1 -u my-user -p my-database
or insert the real ip of the machine instead of the loopback address.
check if there
I am trying to backup a table in mysql without locking my tables it this
posible
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi Brad,
You are running out of file descriptors, type this:
kes# sysctl -a | grep files
kern.maxfiles: 2
kern.maxfilesperproc: 18000
kern.openfiles: 5230
kes# limit -h
cputime unlimited
filesizeunlimited
datasize1048576 kbytes
stacksize 262144 kbytes
So how (forgive me if this is a simpleton's question), how will UTF-8
and UCS2 be used? Can you elaborate a bit.
DA
Hi,
Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode
between them (as well as between any supported character sets).
Some (VERY) technical documentation
NetWare recently (relatively) has added some support for C code running on
the servfer. You should, however, evaluate the NetWare environment
carefully, and take advantage of porting it native to NetWare.
I am sure that you can acquire evaluation software from Novell for NetWare
5.1 and 6, the
In the last episode (Mar 19), Brad Phinney said:
Hello all.
I have an application that does a lot of table creation and writing for
a FreeBSD 4.4 SMP machine. Over time, I begin to see the following
errors.
DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode:
Yes. Setup replication and peform the backup on the slave. Provided this is your only
purpose for having a slave, and there are no queries running on the slave, the specs
can be a lot lower than your master/production machine.
-Original Message-
From: Kathy Reyes [mailto:[EMAIL
I dont know what I have done now but I have locked myself out of mysql. When
I type mysql I get an access violation. At first I thought it might have
been something on my end since I am a remote user. But when I attempt to
enter mysql from linux box. I get the same access violation...
Please
not quite sure what you mean by locking.
each table will be locked during readout for the dump automaticly for the
time the select runs and delivers data to the dumping program.
it is not needed to lock the tables (more than one) in advance for a dump, but
that, might better for dataintegrety.
Running the latest build from bitkeeper (as of Saturday or so) on my
4.0.x slave (FreeBSD 4.3), after several hours, I start getting these
messages when apps try to connect to the server:
ERROR 1041: Out of memory; Check if mysqld or some other process
uses all available memory. If not you
On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote:
[snip]
Here's the relevant entry from the error log, repeated over and over:
020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memory at line 100,
'net_serv.cc'
020319 15:57:33 /home/mysql-4-bk/libexec/mysqld:
If you are running RH7.2, start your GUI and go to System / Service Manager.
Locate mysqld, and make sure it is checked to automatically start on bootup,
then save your settings, and click the start button.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
I'm installing MySQLto a Corel /Debian platform, following
directions in the book Beginning PHP4. Successfully
did ./configure, make, make install, and mysql_install_db
as described on page 387. The book says I'll now need to
start and stop the Mysql server using two sample
scripts, to wit:
Hi All-
We are using the mm driver for MySQL and multiple statements in one
connection do not seem to be supported:
I.e.
SELECT @a:=MAX(Number) FROM Orders;insert into orders (Number) values (@a+1)
The driver throws a syntax error. You can do either one of these statements
on their own, and
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a
I'm taking a database implementation course, and my professor has flipped
his lid this semester and assigned one of the labs to be an SQL parser and
optimizer (using equivalence rules, etc.). Given an SQL statement and a
database schema (with some statistical metadata on the contents), I am to
Hello,
I have to plan a content retrieval system and am thinking of using mysql
cause it's always been very reliable and convenient for my needs.
Now, I do not have any experiences with databases of this size.
The situation is as follows:
We have round about 15gig of user documents (mainly MS
1 - 100 of 134 matches
Mail list logo