how to retrieve a column type's binary attribute

Using Java, I'd like to retrieve the metadata for a mySQL table. I've been looking at and using classes DatabaseMetaData and ResultSetMetaData and found most of what I need, with one exception. How do I determine whether a column was defined with a binary attribute? e.g. col1 CHAR(4) BINARY

Re: Rewind the auto_increment index?

sql,query hello. let us say i have a table: customers idint(10) auto_increment name varchar(20) whenever i do, insert into customers (name) values ('...'); it automatically generates the id, right? that is the meaning of the auto_increment

MySQL embedded?

Hello I have a question about MySQL and regular 'programs', as i am normally used to programming web-apps and the like, with that kind of programming and database interaction. I want to know if it is possible to somehow 'embed' the MySQL database in the program you are making? (on say, Java and

Re: MySQL Privileges Question

Hi Mihail, I have done the flushing before trying to connect and it didn't work. I try the show command and nothing unusal from what it reported. Regards, Michael - Original Message - From: [EMAIL PROTECTED] To: Yat-Shing Tam [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL

Re:myODBC BIGINT conversion

Dennis [EMAIL PROTECTED] wrote on 17.07.2002 20:37:50: sql query We have data stored as BIGINT in unix, and there are 32bit unsigned values but nothing larger. I would assume if we convert this to integer in win98 it would seem that values over 31bits would be wrong. Are there workarounds

Tee Shirt

Hi All Some thing that is a bit lighter Where can I get a MySQL Tee Shirt? We now have a FreeBSD devil and a Linux Penguinin my department All I would like it a Dolphin to keep up! Simon - Before posting,

Re: MySQL embedded?

Hi Thank you for the help. It looks fairly uncomplicated this embedded database. Luckily the application we are planning is also supposed to be Open Source and available on sourceforge.net, so there shouldn't be a problem with licensing. The idea is, that the user, on install, gets to choose

Now it's available MYSQL API for VBA

Hi VBA Developer, Over 45 MYSQL API (base) functions are now available for using in Microsoft VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how you must use this API functions and how you can use multiple connection/query. Memory consumption is 2 kb.Performance

list some records combo-box in my ASP's script

hi all, i have no idea when i want to list some records in one field using ASP's combo box table name: operator field name: desc === field that i want to list-up using combo in my ASP's script table structure: code varchar(8) not null primary key desc varchar(40) null have an idea? TIA

Re: Now it's available MYSQL API for VBA

No differences. - Original Message - From: Ed Carp [EMAIL PROTECTED] To: Gelu Gogancea [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 12:23 PM Subject: RE: Now it's available MYSQL API for VBA Over 45 MYSQL API (base)

RE: Now it's available MYSQL API for VBA

Over 45 MYSQL API (base) functions are now available for using in Microsoft VB,Excel,Word,Visio,Visual FoxPro...etc.Are over 20 examples to learning how you must use this API functions and how you can use multiple connection/query. Memory consumption is 2 kb.Performance guarantied (1700

Re: MySQL Best Practices

Imro STROK [EMAIL PROTECTED] writes: But I would also like to have some MySQL Best Practices documents regarding: * Performance Tuning * Backup Recovery Appreciate if you guys/gals can send me some documents. Take a look at URL:

INSERT SELECT and VALUES

Hi All I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values to this and so some thing like. INSERT INTO table1 SELECT table2 VALUES ('A','B'); But I can not find if this can be done or

backup

Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin

replication privleges issue

Hi, SQL, MySQL. I want my master to contain only recent data, but my slave to hold a long-term archive. My plan to do this is to use a merge table on the master to provide an alias for the underlying real table. I then perform updates and inserts on the real table, and deletes on the merge

Re: backup

Ilyas Keser [EMAIL PROTECTED] writes: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin /System/Library/Perl /Library/Perl/darwin /Library/Perl /Library/Perl /Network/Library/Perl/darwin /Network/Library/Perl /Network/Library/Perl .) at ./mysqlhotcopy line 8. BEGIN

Re: INSERT SELECT and VALUES

Hi SImon Try this INSERT INTO table1 SELECT 12 as fixedvalue1 , 20 as fixedvalue2 ,table2.A , table2.B FROM table2 WHERE table2.id = 10 First the SELECT Query is executed from the table 2 which has id = 10 The Result would be

backup

Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains: /System/Library/Perl/darwin

synopsis of the problem (one line)

Description: My slave log files are filled with the following: Failed reading log event, reconnecting to retry ... server_errno=1159 How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended

Re: MySQL Privileges Question

As a little addition to that: localhost needs to be given extra rights, because localhost will always use socket connections instead of TCP. Yat-Shing Tam wrote: Hi Mihail, I have done the flushing before trying to connect and it didn't work. I try the show command and nothing unusal

Re: backup

Hello! Ilyas Keser wrote: Hi list... What is the best way to backup a Mysql database? I read in the documentation that mysqlhotcopy is the best and quickest way to do this. But I can not start mysqlhotcopy... Error Message is: Can't locate DBI.pm in @INC (@INC contains:

RE: backup

have you tried mysqldump? * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ilyas Keser [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 6:15 AM To: [EMAIL PROTECTED] Subject: backup Hi list... What is the best way to backup a Mysql

Table types in replication

If I have amast/salve pair where the slave is replicating from the master then do the table types have to be the same ? Specifically can I have a myisam table on the master and replicate to a bdb table on the slave ? The reasoning behind this is to try and find a *fast* was to convert a MYISAM

Full Text Search

I am developing a site which shows tv schedules online... http://www.einfotimes.com I want to add search to it. Basically i want to know how to full text search through all the tables in database and i also want the name of table in result along with fields...is it possible? Dasmeet Just

Fw: Problems with high-use tables

- Original Message - From: Christopher A. Libby [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 3:32 PM Subject: Problems with high-use tables Hi - I've been using MySQL for a variety of functions with great success over the last year. However, I recently rebuilt

RE: sql-commands in a file

yes, write them all to a file and put that file in a directory you have access too. Then when you want to execute them: mysql -u user -p filename =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ilyas Keser [mailto:[EMAIL PROTECTED]] Sent:

sql-commands in a file

HI all; I have 3 databases. I want backup all this databases by giving one command. I use the backup command to backup my databases, it seems to be the fastest way. Can I write sql the sql-commands below in a file and execute them by giving only one command? use db1 backup table tab1, tab2

Re: Re: Rewind the auto_increment index?

Erick, Thursday, July 18, 2002, 10:17:12 AM, you wrote: let us say i have a table: customers idint(10) auto_increment name varchar(20) whenever i do, insert into customers (name) values ('...'); it automatically generates the id, right? that is the

Re: Mysql 3.23 for AIX 4.3.3

Morris, Wednesday, July 17, 2002, 4:49:50 PM, you wrote: MF I still need to get a version of mysql working on MF AIX 4. I have been watching the mail list and MF have seen nothing about a new release. I recently MF looked at the web site and found that the current MF download binary release is

Re: instance

Alexander, Wednesday, July 17, 2002, 11:32:19 PM, you wrote: AB When I want to run two servers with different AB configuration. Can I run in the same machine and two AB running? Yes, you can (it's not true for Windows): http://www.mysql.com/doc/M/u/Multiple_servers.html

Re: Deleting foreign keys with Innodb tables

Archbold, Thursday, July 18, 2002, 12:18:09 AM, you wrote: A I'm having a problem dropping a foreign key constraint from an Innodb table. I am using MySQL 3.23.51 for Win32. Any help would be greatly appreciated A I have a simple set up like the one below: A CREATE TABLE mastertable A (

Re: INSERT SELECT and VALUES

Simon, Thursday, July 18, 2002, 1:21:20 PM, you wrote: I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values to this and so some thing like. INSERT INTO table1 SELECT table2 VALUES ('A','B');

Re: safe_mysqld - my.cnf weird foo

Shon, Tuesday, July 16, 2002, 10:45:19 PM, you wrote: SS i configure/make/make install mysql-3.23.51 on sparc solaris using SS gcc-2.95.2. i used the configure option --sysconfdir=/usr/local/etc. SS i ran the mysql_install_db script, i performed all the chown/chgrp SS operations, i copied

Re: how to fast rename column name.

qingfong, Thursday, July 18, 2002, 4:49:16 AM, you wrote: q mysql: q how to rename column name exception that use alter table tablename column newcolumn expression. I want get fast to rename the column name, but use front idea is very slowly when my table has q 1000 record. help me!

mysql_query() hangs if remote database becomes unavailable

Description: With the current series of MySQL RDBMS (tested with 3.23.49 on Debian Linux 3.0 running a 2.4.19-pre10 kernel) connecting to a remote database can be problematic since MySQL doesn't handle very well situations where the remote database has become unavailable. To be more precise,

Sorting order in MySQL

Hi all, I (like almost everyone else) use different character set than latin1. I have noticed that the Hungarian sorting does not work properly. I have checked he .conf files, and if I see it well, the way of comparing character fields is very simple. Just comparing he characters at the same

maximum row

dou you know that mysql can handle maximum row of records? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Convert to largefile support

Hi all, If I want to convert an existing Mysql install from non-largefile to support to largefile support (I rebuilt the software and enabled this), do I need to rebuild my databases/tables/indexes after I upgrade the software? Or should I be able to just upgrade the software and use my

my.cnf - pulled out all my hair

can anyone tell me how to make mysql read my.cnf from /usr/local/etc instead of /etc? i tried configuring with --sysconfdir=/usr/local/etc at compile time. that is not working. thanks, shon - Before posting, please check:

shell script to backup

Hi all... I am a new Linux user. Does any one have a shell script to backup all Mysql databases? Thanks ilyas... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MYSQL freezing

Hi, mySQL wasnt allowing anyone to write to it, so I deleted some stuff and mySQL started working again. However, even though I had freed up more than enough space, the problem repeated itself. When I tried to drop an old database, mysql hung and I cant even get into mysql anymore. Any ideas on

Re: Deleting foreign keys with Innodb tables

On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote: : Archbold, : Thursday, July 18, 2002, 12:18:09 AM, you wrote: : : A I'm having a problem dropping a foreign key constraint from an Innodb table. I am :using MySQL 3.23.51 for Win32. Any help would be greatly appreciated

Re: backup

Also in may NT machine appear the same error. Which is the problem ? - Original Message - From: Ilyas Keser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 1:58 PM Subject: backup Hi list... What is the best way to backup a Mysql database? I read in the

Exporting Replication

Hello Everyone!! I've just joined this list and have already started to enjoy the various threads that are running. I also wanted to get some feedback on something that I'm trying to do. I have currently developed a survey system that uses a mysql database that consists of 15 tables. The

RE: safe_mysqld - my.cnf weird foo

thanks victoria. now that is cleared up for me. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:41 AM To: [EMAIL PROTECTED] Subject: Re: safe_mysqld - my.cnf weird foo Shon, Tuesday, July 16, 2002, 10:45:19 PM, you wrote: SS i

update a row from another table

Hi, is it possible to simply update a row from one table with a row from another table using reference key. Something like this example query (which is doesn't work) UPDATE orders_products SET orders_products.status=orders.orders_status WHERE orders.orders_id=orders_products.orders_id

Re: Table types in replication

Hello! Pete French wrote: If I have amast/salve pair where the slave is replicating from the master then do the table types have to be the same ? Specifically can I have a myisam table on the master and replicate to a bdb table on the slave ? The reasoning behind this is to try and find a

RE: shell script to backup

mysqldump -opt everything.sql * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ilyas Keser [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:44 AM To: [EMAIL PROTECTED] Subject: shell script to backup Hi all... I am a new Linux user.

Re: shell script to backup

On Thu, 18 Jul 2002, Ilyas Keser wrote: Hi all... I am a new Linux user. Does any one have a shell script to backup all Mysql databases? Read The fine Manual - it gives several ways. - Before posting, please check:

RE: MYSQL freezing

You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. after a mysql_install_db command. Ciao, Stefano -Original Message- From:

Re: Fw: Problems with high-use tables

Just a quick question. Why are you not running DBD::Mysql directly? It should eliminate the ODBC layer and help with speed. On Thu, 18 Jul 2002, Christopher A. Libby wrote: Date: Thu, 18 Jul 2002 08:22:33 -0400 From: Christopher A. Libby [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:

RE: shell script to backup

You could use something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message-

RE: backup

DBI is the Perl module used to communicate with the database. The error message is informing you that you do not have the DBI module installed on your system. This isn't a mysql-specific problem, so you should probably consult with an actual Perl help group. At the risk of going off-topic

Re: Table types in replication

CREATE TABLE new_table (all like your current one, besides indexes) TYPE=BDB; INSERT INTO new_table SELECT * FROM old_table; CREATE INDEX ... ON new_table;... ALTER TABLE new_table ADD PRIMARY KEY (...);... RENAME old_table TO old_table_bak; RENAME new_table TO old_table; That should

Re: MySQL: Problem Installing on RH 7.3

The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020717 13:05:05 mysqld ended But I do see the host.frm file: -rw-rw1 root root 8958 Jul 17 13:04

RE: backup

Try useing something like : mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano -Original Message-

Re: backup

On Thu, 18 Jul 2002 16:05:34 +0200, Massimo Petrini wrote: Also in may NT machine appear the same error. Which is the problem ? DBI is a perl module for interfacing with databases see http://search.cpan.org/search?module=DBI -z sql mysql query -- z, [EMAIL PROTECTED] on 07/18/2002

mysql upgrade

hi, I cant use some characters in my full text search (like * , , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me

Replication in v4.0.2 not doing UPDATE

Description: I am using MySQL v4.0.2 and I have set up a master database and 2 slave databases, all on separate Solaris machines. The replication works fine when I INSERT or DELETE but does not perform my UPDATE statements. I have used 'mysqlbinlog' on the relay

mysql upgrade

hi, I cant use some characters in my full text search (like * , , etc.) I found out that it was due to the old version of the mysql i am using. Now the problem is i want to switch from the older version(3.23.49) to 4.0.2 so that my full text search can be more efficient. Can some one tell me

Replication w/ InnoDB

Ok, ok, now that I know that I 'can' replicate InnoDB tables, it's time I got it to ACTUALLY replicate InnoDB tables, eh? This is my /etc/my.cnf file from the master server: [mysqld] log-bin=/storage/mysql/replication.log server-id=1 default-table-type=innodb

Re: Fw: Problems with high-use tables

When the scripts where originally written, I didn't have a clue about the DBD::MySQL module. I've also got scripts running in VBScript via ODBC, so I wanted to stick to a standard I/O method. -Chris - Original Message - From: William R. Mussatto [EMAIL PROTECTED] To: Christopher A.

Re: MySQL: Problem Installing on RH 7.3

I am not sure, but are you sure that mysqld is running as a root? Or as a mysql (user) and mysql (group). Try to check rights of the mysqld user. Jan - Original Message - From: Richard Fox [EMAIL PROTECTED] To: Noamn [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, July 18, 2002

Re: Deleting foreign keys with Innodb tables

Philip, - Original Message - From: Philip Molter [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 18, 2002 6:23 PM Subject: Re: Deleting foreign keys with Innodb tables On Thu, Jul 18, 2002 at 03:41:01PM +0300, Victoria Reznichenko wrote: : Archbold, :

RE: MySQL: Problem Installing on RH 7.3

At first blush it looks like it's a rights problem. Need to have the /var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user mysql... HTH .mark -Original Message- From: Richard Fox [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 8:44 AM To: Noamn;

Re: MySQL: Problem Installing on RH 7.3

First, nice username :) Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql, not the safe_mysqld binary. The init.d script really calls the safe_mysqld binary, but ti also makes a couple sanity checks like ensuring that the initial database files exist and are owned by the

Re: MySQL: Problem Installing on RH 7.3

You can see them because you are root, and you own them. Mysql can't see them because it is mysql. chown -R mysql /var/lib/mysql Richard Fox wrote: The mysqld.log file says: 020717 13:05:05 mysqld started 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm'

count query across two tables

hello all, i'm new to the list (and to mysql, for that matter) and am looking for some help with what should be a fairly simple query. what i'm doing is writing a very simple bulletin board with jsp using two tables in mysql. the first table contains the title and body of the topic and the

slave stop command doesn't work if slave thread is blocked

Description: If a 'slave stop' command is while a slave is blocked waiting for a table, the slave thread must be manually killed in order for the slave stop command to complete. How-To-Repeat: mysql show slave status\G *** 1. row

Re: MySQL: Problem Installing on RH 7.3

On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote: : The mysqld.log file says: : : 020717 13:05:05 mysqld started : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file: : './mysql/host.frm' (errno: 13) : 020717 13:05:05 mysqld ended : : But I do see the host.frm file: : :

HP-UX 11, mysql-max

I tried the HP-UX mysql depot from the HP Software Porting Center, but it doesn't have innodb support. The mysql-max capability page says that innodb is supported on HP-UX, though... so presumably somebody, somewhere, has done this already. When I'm trying to compile with gcc 2.95.3 or with

Innodb startup hangs on AIX 4.3.3 when built with IBM's VisualAgeC/C++ compiler 5.0.x

Hi.. I recently built MySQL 3.23.51 on two different AIX 4.3 boxes using the VisualAge C/C++ compiler 5 only to find that that MySQL daemon is unable to properly start itself.. Below is the excerpt from the err file.. I waited until it was done with writing out the large InnoDB log/data

Three easy, FAST-REPLY questions re: MySQLGUI

Folks, On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I have MySQL-3.23.49 installed with one empty database and password created to get me started. My desktop box is Windows XP Pro. I've already downloaded and installed MyODBC 3.51.03 (full package/docs) and my MS MDAC

Re: count query across two tables

See http://www.mysql.com/doc/J/O/JOIN.html What you basically want is a left join between TalkTopics and TalkReplies. Then any rows in TalkReplies that don't have a row in TalkTopics will come back with all nulls (but they'll still make it through the query), i.e: SELECT *,

Re: Innodb startup hangs on AIX 4.3.3 when built with IBM'sVisualAge C/C++ compiler 5.0.x

[ MySQL ] Here's some additional data now that I've rebuilt using --enable-debug or whatever the configure option is. Here's what GDB is claiming is happening after it ran for about 2 minutes (after initial startup when NO files needed to be created) (gdb) where #0 thr_local_get (id=60) at

Local VB6 using MySQL DB on Web server

Hi I have a web DB proyect and I would like to make a VB6 client where I can connect to a local X database and a Web MySQL on a UNIX server. So far, locally everything works great with VB6 and MySQL, the grids, textbox, ADO control, etc.(DNS-Less and with DNS). But when I connect to the DB on

Re: Innodb startup hangs on AIX 4.3.3 when built with IBM's VisualAge C/C++ compiler 5.0.x

Rick, these code excerpts may explain the problem: /*** Returns the local storage struct for a thread. */ static thr_local_t* thr_local_get( /*==*/ /* out: local storage */

MyOLEDB-Provider - Some fixes by me

Hi! I read a message from venu to somebody called Woods, concerning fixing some of the bugs in the OLEDB-provider for MySQL trough external people. (http://www.geocrawler.com/archives/3/108/2002/4/0/8496671) Are you still interested in some fixes? I would be happy to give them to you for free.

Re: HP-UX 11, mysql-max

Jason, - Original Message - From: Jason Baker [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 18, 2002 11:48 PM Subject: HP-UX 11, mysql-max I tried the HP-UX mysql depot from the HP Software Porting Center, but it doesn't have innodb support. The

help with installation

I am a mysql newbie and in search of some pointers to get mysql 3.23.51 installed on my Redhat 7.3 system. I have the RPM downloaded and installed but I am not able to find the programs listed such as mysqladmin. The mysqld process is running and I can run the mysql_install_db script. Any

Re: Replication w/ InnoDB

James, I am sorry, the manual page at http://www.mysql.com/doc/I/n/InnoDB_restrictions.html is not up-to-date. Look at http://www.innodb.com/ibman.html#InnoDB_restrictions instead: . * In the MySQL replication load table from master does not work yet for InnoDB tables. A workaround is to

Re: Three easy, FAST-REPLY questions re: MySQLGUI

In the last episode (Jul 18), Andy Fields said: Folks, On my FreeBSD UNIX/Apache virtual private server (ISP is NTT/Verio), I have MySQL-3.23.49 installed with one empty database and password created to get me started. My desktop box is Windows XP Pro. I've already downloaded and

Re: Replication in v4.0.2 not doing UPDATE

Hi! Please provide more details. Does the problem happen also if you replicate all tables, not just use the replicate-do-table directive? What is the table definition like (print SHOW CREATE TABLE in the master as well as slave)? Does it have foreign key constraints? Give an example of an

bug/enhancement request

sql query fyi... Section 6.4.1 of the manual says: SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] select_expression,... [INTO {OUTFILE

Host IP is not allowed to connect this MySQL server

Hello, I am trying to connect to a remote MySQL server of mine and I get this error Host IP is not allowed to connect this MySQL server If someone could give me the shortcut to this file so I can edit it to allow me in- It would be greatly appreciated. Thank You Matt

mysqlimport usage

Hi, Does anyone know where to view mysqlimport logs? After running with --replace and I can see a number of rows recorded as deleted and some as warnings. I can't locate any history anywhere - not in the current directory, not in mysql installation location, not in in syslog... Thanks much

Very basic bug: Respecting NOT NULL?

OS: Win2K MySQL: 3.23.51 What: CREATE TABLE Problem:Column specification not honoring NOT NULL specifier. CREATE TABLE PFPBaseRequest ( # Uniquely identify this record id INTEGER NOT NULL AUTO_INCREMENT, trx_type

Query

Hi, I am retrieving the values of some positions of a table in MySQL dynamically.The position has null(automatically database insert that null value),1,2 values.I have to retrieve that values to a java prog and to check whether the retrieved value is 1,2 or null.This I am doing like this.

optimization

MySQL version 3.23.43 for SCO 5.06 binary INTEL. The point is that it doesn't make the rigth selection of the index When it performs explain select nfactura, nauclfe from auxiliar where nfactura like '30%' order by nfactura; The result we have is: table type possible_keys key key_len ref rows

proces to blockade

Hi we have a problem, I have table of 1,000,000 rows and i do query all, and after i can't do any more, because this process to blockade all mysql i can't do query of any table. What can i do ? Thanks and Regards - Before

RE: Host IP is not allowed to connect this MySQL server

It's not a file it's in the database. telnet to the server and login to mysql using the mysql client util like this mysql -u root -p then hit enter and enter the password. now do these commands to create a remote super user mysql GRANT ALL PRIVILEGES ON *.* TO

Re: Re: Host IP is not allowed to connect this MySQL server

Thanks Dude, I gotta same probz... but I got it now :) Regards Nitesh From: Bhavin Vyas [EMAIL PROTECTED] Date: 2002/07/18 Thu PM 08:15:26 GMT+03:00 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Host IP is not allowed to connect this MySQL server

Bash to remote MySql Server

Hi List, Wondering if anyone knows whether it's possible from bash, to connect to a remote mysql database? And if so, where I can find some help. All I require is to connect to another mysql database and get a list of users. (I am trying to avoid running another mysql db for just one table) If

Merge records from multiple tables???

Hi, I am a newcomer to mysql (and pretty much to sql in general). I have a question that is probably pretty simple to answer, but it is escaping me at present. I want to select records from two separate tables and put the results into a result table. Seems pretty simple, but I don't want to

Query cache size

I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that 4.02 performance rocks! :-) I was planning to wait for the beta builds, but the thing that triggered my decision was the discovery of the query cache. Our database server (1.4 GHz Athlon on FreeBSD) typically runs

Query cache size

[Sorry about the early send on the previous one ...] I just upgraded our web server from 3.23.47 to 4.02 -- and I must say that 4.02 performance rocks! :-) I was planning to wait for the beta builds, but the thing that triggered my decision was the discovery of the query cache. Our database

Re: Merge records from multiple tables???

create table abc as (select * from xyz1); insert into abc values (select * from xyz2); The above 2 commands should do it. You might need to change them a bit, if so www.mysql.com/doc should be very helpful. Regards, Bhavin. - Original Message - From: Ollie Acheson [EMAIL PROTECTED] To:

Re: Bash to remote MySql Server

Yes, use the ``mysql'' client. Terence wrote: Hi List, Wondering if anyone knows whether it's possible from bash, to connect to a remote mysql database? And if so, where I can find some help. All I require is to connect to another mysql database and get a list of users. (I am trying

Win and Linux ? Ver 3 and Ver 4 compatibility ?

Hi ALL, I just wanted to clarify something: 1. Can I upgrade the MySQL version from one older version to a newer version? For example if I have data base in ver 3.0 can I import over to newly downloaded ver 4.0 ? Will it still work ? Can I then delete off ver 3..0 and run the old database from

Innodb and unbuffered raw io on linux?

Hello Heikki and all, I've already asked about this a year ago, but didn't finish my investigations then. What's the status with innodb and *unbuffered raw* io on linux? The manual describes the use of the newraw and raw options, and I know these work on disk devices (like /dev/sda8), but

  1   2   >