Question on V5.0.9 and SHOW command
Hello, I have a strange issue. When I issue the command SHOW COLUMNS from TABLE XYZ I get the usual output.The key field is blank because there is no key on the field. However, when I issue the command from a PERL script the the DBI::DBD it returns MUL in the key field. There is no index associated with this column either it's a straight VARCHAR(40) field. Anyone have any ideas? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Date/Time Problem with V5.0.6 views
Hello everyone, I cannot figure this out. I have a table like the following: Tab_A datetime_field datetime not null, num_field bigint not null I do a SELECT as follows: Select datetime_field, num_field from Tab_A where datetime_field='2005-03-10' and num_field = 1234; I return 2 rows correctly. I then create the view: Create view Tab_A_View as select * from Tab_A; I do a SELECT as follows: Select datetime_field, num_field from Tab_A where datetime_field='2005-03-10' and num_field = 1234; 0 rows returned! HOWEVER, IF I do the query as such: Select datetime_field, num_field from Tab_A where datetime_field='2005-03-10 00:00:00' and num_field = 1234; 2 rows returned correctly. Is there an implementation difference? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL / DBI Question
Hello all, This may be a little bit off topic for MySQL newsgroup but here goes.I'm trying to retrieve variables such as basedir and datadir. PERL/DBI returns 2 rows for each varialbe. The first is the name and the second is a value. Is there a way to get PERL/DBI to return each variable as 1 row. Thanks in advance, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Found Wrong Record xxx (using 5.0.6 windoz)
Hi, I will give the output below. I just ran an insert of a small amount of data into Windoz/MySQL 5.0.6. Then, I ran a myisampack agains it. Finally, I ran a myisamchk against it and keep coming up against this error: Found wrong record at 687081 Now, I'm the only one who has access to this database. What's is going on? Can anyone help me? Enclosed is the output of each step below. Regards, George E:\MySQLData\5.0.6\sdidwmyisampack -v --tmpdir=e:\workdir table.MYI Compressing table.MYD: (100349 records) - Calculating statistics normal: 9 empty-space: 0 empty-zero: 1 empty-fill: 9 pre-space: 0 end-space: 0 intervall-fields: 4 zero:14 Original trees: 55 After join: 32 - Compressing file Min record length: 39 Max length: 58 Mean total length: 46 77.63% Remember to run myisamchk -rq on compressed tables E:\MySQLData\5.0.6\sdidwmyisamchk --tmpdir=e:\workdir -rqp --sort-index --analyze mytable.MYI - check record delete-chain - parallel recovering (with sort) MyISAM-table 'mytable.MYI' Data records: 100349 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 - Fixing index 9 - Fixing index 10 - Fixing index 11 Found wrong record at 687081 E:\MySQLData\5.0.6\sdidw __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Connection Issue with DBI::DBD::Mysql
Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn = database=userdb:hostname=192.168.2.113:port=3307, uid = user1, pwd = user1 imp_dbh-MyLogin: dbname = userdb, uid = user1, pwd = user1,host = 192.168.2.113, port = 3307 imp_dbh-mysql_dr_connect: host = 192.168.2.113, port = 3307, uid = user1, pwd = user1 imp_dbh-mysql_dr_connect: client_flags = 2 imp_dbh-mysql_dr_connect: -Access denied for user 'user1'@'192.168.3.90' (using password: YES) error 1045 recorded: Access denied for user 'MSA'@'192.168.3.90' (using password: YES) What disturbs me is that the return error comes back with a different IP address than what I sent out. Anyone have any idea as to why? That would seem to be the problem with the access denied! George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connection Issue with DBI::DBD::Mysql (more information)
Hi, My bad. I forgot to explain that the IP address returned is NOT that of the machine where I'm running the program (the Linux server). That address is different from the one returned. Sorry for the confusion. George [EMAIL PROTECTED] wrote: looking at this the ipnumber 192.168.2.113 is the target windows/mysql machine. the linux machine, whose access is being rejected, has an ipnumber of 192.168.3.90. is that now how your have your machines configured? Original Message Date: Tuesday, June 21, 2005 01:56:50 PM -0400 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Connection Issue with DBI::DBD::Mysql Hi everyone, Trying to connect to a MySQL database from a Linux Server using PERL to a Windows Machine with a MySQL database (5.0.6). I can connect successfully on the windows box but cannot on the Linux server! I ran a SQLTRACE (DBD) with the following output: imp_dbh-connect: dsn = database=userdb:hostname=192.168.2.113:port=3307, uid = user1, pwd = user1 imp_dbh-MyLogin: dbname = userdb, uid = user1, pwd = user1,host = 192.168.2.113, port = 3307 imp_dbh-mysql_dr_connect: host = 192.168.2.113, port = 3307, uid = user1, pwd = user1 imp_dbh-mysql_dr_connect: client_flags = 2 imp_dbh-mysql_dr_connect: -Access denied for user 'user1'@'192.168.3.90' (using password: YES) error 1045 recorded: Access denied for user 'MSA'@'192.168.3.90' (using password: YES) What disturbs me is that the return error comes back with a different IP address than what I sent out. Anyone have any idea as to why? That would seem to be the problem with the access denied! George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- End Original Message -- __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: discuss: user management
Danny, My 2 cents (American dollars): From a security standpoint (if you are a financial institution) you'd would never get away with #2 because there is no audit trail with multiple users using a generic user id. The MySQL implementation of security is not implemented with auditing and standard role based assignments in mind. I am hopeful that they will correct this issue down the road. Regards, George Danny Stolle [EMAIL PROTECTED] wrote: hi, i would like to discuss 'user management' in mysql. Working with Oracle you can assign users to roles giving them privileges provided by that role. MySql doesn't have Roles. I have read (Managing and Using MySql, O'Reilly) 3 options on managing users having multiple roles in a MySql environment: 1. Giving the user a Single user ID and assign the privileges to that user ID 2. Create role-bases users and have different people share the same user ID for a given role. 3. Create multiple user IDs for each role played by each user (dannys_arch as an architect, dannys_dev as a developer). Which of these 3 options is the most preferable one or are there more options which you can use. What are the advantages and disadvantages on working with one of these 3 options? how do you handle hostnames when working with random ip-addresses on your site. Or just plain simple (or stupid) what are your experiences on user management in a MySql environment. Best regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Lower Case Problems with Win XP Pro and 5.0.6 Mysql
Hi, Anyone experience this problem. I did the following: C:\perlsrcmysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database userdb; Query OK, 1 row affected (0.00 sec) mysql use userdb; Query OK, 1 row affected (0.00 sec) mysql create table ABC (col1 varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql show tables; +-+ | Tables_in_sdidw | +-+ | abc | +-+ 4 rows in set (0.00 sec) mysql NOTE THE FACT THAT THE TABLE IS created in LOWER case! Any ideas as to why this is happening? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Repost: Lower Case Problems with Win XP Pro and 5.0.6 MySQL
Hi, Anyone experience this problem. I did the following: C:\perlsrcmysql -f --user=root --password= --port=3307 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create database userdb; Query OK, 1 row affected (0.00 sec) mysql use userdb; Query OK, 1 row affected (0.00 sec) mysql create table ABC (col1 varchar(10)); Query OK, 0 rows affected (0.03 sec) mysql show tables; +--+ | Tables_in_userdb | +--+ | abc | +--+ 1 row in set (0.00 sec) mysql NOTE THE FACT THAT THE TABLE IS created in LOWER case! Any ideas as to why this is happening? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MERGE Table Question
Hello everyone, We're going to be using the MERGE TABLE option of Mysql when we build our Data Warehouse. Basically (for you Oracle folks), we're going to mimic PARTITIONS. My question is this: Other than dumping syntax through a utility and comparing text, is there any way I can read the structure directly through the *.FRM or *.MYD files to make certain that ALL tables match exactly so the MERGE will work? Regards, George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: DBD::Oracle issue
Wrong forum for MySQL but you're getting the error because unless you created a view/table for all_tables then it doesn't exist. I suspect you're trying to use the view USER_TABLES or DBA_TABLES (if you have the GRANT to view that DBA view. [EMAIL PROTECTED] wrote: ALL, Can someone help out with this error: DBD::Oracle::st execute failed: ORA-03106: fatal two-task communication protocol error (DBD ERROR: error possibly near * indicator at char 23 in 'select table_name from *all_tables') [for Statement select table_name from all_tables] at ./oracleTest.pl line 66. I have tried to set TWO_TASK environment variable to no avail. The oracle connection is a remote connection made. I have successfully looked up other information in the database with this script. The actual SQL command being run is select table_name from all_tables. If anyone needs the actual script that is being run please mail me. But I believe this error is specific to the select statement being run because other selects work just fine. ANY ideas / suggestions would be greatly appreciated, Chris Hood __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL give up on a query after a certain length of time
There is a variable called --network-timeout ! You can set it to 300 (5 minutes, etc.). Tony Yau [EMAIL PROTECTED] wrote: Hi Guys, you can always set a max time out for your php script (php.ini) Tony - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, May 20, 2005 12:45 PM Subject: Re: MySQL give up on a query after a certain length of time Hello. I don't remember such way (except your transaction could abort due to lock timeout). Check with SHOW PROCESSLIST in what state your query hangs. Jacob Friis Larsen [EMAIL PROTECTED] wrote: Hello. Is there a way to have MySQL give up on a query after a certain length of t= ime? I use Debian Linux Sarge, MySQL 4.1 and Php 5. Sometimes I have queries that take forever although the same query returns fast at other times. Thanks, Jacob -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Solution to slow queries
I'm somewhat a newbee on this database but some observations: As your table grows (and indexes) INSERTS will definitly slow because of the indexes. Consider MySQL's version of Oracle's partitioning and using MERGE TABLES feature. Just remember that if you change 1 table, all of them have to be rebuilt the same way. Consider compressing the tables (Making them READ ONLY) with the MyISAM engine. The updating table (current one) would not be available since it could not be compressed. Paul Halliday [EMAIL PROTECTED] wrote: Hello, I am working on a database that deals with network statistics. I have a program that generates web reports based on this data every ten minutes. The table layout looks something like this: CREATE TABLE traffic ( unix_secs INT UNSIGNED NOT NULL, dpkts INT UNSIGNED NOT NULL DEFAULT 0, doctets INT UNSIGNED NOT NULL DEFAULT 0, first INT UNSIGNED, last INT UNSIGNED, srcaddr VARCHAR(15), dstaddr VARCHAR(15), srcport SMALLINT UNSIGNED, dstport SMALLINT UNSIGNED, prot TINYINT UNSIGNED NOT NULL DEFAULT 0, tos TINYINT UNSIGNED NOT NULL DEFAULT 0, tcp_flags TINYINT UNSIGNED NOT NULL DEFAULT 0, INDEX unix_secs (unix_secs), INDEX srcaddr (srcaddr), INDEX dstaddr (dstaddr), INDEX srcport (srcport), INDEX dstport (dstport) ); Now, as time progresses the queires are getting slower and slower. I know this is expected, so I am curious as to how I can have a main table that has all traffic, so that I can do monthly/yearly reports, and also have a daily table so that I can quickly do reports every minute or so on that data. I have read up a bit on merge tables (this is probably the answer) but I am unsure as to how you trigger the changes. ie, how do you do the rollover after every 24hours? Any thoughts, or a pointer in the right direction would be greatly appreciated. Thanks. -- _ Paul Halliday http://dp.penix.org Diplomacy is the art of saying Nice doggie! till you can find a rock. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk and myisampack
Hello everyone, When running these utilities does the MySQL daemon have to be down? There's no activity against the database other than an occasional query. George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyISAM error 127
Hi, Thanks for the reply. Are u suggesting that I shutdown MySQL? I thought that a FLUSH table command would take care of things. Stupid me! gerald_clark [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading. That all worked as advertized when single threaded. Once all the data was loaded one of the tables had several indexes created. Again, no problem. Then we tried running myisampack against one of the tables. It worked against the table, however other tables somehow got corrupted. Running a query against the table produced the following error: MyISAM Engine returned error 127 Ok, so we ran myisamchk --quick --recover It ran successfully (or so we thought). Query the table for rows and the number comes back. Query the data get same error message. Next, we ran myisamchk --force --extended-check It ran successfully (or so we thought). Query the table for rows and the number comes back. Query the data get same error message. Then decide to truncate the table. Same error. Dropped the table. Same error. Recycled MySQL then dropped the table. It worked. Any ideas as to what may be going on here. George You did not state that you stopped the server before running myisamchk. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyISAM error 127
Hi, We're in the process of benchmarking/evaluating MySQL(4.1.9) on Linux for our data warehouse. I have a group of tables (9/2004 through 2/2005) that average about 95 million rows (215 byte rows). Using PERL and piping to mysql LOAD DATA is the way we've been loading. That all worked as advertized when single threaded. Once all the data was loaded one of the tables had several indexes created. Again, no problem. Then we tried running myisampack against one of the tables. It worked against the table, however other tables somehow got corrupted. Running a query against the table produced the following error: MyISAM Engine returned error 127 Ok, so we ran myisamchk --quick --recover It ran successfully (or so we thought). Query the table for rows and the number comes back. Query the data get same error message. Next, we ran myisamchk --force --extended-check It ran successfully (or so we thought). Query the table for rows and the number comes back. Query the data get same error message. Then decide to truncate the table. Same error. Dropped the table. Same error. Recycled MySQL then dropped the table. It worked. Any ideas as to what may be going on here. George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Message repeating every second in Error Log
Does anyone know why this message keeps repeating: 050425 11:31:40 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:41 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:42 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:43 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS 050425 11:31:44 229 Query SHOW STATUS 229 Query SHOW INNODB STATUS __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Changing the Prompt for timing purposes
Hi, The MYSQL command line interface is very basic. Can it be modified like the shell command prompts so that I can include date/time for timing benchmarks? Secondly, is there an echo command in MYSQL command prompt so that I can see the command I issued or a log file that I can write to.sorry about the basic questions but I'm a newbe. George __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re:ERROR 2013: Lost connection to MySQL server during query
Hi, I'm having a similar problem using the LOAD DATA. I get an intermittent error: ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query The command is: LOAD DATA local infile 'pipefile' into table FACT_TABLE fields terminated by '~' lines terminated by '\n'; I cannot seem to replicate it all the time. I have a PERL program that writes to the PIPE and MySQL reads the pipe. Did you have any success in figuring out the problem? Regards, George sol beach [EMAIL PROTECTED] wrote: I've tried looking up this error code on www.mysql.org via Google. I'm not sure it matters but if you look closely at the SQL below, you can see it is working on file page_path.tab4. It has already successfully loaded files page_path.tab1 thru page_path.tab3 I seriously could use a CLUE on what needs to be changed to avoid this error. TIA! Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 183 to server version: 3.23.58-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql LOAD DATA CONCURRENT LOCAL INFILE '../data/mysql/initial_20050318_102517/page_path.tab4' - REPLACE INTO TABLE page_path - FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' - (PAGE_PATH_ID,NAME,DATE_CREATED); ERROR 2013: Lost connection to MySQL server during query mysql [EMAIL PROTECTED]:/b/martgen/mysql/bingrep -i large show-variables.log large_files_support ON [EMAIL PROTECTED]:/b/martgen/mysql/binuname -a Linux sdb2.hitbox.com 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003 i686 i686 i386 GNU/Linux [EMAIL PROTECTED]:/b/martgen/mysql/bin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
