View all temporary tables in a database

HI, I create temporary tables using the query CREATE TEMPORARY TABLE .. How do i list all the temporary tables in the database "SHOW TABLES STATUS " does not show the temporary tables. Thanks Anis - Before posting,

How to view all the temporary tables ?

Hi, I am able to create temporary tables in MYSQL,using CREATE TEMPORARY TABLE I am using JDBC for this. Just like "show tables" will give all the table names in that databases, is there any query to view all current Temporary table names? Rgds Anis ---

Temporary tables/ view in MySQL

Hi. Are temporary tabels or views supported in MySQL? Some info required please Thanks Anis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

MySQL Limits....streched !

Hi, I need to set a variable limit on the MySQL file size (Average row length * no of rows ) When we insert data in to the table using JDBC .i should get a unique JDBC exception (so that i trigger an archive). Is this posible in MySQL? I notice that during creation of table i can give such op

Re: Rights required to archive a table

Yes you can. Try this query grant file on database.* to user@'. also remember grant file on database.table to user@'. does not work Anis >>> "Lakshminarayna U" <[EMAIL PROTECTED]> Friday, March 07, 2003 5:00:30 PM >>> Hi, I want to archive and restore a table in MySQL using

MySQL Rights query

HI, I need to create a new user who can can run these two queries 1. SELECT ... INTO OUTFILE 2 LOAD DATA INFILE. I create a user with this query, GRANT USAGE, SELECT, FILE ON database.table to [EMAIL PROTECTED] It gives error running this query...it says illegal Grant/comman check the manual.

maximum column width

What is the maximum column width allowed in MySQL. 255 or 256? Anis >>> Floyd Wellershaus <[EMAIL PROTECTED]> Tuesday, March 04, 2003 6:24:50 PM >>> Hello, I am trying to start replication between 2 linux servers mysql version is 4.0.8. I am following all instructions, but I keep getting the fo

Archive on remote Machine .

Any other opton.? >>> Victoria Reznichenko <[EMAIL PROTECTED]> Tuesday, February 18, 2003 7:15:01 PM >>> On Tuesday 18 February 2003 12:51, Ahmed S K Anis wrote: > I use Select * into outfile "filepath" from table to archive the > database. > Is t

Archive on remote Machine.

Hi, I use Select * into outfile "filepath" from table to archive the database. Is there any way to archive this into a different machine. (Not current machine) Yes Mapping to new machine and then giving path is an option. Any other opton.? Anis -

Re: JDBC and LOAD DATA LOCAL INFILE :

HI, Thanks all for the suggestions given for load data... It indeed helped me a lot. Right now i am using J/connector version 3 . Load data local works fine with version 3. I hit a new problem. It works fine when there are below 2 records in the file. When i tried wiht 4,00,000

Re: JDBC and LOAD DATA LOCAL INFILE :

r why ? Like to add here that Select * into outfile works perfect from JDBC wiht same filepath >>> Mark Matthews <[EMAIL PROTECTED]> Wednesday, February 12, 2003 7:49:42 PM >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed S K Anis wrote: > Thanks Mark, >

Re: JDBC and LOAD DATA LOCAL INFILE :

Thanks Mark, I tried to work with the latest driver. 3.0.4 Now it gave error shown below . Also see code snippet below at the end Error code is0 estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying IOExcepti on: ** BEGIN NESTED EXCEPTION ** java.io.FileNotFoundException esto

Re: JDBC and LOAD DATA LOCAL INFILE : The used command is notallowed with this MySQL version

Hi all, please let me now if there is a solution to this. I am facing the same problem. Anis >>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12, >2003 3:48:16 PM >>> Hello, I'm using this command into a Java servlet LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INT

Re: [mysql] Counting rows

show table status: check out the columns names you will get as idea as to how info it gives. >>> olinux <[EMAIL PROTECTED]> Wednesday, February 12, 2003 12:21:16 PM >>> SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's sup

Testing thr list

>>> Francesco Leonetti <[EMAIL PROTECTED]> Sunday, February 09, 2003 5:43:45 AM >>> Dear list, I've been searching the archives before posting this request since it is about something you've already discussed. But I didn't find the solution, so here it comes my question. It is about RAM consu

MM driver / connector support for DB Acrhive

HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this ? Regards

MM driver / connector support for DB Acrhive

HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this ? Regards

Archive and retrieval in MySQL

HI, I have a few questions related to DB archving / restore capability of MySQL. Most of them are design issues but have a lot to do with what MySQL provides. PLease share your view on them. 1. How can i trigger a database archive when a certain data base limit is reached in a table. Ex: when 1,

MySql on Non english locales.

Hi, I am using MySql 3.22 on a server with code page set to Japanese. I am using MM JDBC driver. I insert english and Japanese data into a few tables, when i query for the data from MySql i get junk characters in place where Japanese charaters need to appear. How can i enable MySql for Non engl

Problem with MM MySql driver on Solaris

I am currently using MySql. I am using the mm.mysql-2.0.4-bin.jar downloaded from mysql site as the DB driver on SOLARIS. Java version being used is Java 1.2.1 I Tested using Test programs and i found everything to be fine. Our application creates JVM in its address space and loads Java programs.

Case sensitivity in Mysql

Hi, I run mysql on windows as well as linux. table creation and access right are given by java program. Problem im facing is., i create a table with name TEMP in windows in creates table with name "temp" and linux "TEMP" while giving rights thru GRANTstatement , it fails in windows cause it exp

Mysql on Windows accessed client on Solaris--gives problem

hi, Mysql is installed on Windows 95. Client program runs on solarisConnection to DB fails I used the mm driver for mysql. see stack trace. please help!! *** panic: symbol "ioctl" undefinedSIGABRT 6* abort (generated by abort(3) routine)si_signo [6]: SIGABRT 6* abort (genera

RE: Mysql/Solaris: can't run configure or mysql_install_db

Hi, I too am stuck with mysql installaiton on solaris. Please let me know if you can help me out. I prefer downlaoding the binary and installing ot..rather then getting the src and building. thanks Anis >>> "Chuck Roberts" <[EMAIL PROTECTED]> 03/11/02 07:47PM >>> > -Original Message-

MySql in Linux, Unable to connect from windows

Hi, i am using the standard Mysql installation on Redhat Linux. I am trying to run a simple JDBC test pgm from windows machine and connect to DB on linux. I am not getting any error , but its hanging at this statment . statement is Connection connection = DriverManager.getConnection("jdbc:mysq

MySQL installation On solaris.

hi, I am resending this query. Anyone who has information on installing the MySQL binaries on solaris please help me with some information. The product doc doesnt seem to help. I am NOT too keen on building MYSQL by down loading the source code. Any help on installation of binaires? Thanx Anis

MySql on Solaris

Hi members, This is my first query :) My query is about installing MySql on Solaris. I am interested in downloading and installing the stable version of MySql on solaris 2.6. I downloaded mysql-3.22.25-solaris7-x86.pkg.tgz and MySQL 3.23. I tried to install the first one (used GNU tar) . I foll