Re: Mysql Problem

Hi Here is my my.cnf. pls suggest the changes to make the performance better. I am upgrading to the latest version. === # Example mysql config file. # You can copy this to one of: # /usr/local/mysql/etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific

Re: Problem Starting MySQL Daemon

Andrey: Check your mysql var directory, that's symptomatic of a misconfigured mysql daemon. Look for a file called $hostname.err, read it, and fix what its complaining about. -Kyle Rollin [EMAIL PROTECTED] On Mon, 14 May 2001, Andrey Nepomnyaschih wrote: Hello, I've been experiencing some

RE: Problem Starting MySQL Daemon

As I said I've checked it out, and all what I found is 010514 09:31:19 mysqld started 010514 09:31:19 mysqld ended Without a clue on what is happening. If there's something like log level, then where I can raise it? Regards, Andrey Nepomnyashih [EMAIL PROTECTED] -Original Message-

How I can mysqlhotcopy?

when I use mysqlhotcopy ,it say this: [root@my bin]# ./mysqlhotcopy Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/perl5/5.00503 /usr/lib/perl5/site_perl/5.005/i386-linux /usr/lib/perl5/site_perl/5.005 .) at ./mysqlhotcopy line 8. BEGIN

Re: How I can mysqlhotcopy?

perl -MCPAN -einstall DBD::mysql - Original Message - From: freelsq [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 13, 2001 11:59 PM Subject: How I can mysqlhotcopy? when I use mysqlhotcopy ,it say this: [root@my bin]# ./mysqlhotcopy Can't locate DBI.pm in @INC (@INC

Re: How to transfer database from one machine to another without network

i have created a database ,Now i want to copy it on the server. Is there any way to do it or i have to make tables on the servers if anybody knows please reply a.e.a possible. Take a look at the manual (www.mysql.com).. mysqldump might be what you want. Bye, B.

Problem in running mysql

Hi ! I have some problem in running bin/mysql.when i run this it is not responding. when i run with timeout option it says connection with server is lost. mysqld is running . There is a warning in the host.err file which says that One can only use the --user switch if running as root.And

Solaris 2.6 issue

Hi, I am new to MySQL. Can I use the binary distribution of Sun Solaris(Sparc)[sun-solaris2.7-sparc] on Solaris 2.6? Thanks for your info advance! Best regards, Gu Zhenghao - Before posting, please check:

Backup a database

Hello: This is my first message to this list, I want to know how to make a backup of a database that has memo fields, those memo fields are html articles (it's a php-nuke web), I use mySQLFront, to extract the .sql with structure+data, and then I uses mySQLAdmin to create the new

make problems on solaris 8 x86

Hello I am installing mysql 3.23.37 on solaris 8 x86. I am having problem with strings-x86.s when running make Has anybody come accross this problem and is there a work around I am using gtar and gmake Thanx in advance Suresh

Security Update ?

A few weeks ago there was a flurry of postings re a security hole in MySQL (including flames about whether or not the message should have been posted, but that's a different issue. Are there any status updates regarding this problem ? Fixed / Gone away / never there in first place ? Info

Urgent Help Needed

Hi Group, I posted this question before, and need help urgently. The problem is using a specific search! What we are trying to do is intially search 3 fields and then once the results are found it needs to be able to narrow down the results by searching the intial 3 criteria and also a

Re: Backup a database

Hello: I have already searched on the archives, but any of the solutions are valid for me because I only have remote access to a windows server to get the data+structure, and to the new server I only have mySQLAdmin access to the database. Best Regards Visual PHP Studio, RAD

RE: Urgent Help Needed

The one we tried was: $SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type' AND location = '$location' AND related_discipline = '$related_discipline', MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST ('$keywords') AS score FROM cvtemplate

restarting

I did install mysql server on my linux box, but something went wrong, i guess. I wuold like to know how to rebuild the whole system, destroying all mysql RPMs and its directories, creating a new one by running RPMs once more. All this to use mysqlgui.. Please, i know this is a dumb quyestion,

Re: Urgent Help Needed

Hi, Does $keywords contain a quote ? You must escape special characters in strings before using them in SQL statements. If you are using Perl DBI look use 'quote' function otherwise, check MySQL API for your programming language. Hope this helps -- Joseph Bueno NetClub/Trader.com [EMAIL

Input of special characters!

Hi! I have started to write a small web based application and encountered a small problem. If I use any of escape characters in the web based forms like the singel quote ' the value of that field will not be inserted in the database. I know that a singel quote can be written like '' to be able

Re: Urgent Help Needed

Hi I escape all the characters as the values are passed to the page. It is driving me mad, just to get this to work! Not many people I know have the solution. I would have thought searching FULLTEXT and other fields at the same time would be easy. Any help again appreciated. Barry In a

Bad import with ID='-1', bug or feature?

Hi, I tried import some tables from dumped text file (command line - with command SOURCE), where one row in table ABC had a value -1 in ID column (it means with properties 'primary key auto_increment' etc.). After, when I tried insert some new data to table ABC (INSERT without ID column

Re: Urgent Help Needed

Hi, Tried that and also got an error, I just hope someone has had to do this type of search!! Would have thought so! Just need to search a MATCH and others at the same time. Thanks all. Barry In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes: The one we tried was: $SQL =

Re: Input of special characters!

Please RTFM http://www.mysql.com/doc/S/t/String_syntax.html - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 14, 2001 18:12 Subject: Input of special characters! Hi! I have started to write a small web based application and encountered a small

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

On Sun, May 13, 2001 at 06:09:12PM +0300, Heikki Tuuri wrote: Suggested improvements would be the addition of COALESCE TABLESPACE Do you mean reorganization and compaction of a tablespace? The way to do it is to dump and reload all tables in the tablespace. During my tests I've

Problems BDB tables

Hi. This is my first post to this list, and it's about a problem we have with BDB tables in MySQL. From time to time when we retrieve data from a table we don't get right answer, i mean, we get part of the result set. Then if we make an optimize table tablename and try to retrieve same data we

Re: Can't compile mysqlgui because edfile.o missing (fwd)

[EMAIL PROTECTED] writes: I'm trying to compile the mysqlgui source currently available on mysql.com (version 1.7.5). I've successfully compiled/installed the packages fltk-1.0.11 and flek-0.1.1 (as suggested by the doc/README.TXT file supplied with mysqlgui), as well as the fl_editor-0.4

Query regarding backup of database

how to copy database from one pc to another without networking _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before

Re: MySQL and c++ API

dave writes: Here's my problem. I'm new to the linux world. I've installed linux 7 on an old pentium machine. I've gotten MySQL server started (safe_mysqld ) and can work with the MySQL interface (mysql). What I want to do is code in c++ against a MySQL database. I've downloaded the API

execute insert error, ERROR 2006

I insert a sql statment, size is 30M, a field type is longtext using mysql dbname filename in file, it is a sql as insert into table ... values ... where file size is 10 M, it execute well, but report error when file size is to 30M it report: ERROR 2006 at line 1: MYSQL server has

Re: execute insert error, ERROR 2006

SJ writes: I insert a sql statment, size is 30M, a field type is longtext using mysql dbname filename in file, it is a sql as insert into table ... values ... where file size is 10 M, it execute well, but report error when file size is to 30M it report: ERROR 2006 at

(URGENT) Help mysql+redhat automatically reboot.

Hi all, My RedHat 6.1 + MySQL server box has some rare thing happens today. This box is sitting on the 192.168 network. It allows a cgi program to select and update its records. The cgi program was triggered by the Internet. This box was received a lot of query this afternoon. Suddenly,

why will mysql support view?

i wonder when mysql can support view?does the 3.23 support it? if no,but now i need to use view,can u tell me other way to replace it? i am eager for your help! _ IP¿¨¡¢ÉÏÍø¿¨ÌøË®¼Û http://shopping.263.net/category08.htm NO.5ÏãË®µêÓ­ÏÄÈÈÂô

Database (Recursion and Factorials)

I am currently working on a factorial procedure that figures out a factorial for a number and eventually I will store it in the mysql database. I am kind of getting caught up with this program below. I am confused how the program is executed with all the recursive direct calls to itself. Can

Re: Bug in CAPI of My Sql

Sinisa, 1. Thanks for the mail. 2. I observed that mysql_escape_string()soes not work either.If I want to store a file name with back slashes,I feel mysql_escape_string() should introduce the additional backslash required .But it does not do so.It is just copying from source string to destination

Re: Bug in CAPI of My Sql

VVM Ravikumar Sarma Chengalvala writes: Sinisa, 1. Thanks for the mail. 2. I observed that mysql_escape_string()soes not work either.If I want to store a file name with back slashes,I feel mysql_escape_string() should introduce the additional backslash required .But it does not do so.It

Converting MS-Access to MySQL

Hello MySQL, We are a company that is considering a change to the MySQL database. Due to the fact that we got a lot of MS-access databases around here we want to ask you about the possibilities to converte MS-access databases to mySQL. I m interested in the bugs that is known ( loosing

Re: Database (Recursion and Factorials)

On Mon, May 14, 2001 at 09:32:05AM -0400, lkeeton wrote: [snip] how does it take place. For instance in this example I pass 5 it then gets to the line below and evaluates value = 5 * factorial(5-1)- right there that tells me to call the function again and pass it 4 then when I get to the

RE: Hom many columns is too many?

Without knowing more detail about the data and the requirements of that data its hard to say how the database structure should be. To say I am right over you and you are right over me is pointless. Its very dependant on the data. I agree you can have a entity with 75+ attributes and its not

RE: MySQL 3.23.38 released

Can you compile a win32 version of this? Or will there be a binary for win32 soon? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: MySQL 3.23.38

Re: Converting MS-Access to MySQL

[EMAIL PROTECTED] writes: Hello MySQL, We are a company that is considering a change to the MySQL database. Due to the fact that we got a lot of MS-access databases around here we want to ask you about the possibilities to converte MS-access databases to mySQL. I m interested in the

Re: Bug in CAPI of My Sql

Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: VVM Ravikumar Sarma Chengalvala writes: Sinisa, 1. Thanks for the

Re: Bug in CAPI of My Sql

VVM Ravikumar Sarma Chengalvala writes: Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi Here is an example from C++ : char* s = new char[in.size()*2+1];

RE: MySQL 3.23.38 released

Sorry its early for me and I didnt read the bottom of this email. Sorry:) -Original Message- From: Robert Henkel [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 8:40 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 3.23.38

Mysql shutdwon very long

Bonjour, I'm using mysqladmin shutdown to take the server down. In the past, it was the question of a few seconds. But now, it takes many minutes to Mysql to shutdown. I'm wondering if this as something to do with Innobase ... ? Could there be a reason for Mysqld to take minutes to

telnet MySQL

When I try to telnet MySQL which uses port 3030 as below: telnet grdmss57 3030 I get : Trying 163.143.156.38... Connected to grdmss57.u-aizu.ac.jp. Escape character is '^]'. ( 3.23.38jN(xIDWiConnection closed by foreign host. What is the possible reason? Is it normal?

About MySql users

Hi everybody, I have MySql installed in My own LAN and I alrready made test to use MySql as optional SQL server. Test was great in speed, so I have just one question. I want to offer my Systems with tradicional LAN Access and optional SQL server. As you know, SQL Servers are too expensesive

Re:Mysql shutdwon very long

Alex, InnoDB will flush the buffer pool and do the purge of old versions at shutdown. It does these operations also when the database is running, but there may be remaining work to do at shutdown. How is the load of your database when you are running it? Does mysqld say? InnoDB: Starting

Re: telnet MySQL

On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman spake thusly: *] telnet grdmss57 3030 Can you connect to the database through a normal client? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] Linux

Re[2]: Mysql shutdwon very long

Bonjour Heikki, HT InnoDB will flush the buffer pool and do the purge of old versions HT at shutdown. It does these operations also when the database is HT running, but there may be remaining work to do at shutdown. HT How is the load of your database when you are running it? HT Does mysqld

Re: telnet MySQL

On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman wrote: When I try to telnet MySQL which uses port 3030 as below: telnet grdmss57 3030 I get : Trying 163.143.156.38... Connected to grdmss57.u-aizu.ac.jp. Escape character is '^]'. ( 3.23.38jN(xIDWiConnection closed by foreign host.

Re: Bug in CAPI of My Sql

Hi Sinisa, Thanks for spending the time.Here are few observations on mysql_escape_string().I have checked it up and found to be working but with the following problems. i) It works well when I want to insert strings like: 'xyz or x'yz. ii) When I use x\yz with the function I see a junk character

mysql++ and Programming with MFC

Anyone have success in using mysql++ with MFC in Visual C++ 6.0, if so what did you do to get it to work? I emailed the guy who did the mysql++ port for Visual C++ and he told me that it is a major problem getting it to work with MFC. I tried all the stuff he suggested to get it to work, changing

Re: group by and order by

I have a table with texts, all of different type, I have field named type to know which is which. What I would want is with one SQL query select the latest from each type, but this query... select id, headline, type from texts group by type order by date; will give the first of each type. I

Re: INNER JOIN problem

Is there a limit to the number of inner join statements within an sql statement. I am using the following statement: SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL FROM (suburb_def INNER JOIN church_location ON suburb_def.ID = church_location.Suburb)

MySQL suddenly shutdown and cannot start up again.

Hi all, My RedHat 6.1 + MySQL 3.22.32 server box has some rare thing happens today. This box is sitting on the 192 network. It allows a cgi program to run select and update SQL statement, which triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redhat)

Excluding Data from a Query with PHP

Hi I've got a question on how to exclude a data from a query. Suppose I have the following query that is being used in combination with a PHP web site: SELECT * FROM activities WHERE month='$month' AND year='$year' Now suppose the activities table looks like this: ID username month

RE: Excluding Data from a Query with PHP

SELECT * FROM activities WHERE month='$month' AND year='$year' and username != 'myuen' -Original Message- From: Kelly Alexander Zia [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 1:45 PM To: mySQL Subject: Excluding Data from a Query with PHP Hi I've got a question on how to

Re: Excluding Data from a Query with PHP

KAZ Hi KAZ I've got a question on how to exclude a data from a query. Suppose I KAZ have KAZ the following query that is being used in combination with a PHP web KAZ site: KAZ SELECT * FROM activities WHERE month='$month' AND year='$year' KAZ Now suppose the activities table looks like this:

MySQL FullText improvements in V4.0

Hi, I've heard that there are plans to improve the database fulltext capabilities such as the ability to search for words less than 4 characters in length and searches such as +word1 -word2 and that these changes are to come in version 4.0. Can anyone confirm this and also if so can you give

my sql_escape_string()--Bug?

Hi Sinisa, 1. Thanks for the detailed mails .I got to the problem I am facing with '\' character. 2. Actually I am expecting the function to add an additional \ when a single '\' comes as a part of string.For example: I want to insert a File path like \Program Files\xy\xyz.geo I n expecting the

Re: table options and performance

Steve Ruby wrote: Steve Ruby wrote: I'm inserting 49,990 rows via file containing individual inserts (1 insert per sql statement). The table contains 7 columns and 6 indexes. Why is there so much difference on the time taken to insert the files? averages: MyISAM45

What is reference_priv used for?

When granging privaleges for sql databases, what is the reference_priv privalege used for? I have check the online documentation and I can find no clear description of what this is used for. There are a few mentions of the reference_priv but only that it exists, not what it is used for. If

Re: MySQL FullText improvements in V4.0

I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris On Mon, 14 May 2001, David Simmons - EliteUKServe.Net wrote:

InnoDB tablespace tools

Is there a plan to have any tablespace management tools for innobase? I personaly dont' care if these are via a separate program or through the mysql SQL interface but the following would be very handy. move tables between tablespaces list tables in a tablespace shrink tablespace It is

RE: What is reference_priv used for?

hi. last i heard, it was unused... -ravi. -Original Message- From: Jose de Leon [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: What is reference_priv used for? When granging privaleges for sql databases, what is the reference_priv

Require an opinion

I am new to Linux as well as MySQL. I moved to Linux from OS/2 where I was using R:Base to do my database work. When I inquired about a database for Linux I was overwhelmed with the response MySQL. So I went out and bought a few books and started to study. MySQL is obviously a ready for prime

PATCH: InnoDB asserts in trx0roll.c if run out of space in 3.23.38

Hi! I noticed that in the rollback code of 3.23.38 a new bug had slipped in. If you run out of tablespace, you will get an assertion failure in trx0roll.c line 887. You can download a fixed mysql/innobase/row/row0undo.c from http://www.innobase.fi/bugfixes.html, or alternatively just delete the

Re: Require an opinion

MySQL is in fact, as you said, a backend database. Forms, reports, labels, those are all done client side. If you do not want to develop your own client application, I suggest using Mascon (if you have some windows clients) available at: www.scibit.com. I have found it to be a VERY nice client

manual on spanish

You know about mysql manual on spanish ? Carlos Dagorret Rio Cuarto Argentina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

InnoDB Autoincrement deadlock,

I'm having some problems with tables using autoincrementing primary keys when I use InnoDB.. I've searched through the documentation at Mysql and innobase's website, and havn't been able to find anything saying this is a limitation of innodb, so I will assume this is a bug (or

Re: AUTO_INCREMENT value

Hi, how I can change AUTO_INCREMENT value for one concrete table in mysql database? (this value you can get from 'show table status'). Thanx! oSup e-mail: [EMAIL PROTECTED] ICQ: 10798264 tel.: 0608/974782 SMS: [EMAIL PROTECTED]

i have question

hi; i tried to download the file mysqlDBD but how to find GNU zipping program? thnks leo

does the create table supports checks on column definition on mysql???

part of database structure example: Create table cliente ( idcliente Int(8) NOT NULL, nombre Varchar(30) NOT NULL, idzona Int(5) NOT NULL, zipcode Varchar(8), direccion Varchar(30) NOT NULL, idasiscom Int(5) NOT NULL, listaprecio Int(2) NOT NULL, diasvencimientofactura Int(2) NOT NULL,

InnoDB and concurrent operations

There seem to be some operations that cannot be performed on the server whie InnoDB is doing something. For example I inserted about 200,000 rows in to a table from a file (mysql database file) the file starts with begin; and contains many inserts, I cancelled (ctrl-c) in the middle of the

Re: i have question

try: tar -zxvf thezippedfile.tar.gz this should feed by way of tar and gzip - Original Message - From: LS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 14, 2001 3:02 PM Subject: i have question hi; i tried to download the file mysqlDBD but how to find GNU zipping

Re: InnoDB Autoincrement deadlock,

Joe, it is a feature which will change :). What it currently does is to execute a SELECT MAX(auto-increment-column) before it does the insert. When the other user comes, he will set a waiting next-key lock in his SELECT MAX(...). The waiting lock prevents the first user from inserting. I knew

Re:InnoDB and concurrent operations

Steve, on what operating system you are running? Was the rollback (and the table load) disk bound? Did you configure much memory to the InnoDB buffer pool? Was MySQL responsive during the table loading? Is MySQL responsive if you do a big rollback without cancelling (ctrl-c) the client

Changing Data Fields through GUI?

Could someone tell us, how to change individual data fields with MYSQLGUI, or when is this feature going to be available? Does anyone know about any other tool that enables you to change individual data fields in tables? Thanks, -Peter

Re: SCO and getrusage()

Paul, I am not sure, but I think this is coming up because you need to use gcc libraries. I seem to remember that I tried to link libmysql... with the regular SCO compiler and I got this message. The regular SCO cc will not work. You have to use gcc-2.95.2 or newer, because the regular SCO

Re: Hom many columns is too many?

Personal data databases often seem to have variable information that doesn't fit all that well in relational databases. For example, multiple phone numbers for different purposes. One thing I'm considering is to have a variable text field that contains XML-encoded data to handle all this

Re: Changing Data Fields through GUI?

You can change data with ksql http://ksql.sourceforge.net but to use it, you will have to install some old Qt1.44 and old KDE stuff, asl well as an old libstc++ library, if you don't already have them installed. j- k- On Monday 14 May 2001 14:40, Peter Kovari wrote: Could someone

Re: InnoDB and concurrent operations

Heikki Tuuri wrote: Steve, on what operating system you are running? linux, intel 2.2.12 Was the rollback (and the table load) disk bound? Did you configure much memory to the InnoDB buffer pool? I would say the rollback was processor bound, the machine was running with almost no

Error 1067 - 010514 19:00:45 MySql: Forcing close of thread xx user: 'sync'

Hi I have tried to search through your knowledge base however I could not find anything that specifically addressed an issue I am observing. I am trying to set up a batch file that will launch the necessary components/services for my AvantGo 3.4 Server. I am processing this on an NT 4.0

Re: Hom many columns is too many?

On Mon, May 14, 2001 at 03:51:00PM -0700, Gary Bickford wrote: Personal data databases often seem to have variable information that doesn't fit all that well in relational databases. For example, multiple phone numbers for different purposes. Create a table with three columns. (1) And id

Error 1049 - Unknown database...

Hi, I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs some semi-intensive web applications. The system itself has 1GB memory. A few times a minute, I get the following error from my applications: MySQL Error: 1049 (Unknown database 'databasename') The server

Re: Looking for info on Fuzzy Searching with MySQL

Here's the approach I used for searching through a table that needed to search 7 different fields in the table and weight them differently: I run through this expression for each word that's split from the searchstring and through each field with different weights given to each field. Then

RE: RE: Hmmm...I have all the info, but how do i analyse this?

Hi... I have a table where I log every search entered into my site, and I = enter every match returned, Searches had LogType 1 and results have logtype = 2... And a field called GroupIdentifier links several results to one = search... How can I get a number of searched without responses? It is

Re: Auto_increment value

Refer to the man page for myisamchk ryan Hi, how I can change AUTO_INCREMENT value for one concrete table in mysql database? (e. g., this value you can get from 'show table status'). Thanx! oSup e-mail: [EMAIL PROTECTED] ICQ: 10798264 tel.: 0608/974782

Re: Error 1049 - Unknown database...

Just starting using mysql. I am just guesing here :-). It seems to me that it is looking for a database called databasename? Perhaps somewhere in your application you are asking the mysql about databasename database. I mean, is it possible that you forgot to replace databasename with the real

Re: MySQL 3.23.38 released

On 12 May 2001 00:51:11 +0300, Michael Widenius wrote: You can now find MySQL-Max (MySQL binaries with support for the above table types) for most supported platforms at http://www.mysql.com/downloads/mysql-max-3.23.html That's great news!!! Congratulations, guys! Now the problems: :-)

Grant

I am looking for different views about this I have a few question about Granting privileges to a user 1. Do you have to give them GRANT SELECT,INSERT,UPDATE, DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER for them to use their database? 2. Is it best to give them the least amount of privileges?

RE: SCO and getrusage()

Boyd, Thanks for the reply. I do have to agree with you however. I do have a system here at home in which client programs compile correctly with the SCO cc. I am still trying to figure out what is different from the development system at work and the system I recently built at home. Thanks,

RE: Error 1049 - Unknown database...

I'm going to add that there is nothing wrong with the database name that is in the query. If the same query, with slightly different constraints and the _exact_ same database name, is run 1000 times and 3 of them give the Unknown database error, that rules out an application error. Furthermore,

Replication Survey

Hello, everybody. As some of you may be aware, I will be doing a presentation along with David Axmark on replication at O'Reilly Open Source Convention on July 25, 2001. And I could use your help to prepare. What would be really helpful if you, guys, who are using replication on a more or

ERROR 2002

Hi, I've installed Mysql on my Linux version 7 and i'm having problems starting the database. I'm getting this message ERROR 2002: Can't connect to local Mysql server through socket '/var/lib/mysql/mysql.sock' (111). I've tried the find this file on my system and it not there. Anybody have a

Re: How I can mysqlhotcopy?

TYou need to obtain and install the perl DBI (database interface) and the DBD (DataBase Driver) for msql/MySQL, then it will work. freelsq wrote: when I use mysqlhotcopy ,it say this: [root@my bin]# ./mysqlhotcopy Can't locate DBI.pm in @INC (@INC contains:

Re: Grant

- Original Message - From: Richard Kurth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 8:16 Subject: Grant I am looking for different views about this I have a few question about Granting privileges to a user 1. Do you have to give them GRANT

Re: ERROR 2002

This is an FAQ and usually means that the mysql server hasn't been started yet. Please search the archives at http://lists.mysql.com for further details. - Original Message - From: albany [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 9:34 Subject: ERROR 2002 Hi,

URGENTE!!!!!!!!!!

Disculpen pero no se si me podrian mandar todo lo referente a My SQL todo lo que tengan. por favor _ http://www.latinmail.com. Gratuito, latino y en español. -

Problem with Sig11 stack trace.

If I am posting this to the wrong list, please let me know which is the more appropriate list. Thanks. I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36 for the installation. I am also using the Msql-MySQL modules 1.2215.

ERROR 1030 at line 1: Got error -1 from table handle

Hi, I am having problems with the above error, which I get when trying to do this: select name from category where match (name) against ('ipaq'); on this table: Field TypeNullKey Default Extra Privileges id int(10) unsignedPRI NULLauto_increment

MySQL get Sig 11 during query from Bugzilla

Description: When I sent this problem to the list earlier, I hadn't read about mysqlbug, so please excuse the improper question submission. Here is the repeat; I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36

  1   2   >