Re: Mysql by itself? [err: 10061]

EP wrote: OK, I need to ask a stupid question. Obviously, MySQL can run on its own, not quite sure what you really mean by this though. Amazing that it wasn't obvious to me, but I originally installed MySQL after installing Apache, based on home brew instructions that implied a dependency; t

Re: help about mysql_real_connect!

Hi Li, If you want to see the implementation portion of C coding for mysql_real_connect, U can see open the mysql.h header file in any C++ editor. I don't know Why do you want to see those iplementation? libmysql.lib is a library file used to permit dynamic calls from it's clients. libmysqld.lib

Re: Mysql by itself?

As you suspect mysql is definitly a server all it's own with a command line client also all it's own here is a great easy book to start with http://www.amazon.com/exec/obidos/tg/detail/-/0672323494/qid=1073622815//ref=sr_8_xs_ap_i1_xgl14/103-5310250-5540600?v=glance&s=books&n=507846 EP wrote:

Re: odbc

Oh, if that's the case, I'm sorry for false info. Of course, if server is not accessible, then you cannot connect to it anyway, directly or through Access. Sorry again Nitin - Original Message - From: "Daniel Kasak" <[EMAIL PROTECTED]> To: "Nitin Mehta" <[EMAIL PROTECTED]>; "Matthew McN

Re: Mysql by itself?

EP wrote: OK, I need to ask a stupid question. Obviously, MySQL can run on its own, not quite sure what you really mean by this though. Best Bao I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there

Re: Mysql by itself?

EP wrote: OK, I need to ask a stupid question. I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there a way to run MySQL without a server like Apache underneath it? I see MySQL coined a "database serve

Re: odbc

Nitin Mehta wrote: You can just install MyODBC on the client (running MS Access) then you can link tables stored anywhere. have a look at: http://forums.devshed.com/t56700/s.html for more info Hope that helps Nitin I think Matthew meant that his ISPs MySQL installation is firewalled, and so a

Re: Mysql by itself?

You dont need Apache to run MySQL. Apache is a web server, which is required to publish web pages. So the answer is yes. Enjoy Nitin - Original Message - From: "EP" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 9:53 AM Subject: Mysql by itself? > > OK, I ne

Mysql by itself?

OK, I need to ask a stupid question. I normally run MySQL on Apache. I have a second machine [a laptop] which I can't get Apache to run on [the ports are restricted/closed]. Is there a way to run MySQL without a server like Apache underneath it? I see MySQL coined a "database server"; have I

Re: odbc

You can just install MyODBC on the client (running MS Access) then you can link tables stored anywhere. have a look at: http://forums.devshed.com/t56700/s.html for more info Hope that helps Nitin - Original Message - From: "Matthew McNicol" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Re: how to determine user Privilege fields

Can I create a php script like: $privSQL = "SHOW GRANTS FOR 'paul'@'localhost'"; $priv_result = mysql_query($privSQL) or die("Couldn't Select Priv"); $k=0; for ($i=0;$i"; } to print out the results to the browser.? I tried this but I couldn't get past mysql_query Chris "Paul DuBois" <[EMAI

Re: how to determine user Privilege fields

At 20:24 -0500 1/8/04, Chris wrote: I am just a user (not an administrator) and would like to know what privileges I have with my MySQL user account. Is there a SELECT command I can construct that will list these privileges? Yes, SHOW GRANTS: http://www.mysql.com/doc/en/SHOW_GRANTS.html Issue a S

Re: select lock - How reliable?

At 19:16 -0600 1/8/04, Alfredo Cole wrote: Hi: I have an application that is used by around 40 users who need to access a table, obtain a sequential code, and write it back. I'm using MyISAM tables, and mysql 3.23 running under LM 9.0. A couple of times during the day, the users get the same code,

ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)

Hello, please help me solve this problem, ON DELETE SET DEFAULT should be supported, == USE test; DROP TABLE IF EXISTS relvar_a; CREATE TABLE relvar_a ( #PK SSNCHAR(9) NOT NULL, #FK SUPERSSN CHAR(9), DNOINT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN),

ERROR 1005 at line 38: Can't create table '.\test\#sql-748_17.frm' (errno: 150)

USE test; DROP TABLE IF EXISTS relvar_a; CREATE TABLE relvar_a ( #PK SSNCHAR(9) NOT NULL, #FK SUPERSSN CHAR(9), DNOINT NOT NULL DEFAULT 1, PRIMARY KEY (SSN), INDEX (SUPERSSN), INDEX (DNO) )ENGINE = INNODB; SHOW WARNINGS; DESCRIBE relvar_a; DROP TABLE IF EXISTS relvar_b;

how to determine user Privilege fields

I am just a user (not an administrator) and would like to know what privileges I have with my MySQL user account. Is there a SELECT command I can construct that will list these privileges? Thanks, Chris $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Never place friendship be

odbc

I have a PHP/MySQL database application running on linux hosted webspace (via webfusion.co.uk). I'd like to make the information accessible from a MS Access database which sits on my clients office server (microsoft os), either by using odbc, or an alternative. This is because the client would

select lock - How reliable?

Hi: I have an application that is used by around 40 users who need to access a table, obtain a sequential code, and write it back. I'm using MyISAM tables, and mysql 3.23 running under LM 9.0. A couple of times during the day, the users get the same code, and that is causing us many problems.

Re: Using UNIX_TIMESTAMP() as default field value ?

Currently I am using UNIX_TIMESTAMP() in my INSERTS, just the idea came to me that maybe I could use a MySQL function as a default for a field. Too bad MySQL doesn't allow it though.. Thanks for your reply though =) Oh and yeah, I knew the int(10) was for the display length ;p -- Keith Bu

Re: MySQL 4.0 Installation Problem -- trying again

In one message you say you've run mysql_install_db, in another you say you're logged in as root. In your second message, you say you got the error Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... You can use perror to translate the error number (13

Help optimising a query

Hi all. Im looking for some help to speed up some queries I have to run. Ill try to briefly describe the setup, but mostly try let my code explain itself. There are three tables described below from a database that describes the execution of a Java program. class_loads records details of each cl

Re: Using UNIX_TIMESTAMP() as default field value ?

Sorry, my reply was incomplete, considering your question. You want Unix timestamp format, and you want it to default to the current time. Unfortunately, you can't do both. You can use a TIMESTAMP column, which will default to NOW (the default you want), or you can use an INT column and assig

Re: Compiling from source

Christopher L. Everett wrote: > I'm using AMD K7 servers and don't need/want InnoDB so I want to compile > mysql from source and I was curious about what compiler flags to use, so Without recompiling binaries, you can add skip-innodb skip-bdb to your my.cnf file. > 2. What compiler flags do the b

mysql In Israel

Are there any mysql users who wold be willing to chat with me off the list? The questions I would like to ask don't pertain to very many people on this list, though they do have to do with mysql, specifically about how its used in Israel, how many administrators of mysql in Israel are certifie

Re: Restore Data from deleted DB in MySql

Alex wrote: Hi I created DB in MySql with name “x” I finish fill data to this DB Next day somebody run any script And this script removed my DB and created new DB with the same name How can I get my data back in MySql Did you have any logging running? Maybe a binary transaction log

Restore Data from deleted DB in MySql

Hi I created DB in MySql with name “x” I finish fill data to this DB Next day somebody run any script And this script removed my DB and created new DB with the same name How can I get my data back in MySql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Compiling from source

Christopher L. Everett wrote: I'm using AMD K7 servers and don't need/want InnoDB so I want to compile mysql from source and I was curious about what compiler flags to use, so I went to http://www.mysql.com/doc/en/Compile_and_link_options.html which left me with some questions: 1. Does pgcc _still

Getting Garbage

I have a very strange problem with mysql version 4.1.1 . I have a table in utf-8 character set. When I insert the following into one of the columes that is TEXT: گسترده جناح اصلاح طلب درون حاکميت از رد گسترده صلاحيت نامزدهای اين جناح از سوی شورای نگهبان محسوب I get the same thing back,

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

Well I will test that on my win2k server machine is now down running instead Suse 9.0. Thanks, If I know that it runs satisfactorily under suse, I'm satisfied, I have suse 8.2, but I can go for suse 9.0 If necessary. Anyway you have the option for to download the package without installer,

Compiling from source

I'm using AMD K7 servers and don't need/want InnoDB so I want to compile mysql from source and I was curious about what compiler flags to use, so I went to http://www.mysql.com/doc/en/Compile_and_link_options.html which left me with some questions: 1. Does pgcc _still_ produce the fastest executabl

MYSQL Aborting

Need some help on this one. We are using the MYSQL on Server 2003. This is what I keep getting: Microsoft Windows [Version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\MySQL\bin>mysqld --console InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new datab

re: Japanese in MySQL

MySQL doesn't support unicode until version 4.1.0. If this isn't a production server I suggest you upgrade to MySQL 4.1.1. Its still in the ALPHA stage but it is pretty stable. I use it every day and I don't have any problems with it. Good luck, Jeremy ___

Re: Using UNIX_TIMESTAMP() as default field value ?

Quoting Michael Stassen <[EMAIL PROTECTED]>: > Defaults must be constants, not functions. Ahh. Thanks for the info. > You want a TIMESTAMP column, not INT. See > . I want to store my time in unix timestamp format though, not in a mmddyy type. > Mi

Show Master Status php

I am having a heck of a time ... I would like to use php to do a "SHOW MASTER STATUS" and print the output but for the life of me can't figure it out. I can get it to SHOW DATABASES and SHOW TABLES in a database but now SHOW MASTER STATUS or SHOW SLAVE STATUS. David Rodgers -- MySQL General

Re: Using UNIX_TIMESTAMP() as default field value ?

Defaults must be constants, not functions. You want a TIMESTAMP column, not INT. See . Michael Keith Bussey wrote: Hi all, I was wondering if it is possible to have the default value of an integer field be the current UNIX timestamp ? MySQL doesn

Re: 4.1.1 --old-paswords & 4.0.X clients

According to that page, if you start the 4.1 server with --old-passwords, it is supposed to generate short password hashes rather than long, so you shouldn't have to shorten the password column (though that works). Is it possible you didn't restart, or perhaps started with --old-password (miss

Re: 4.1.1 --old-paswords & 4.0.X clients

Is that equivalent to NOT running mysql_fix_privilege_tables? Or, do I need to run the script -- or do I even need to run the script on a new 4.1 install; just go back and alter the table to change the size? Didn't think of "Password hashing" as a search term. Thanks for the tip. Randy Randolp

help about mysql_real_connect!

Hi, ALL I have problems understanding the libmysql.def and libmysqld.def. I know they are interfaces for client and server. A lot of other modules are just calling functions definded in those two. But I can not see where they are actually implemented. For eaxample, mysql_real_connect, it is sho

Using UNIX_TIMESTAMP() as default field value ?

Hi all, I was wondering if it is possible to have the default value of an integer field be the current UNIX timestamp ? MySQL doesn't allow me to use not null default UNIX_TIMESTAMP() . If anyone knows a way of achieving this, it would be great =) Also, I currently use "int(10) unsig

Re: 4.1.1 --old-paswords & 4.0.X clients

If you resize the password column to what it was pre 4.1 it will store a hash the same length as the old algo used to produce and users will be able to log in just fine. Michael Stassen pointed me to this link http://www.mysql.com/doc/en/Password_hashing.html>. and it has a number of work arounds

Re: 4.1.1 --old-paswords & 4.0.X clients

It would be nice to dump the confidentiality statement. Unfortunately, our mail server adds it to the message as it's sent to the internet -- I have no control over it. It's alright though since my message is "intended to be for the use of the entity named above." In this case, the MySQL list c

Re: 4.1.1 --old-paswords & 4.0.X clients

you can still do a dump and restore, it works nicely. I think the problem is that he users table changed. I have a 4.1 server running, i just do a dump and restore from the old server to the new one. and added the --old-password option. Hope this helps! On Thu, 2004-01-08 at 16:14, Victor Medina w

Re: 4.1.1 --old-paswords & 4.0.X clients

It did change, but you can still use the old protocol by adding --old-passwords option to the mysqld or adding old-passwords option to the [mysqld] group in my.cnf, using this, old clients will be able to connect to 4.1 series servers without probs :) By the way, i am not quite sure, but you shou

Re: How 'if not exists' implemented in MySQL?

Stored procedures are MySQL are real new so I don't have much experience with them yet. The manual does seem to include some good info but I haven't delved too deeply. MaxDB is actually a separate DB. It is a re-brand of SAP DB. You might look for SAP DB info. It would probably apply to MaxDB.

RE: consistency checking InnoDB tables

That's ok, we got the right answer. Mailing lists are great like that. :-) Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -Origi

Re: consistency checking InnoDB tables

Thanks for the correction. I didn't think to check InnoDB's docs. MySQL's docs don't mention this. Sorry for leading you astray Joshua. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

At 20:02 8/1/2004 +0100, Morten Gulbrandsen wrote: hi, Well I will test that on my win2k server machine is now down running instead Suse 9.0. Anyway you have the option for to download the package without installer, then is just an issue to unzip the files in the right place. You should this option

4.1.1 --old-paswords & 4.0.X clients

I have a workstation that I set up as a 4.0.16 server to prove to myself that I could use MySQL for an application we are developing. Now, for beta testing, I set up a new 4.1.1 server on a real server box. I did not upgrade the workstation with the 4.0.16 server. In setting up the new server,

migration to 64 bit - successful!

We moved our main production server to a dual opteron last night, running SuSE 9.0 x86_64 (kernel 2.4.21), and the binaries mysql offer for mysql4 work great. The only hitches doing the change were between the chair and the desk. MYD/MYI/frm are all binary compatible, and the server speed is awes

Re: consistency checking InnoDB tables

Hi! - Original Message - From: "robert_rowe" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Thursday, January 08, 2004 7:16 PM Subject: Re: consistency checking InnoDB tables > > I had the same question a while back and I was told that InnoDB does this automatically. Ther

RE: MySQL 4.0 Installation Problem -- trying again

What does the .err file tell you? -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Thanks ... but yeas, I have done both an

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

MySQL 5.0 should install and run on any Win32 OS, then I guess that some installation's steps/options has failed for to add the missed files. Interesting, obviously something is missing, anyway 5.0.0.a is present. I could try that, It is important for us to know what exactly is failing, my

RE: MySQL 4.0 Installation Problem -- trying again

Thanks ... but yeas, I have done both and still got that ... that's why I was asking the questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED]

MySQL 4.0 Installation Problem -- trying again

OK I was wrong: those files are mentioned in the doc, but I strictly followed the manual and I still got those errors. The first problem is host.frm cannot be found while starting mysqld (when starting InnoDB) (in the mysqld.log file), and the server start aborted. The manual says script/mysql_i

Re: MySQL as document storage?

On Thursday 08 Jan 2004 16:50, you wrote: (B> On Thu, Jan 08, 2004 at 02:47:51PM +, Richard Davies wrote: (B> > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote: (B> > > In article <[EMAIL PROTECTED]>, (B> > > (B> > > Richard Davies <[EMAIL PROTECTED]> writes: (B> > > > I find at present

Re: ERP / Accounting

In a message dated 2004-01-08 8:50:46 AM Eastern Standard Time, [EMAIL PROTECTED] writes: > Hi, > > Could anyone please provide a list of established ERP/Accounting software > based on MySQL? I know about SAP so that doesn't count. ACCPAC, now part of > sage.co.uk, is offering on Linux but th

Re: How 'if not exists' implemented in MySQL?

Thanks a bunch for your instance responce. Right now, I'm just testing the stored procedure feature of MySQL 5.0. If that works, we'll see next if the timetable for MySQL 5.0 go production can meet our own timetable. 'Select Into' was also what I figured. Just wanted to see if MySQL has already

Re: GUID

Hassan Shaikh wrote: How do I generate a GUID (Globally Unique Identifier) under MySQL on Linux. I am doing it under Win32 using one of the documented Win32 API but I want to do it on a Linux platform? Do you need a GUID or would a UUID be alright too? (128 bit identifier just like GUID, guarantee

Re: consistency checking InnoDB tables

I had the same question a while back and I was told that InnoDB does this automatically. There are no utilities that I could find. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: When does using multiple databases make sense?

Sorry Robert, didn't mean to send to only you. We're developing a management program that can manage several jobs that a construction company is working on. We have a separate database for each job that is installed in the program. This eliminates the need to keep an extra field in each table t

Re: Problem displaying 'count'

It sounds like Zeos is checking the value of the number and reducing it's data type if it can (for efficiency I guess). If cast isn't available in your version of MySQL you might try Convert(). Here's a manual link: http://www.mysql.com/doc/en/Cast_Functions.html -- MySQL General Mailing List

RE: When does using multiple databases make sense?

I would still keep them in one database. My experience is that duplication of code (in this case tables) leads to maintaince headaches. Plus this way, you can backup/restore easily, and if necessary, once 5.0 comes out, you can use views per client to limit selects, I suppose... My $0.02 Dan

Re: GUID

I don't think that Linux uses GUID's. They are a Microsoft construct. I just searched the MySQL manual and it doesn't mention them. What are you using them for? There may be an equivilent available. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL as document storage?

On Thu, Jan 08, 2004 at 02:47:51PM +, Richard Davies wrote: > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote: > > In article <[EMAIL PROTECTED]>, > > > Richard Davies <[EMAIL PROTECTED]> writes: > > > I find at present from reasons I can't work out if the image to be stored > > > is a jpg t

Re: When does using multiple databases make sense?

In our accounting software our users can manage the books for several different companies with the same program. As such I have to keep a field (in every record) that designates which company the given record is for and use it for report filtering, lookups, etc. Had I used a different database

Re: Knowing the real size of a column

If you are using ADO then the field object has an actualsize property that should give you your value. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Free software to design forms and report

That depends on what programming languages that you know how to use. You could use PHP, Perl, Python, Java, C++, ASP (if you're on Windows) or many others. All of these are available for free but you need to know how to use them. If you're looking for a GUI driven program and you are already fa

Re: Knowing the real size of a column

"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote: > Does anyone know of a simple way of knowing the real size of a column. > Currently I am interested in knowing the size of data stored in a BLOB column. > I have tried BIT_LENGTH() but this one does not seem to return the real size. Would yo

MyODBC3.51+Linux

Hello, I have installed MyODBC3.51 driver but I do not know how to make it work with unixODBC-2.2.6-4 and unixODBC-gui-qt-2.2.6-4. When registrating the driver, the ODBC manager needs two paths. The first is for the driver library itself (/usr/local/lib/libmyodbc3.so) and the second is for "setup"

Re: How 'if not exists' implemented in MySQL?

First, please be aware that MySQL 5.0 is an alpha release. It is very young and there may still be some unresolved issues. It is not generally recommended to use alpha releases in production situations. Besides, anything that can be done in a stored procedure can be implemented in client side c

Re: MySQL as document storage?

pardon me for asking a stupid question, but when your storing data into MySQL or any database for that matter, isn't "data" data? Does this have something to do with the BLOB type? ( Which I've never understood anyway ). I'm very new at this and am wanting to store documents that have database fi

How 'if not exists' implemented in MySQL?

Greetings, We're trying to migrate an application from MS SQL Sever 2000 to MySQL 5.0. Choosing version 5.0 of MySQL is because its support of stored procedure is needed. We have a stored procedure doing something as shown below on the MS SQL Server 2000: IF NOT EXISTS (SELECT statement) {sql

CRN Has A MySQL Poll...

...on the front page: http://www.crn.com/ Not that I am recommending we stack the poll or anything... :) -- Anthony L. Awtrey Vice President __ I.D.E.A.L. Technology Corporation - Orlando Office http://www.idealcorp.com - 407.999.9870 x13 -- MySQL

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

At 14:40 8/1/2004 +0100, Morten Gulbrandsen wrote: Hi, Thank you, I am comparing the two \mysql\data\mysql directories, finding that many files are simply missing in my installation. I had another mysql version previously, which I removed, I also have a different operating system. win2k MySQL 5.

Re: MySQL as document storage?

On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote: (B> In article <[EMAIL PROTECTED]>, (B (B> Richard Davies <[EMAIL PROTECTED]> writes: (B> > I find at present from reasons I can't work out if the image to be stored (B> > is a jpg then there is no problem but if it is a tiff them MySQL won't

Problem compiling due to bad lex_hash.h (solved)

>Description: I have gcc installed in a nonstandard place so on the first run gen_lex_hash failed becuase it could not find libstdc++.so.2.10.0. I did a 'make distclean' and the reran configure with correct flags. Unfortunately the build failed again, this time in an

Re: Storing mysql dates as an integer

An unsigned int is probably more appropriate for timestamps than a signed int. Also note that the range for timestamps is 1970 until 2038 (or 2106? for unsigned ints), where DATE and DATETIME have a much greater range. Using a UNIX timestamp for birthdays might not be appropriate.

Re: ERP / Accounting

To all list readers: I apoligise in advance for the following self serving plug. I don't have a list of packages but the company I work for offers accounting software that runs with MySQL on Windows. Email me at [EMAIL PROTECTED] or [EMAIL PROTECTED] if you want more info. -- MySQL General

Re: MySQL 4.1 Installation

first download and install Dynamic client libraries (including 3.23.x libraries) available on same page to satisfy the dependencies Enjoy Nitin - Original Message - From: "Nikos Gatsis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 6:01 PM Subject: MySQL 4.

RE: Storing mysql dates as an integer [SOLVED]

Fred, > An unsigned int is probably more appropriate for timestamps than a > signed int. Thank you, that was the kind of advice I was looking for. And your point about not using UNIX time stamps for birthdays and things that could well be outside their date range is well taken. I'm only u

ERP / Accounting

Hi, Could anyone please provide a list of established ERP/Accounting software based on MySQL? I know about SAP so that doesn't count. ACCPAC, now part of sage.co.uk, is offering on Linux but they don't use MySQL. TIA. Hassan Shaikh

Resetting Auto_Increment

Hi, How do I reset the RTID to the last-highest-number? +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---

GUID

Hi, How do I generate a GUID (Globally Unique Identifier) under MySQL on Linux. I am doing it under Win32 using one of the documented Win32 API but I want to do it on a Linux platform? Thanks. Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Re: ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist

Thank you, I am comparing the two \mysql\data\mysql directories, finding that many files are simply missing in my installation. I had another mysql version previously, which I removed, I also have a different operating system. win2k Pasta de c:\mysql\data\mysql 07/01/2004 11:39

Re: innodb_buffer_pool_size / *_buffer_size relation

# [EMAIL PROTECTED] / 2004-01-08 13:26:26 +0200: > Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]> > > # [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200: > > > From: "Roman Neuhauser" <[EMAIL PROTECTED]> > > > > My first question is: what is the interaction between MySQL's > > > > *_buffer_size and

Re: Replication syncronization lag.

Jonathan, On Thu, Jan 08, 2004 at 12:54:06PM +, Jonathan Tullett wrote: > I am currently syncronizing two MySQL servers (version 3.23.49) on a > very high traffic website. > > There are, at peak times upwards of 600 updates a second (and many many > more selects) > > During these times the

MySQL 4.1 Installation

Hello list I'm trying to install MySQL-server-4.1.1-1.i386.rpm on a RH-8 Linux. System after systme check says than need LIBMYSQLCLIENT.SO.10 file to continue. Can somebody help me with this situation please? Thanx in advance Nikos -- MySQL General Mailing List For list archives: http://lists

Replication syncronization lag.

Hello. I am currently syncronizing two MySQL servers (version 3.23.49) on a very high traffic website. There are, at peak times upwards of 600 updates a second (and many many more selects) During these times the slave database will fall out of sync, sometimes by several thousand seconds (im a

Problem displaying 'count'

I don't know whether this is a problem with mySQL or Zeos (freeware Delphi components), but I'll ask here: When I use 'count' in a one table query, Zeos defines the resulting field as TIntegerField. When I use 'count' in a two table query, the resulting field is TLargeIntField, which causes problem

Re: something like show warnings?

Craig Harding <[EMAIL PROTECTED]> wrote: > Using Mysql 4.0.12 > > I know that 'show warnings' isn't implemented until 4.1.* but is there > something else that I can do to view warnings? > You can't. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is s

RE: Free software to design forms and report

Well, I know you stated that you do not find M$ Access all that good, but you could use Access as a GUI Front end to the MySQL backend. Just a thought. If you are looking at doing that, I suggest you read up on MyODBC since that is what is needed to get the two to talk to each other. I have done

Free software to design forms and report

Hi, I am a new to MySQL. Would like to find out if there is any free software out in the market to design forms and report that links to MySQL. I am looking at a local database, forms and report. Used to work with MS Access, but find that it is not that good. Just got to know MySQL, so would li

Re: innodb_buffer_pool_size / *_buffer_size relation

Roman, - Alkuperäinen viesti - Lähettäjä: "Roman Neuhauser" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Wednesday, January 07, 2004 8:05 PM Aihe: Re: innodb_buffer_pool_size / *_buffer_size relation > # [EMAIL PROTECTED] /

Re: mysqld without LinuxThreads

On Thu, 2004-01-08 at 21:10, [EMAIL PROTECTED] wrote: > Andy Bakun wrote: > > >On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote: > > > > > >>Hi all, > >>does anyone know if it's possible to compile MySQL under Linux so that > >>mysqld doesn't rely upon LinuxThreads, but makes direct call to

Re: Problems with fulltext search in boolean mode

Sure, SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, lastName, debNo, houseNoExt , MATCH (companyName, streetName, city, postalCode, lastName, firstName) AGAINST ('Mark -Nijmegen' IN BOOLEAN MODE) AS score FROM Customer WHERE MATCH (companyName, streetName, city, p

Re: Consultation in 4 tables

I found what was missing. I put distinct into the 'count( )' tag then it resolve the problem. Tkz for all Joao Pedro - Original Message - From: "Joao Pedro" <[EMAIL PROTECTED]> To: "Joao Pedro" <[EMAIL PROTECTED]> Sent: Thursday, January 08, 2004 8:24 AM Subject: Consultation in 4 tabl

Re: Problems with fulltext search in boolean mode

Mark van Herpen <[EMAIL PROTECTED]> wrote: > I've having some strange problems with a fulltext search in boolean mode. The > '-' operator doesn't seems to work correctly. First let me show you my query: > > SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, >

Problems with fulltext search in boolean mode

I've having some strange problems with a fulltext search in boolean mode. The '-' operator doesn't seems to work correctly. First let me show you my query: SELECT ID, companyName, streetName, houseNo, postalCode, city, firstName, lastName, debNo, houseNoExt , MATCH (companyName, s

Using a NetApps server for MySQL databases

Currently we are using mysql-standard-4.0.12-sun-solaris2.8-sparc on a Solaris 8 machine where the MySQL databases, MySQL binaries and MySQL logs are stored on local discs. We now want to store the MySQL databases, the MySQL binaries, and the MySQL logs on a NetApps server, and to access these fil

Re: mysqld without LinuxThreads

Andy Bakun wrote: On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote: Hi all, does anyone know if it's possible to compile MySQL under Linux so that mysqld doesn't rely upon LinuxThreads, but makes direct call to fork() or clone() system calls instead? As far as I know and can tell fro

  1   2   >