install myodbc 2.50.39

I'm installing the myodbc2.50.39win95 in a Athlon XP 2200+, but when I start the setup.exe the following error: insufficient memory or disc space. After this, it's finishing the installation. My machine have RAM 256 and +/- 30GB free disc. What is happening? Thanks Silmara

backup using .bat in Delphi

I'm working with Delphi and MySQL, and I would like to do a backup through my application executing a .bat like c:\mysql\bin\mysqldump -h%1 -u%2 -p%3 DATABASE%4, but when I run bat through of the following statement if ExecuteFile('bkdata.bat ',192.128.0.6+ ' USER' + ' PASSWORD'+'

NOT IN

How can I query all records that not matching in another table? Ex. Select * from employees where emp_DepId not in (select dep_id from dept) Silmara MySQL - Before posting, please check: http://www.mysql.com/manual.php

Re: Creating foreign key

Change room to unit FOREIGN KEY (unitCode) REFERENCES room (unitCode) ON DELETE CASCADE FOREIGN KEY (unitCode) REFERENCES unit(unitCode) ON DELETE CASCADE Hope this helps, Sil - Original Message - From: vinita vigine Murugiah [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, November

DROP PRIMARY KEY

Thanks for the answers, but I have other problem... When I try to use the following command ALTER TABLE TABLE_1 DROP PRIMARY KEY; I get one error ERROR1114: The table '#sql-240_2' is full My table have 309195 records. How can I resolve this problem? Kind regards, Sil

SPOOL

The MySQL have SPOOL where can I stores query results in a file? How can I do this? How can I show my Indexes, Primary keys and Foreign Keys? best regards, Sil - Before posting, please check: http://www.mysql.com/manual.php

remove primary keys

I'm working with MySQL-Innodb and I have one table with primary key composed by the 5 first fields, and I want to change this removing the primary keys attributes and add one new field in the first position as primary key and auto_increment. How can I do this? best regards, Sil

DATETIME + days

I executed the following statement: UPDATE Table1 SET date_adm=date_adm+2 where date_adm='2002-10-30'; the result was...-00-00 I´m working with Mysql-max-nt 3.23.39. What´s wrong? best regards, Sil - Before posting,

Start mysql... after the blackout of energy

I'm working using innodb and last night, during a storm, our energy system fell. After the energy came back, my database didn't start, and the .err don't have messages of error, except abort connections dated of yesterday. What should I do? If to restore backup... my last backup is of Friday. How

error 1067

I can't start mysql after the blackout of energy, when I try by services(Win2000), start I get the following error 1067 Can't started the MySQL in local machine Please, help me! - Original Message - From: Silmara [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 05, 2002

recovery database

I have one backup (back.sql) of 5 days ago and I don't start my database. How can I do to recovery my backup in other database and to use old logs to adjust my dataBase? After install a new mysql and to create a new tableSpace Innodb, I can do that? regards, Sil

Backup InnoDB

How can I do backup of only one DataBase? And How can I do recovery the data? I'm working with MySQL ( InnoDB) and I have three DataBase in my TableSpace. But I would like doing backup of only one. regards, Sil - Before

Re: getting name of columns

Try: Desc name_table - Original Message - From: Martin Hudec [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 12:31 PM Subject: getting name of columns Hello, How can i extract names of columns from table? I am doing select * from table, then i want to get

Free space in Database

How do I know how much free space I have in my database innodb? MySql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Connectiva 7.0

I have an installation of Linux Connectiva 7.0 with the default installation of MySQL. I stated MySQL but I can't connect to DataBase. mysql -u root mysql Access denied to 'root@localhost' (Using Password NO) What's wrong? -

Re: Connectiva 7.0

: gerald_clark [EMAIL PROTECTED] To: Silmara [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 12:11 PM Subject: Re: Connectiva 7.0 What is Linux Connectiva 7.0, what is the default installation of MySQL, and where did you get it? Silmara wrote: I have an installation of Linux

Sort aborted

I converted one table from Paradox to Mysql with 532.458 registers. After that I try converted more 473.493, but i recept this error: Key Violation. [MyODBC][ODBC 3.51 Driver] [mysqld-3.23.39-max-nt] Sort Aborted My table: Create table FichaFin FinID MEDIUMINT NOT NULL AUTO_INCREMENT,

Autoextend

How can I create a autoextend database? I tried using the following configuration: inoodb_data_file_path=date_d1:100M:autoextend But the MySQL don't started. What's wrong? - Before posting, please check:

Re: Autoextend

- Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Silmara [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 12:16 PM Subject: Re: Autoextend At 12:08 -0300 10/16/02, Silmara wrote: How can I create a autoextend database? I tried using the following

Re: Autoextend

- Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Silmara [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 12:18 PM Subject: Re: Autoextend 1. inoodb should be innodb. Ok. I typed wrong in the e-mail. 2. Does the directory named

MySQL-max-3.23.52-win

I installed MySQL-max-3.23.52-win in the Win98 with the following configuration #This File was made using the WinMySQLAdmin 1.4 Tool #16/10/2002 14:37:55 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [WinMySQLadmin]

Kylux

I need use MySql to Linux ( Connectiva 7 )and Kylux. What version of the MySQL? Do I need MyODBC? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Innodb X myisam

I have been working with Mysql-Myisam, but when I converted to Inoodb I noticed that my queries were much slower. Why? what can I do for best the performance? When do I have to use the innodb? Best regards. Thank you! -

text

I'm working with MySQL and Delphi. I created the following table: Create table Ligacoes ( Lig_cod INTEGER NOT NULL, Lig_codate INTEGER NOT NULL, Lig_nomeat VARCHAR(20), Lig_data DATE NOT NULL, Lig_duv TEXT, Lig_resp TEXT, Lig_penden CHAR(1), Lig_codcli INTEGER, Lig_erro CHAR(1), Lig_os

lost connection

I have one client with three IPs one 0.0.0.0 other to connect internet and the last from LAN. The problem is that when i try to connect a server MySQL through MyODBC, i get the follow error message: [MySQL][ODBC 3.51 driver] Lost connection to MySQL server during query What's happening? Thank

create a new table in a tablespace...

I'm using MySQL 4.0.1 and my question is How can i do to create a new table in a tablespace?. Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: create a new table in a tablespace...

If i had more than one tablespace, don't i control where it will be stored ? - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 11:06 AM Subject: Re: create a new table in a tablespace... Silmara, Tuesday, June 18, 2002, 3:43

Create database in other location ...

I'm using MySQL 4.0.1 ( Innodb) and I want to create a database 'c:\mydata\sami_d0' and log file 'c:\mylogs\sami_l0', How can i do that? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

newbie - start (innodb)

This is the configuratin My.ini: [WinMySQLAdmin] Server=C:/MYSQL/bin/mysqld-max.exe user=root [mysqld] basedir=C:/MYSQL #bind-address=192.168.10.10 datadir=C:\mydata innodb_data_home_dir = c:\mydata innodb_data_file_path =sami_d1:100M innodb_log_group_home_dir =c:\mylogs innodb_log_arch_dir

license...

I'm developing a program, that is not free software and i'm using mysql with myodbc. The question is if i need a license or not... - Before posting, please check: http://www.mysql.com/manual.php (the manual)

newbie

I'm newbie MySql I have one field path-char-250. How can i insert the following value ('c:\temp\calc.exe')? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

lock table...

I using MySQL (type=MyISAM) with Delphi5 -MyODBC, the problem is that when I edit one row The MySQL not lock for other machines, therefore other person can edit the same row and save the changes and when I try to save, it get one error. Tell me I to do? Thanks.