New To MySql

Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks Abdul Sheikh

Re: Speed !

On Saturday, 3. August 2002 06:44, Lord Loh wrote: Hi, I have a database of mysql with 3 million records. No query is performed in less than 10 seconds!(With Index and all that) Some more information like your table structure, indexes and a sample query and an explain could help to give

Re: Crashing under high load

Shane, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, August 03, 2002 2:21 AM Subject: Re: Crashing under high load On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder

Re: InnoDB: Looong pause when log file is full?

Pete, - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, August 02, 2002 2:40 AM Subject: Re: InnoDB: Looong pause when log file is full? On Thu, Aug 01, 2002 at 04:37:05PM -0500, Pete Harlan wrote: Hi, I've read the

Re: THIS IS NOT AN ADVERTISEMENT: BugReport..Need Help

At 23:19 2/8/2002 +, Tien Lim wrote: Hi, To Whom It May Concern: Environment: Operating System Windows XP Home Edition Using MySQL 3.23 Using Apache 1.3.12 Initially it started working suddenly after trying all of the commands below... : ) The next day I started the computer and it does

hey

hope its okey for me too ask you an question regarding linking of tables... i have been building the tables that are in the manual http://www.mysql.com/doc/en/example-Foreign_keys.html Still i cant understand why i can add and new shirt for an person that isnt there, i am using the mysql 3.23.49

FW: trouble getting started

Hi Installed Mysql (from mysql-3.23.51-win.zip) to c:\mysql on my pc (running Windows XP Professional) Started Apache (1.3.20) that I got with mod_perl . runs ok (can do perl scripts on it ok) Tried to execute c:\mysql\binmysqld (as in the manual) after about 5 seconds, comes back with

Using MySQL for a destop application

Hi, What I would like to do is use MySQL for a desktop application. So not with a remote SQL Server. I'm using VB.NET and Native MySQL support to connect to mysql servers, which works just fine. But I would like to distribute an application which runs only on the local machine and uses mySQL

Socket Error

Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command: bin/safe_mysqld --user=mysql , and all was done. When I tried to access

Re: Using MySQL for a destop application

First, make sure you purchase the necessary licenses and support contract. Building your own installer is a piece of cake. We use InstallConstruct, but InstallShield, Wise, etc. will do just fine. Create the database(s) the way you want them, and include them in your installer package. Make sure

Re: BUG report (CREATE TEMPORARY TABLES problem) 4.0.2/4.0.3-bk snapshot

Sergey S. Kostyliov writes: Description: Any grant at a tables level make 'CREATE TEMPORARY TABLE' privilege not working ERROR 1142 How-To-Repeat: 1) (under root) mysql GRANT CREATE TEMPORARY TABLES ON *.* TO test_user@localhost IDENTIFIED BY 'test_pass';

Re: hey

Are you using InnoDB type tables? The default table type is MyIsam which does not support foreign keys. Regards, Bhavin. - Original Message - From: muad [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 03, 2002 5:52 AM Subject: hey hope its okey for me too ask you an

Repetitive link error when making

Description: The following command is invoked by make: g++ -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -rdynamic -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath

mySQL CF5 - auto increment??

Hi, I'm trying to get mySQL 4/myODBC working properly with CF5 on a Win2k machine, but am having problems with auto_increment. I've set up some tables using auto_increment for the ID field, and when I insert a record using mySQLgui or the MSDOS mysql command line tool, it increments

Re.: Socket Error

Are you sure that you are running the server at all? Nikodim Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command:

Re.: Socket Error

Are you sure that you are running the server at all? Nikodim Here's my bug report Version: MySql 3.23.51. OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown Memory: 64MB + 256MB(Swap) Distibution Name: mysql-3.23.51-pc-linux-gnu-i686 I runned MySQL with the command:

Re: mySQL CF5 - auto increment??

Hi Flash: This is a shot in the dark, but when I set up some tables using phpMyAdmin, I set a field to auto_increment and a default value of 0, phpMyAdmin created the table, but without the default value. When I add records from a form, it increments correctly. Perhaps the default value

Re: New To MySql

Hello everybody! I am new to mysql and am totally confused as how to proceed? Is it installed automatically like perl or do I have to install and configure? in the docs its often referred as shell mysql but when I type it on c: prompt it says access denied. can anybody help? Thanks

Re: [Bug in UNION clause]

Here is the dump of those tables being used: allusa: +--++--+-+--+--- + | Field| Type | Null | Key | Default | Extra | +--++--+-+--+---

Re: Do you run multiple servers on WIndows?

At 3:03 -0300 7/26/02, miguel solorzano wrote: At 19:07 25/7/2002 -0700, Bhavin Vyas wrote: Hi, From what little I know of MySql on Windows, it runs as a service and you can't run multiple services on the same Win Server. cut From 4.0.2 release you are able to run several services. For

users and db visibilty

how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' they only are shown the db(s) they have access to. ? Thanks - Before

users and db visibility

how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' they only are shown the db(s) they have access to. ? Thanks - Before

Re: Do you run multiple servers on WIndows?

At 16:05 3/8/2002 -0500, Paul DuBois wrote: Hi Paul, cut Thanks, Miguel. This sounds promising. I don't see anything about this in the 4.0.2 change notes, Sorry Indeed it wasn't mentioned. and I have some questions about how this works: - What does the argument after the --install

benchmark to my MySQL

Is there any standard method or benchmark to run localy or remotly to my host to help me to setup MySQL better or to check various computer/configurations? I could find anything on http://www.mysql.com/information/benchmarks.html links. Only at third part software but it is in C++, not .sql.

mysqldump --xml does not generate well formed XML

mysqldump invoked with --xml/-X omits the backslash from closing tags for columns of type: enum, varchar and date. Martin Tsachev Web developer http://martin.f2o.org MySQL support: none Synopsis: mysqldump --xml generates opening tags instead of closing for data, varchar and enum