create table y select * from x;
MYSQL I am trying to create tables that will be used in merge definition. The merge seems to be very strict in the definition of like tables. So I tried to use the "create table y select * from x;" but it does not create the indexes in the new table. I did copy the x.frm to y.frm and all seem ok. Is there a better way to do this? When I created the original 150 tables I used a perl program that generated all the like tables, now I am faced with setting up another 15 tables and was trying to get out of writing another perl program. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
merge tables
I frequently get a error 127 on merged tables. The query is a join of two merged table with each merge table have 4 base tables. If I flush tables the query works. I notice that when have about 190 tables in memory this situation is more likely to happen. I am using 3.23.32. Using 3.32.35, I got 'no rows' response instead of error 127. Again the flush table allow the query to run. I knew data shoud have been return because I query the base table and got a positive response. I noticed some discussion on this over the past couple weeks but no one mentioned the flush table impact. I tried to increase the number of files allowed, but this problem is not too predictable. Guess I could try and break it with large number of queries, but I have not. Is there any problems with issueing a flush table every x hours ... minutes to avoid this problem? When are tables flushed by mysql? Dave Clark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
merge tables - rename
I got into trouble the other day trying to delete gobs of rows. Actually I was selecting 90% of the rows from table1 and inserting them into a table2, then deleting from table1. It was way too slow! So I stopped all activity (inserts) from table1 and flipped table1 with table2 using rename statements. Then started up the inserts! Worked great. How can I do this with out stoping inserts? Can I lock the table1, rename table1 to table2, then create a new table1 and release all locks? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql dbi modules
At 11:05 AM 3/2/01 -0500, you wrote: On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote: HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf. _Where_ is the socket? Assuming you've done a 'make install' as root, and you are running 'make test' as a mere mortal, do you have read permissions on the full path to the socket? (Remember that you need read _and_ execute permissions on directories.) You make it sound like you're using a relative path 'local/mysql'; that doesn't sound right. What _do_ you have in my.cnf? (I, for one, _never_ use my.cnf. In fact, I don't use safe_mysqld, either; I run mysql, with a ton of command-line flags, directly under a watchdog script.) I don't know the details of how you set everything up, but it would seem you managed to trick either the test scripts in Msql-Mysql-modules-1.2215.tar.gz (which is possible), or you've built/run MySQL itself in a confusing manner, such that safe_mysqld is really running it with different paramaters than you've intended. If you have read access to the socket, but the '10dsnlist' can't tell it there, then perhaps the test script is making a bad guess. You can tell MySQL clients to look for the socket via an environemnt variable: section A Environment variables: MYSQL_UNIX_PORT The default socket; used for connections to localhost. Maybe that'll help... Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USAIntel architecture: the left-hand path -- Thanks Brian, Setting the environment variable worked. Dbi/dbm is now installed! To clarify my other posts, my data is on '/local/mysql' where '/local' is defined as most of disk available. mysql is running as a user and I was trying to run the install dbi/dbm as root. It would not run as the user either. I did have a little problem in setting the variable. I used the command: export MYSQL_UNIX_PORT='/local/mysql/mysql.sock' Then displayed the environment with export I sure you know this but thought I would explain what I did in case some one else has a similiar problem. Thanks agzin, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql dbi modules
HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't start server : Bind on unix socket: Permission denied
I am trying to bring up my third mysql server. This one is MySQL-3.23.32-1.i386.rpm..rpm on a redhat 6.2 base. I was successful in installing both the server and the host. Look around and every thing looked cool! Piece of Cake! Then I decided to set up the mysqladmin user and setup privelidges, etc. The other two servers are run as root with no security. Every thing has gone down hill. All I get is this message: 'Can't start server : Bind on unix socket: Permission denied' whenever I try to start mysql.I've even rebooted the unix a few times, rebuilt the initial data base, etc.Tried every command I could find in the doc, but it won't budge. Only trying to get mysql to startup as root. I am about ready to start from scratch ... but reformat the drives and re-installing redhat seems too drastic. Please help. The hardware is IBM 6000R Netfinity with 1.5 g memory, dual 700 mh pentium processors, 200 g scsi raid set up as 1E. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I create one more table with existing table structure
From: Subba Reddy M Date: Fri, 26 Jan 2001 14:52:29 +0530 Hello MySQL guru, Please advise me, on creating new table with existing table structure. I have tried, how MySQL documentation referred, but unable to get success. create table newtable select * from oldtable; This works on 3.23.x check doc for version. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to use count to compare number?
From: Liu Danyu Date: Thu, 18 Jan 2001 18:08:37 +0800 I would do the query as select maker, pc.id from table1 where pc.id 2 order by maker; dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) 2 group by maker. thank you Danyu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php