Re: mysql 4.0.11-gamma: TRUNCATE table bug

2003-03-10 Thread indrek siitan
, Indrek -- MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Support Guy /_/ /_/\_, /___/\___\_\___/ UuemƵisa, Haapsalu, Estonia

Re: FAQ hosting site [FAQTS.COM]

2003-01-03 Thread indrek siitan
(http://www.mysql.com/documentation/index.html) now. Rgds, Indrek -- MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru

Re: Query

2002-07-17 Thread indrek siitan
more information about the limits of MySQL and other databases at our Crash-Me pages at: http://www.mysql.com/information/crash-me.php Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/?ref=mtfr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan

Re: MySQLGUI

2002-01-15 Thread indrek siitan
/P/r/Privileges_options.html You need to run the server with the --safe-show-database option. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED

Re: Why I will stay with Microsoft SQL Server

2001-12-27 Thread indrek siitan
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com

Re: Why I will stay with Microsoft SQL Server

2001-12-27 Thread indrek siitan
, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com

Re: mySQL newbie?

2001-09-16 Thread indrek siitan
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http

Re: MySQL home page redirects to obsolete link (sunsite.dk)

2001-09-14 Thread indrek siitan
downloads should be operational again real soon. Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread indrek siitan
/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com - Before posting, please check: http

Re: GEMINI Table Type

2001-09-11 Thread indrek siitan
a binary distribution, you should download the MySQL-Max binary, that has BDB/InnoDB compiled in (the default MySQL does not). Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED

Re: Permissions Problems

2001-08-14 Thread indrek siitan
support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com

Re: Copy of databse on my PC....

2001-08-13 Thread indrek siitan
://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Indrek Siitan [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, The Web Guru /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ www.mysql.com

Re: MySQL - Table damaged Help!

2001-08-01 Thread indrek siitan
Hi, mysql select * from logezboo; ERROR 1016: Can't open file: 'logezboo.MYD'. (errno: 145) shut down your mysql, change to your MySQL data directory (as root or the user MySQL runs as) and run: myisamchk -r */*.MYI and then restart MySQL after that and you should be back and running.

RE: why does it not work

2001-05-21 Thread indrek siitan
Hi, - DAY) '$tdate' and city.id=special.cityid order by RAND() limit 1; ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at line 3 select version(); +---+ | version() | +---+ | 3.22.32 | +---+ What could be the problem order by

RE: Inserting images into BLOB Fields

2001-05-20 Thread indrek siitan
Hi, How can I insert an image file into a blob field? I search the MySQL Documents but nothing came up specificaly on inserting images from files. INSERT INTO sig VALUES ( 1, 'Paul', 'Davolio', LOAD_FILE('d:/signatures/paul.txt') ); Rgds, Tfr --== [EMAIL PROTECTED]

RE: Fulltext and phrases

2001-05-20 Thread indrek siitan
Hi, I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. you're right, phrase and AND searches will be in MySQL

RE: I have a question

2001-05-20 Thread indrek siitan
Hi, I can not access to an access file via ODBC It gives me Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL

RE: Access denied error

2001-05-17 Thread indrek siitan
Hi, i am trying to import or export using MYSQL driver. that time it gives following error; Access Denied For User '[EMAIL PROTECTED]' (Using password:YES) did you give all the privileges manually through editing the grant tables, or by the GRANT command (the right command should be

RE: mysql

2001-05-17 Thread indrek siitan
Hi, Does anyone know the correct syntax to connect to a mysql database with DBI? I tried the syntax mentioned in the Perl DBI O'Reilly book, but I got errors. i'm pretty sure the syntax given in the O'Reilly book was right. and it would really make it easier to help solve your problems, if

RE: if then (SQL statement) else (SQL statement 2)

2001-05-17 Thread indrek siitan
Hi, Hi, I'm trying to use an if then alike statement in MySQL, myabe anyone can tell me the correct syntax if got a variable named naam. when the content of this variables is empty the following SQL statement should be executed: select * from beheerder; when naam is not empty: select *

RE: Query for Accessing MySQL in C/C++

2001-05-17 Thread indrek siitan
Hi, I have to manipulate (or access) MySQL Database through pure C or C++, but I am not getting the exact libraries for it. Also, I don't know how to do it. Please anybody would tell me if it is possible or not. And if it is possible, then let me know how to do it and what to do for it. in

RE: Problem

2001-05-10 Thread indrek siitan
Hi, I have some tables in the ISAM format in the database. The tables have the data, but whenever I do a select * from table_name, it returns an empty set for most of the tables. Whenever I do a count(*) query I get the total no of records. try running isamchk (c:\mysql\bin\isamchk

RE: database recovery (errcode 13)?

2001-05-10 Thread indrek siitan
Hi, The server where the db was located got hacked and I had to reinstall the whole thing. The old HD is preserved as was and the server got a new HD. I moved the old db to the new disk and when I try to access it, I get the following error: mysql use thedb; Can't read dir of

RE: [Help] best way to synch mysql with an Oracle DB

2001-05-10 Thread indrek siitan
Hi, I have a project which need to synch our mysql db with external Oracle DB. It requires that anytime DB admin modifies their Oracle DB, the change should be synched remotely with our DB in mysql. To make thing easy, we could use the same table structure on both end. just a quick idea

RE: RE: Problem

2001-05-10 Thread indrek siitan
Hi, Tried doing isamchk on the .ISM files and got that following error The Exception Integer division by zero (0xc094) occured in the application at the location 0x0040224a. getting such errors usually means you've got hardware (bad memory?) or some serious software installation

RE: Migrate Lotus Domino .nsf == MySQL 3.23.27

2001-05-10 Thread indrek siitan
Hi, we have to migrate a database from Lotus Domino (.nsf format) to MySQL. Is there anybody out there having had experience on this kind of job? Let we know, we are a bit .. desperate ... the easiest way is to try to make SQL dumps from your current database (Domino) and then work around

RE: Need help with 23.36

2001-04-23 Thread indrek siitan
Hi, mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes'

RE: duplicating rows

2001-02-01 Thread indrek siitan
Hi, Table 1 is called: active_users Table 2 is called: deleted_users When "joe_smith" wishes to be deleted, I want to remove his entry from the active_users table, and place it into the delete_users table, with exactly the same information. INSERT INTO deleted_users SELECT * FROM