SAPDB on RedHat 9

I am new to SAPDB and install it on Red Hat 9 ...When I wanted to start an instance ,I encounter with error 24994 runtime environment error [db_online -s] check knldiag ,kernel died before reaching admin state and in knldiag i see : ERR 11330 Corehand Aborting due to Signal 11 For solvin

Re: Backing up all databases

You're joking, right? (Perhaps you thought the original question was a joke, too, as root normally has access to all dbs?) As I understand the manual , that will give root access to every db, from every host except localhost, with no password! I can't i

Import from excel to MYSQL

Is there an easy way to get an excel spread sheet imported into a MYSQL database? Any links to a tutorial? Thanks in advance! Dustin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: self-join, group by, single SQL query

On Tuesday, November 11, 2003, at 03:06 PM, Roger Baklund wrote: * Robert Citek Is there a way to do a self-join and a group by in a single SQL query? See the max-concat trick, described here: http://www.mysql.com/doc/en/example-Maximum-column-group-row.html > Thanks for the tip. It looks like

memoryTrap

Hi In my program, i have a process to do a set of calculations to around 15 000 records.Earlier it was working nice.But this time database crashed in the middle of the execution.Error lod says that "we intensionally create a a memory trap" ???. I tried to recover the database but still im

Re: Mysql just stopped working on my server - any way to track down the problem?

Hi Matt, So one database "disappeared" all of a sudden while the others are OK? Is MySQL running on FreeBSD? If so, that'll be the problem :-) and we'll point you toward the fix. Matt - Original Message - From: "Matt Babineau" Sent: Tuesday, November 11, 2003 3:28 PM Subject: RE: Mysql

back up database

Hi everyone,   this is my first post, you will excuse me for my english cause french is my fluent language.   So i'm also new to mysql, tonight my question is how to make a back up of all the database on MySQL 4.0.12 running on netware server 6   i hava acces to the web console but i don't know t

Re: SQL query question

try group by SELECT firmal.beskrivelse as Businessline, lokasjon.navn as Location, count(person.name) as "Sum People" FROM firmal INNER JOIN ( person INNER JOIN lokasjon ON person.lokid = lokasjon.lokid) ON firmal.firmalid = person.firmalid group by firmal.beskrivelse, lokasjon.navn -leo- From:

Re: Some help with a complex query

it would help alot if you dump the table structure for us - Original Message - From: Elisenda To: [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:10 PM Subject: Some help with a complex query I have a query which tries to select different fields from 5 different tabl

RE: Mysql just stopped working on my server - any way to track down the problem?

Its not a startup problem, that works fine. What happened was my php application stopped working. This server has multiple databases on it mind you. The other databases were working fine. So one database stopped working and the application could not connect to it. so I did a 'service mysql restart

RE: Error 127 = Record-file is crashed

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: rmck [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 3:17 PM -->To: [EMAIL PROTECTED] -->Subject: Error 127 = Record-file i

RE: max_user_connections problem after upgrading

Hello! I have tested this now, and that isn't the case. Any other ideas? -- Henrik Michael McTernan skrev: > Hi, > > Have you tried "netstat -a" on the box with the MySQL server? This > command > (Linux) will show what is connected to where, and will help you double > check > that there really

Mysql just stopped working on my server - any way to track down the problem?

Hi All- I am running 4.0.15-standard on RH9. My mysql database just stopped working, is there a way I can log information about why it stops like this? the *.err was unhelpful. Any help here is appreciated. Thanks -Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Error 127 = Record-file is crashed

Hello, I have "mysql-standard-4.0.16-pc-linux-i686" installed on a 4gig mem, 2cpu system, RH 9. I have a large table (Data records: 72426930) that is now giving me this error "Error 127" when doing selects... This is my first crash of any kind with Mysql. So I'm a liitle confused on what I s

RE: Backing up all databases

Look at GRANT on mysql.com GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFITED BY ''; - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Randall Perry [mailto:[EMAIL PROTECTED] -->Sent: T

Backing up all databases

Am testing this command to backup databases: /usr/local/mysql/bin/mysqldump --opt --all-databases > /usr/local/mysql/data/mysqldump Am running as root, but it only backs up databases root has access too. What's the best way to handle this -- give root full perms on all dbs? -- Randall Perry s

Re: newlines and carriage returns in string data

Hi Stephen, Oh yes, the second one will work fine. :-) Note, however, that the string may not be *exactly* the same, even if it appears to be. For example, if I copied the second query and executed it on my Windows system, the newline would actually be \r\n and not just \n as with the first query

RE: Dirt Slow Query On Datetime Range...the saga continues

Thanks for the quick help everyone...OK I made a few changes The Query is now: SELECT COUNT( * ) AS CallCount FROM ServiceRADIUSAccounting WHERE (Realm = 'testrealm.com') AND ('2003-10-11 16:00:00' BETWEEN AcctStartTime AND AcctStopTime) Which uses the RealmAndStart index (which as you see in

Re: Dirt Slow Query On Datetime Range

Hi, Well, as a side note, you *could* use '2003-11-11 15:30:00' BETWEEN AcctStopTime AND AcctStartTime but MySQL can't optimize that to use indexes. Besides, even if it was on the same column, BETWEEN is treated exactly the same as <= and >= so BETWEEN wouldn't help anyway (except for legibilit

Re: Foreign Key

- Original Message - From: "Shravan Durvasula" <[EMAIL PROTECTED]> To: "MySQL HELP" <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 12:48 PM Subject: Foreign Key > Hi all: > > I have a table A(Id, Type). Primary Key is "Id" > I have another table B(Id, State). Primary Key is "Id" >

RE: Dirt Slow Query On Datetime Range

No reason for the varchar so I guess I can change it to char if that will help. I have tried many different settings in the my.cnf file for inno db but have seen little improvement. Any thoughts there? -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, Novemb

newlines and carriage returns in string data

Is it OK to have actual newline/carriage return characters in string data? E.g. consider the insert statement INSERT into table t1 ( ) VALUES('Here is a newline:\nThere it was!'); Now consider the statement, typed as INSERT into table t1 ( ) VALUES('Here is a newline: There it was!'); Is the sec

RE: Dirt Slow Query On Datetime Range

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Change your query to use BETWEEN rather that <= and >=. > > --ja > > And here is the query: > > > > SELECT COUNT(*) AS CallCount FROM ServiceRADIUSAccounting > WHERE (Realm = > > 'testreal.com') AND (AcctStartTime <= '2003-11-11 15:30:00'

Re: Dirt Slow Query On Datetime Range

Change your query to use BETWEEN rather that <= and >=. --ja On Tue, 11 Nov 2003, Michael Shuler wrote: > OK, I give up. To anyone out there who can help me, please explain why this > query runs slower than dirt. The table has about 1,300,000 records in it, > which is not supposed to be a big

Re: Dirt Slow Query On Datetime Range

The first thing I noticed is that you are using varchar instead of char, why? Unless you have a variable length field like text or blob, you can and should use char. As far as I know, you can't "optimize" InnoDB tables, but you can optimize MyISAM using the analyze command as I recall. Next, ha

Foreign Key

Hi all: I have a table A(Id, Type). Primary Key is "Id" I have another table B(Id, State). Primary Key is "Id" I also have another table C(Id, ConditionId). Primary Key is "Id". But, "ConditionId" could be "Id" values from Table A or Table B. So i want to make it a foreign key. But how can i

Dirt Slow Query On Datetime Range

OK, I give up. To anyone out there who can help me, please explain why this query runs slower than dirt. The table has about 1,300,000 records in it, which is not supposed to be a big deal for MySQL to deal with. I have tried it with MyISAM and then changed it to InnoDB which made it even slower

Re: Some help with a complex query

* Elisenda > I have a query which tries to select different fields from 5 different > tables. > > In WHERE part I have write all the conditions and relationships. > Perhaps two many. Joining 5 tables should not be a problem, but having indexes on the relevant columns may be essential, especial

RE: After installing MySQL 4.0.16 (rpm), it did not create /etc/my.cnf ?

After I copied /usr/share/mysql/my-large.cnf it to /etc/my.cnf Then I restart mysql, and executed ps -ax I got this : 32175 pts/3S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/myserver.pid 32200 pts/3S 0:00 /usr/sbin/mysqld --basedir=/ -

RE: Upgraded to 4.0.16 from 3.2.x --- why did service file change?

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Brian Snyder [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 1:12 PM -->To: [EMAIL PROTECTED] -->Subject: RE: Upgraded to 4

Re: C API: undefined reference

alright. looking at your directory this should be ok. gcc seeLog.c -o seeLog -I/usr/include -L/usr/lib/mysql -lmysqlclient ;) Aftab Jahan Subedar Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh sms://+447765341890 tel://+88027519050 [EMAIL PROTECTED] http:/

Re: Database-design

you need to normalize your database structure, and create an ER diagram based on that. On Tue, 11 Nov 2003, Meli Meli wrote: > > I have a table with following structure: > > Id > first quarter > second quarter > third quarter > last quarter > year > month > week > day > > On an entry not all fie

Re: self-join, group by, single SQL query

* Robert Citek > Is there a way to do a self-join and a group by in a single SQL query? Yes, but I'm not sure if that is what you need... > For example, I have an PurchaseOrder table (see below) and would like > to know what was the most recent order-number for each customer and the > amount of t

RE: Upgraded to 4.0.16 from 3.2.x --- why did service file change?

On Tue, 2003-11-11 at 16:04, Dathan Vance Pattishall wrote: > - Dathan Vance Pattishall > - Sr. Programmer and mySQL DBA for FriendFinder Inc. > - http://friendfinder.com/go/p40688 > > > -->-Original Message- > -->From: Brian Snyder [mailto:[EMAIL PROTECTED] > -->Sent: Tuesday, Novemb

Re: maintaining size of a db

Repost - Haven't gotten any response on this and can't find an answer. If no one on the mysql list knows, where does a fellow turn? Help! > Can't seem to find this one in the manual or > archives - how do I control a db to maintain > its size to an arbitrary value, say 20 GB? I > want to just r

RE: Upgraded to 4.0.16 from 3.2.x --- why did service file change?

- Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Brian Snyder [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, November 11, 2003 12:51 PM -->To: [EMAIL PROTECTED] -->Subject: Upgraded to 4.0.

RE: Unix Socket Daemon

mySQL already does that look at /var/lib/mysql/mysql.sock=. You can add skip-networking to my.cnf not to allow tcp connections at all. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From:

Re: Query question (php)

- Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Obantec Support1" <[EMAIL PROTECTED]> Sent: Tuesday, November 11, 2003 8:46 PM Subject: Re: Query question (php) > * Obantec Support1 > > mysql 3.23.56 RH 8.0 > > > > I have got the sql query to wo

Re: Query question (php)

* Obantec Support1 > mysql 3.23.56 RH 8.0 > > I have got the sql query to work but is there a better way of writing the > syntax? > > $sql = "SELECT * FROM Contacts WHERE Categories=\"$calltype\" and > BusinessCodes !=\"R\" and BusinessCodes !=\"I\" and BusinessCodes !=\"L\" > ORDER BY Company A

Upgraded to 4.0.16 from 3.2.x --- why did service file change?

I upgraded from RPM and I noticed that the /etc/rc.d/init.d script was changed from mysqld to mysql. It also appears as if the 'status' option that you can pass into service was removed. I'm just curious why the owners would do that? What is the rationale to changing a script name and removing

Unix Socket Daemon

I wanna bring up the mysql daemon on a unix domain socket. Any Idea how?? I don't wanna use the localhost TCP

RE: After installing MySQL 4.0.16 (rpm), it did not create /etc/my.cnf ?

Create one. Look in your base directory under support-files Look for my-small.cnf - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->-Original Message- -->From: Admin-Stress [mailto:[EMAIL PROTECTED] -->Sent: Tuesda

Re: Database-design

> On an entry not all fields of the four quarter fields are covered with > values. Following combinations are possible: Why don't you just use one extra column (apart from whatever other data you are storing) with that column being a date field. Then, you can determine what data is part of w

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

If you're using only MyISAM tables for your data, then key_buffer should generally have as much RAM as it can have (up to the point where it makes sense, i.e., only has much RAM as is needed to store your index data). myisam_sort_buffer_size ought to be about 1/4 of your RAM. I re-ran the bench

After installing MySQL 4.0.16 (rpm), it did not create /etc/my.cnf ?

Hi, My server is using RedHat 9.0. I just CHANGED the mysql from 3.23.58 (rpm) to 4.0.16 (rpm). What I did : # rpm -e # rm -rf /var/lib/mysql then install the 4.0.16 (rpm) # rpm -i MySQL-server MySQL-client ... MySQL-devel ... MySQL-shared-compat After this, I can start the

Database-design

I have a table with following structure: Id first quarter second quarter third quarter last quarter year month week day On an entry not all fields of the four quarter fields are covered with values. Following combinations are possible: first quarter | second quart

Re: Getting Corrupt MyISAM Table

Héctor Villafuerte D. wrote: mysql> repair table otr_hist; +--++--+-+ | Table| Op | Msg_type | Msg_text| +--++--+-+ | otr.otr_hist | repair | error|

RE: A question on INTERVAL

The parser does not execute the query before it parses it. Thus you cannot do that. Use Code, and or have an idea what the INTERVAL UNIT is prior to executing the query. - Dathan Vance Pattishall   - Sr. Programmer and mySQL DBA for FriendFinder Inc.   - http://friendfinder.com/go/p40688 -->--

A question on INTERVAL

I would like to do something like this SELECT * FROM orders,subscriptions WHERE orders.subscription_id = subscriptions.id created < created - INTERVAL subscriptions.term subscriptions.unit; But I get "ERROR 1064: You have an error in your SQL syntax near 'subscriptions.unit)

large LOAD DATA INFILE and replication

I performed a LOAD DATA INFILE on two very large (2G and 997M) files to a db server that acts as a master to several slaves. The LOAD DATA was to a non-replicated db, and should not have been replicated, but it appears that, as it was not done as a LOAD DATA LOCAL INFILE, the data files were rep

Re: Getting Corrupt MyISAM Table

Héctor Villafuerte D. wrote: Hi all, In the following lines I'll try to describe the situation the best I can. Thanks in advance for your help! Hector -> Here's the situation: * I have repeatedly got a corrupt table (which is pretty big, like 25M rows) * MyISAM tables (the one with the problem i

Getting Corrupt MyISAM Table

Hi all, In the following lines I'll try to describe the situation the best I can. Thanks in advance for your help! Hector -> Here's the situation: * I have repeatedly got a corrupt table (which is pretty big, like 25M rows) * MyISAM tables (the one with the problem is *otr_hist*) * MySQL 4.0.16-nt

Re: offline replication with binlogs

"Mauro Marcellino" <[EMAIL PROTECTED]> wrote: > > Hello again... > > I am transferring binlogs between two networks that are not connected as an offline > replication solution. I have two databases which I have configured the my.ini file > to create binlog entries for. > > Do both databases

Re: GUI interface

Hi Alisa, > Hello. I'm looking for a GUI client that will run under Windows 2000 and > attach to Solaris 8 server that will allow me to see all the tables and data > in my mysql database. If you're looking for another tool that does more, there's a new tool in town: Database Workbench ( www.upsc

Re: GUI interface

> Hello. I'm looking for a GUI client that will run under Windows 2000 > and attach to Solaris 8 server that will allow me to see all the tables > and data in my mysql database. Others have mentioned phpMyAdmin. While that is an excellent piece of code, I find that it's someone slow to do what

Re: GUI interface

Ye, me to, only its solaris 9. Dosn't matter what server you have though. phpMyAdmin is cool, I use it most of the time. Runs on the apache server (also solaris), works like a dream in every browser I have used so its fairly platform independant. :-) - Original Message - From: <[

Re: GUI interface

if you want a windows client, get MySqlCC right off the home page www.mysql.com. I'm using htis in the exact setup you mentioned. a webclient? -> http://www.phpmyadmin.net/home_page/ There are morethese are free. hth Jeff

GUI interface

Hello. I’m looking for a GUI client that will run under Windows 2000 and attach to Solaris 8 server that will allow me to see all the tables and data in my mysql database. Thanks for any help. Thank you, Alisa Brouwer Network Administrator eServ, LLC 8200 North Allen Road Peoria, IL 61615 (309)

Re: Retrieving the system type that MySQL is running on.

The user is to define the database and table names, but may not know the system that MySQL is on, and try to request a table or database expecting case sensitivity and wind up with case insensitivity. I want to check the existence of the database or table, before trying to create it, rather tha

RE: Creating random data in a test table based on an existing tab le

Thanks for the help. I tried your suggestion but only got 1 row inserted in the test table. Luis -Original Message- From: Olof Tjerngren [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 3:01 AM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Creating random data in a test table

RE: Setting wait_timeout in my.cnf?

tsss, how about that :) yes, I can set interactive_timeout to a value in my.cnf (interactive_timeout=30). This works! However, as a side-effect, wait_timeout is *also* set to 30. Right, problem solved. Thanks, Nils. Maarten -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTE

Re: Setting wait_timeout in my.cnf?

"Hoeven, Maarten van der" <[EMAIL PROTECTED]> wrote: > > gosh, I must be overlooking something obvious. Running mysql 4.0.16. I > want to set the wait_timeout in my.cnf (section [mysql]) like: > > wait_timeout = 300 > > also tried the depricated > > set-variable = wait_timeout=300 > > Both are

SPADE on RAH

Hi I am new to SPADE and install to on Red Hat 9 ...When I wanted to start an instance ,I encounter with error 24994 runtime environment error [db_online -s] check knldiag ,kernel died before reaching admin state and in knldiag i see : ERR 11330 Corehand Aborting due to Signal 11 I apprec

Re: Setting wait_timeout in my.cnf?

Hmm. You could try show variables like "%timeout%"; perhaps interactive_timeout can help you out ? -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 21:37, Hoeven, Maarten van der wrote: > nope, that didnt help. Thanks though! >

RE: SQL query question

So close, Thanks you very much Andy. I tried one similar to your suggestion, but didn't get quite the result i expected. Cheers Paal Ny versjon av Yahoo! Messenger Nye ikoner og bakgrunner, webkamera med superkvalitet og dobbelt så morsom

RE: Re: Setting wait_timeout in my.cnf?

nope, that didnt help. Thanks though! Any other suggestions? -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 1:00 PM To: [EMAIL PROTECTED] Subject: Re: Setting wait_timeout in my.cnf? Hi Maarten, I havent tried it recently but substitu

RE: SQL query question

Pael, Try this: SELECT firmal.beskrivelse as Businessline, lokasjon.navn as Location, count(person.[uniqueid]) FROM firmal INNER JOIN ( person INNER JOIN lokasjon ON person.lokid = lokasjon.lokid) ON firmal.firmalid = person.firmalid GROUP BY firmal.beskrivelse, lokasjon.navn Replace [uniqueid]

SQL query question

Hi, i have the following query: SELECT person.name as Name, firmal.beskrivelse as Businessline, lokasjon.navn as Location FROM firmal INNER JOIN ( person INNER JOIN lokasjon ON person.lokid = lokasjon.lokid) ON firmal.firmalid = person.firmalid which will give me a list of Name, Businessline,

Re: Setting wait_timeout in my.cnf?

Hi Maarten, I havent tried it recently but substitute any underbar (_) with a hiven (-) when doing a setting in the my.cnf. -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ On Tuesday 11 November 2003 20:22, Hoeven, Maarten van der wrote: > correction: section

Re: MaxDB Release?

Hello Iago, I dont know anything, but I remember that a while back (3 months ago) some people mentioned that the 15th November should be a remarkable day for a MySQL announcement. Wether this is true or not I dont know. Best regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/my

RE: Setting wait_timeout in my.cnf?

correction: section shoud be read as [mysqld] -Original Message- From: Hoeven, Maarten van der Sent: Tuesday, November 11, 2003 12:02 PM To: [EMAIL PROTECTED] Subject: Setting wait_timeout in my.cnf? Hi all, gosh, I must be overlooking something obvious. Running mysql 4.0.16. I want to

MaxDB Release?

Hi. Some curiosity. Does anyone know when the release of MySQL MaxDB 7.5 version will come out? In the MySQL web page at http://www.mysql.com/sapdb/timeline.html says that the release was planned for 15 of October but now we are at 11 of November and nothing has been released. Is it delayed until

Some help with a complex query

I have a query which tries to select different fields from 5 different tables. In WHERE part I have write all the conditions and relationships. Perhaps two many. The main table for me is FASE. From this table I try to find all the other information. I guess I'm doing something wrong but I d

Setting wait_timeout in my.cnf?

Hi all, gosh, I must be overlooking something obvious. Running mysql 4.0.16. I want to set the wait_timeout in my.cnf (section [mysql]) like: wait_timeout = 300 also tried the depricated set-variable = wait_timeout=300 Both are not working; still default to 28800. Sure, I stopped and started t

self-join, group by, single SQL query

Hello all, Is there a way to do a self-join and a group by in a single SQL query? For example, I have an PurchaseOrder table (see below) and would like to know what was the most recent order-number for each customer and the amount of that order. So far, I have been able to do this in two steps

Re: Problem with query comparing to a DATE on Linux OpenOffice

On Tue, 2003-11-11 at 00:15, Alaios wrote: > what a front-end is? And what OO1.1.0 provides? MySQL is a database server and a front-end is another program that you use to get to that server and use the database. OpenOffice is a complete office software package (word processor, spreadsheet, ...) th

Query question (php)

Hi mysql 3.23.56 RH 8.0 I have got the sql query to work but is there a better way of writing the syntax? $sql = "SELECT * FROM Contacts WHERE Categories=\"$calltype\" and BusinessCodes !=\"R\" and BusinessCodes !=\"I\" and BusinessCodes !=\"L\" ORDER BY Company ASC"; basically i Categories (a

Re: Creating random data in a test table based on an existing table

How about somethine like this as a starting point: insert into testuser (firstname,lastname) select u1.firstname,u2.lastname from user u1, user u2 order by rand() limit 1; MvH, Luis Lebron wrote: I have an users table for a php application that I am programming. The current users table has

Re: Cronjob / rights problem.

> /usr/bin/mysqladmin: refresh failed; error: 'Access denied for user: > '@localhost' (Using password: NO)' You can specify all the user & host details that you want to use in the mysqladmin command. mysqladmin -u john --password=mypassword You will need to make sure that you use a user/host c

Re: SQL [Q] how to migrate 4.0 -> 4.1

Добрый день. > Andrey Kotrekhov <[EMAIL PROTECTED]> wrote: > > Hi, All. > > Other question is: > > Can I create case sensitive field with right ordering of national > > characters. > > > > Take a look at collation name: "ci" at the end of the collation name means case > insensitive, "cs" - case s

Re: Nuke_

> Looking at our dbase I noticed that a number of tables have been added > > The all start nuke_ > > I have no idea who added them, I can only assume my ISP added them, do > they have a purpose, can I remove them etc The nuke_ tables are created automatically by a portal/conent management system

RE: C API: undefined reference

http://www.mysql.com/doc/en/mysql_connect.html This function is deprecated. It is preferable to use mysql_real_connect() instead. #include #include int main(void) { MYSQL mysql; if(mysql_init(&mysql) == NULL) { fprintf(stderr,"Unable to initlize MySQL structure.\n");

Re: running 4.0.15 side-by-side with 4.1alpha

On 11/11/2003 09:21 AM Egor Egorov wrote: Adam Hardy <[EMAIL PROTECTED]> wrote: I am sure I say someone asking a similar question on the list before but I can't find anything in the archives, nor anything relevant in the mysql docs. You can find info how to run multiple MySQL servers at:

Re: running 4.0.15 side-by-side with 4.1alpha

Adam Hardy <[EMAIL PROTECTED]> wrote: > I am sure I say someone asking a similar question on the list before but > I can't find anything in the archives, nor anything relevant in the > mysql docs. You can find info how to run multiple MySQL servers at: http://www.mysql.com/doc/en/Multipl

MySQL on Windows 2000 Server

Hi to all, I'm implementing a database in MySQL runnig on Windows 2000 Server. It's working fine. I'm wondering what kind of rights do need MySQL Server to run on Windows 2000. Now its runnig as service with administrator rights. But I am affraid that seriosly effect the securit

remote and local access problem

I have MySQL 3.23.52 server running on 192.168.1.1. This behavior seems to be strange for me: In mysql client runned on 192.168.1.1 I set these commands: CREATE DATABASE pokus1; GRANT ALL PRIVILEGES ON pokus1.* TO [EMAIL PROTECTED] IDENTIFIED BY 'heslo'; GRANT ALL PRIVILEGES ON pokus1.* TO pokus1@

Re: Retrieving the system type that MySQL is running on.

Hi Nathan, I don't think there's a way if MySQL is on a separate machine, as I'm only aware of checking in PHP. Hmm, maybe you could create a dummy table and see if it's case-sensitive or not? He he. Just curious, why would you need to know what OS MySQL is on? Matt - Original Message --

Re: In which version of MySQL was ADD COMMENT added

Hi Karam, Comments per *column* were added in 4.1.0. Comments per *table* were added in 3.23.0. http://www.mysql.com/doc/en/News-4.1.0.html http://www.mysql.com/doc/en/News-3.23.0.html Hope that helps. Matt - Original Message - From: "Karam Chand" Sent: Monday, November 10, 2003 11: