PROBLEM WORKING WITH MYSQL

I am a student using your mysql 2.23.38 version.My application details are, App-Server = TOMCAT3.2 APPLICATION USED= JAVA AND JSP I have started MYSQLADMIN and I have a green signal of MYSQL in my taskbar. MYSQL is running but it is not responding. It is giving an error

complete delete to begin again, instructions please

could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use' hardly ever' work ;) e. i just don't get the root stuff and winder whay i can't

Re: Bizarre

Aah!! Thanks :-) I didn't know a flush privileges; SQL statement was necessary. I'll be sure to remember that! Thanks! Brian Perhaps the 'replication' of 'user' data (and/or other MySQL 'control' data) doesn't perform the necessary 'refresh' (which occures when you do a flush privileges),

Problem with safe_myslqd

I have installed mysql 3.23.39 on Linux Mandrake 8.0. I have created a database but today I can't execute safe_mysqld. Mysql tell me: The file /usr/local/mysql/libexec/mysqld doesn't exist or not executable. Please do a cd to the mysql installation directory and restart this script from there as

RE: complete delete to begin again, instructions please

Use http://www.mysql.com/doc/R/e/Resetting_permissions.html to reset your password. could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use'

DBD::mysql - connection problem

Hi, I am a newbie and hope someone can she light on why I can't get the DBD::mysql connection working in my perl script. The script is a test one and very simple. I have the mysql daemon running and mysqladmin works, and DBI is installed too. I went through the installation process for DBD

any size limitation as to the size of a query statement?

Hello, I have a table with approximately 68,000 records. I then get a file uploaded to the server with approximately 68,000 master_id's listed in it. If the master_id's in our MySQL table are not one of the master_id's listed in the file, they need to be deleted from the MySQL table. Right

Re: any size limitation as to the size of a query statement?

Why not do something like: my $q = DELETE FROM master WHERE master_id NOT IN (; $q .= join(',', @masteridarray); $q .= ')'; $dbi_dbh-do($q); Though this will obviously fall into the same size limitations that you were doing, but it should execute a lot faster, and be a bit

Re: Database MySQL: possible errors when using myisamchk andisamchk ?

This is not a good idea I think, because when the check would report errors my backup would be useless ! the idea is to have clean backups, so I want to check before I do any backup and if necessary (when the check reports errors) restore the dammaged tables first. any other idea's ? regards

Re: MySQL stm

Hi, On Wed, 20 Jun 2001, Benjamin Pflugmann wrote: This is my sql statement: mysql select count(*),travel.nome_hotel,travel.tour_operator, city.city,travel.vitofferta from travel,city where city.id=travel.cityid group by travel.nome_hotel limit 5; The result:

MySQL data_seek performance

I have been bench-marking an in-house higher-level library to access the MySQL database which uses the store_result and data_seek functions to provide random access to records in a selected dataset. This has brought to light that for 'large' result sets over 10,000 records, the data_seek is

RE: :mysql - connection problem

Download and install http://www.perl.com/CPAN-local/authors/id/J/JW/JWIED/DBD-mysql-2.0901.tar.gz Hi, I am a newbie and hope someone can she light on why I can't get the DBD::mysql connection working in my perl script. The script is a test one and very simple. I have the mysql daemon

AN AUTOMATED SIMPLE WAY TO EXPORT ACCESS 2K DATA TO MYSQL ?

I have made an Access 2000 application for a real-estate company. My client will be exportign his Access data in a MySql database which will produce dynamic HTML pages (with some scripting) in an ISP server. So, his data will be published at the Internet, this way. My client will need to just

bad exe file in win32 download

Hi: I have tried several times to download the win32 zip file. When I try to unzip it, winzip says that the exe file is invalid. Any thoughts? Thanks for your help. Ted Chila

Re: Re: any size limitation as to the size of a query statement?

My code generates a large query. I had to increase the size of max_allowed_packet so that this query would work. I have this in my /etc/my.cnf file: set-variable = max_allowed_packet=2097152 -bill - Before posting, please

Binding to one IP address on a multihomed host

Dear All I want to bind mysqld to one IP address on a multi-homed host. A search of the manual has not revealed anything - have I missed something or is this not an option ? If its not an option can it be added ? Thanks Greg

skip-resolve

database Hi there I remember seeing somewhere that there is a way to skip resolution of names when conneting to the DB, can someone tell me how. I can't seem to find it in the manual. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty)

Lock Tables

database Hi there Is there anyway to see what tables are locked and by who? I have a problem where tables are locked but I am not sure who or why they are. Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South

Sort Thai Language in MySQL.

My name is Thanatip Tantulavanich.I study computer sience Burapha University in Thailand. I do the Project to topic Sort Thai Language in MySQL.I can Sort Thai Language but I don't know module for Sort in MySQL.If I command order by for sort Thai-database. Project for

Re: Compiling MySQL 3.23.39 on HP-UX 11.00.

Please run mysql-test and sql-bench in order to verify that all is working well. Please let us know the result. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/

Re: Binding to one IP address on a multihomed host

Greg Cope wrote: Dear All I want to bind mysqld to one IP address on a multi-homed host. A search of the manual has not revealed anything - have I missed something or is this not an option ? If its not an option can it be added ? Thanks Greg Hi, You can do that, look at

convert myxsql types to java types

Hello, Where can I find a table that compares between MySQL data types and java types. Is there a table in the documentation? If there is, where can I find it? Thanks Meital

How to make MySQL selfdeleting old entrys?

How can i set a date or a number of seconds/hours/minutes/days, after the date expired, that mysql deletes the entry. I want a entry that is only shown a week, after the wekk the entry should be deleted. Is there a way?

Fuzzy results from NOW()-... in select statement?

As I tried to find out how many entries are written to a 'log' table in the past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any reason (NOW()-60) should result in something completely different from (NOW()-120), could somebody clarify what's going on

Re: How to make MySQL selfdeleting old entrys?

Unix: Create a cron job that executes a shell script to do it. Win: Create a scheduler job that runs a batch file. You should be able to write a generic SQL statement that deletes all records older than X time units. Your shell script/batch file should call mySql and pump the script into it.

Re: Database MySQL: possible errors when using myisamchk and isamchk ?

The idea is to have backups. Backups of unchecked data are not useless. Backups of truncated data files are. People have lost data when the disk became full during isamchk, or the index had been crashed because it reached filesystem size limits. If you blow the data away with a failed

RE: Lower Level Visibility

wendorf, pat writes: I'm not entirely familiar with how the daemon stores these values for the entire database, but I'm guessing it's done in memory. Is it not possible to allocate storage for these values in memory for each table that has been opened?(they'd be removed once the table is

Re: Problem with safe_myslqd

find / -name mysqld -print should tell you where it is. locate mysqld may work also. Guillaume Denizot wrote: I have installed mysql 3.23.39 on Linux Mandrake 8.0. I have created a database but today I can't execute safe_mysqld. Mysql tell me: The file /usr/local/mysql/libexec/mysqld

Re: Full Text Search and Japanese

On Wed, 20 Jun 2001 15:22:22 -0700 "Ryan Knopp" [EMAIL PROTECTED] wrote: I'm trying to use the Full text Search with the japanese language using either doublebyte or singlebyte character. The problem is it doesn't seem to be working at all for any searches. I use a sql statement like this

make install

I am trying to set up a server. When I try to run the file mysql_install_db I get the error message You need to do a 'make install' before exectuing the script. Does anyone know what I should do? Please help. Thanks. -Mike

Compiling MySQL under Windows

Hi. Can anyone tell me how this [viz. compiling MySql on Windows] is done? There doesn't seem to be any documentation on how to do this under Windows, and when I tried running the make_all batch file, it didn't seem to work with my version of nmake. Does anyone have any guidance - what

Re: make install

Seems your installing on a Linux / Unix system... In te directory where your mySQL setup (such as mysql_install_db) is, run make install ... just type it at the command line. F.Y.I.: read 'man make' I am trying to set up a server. When I try to run the file mysql_install_db I get the error

Re: Compiling MySQL 3.23.39 on HP-UX 11.00.

ok, good call :) Ran the mysql-test (it failed some), details below: FAILURES: $./mysql-test-run --force 2/dev/null | grep \[ fail \] rpl01 [ fail ] rpl04 [ fail ] rpl07

Problems setting up

when using gui passes my whole address = '[EMAIL PROTECTED]' and I only need the user name sti to be sent therefore I get the message shown below. Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)

MySQLDAC v.1.3.3

Hello Delphi/C++Builder developers, 1. MySQLDAC v.1.3.3 (MySQL Direct Access Components for Delphi/C++Builder) just released. Download: http://www.microolap.com/trials/md.zip 2. Support mail lists: http://www.microolap.com/newsletter.htm You are welcome! --- Best regards, Edward Smirnov

Bug in Windows version 3.23.37

show tables returns only small letters tab1 , tab2 but in the database all tables are wir big letter Tab1, Tab2 the linux version works all right... but this ist a realy problem. that the reasan ,i think, that the revoke not works correkly If i set a Col - Right or a Tab Right , it

Creating the correct SQL statement

Hello,   I am a little stumped on how to create the select statement that I need.   I have a table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to convert Pesetas to Pound Stirling. ( divide

password peculiarities

Lately, I have been suffering the winds of misfortune with respect to user AND root password acceptance. It seems I have granted the root password correctly finally, but to date, though the SQL syntax gets accepted for changing the user password, the user can not log in WITH the -p switch; she

RE: Creating the correct SQL statement

Hi If I am right you can not do this in one move.. You can use temp tables to help thow Hope this helps a bit Simon -Original Message- From: Craig Atkins [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 15:48 To: '[EMAIL PROTECTED]' Subject: Creating the correct SQL statement

replication doesn't maintain logs?

I hope I've merely misread instructions. I've successfully set up replication, a master to one slave. However, even though the slave was comfigured to maintain both a 'classic' update log, as well as a binary log, none of the stuff it's replicating are reflected in the logs. Said logs are

Re: Creating the correct SQL statement

Is there a way to relate the items table to the exchange table? i.e. does your item have an excahngeID? (probably not) Does you item have a FK relationship into a Vendor/Mfgr who has a FK into exchange? (this would make more sense.) If so, we can probably figure it out, If there is no way to

RE: make install

That did not work. I am doing a clean install by following the instructions from http://www.mysql.com/doc/I/n/Installing_binary.html. Did I miss something? -Mike -Original Message- From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 10:13 AM To: Michael

Re: password peculiarities

At 10:54 AM -0400 6/21/01, Peter H. Burris wrote: Lately, I have been suffering the winds of misfortune with respect to user AND root password acceptance. It seems I have granted the root password correctly finally, but to date, though the SQL syntax gets accepted for changing the user password,

Re: any size limitation as to the size of a query statement?

On 21-Jun-01 Chris Petersen wrote: Why not do something like: my $q = DELETE FROM master WHERE master_id NOT IN (; $q .= join(',', @masteridarray); $q .= ')'; $dbi_dbh-do($q); Though this will obviously fall into the same size limitations that you were doing, but it

How can I build a sequence table, please help!

Hello, We are using mysql 2.22.32 (yes antique, but ISPs) I need an sequence table. Every time a client reads, the value shall be incremented. A single row, integer value would be an ideal sequencen I think. CREATE TABLE sequence( id int4; ); now, is this the correct way to emulate a

Re: replication doesn't maintain logs?

You need to have log-slave-updates in my.cnf On Thu, Jun 21, 2001 at 11:14:54AM -0400, Brian Reichert wrote: I hope I've merely misread instructions. I've successfully set up replication, a master to one slave. However, even though the slave was comfigured to maintain both a 'classic'

RE: Fuzzy results from NOW()-... in select statement?

On 21-Jun-01 Sebastiaan J.A. Kamp wrote: As I tried to find out how many entries are written to a 'log' table in the past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any reason (NOW()-60) should result in something completely different from

RE: Creating the correct SQL statement

On 21-Jun-01 Craig Atkins wrote: Hello, _ I am a little stumped on how to create the select statement that I need. _ I have a_table of items, with a column called price, which contains a price in Spainish Pesetas. I have another table, with 1 record, that contains an 'exchange rate' to

Re: How can I build a sequence table, please help!

Hallo Jason, my problem is that the mysql 'auto_increment' behaviour will increase the 'sequence' always to the maxnumber +1. We now have p.e. a table with customers. Every new customer will of course get a customer_id. We now have 2 different id_ranges. Some customers should get their id

Upgrade

I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to the new version 3.23.39 what steps or precautions should I take when doing this. Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more to it? Thanks Mike

Re: make install

I don't recall you identifying the file you are installing from, but it sounds like a source file, not a binary file. Michael Kirschenbaum wrote: That did not work. I am doing a clean install by following the instructions from http://www.mysql.com/doc/I/n/Installing_binary.html. Did I miss

Re: skip-resolve

Hello. This is (only) changeable when starting the server: /usr/sbin/mysqld --help [...] --skip-name-resolve Don't resolve hostnames. All hostnames are IP's or 'localhost' [...] Bye, Benjamin. On Thu, Jun 21, 2001 at 12:52:30PM +0200, [EMAIL PROTECTED]

RE: any size limitation as to the size of a query statement?

Thanks, Don. However, this is sort of the opposite of what we need. We need to delete from master where master_id NOT IN the array. If we do that in chunks, after the first chunk, we would have wiped out all of the records outside the array. It seems like with Chris's suggestion, along with

Re: Upgrade

Mike Jimenez [EMAIL PROTECTED] writes: Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more to it? rpm -Uvh should be used instead of rpm -i, as this is an upgrade, not install (the vh is added to be more verbose). -- Trond Eivind Glomsrød

Re: Upgrade

On Thu, 21 Jun 2001, you wrote: I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to the new version 3.23.39 what steps or precautions should I take when doing this. Do I just download the new RPM and run a rpm -i MySQL-3.23.39-1.i386.rpm and thats it or is there more

constraint question

hi I am using mysql 3.23.29 under windows 2000.I have a table: create table raries( libID bigint NOT NULL AUTO_INCREMENT , lib_datsvrID bigint null, primary key (libID), constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID)

Connect mySQL with HTML or something

I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Laura Lía Marcello Web Development

Somebody kindly get me off this list

I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Gerald Clark wrote: I don't recall you identifying the file you are installing from, but it sounds like a

Re: constraint question

just do: mysqldump options db_name db_name.sql Your database tables and contents will be dumped into db_name.sql Tylre - Original Message - From: ah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM Subject: constraint question hi I am using mysql

Re: Connect mySQL with HTML or something

You'd probably be interested in PHP: www.php.net Tyler - Original Message - From: Laura Lía Marcello [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:03 PM Subject: Connect mySQL with HTML or something I need to know if there is a way to create a searchable

Re: any size limitation as to the size of a query statement?

here, @ids is the array, delete in chunks of 64: while ( my(@id)= splice(@ids,0,64)) { $qry=DELETE FROM master WHERE master_id in (.join(',',@id).); SQLQuery($qry); } I thought about this, too.. But Mark said that he needed to delete from the table where the ID's don't match. If you

Re: Connect mySQL with HTML or something

On Thu, 21 Jun 2001, Laura La Marcello wrote: I need to know if there is a way to create a searchable database that returns results as a web page... As you can see, I'm just begining, so I would really apreciate an answer, even if it's short. Thanks! Yes, but the web page will more than

AIX Compile with GCC

I am trying to get MySQL version 3.23.3x running on my AIX 4.3.3 system. I have tried the following: 1. Binary distributions from bull and mysql sites. I get problems with the readline shared libs on these distributions. I have the GCC versions of readline install. 2. Source compiled

Startup Question

I have just installed Suse Linux 7.1 and I am trying to configure the mysql database on it. I new that I was going to be using mysql on this system so I set it up with its own filesystem. By default it is installed in /var/lib/mysql. in this directory is the ./mustang-bin.index and also

MySQL MAX HPUX 11x depot file????

Hi I have installed/configured Oracle under HPUX, but thinking of moving to mySQL. But finding that a little difficult. First of all, document talks about (including throughout the Internet) a depot file (i.e. mysql.full) to be run with swinstall utility. But I have yet to find it. I

Backing up raid tables

Well, I successfully solved our 2 gig file limit problem with RAID tables without too much hassle, despite a dearth of documentation. However, it has introduced another significant problem. It would seem mysqldump isn't smart enough to look for raided tables. Taking the server down to do

Re: any size limitation as to the size of a query statement?

On 21-Jun-01 Chris Petersen wrote: here, @ids is the array, delete in chunks of 64: while ( my(@id)= splice(@ids,0,64)) { $qry=DELETE FROM master WHERE master_id in (.join(',',@id).); SQLQuery($qry); } I thought about this, too.. But Mark said that he needed to delete from the

mysql installation from source

Hi, I have been trying to install mysql on my server for way too long now! my system specs are: intel i686, with linux 6.2 loaded. I think i once did get the installation to work almost correctly, or at least more correctly than it does now... the problem: when i compile/make etc., i get

Re: mysql installation from source

I think mysql.sock gets created once you start the server. Have you tried starting it and then looking in /tmp? Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June

Re: mysql installation from source

Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and 'install' the distribution (which package have you downloaded ?) ?? - Original Message - From: Aditya Dhekney [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 21, 2001 12:19 PM

Re:Error/crash with InnoDB if table name = database name

Heikki, when you try to create the table test with type = innodb, does the server print into the error log or to the screen: Innobase: error: table test/test already exists in Innobase data dictionary Yes, indeed. I missed that line between all the stack backtrace output. If so, then you

mysql installation from source

-Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:38 PM To: Aditya Dhekney Cc: [EMAIL PROTECTED] Subject: Re: mysql installation from source Could you list (exactly) what commands you are using to 'unpack', 'configure', 'build', and

RE: mysql installation from source

-Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 3:31 PM To: Aditya Dhekney; [EMAIL PROTECTED] Subject: Re: mysql installation from source I think mysql.sock gets created once you start the server. Have you tried starting it and then looking

mysql crashing under 100 user loads

I am having a problem with mysql. I am running a php web site that uses a (mysql Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of about 100 simultaneous users, mysql begins to spawn D stat processes and the site dies. Everything works very well with

gui

does enyone knows a GUI to use with mysql wich is verry friendly one? thanks advanced. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -

Re: Somebody kindly get me off this list

Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Angela: It's not: Date: Thu, 11 Aug 1904 15:17:05 -0700 Might want to check on

Re: gui

I like webmin. http://www.webmin.com phpMyAdmin is another good one, but I'm not sure where you can go to download it. alan On Thu, 21 Jun 2001 16:55:22 -0400, Ricardo Striquer Soares [EMAIL PROTECTED] wrote: does enyone knows a GUI to use with mysql wich is verry friendly one? thanks

Re: gui

For the Windows platform, have a look at urSQL -- http:/www.urbanresearch.com/ursql You might also want to have a look at the MySQL documentation (very friendly is a subjective and vague requirement): http://www.mysql.com/doc/n/o/node_17.html http://www.mysql.com/doc/S/E/SEC592.html On Thu,

Re: mysql installation from source

You have some 'odd' options in your configuration line...Have you tried using a 'simple' configuration to see if it will buildproperly ? ./configure --prefix=/apps/mysqlAre you in the "/apps/mysql" directory when you run "mysql_install_db" ??(you should actually be typing

RE: multiple indexes

Just a couple of questions regarding indexes... Can I have multiple indexes on the same column? Yes, but it's kind of pointless. Will this decrease performance when inserting? Yes. Can you create and remove indexes after the creation of the table? Yes.

Re: gui

check out mysqlfront. You can download it from download.com and it kicks some major ass.. Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P.

Re: gui

Nope. On Thu, 21 Jun 2001 16:04:03 -0400, md [EMAIL PROTECTED] wrote: Is this the same alan cox who has been involved with the linux kernel for the last 5 years? Just checking... Mark Diener Alan Cox wrote: I like webmin. http://www.webmin.com phpMyAdmin is another good one, but I'm

(anonther) user permission problem

Hi fellow mysql'ers Here my simple problem I can connect to the mysql server host from any other host, but I cannot from the host with the mysql server. More detail Mysql 3.23.30-gamma (yea I know I need to update it) Example user is foo, password is bar Columns_priv, func, and host are

CRASH with BDB Tables and replace into

Description: MySQL Crashes with BDB Tables and replace into in some cases How-To-Repeat: mysql create table test (sessionid varchar(80) not null primary key, sessionval blob, lastopen timestamp not null) type=bdb; Query OK, 0 rows affected (0.88 sec) mysql alter table test add

mysql mod for apache

on my box, apache is compiled with dso support (and php many other mods). is there any way to bring in mysql support with out having to recompile apache or php. normally, i would just recompile php and everyone would be happy, but i'm running a cobalt xtr, and recompiling php breaks some of

RE: gui

there is also a programme called JSPerm (JSP Enterprise relational manager) search for it on google... it's very good -Original Message- From: j.urban [mailto:[EMAIL PROTECTED]] Sent: 21 June 2001 10:36 To: Ricardo Striquer Soares Cc: mysql Subject: Re: gui For the Windows

AW: UPDATE with values from another table?

is it possible to update fields of a table with values taken from another table? Like this (illegal) command would do: UPDATE b SET b.v = a.v WHERE b.id = a.id; Not yet. Multi-table deletes/updates are planned for MySQL 4.0, AFAIK. Then I have to stick to the method I am currently

AN AUTOMATED SIMPLE WAY TO EXPORT ACCESS 2K DATA TO MYSQL ?

I have made an Access 2000 application for a real-estate company. My client will be exportign his Access data in a MySql database which will produce dynamic HTML pages (with some scripting) in an ISP server. So, his data will be published at the Internet, this way. My client will need to just

Upgrading MySQL on Windows Platform

Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the

Re: Somebody kindly get me off this list

on 6/21/01 16:04, Van at [EMAIL PROTECTED] wrote: Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Thanks, Angela Angela: It's not: Date:

RE: (anonther) user permission problem -- hit send to fast

Forgot to add Can connect from a different host by using both the hostname and FQN, For example the name of the host with the mysql server is sparky. From sparky -h localhost -h sparky -h [EMAIL PROTECTED] All fail From another host both sparky and [EMAIL PROTECTED] let me in, and Of

Re: Re: replication doesn't maintain logs?

No, this isn't spam. I was publicly thanking someone for advice given. :/ On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the

mysql

I am running mysql-3.23.39 and I can't get it to use the tmpdir I specify. Is there a minimum size it needs to be? - Gabe E. Nydick Project Manager ClubPhoto, Inc. P - 408.423.6611 F - 408.557.6799 -

RE: Upgrading MySQL on Windows Platform

Yes, just stop the mysql service before you begin installation by running something like net stop mysql from a command prompt. Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I

Re: Upgrading MySQL on Windows Platform

At 14:32 21/06/2001 -0700, Martin Tunggorono wrote: Hi! Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it

Large Replace/Inserts Truncating.

Hi! We have started doing some rather large replace intos and inserts (~3MB) using a client written in C. However, these queries are truncating at around 100k. There is no error returend by the connection, but, the error log does have errors such as these: 010323 11:15:19 Aborted connection

what is the difference between, MDB and MySQL

Re: what is the difference between, MDB and MySQL

MySQL is a database just like others: Oracle (Oracle) SQL Server (Microsoft - for large systems) Access (Microsoft - for small systems) DB2(IBM) etc... MDB, as I know, is the termination (extension) given to a database generated by MS Access. For example: NorthWind.mdb

GUI - again

Someone was asking about GUI's for mysql and I saw a number of responses. Unfortunately, in my case, mysql (on *nix) is limited to listening to requests only on localhost (security), so I can't use any of the windows clients. Are there any gnome front ends to mysql? I'm looking for something

Database Schema

Hi, Can I generate my Database Schema from mySQL? How? TIA, Juan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

  1   2   >