I got a lot of good help from people on this list. Some of them got
pissed at me because I was slow to use their suggestions. My reason was
I could not believe someone would release a rpm(s) that required the
user to make a directory not mentioned in the referance manual and
change it's owne
Karl Larsen wrote:
None of the above is in the referance manual. It's no wonder very few
ever use mysql...
Some basic computer administration knowlege is assumed. This way, when
someone says "it runs as its own user, not root," the words mean something.
--
Rob Munsch
Solutions For Progres
" It's no wonder very few ever use mysql..." -- nice bash there Karl.
Maybe would fit in a postgres forum better than here.
You could have followed my suggestion sent to you 7 hours ago to check
permissions on /var/run/mysqld ... and/or read the manual (it's in the
installation notes!) to learn
I have burned another 2 hours but got mysqld to run and have version
5 up and running! I'm now ready to get back to views.
To get things running I had to manually make a directory
/var/run/mysqld/ and then change the owner to mysql. I ran mysqld_safe
and it made a mysqld.pif and is now r
Chris
>I would like to create an audit trail for one table in my DB.
Users will login to my
>web site and be able to enter and edit information, I want to keep
a record of what
>changes are made by what user. These users will be web site users
and not actual
>MySQL users. Is there an eas
Well MySQL will see all the changes coming from a single user (the user who
the web site connects to the database as). You'll have to add your own
routines to log that info to a table or something...
Unless ofcourse, I'm missing something, which I doubt :)
Regards,
Chris.
- Original Mes
I would like to create an audit trail for one table in my DB. Users
will login to my web site and be able to enter and edit information, I
want to keep a record of what changes are made by what user. These
users will be web site users and not actual MySQL users. Is there an
easy method in My
I am going to do the simple things. I will delete mysql from the
computer both with rpm and rm as needed. After I can find NOTHING about
mysql anywhere, I will reboot, and then load the rpm's. Then I will
assume the rpm's did all the work and try the stuff needed to get
passwords for root an
Hi everybody
I am running linuz AS-4 with 5.0.24 max version MySQL Cluster i am able to
create all the table as ndb but when comming to
the import i am not able to import 20 lakhs of record for a table.please help
to solve the problem .
20 lakhs => 2 million rows?
My memory is that cluste
On 8/21/06, Chris White <[EMAIL PROTECTED]> wrote:
On Monday 21 August 2006 08:40 am, Karl Larsen wrote:
> I think I need to su - mysql and it askes for a password. What is
> that password?
If you're root you don't need to enter a password. If you can't become root
then the system admin has
Yes, evidentially, MS SQL Server does allow regular expressions. I've used
this for a long time, and it's working just fine. I am using version 2000
since I started working with MS SQL Server, so maybe it is a new feature.
Your suggestion appears to have resolved the problem. I really apprecia
I think you are trying to use a regular expression in the like
phrase. I wasn't aware that MS SQL can do regular expressions at
all? I've been using 2000 - perhaps the newer version can?
In MySQL, instead of saying:
LA.LastName LIKE '[A-E]%'
try this:
LA.LastName REGEXP '^[A-E]'
You can
I have the following query which works in MS SQL Server, but I'm sure the
syntax is different for Myself. I'm sure it's in the area of the "LIKE"
clause. I don't know how to do this with Myself. Can anyone point me in
the right direction?:
SELECT LA.FirstName,LA.LastName,LA.EMailAddress, LA
On Monday 21 August 2006 08:40 am, Karl Larsen wrote:
> I think I need to su - mysql and it askes for a password. What is
> that password?
If you're root you don't need to enter a password. If you can't become root
then the system admin has that information.
> Karl
--
Chris White
PHP Prog
I think I need to su - mysql and it askes for a password. What is
that password?
Karl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi again folks,
The problem is solved.Was entirely my fault because i didn't check the version
of mysqlclient library.
-Original Message-
From: Gelu Gogancea
Sent: Monday, 21 August, 2006 12:47 PM
To: mysql@lists.mysql.com
Subject: How to call stored procedures using C API
Hi to all,
Karl, MySQL usually runs under its own user, the "mysql" user, not
root, so it's quite likely MySQL is failing because it can't write
into that directory.
Dan
On 8/21/06, Karl Larsen <[EMAIL PROTECTED]> wrote:
I have mysql 5 on Fedora Core 4 linux via RPM files. It does not
run. I used the
Marco, it would be more helpful if you could post the table structures
involved ("SHOW CREATE TABLE ") as well as the SQL query
that is giving you this problem.
Off the top of my head:
- InnoDB is designed to solve this exact problem; maybe re-visit why
you cannot use it, given that it solves you
Assuming that the locking issues occur mainly when an insert is being
performed (i.e. replying to a post) then what about using read local
locks for selects so that you can perform con-current inserts?
If you have a lot of old threads that are no longer updated but viewed
regularly then you co
Marco, it's a flag passed to mysqld on startup. Check out
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
and look for --myisam-recover
Dan
On 8/21/06, Marco Simon <[EMAIL PROTECTED]> wrote:
My mysql-db starts a "check tables xy fast" for all tables as soon
as I re-start the db-ser
I have mysql 5 on Fedora Core 4 linux via RPM files. It does not
run. I used the instructions from the info file and was able to populate
the dirctory /var/lib/mysqld/ with the mysql db and some other files
using mysql-install-db. But when I try to start mysqld with mysqld_safe
it errors out
Hello All,
I wanted to know what is the best size for Innodb key cache. We are currently
running MySQL 4.1.11
And we have set the buffer size to 1GB.
innodb_buffer_pool_size = 1G
The system has 4 GB RAM.
1) In such a case is the above setting ok?
2) All the tables are of Innodb type
3) We are
My mysql-db starts a "check tables xy fast" for all tables as soon
as I re-start the db-server. I didn't find a place where I can control
if the db should be checked at start or not. So where can I switch
of this checkings at db-server-start ?
Thanks in advance
Greetings Marco
smime.p7s
Descrip
Using this query seems to hang my computer and mySQL server reported the
queries had been LOCKED.
> Date: Mon, 21 Aug 2006 11:09:35 +0200> From: [EMAIL PROTECTED]> To: [EMAIL
> PROTECTED]> CC: mysql@lists.mysql.com> Subject: Re: Return list where no data
> exists> > Hi Neil,> what you need is a
Hi everybody,
I've got a little problem with a web and mysql based
bulleting-board-application.
The board is quite well visited and users are writing aprox. 1 new post
per second. In total the db gets aprox. 250 queries/sec.
The webserver and mysql-server are running on different hosts, the db se
Hi to all,
I try to call a stored procedure using mysql_real_query and with the
CLIENT_MULTI_STATEMENTS flag on mysql_real connect() function.
When i try the statement "call sp1(@myparam);" the error "can't return the
results in actual context" is occur.
Please, if is some one which have experie
Hi Neil,
what you need is a LEFT JOIN:
SELECT a.*
FROM TableA a
LEFT JOIN TableB b ON a.ID = b.ID (assuming ID is what you relate the
tables on )
WHERE b.ID IS NULL;
should hopefully do what you want.
/Johan
Neil Tompkins skrev:
Hi,
I've two tables. What q
Hi,
I've two tables. What query do I need to use to get a list of all records from
table A where table B doesn't contain a a mathing record. For example
TableA
ID
Name
TableB
Date
ID
Name
Thanks
Neil
_
Be one of the first to
Здравствуйте!
Загляние сюда:
http://dev.mysql.com/doc/refman/4.1/en/charset.html
Обратите внимание на 'SET NAMES', оно должно помочь, если проблема при
"выходе" из таблицы.
Have a look here:
http://dev.mysql.com/doc/refman/4.1/en/charset.html
Pay attention to 'SET NAMES' statement.
Г
29 matches
Mail list logo
