InnoDB: Error: tablespace
Hi list, I have the following error in a MySQL server: 050617 09:16:35 mysqld started InnoDB: Error: tablespace size stored in header is 8660992 pages, but InnoDB: the sum of data file sizes is only 6432768 pages 050617 9:16:40 InnoDB: Started /usr/sbin/mysqld-max: ready for connections And here is the background: This server is setting up as a slave server, We configured it via master's full backup, so we copied all the directories of the data bases, ibdata files and its config file almost is equals to the master config file the only differences are the ibdata_path. When the server starts, displays the previous message. I checked the size of the master's ibdata files versus the slave's and both files are the same size. I did a count(*) from all the tables, check table of all the tables and it seems that all the tables are fine. Any suggestions to correct the slave message error. Thanks in advanced and greetings -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
recovering a 17G dump
Hi list, I have a 17G dump from my DB, any suggestions to recover that dump faster, any variables to tune up?... I don't have an accurate binary backup, so I have to restore it from my 17G text file. I remove the indexes, foreign keys, I will create them after I've recovered all the data. I have an innodb storage, mysql ver. 3.23-58, 80G HD, 1G RAM on a white-box linux distribution. Thanks in advanced for your suggestions Greetings -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MYSQL to XML
Mathias Thanks for your help, I really appreciated it. And I was just wondering if MySQL has another statment (besides show create table) that only displays the foreign key, but I see that only with the show create table MyTable could get this. Greetings From: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Mon, 25 Apr 2005 17:41:47 +0200 MIME-Version: 1.0 X-Originating-IP: 213.41.126.253 Received: from lists.mysql.com ([213.136.52.31]) by mc5-f35.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Mon, 25 Apr 2005 08:44:24 -0700 Received: (qmail 21182 invoked by uid 109); 25 Apr 2005 15:41:56 - Received: (qmail 21160 invoked from network); 25 Apr 2005 15:41:55 - Received: pass (lists.mysql.com: local policy) X-Message-Info: JGTYoYF78jHafVH/hFUFqKtbfGVCQG07u9r/IzplGqc= Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:mysql@lists.mysql.com List-Archive: http://lists.mysql.com/mysql/183082 Delivered-To: mailing list mysql@lists.mysql.com References: [EMAIL PROTECTED] User-Agent: Internet Messaging Program (IMP) 3.2.5 X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 25 Apr 2005 15:44:24.0943 (UTC) FILETIME=[A82A1FF0:01C549AD] Hi Mikel, Show create table shows a line CONSTRAINT ... FORIEGN KEY ... you can add a grep on this line. But this will be difficult. You can construct another desc2xml using just show create table to have it easier. Mathias Selon Mikel - [EMAIL PROTECTED]: Thanx Mathias for your quick and effective response, I see that your program almost display the format that I need, the thing is that I need the foreign key information too, Does MySQL have a statement besides show create table to display this information?Thanks again for your suggestions and help Greetings From: mathias fatene [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Sun, 24 Apr 2005 21:39:14 +0200 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc3-f23.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Sun, 24 Apr 2005 12:42:26 -0700 Received: (qmail 15912 invoked by uid 109); 24 Apr 2005 19:40:50 - Received: (qmail 15893 invoked from network); 24 Apr 2005 19:40:50 - Received: pass (lists.mysql.com: local policy) X-Message-Info: JGTYoYF78jEQFMtosA6GPW/w+/WF28t94KBGDmreITY= Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:mysql@lists.mysql.com List-Archive: http://lists.mysql.com/mysql/183030 Delivered-To: mailing list mysql@lists.mysql.com X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 24 Apr 2005 19:42:26.0285 (UTC) FILETIME=[BE1839D0:01C54905] Hi Mikel, There are a lot of possibilities including commercial (:o)) products. I suggest you those solutions. The output should be reparsed for your needs : 1. the -X on client : C:\Mysqlmysql -u mathias world -X -e desc country ?xml version=1.0? resultset statement=desc country row FieldCode/Field Typechar(3)/Type Null/Null KeyPRI/Key Default/Default Extra/Extra /row row FieldName/Field Typechar(52)/Type Null/Null Key/Key Default/Default Extra/Extra /row row FieldContinent/Field ... ... 2. install perl DBI and DBIx-XML_RDB modules : #!perl -w # --- # Describe2xml # Author : Mathias FATENE # Date : 24 april 2005 # --- use DBIx::XML_RDB; my $userid='root'; my $password='**'; my $dbname='world'; my $dsn = DBI:mysql:database=$dbname;host=localhost; my $xmlout = DBIx::XML_RDB-new($dsn,'mysql',$userid, $password) || die Failed to make new xmlout; $xmlout-DoSql(describe country); print $xmlout-GetData; C:\Mysqlperl describe.pl ?xml version=1.0? DBI driver=DBI:mysql:database=world;host=localhost RESULTSET statement=describe country ROW FieldCode/Field Typechar(3)/Type Null/Null KeyPRI/Key Default/Default Extra/Extra /ROW ROW FieldName/Field Typechar(52
RE: MYSQL to XML
Thanx Mathias for your quick and effective response, I see that your program almost display the format that I need, the thing is that I need the foreign key information too, Does MySQL have a statement besides show create table to display this information?Thanks again for your suggestions and help Greetings From: mathias fatene [EMAIL PROTECTED] To: mysql@lists.mysql.com CC: mysql@lists.mysql.com Subject: RE: MYSQL to XML Date: Sun, 24 Apr 2005 21:39:14 +0200 MIME-Version: 1.0 Received: from lists.mysql.com ([213.136.52.31]) by mc3-f23.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Sun, 24 Apr 2005 12:42:26 -0700 Received: (qmail 15912 invoked by uid 109); 24 Apr 2005 19:40:50 - Received: (qmail 15893 invoked from network); 24 Apr 2005 19:40:50 - Received: pass (lists.mysql.com: local policy) X-Message-Info: JGTYoYF78jEQFMtosA6GPW/w+/WF28t94KBGDmreITY= Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:mysql@lists.mysql.com List-Archive: http://lists.mysql.com/mysql/183030 Delivered-To: mailing list mysql@lists.mysql.com X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Checked: Checked Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 24 Apr 2005 19:42:26.0285 (UTC) FILETIME=[BE1839D0:01C54905] Hi Mikel, There are a lot of possibilities including commercial (:o)) products. I suggest you those solutions. The output should be reparsed for your needs : 1. the -X on client : C:\Mysqlmysql -u mathias world -X -e desc country ?xml version=1.0? resultset statement=desc country row FieldCode/Field Typechar(3)/Type Null/Null KeyPRI/Key Default/Default Extra/Extra /row row FieldName/Field Typechar(52)/Type Null/Null Key/Key Default/Default Extra/Extra /row row FieldContinent/Field ... ... 2. install perl DBI and DBIx-XML_RDB modules : #!perl -w # --- # Describe2xml # Author : Mathias FATENE # Date : 24 april 2005 # --- use DBIx::XML_RDB; my $userid='root'; my $password='**'; my $dbname='world'; my $dsn = DBI:mysql:database=$dbname;host=localhost; my $xmlout = DBIx::XML_RDB-new($dsn,'mysql',$userid, $password) || die Failed to make new xmlout; $xmlout-DoSql(describe country); print $xmlout-GetData; C:\Mysqlperl describe.pl ?xml version=1.0? DBI driver=DBI:mysql:database=world;host=localhost RESULTSET statement=describe country ROW FieldCode/Field Typechar(3)/Type Null/Null KeyPRI/Key Default/Default Extra/Extra /ROW ROW FieldName/Field Typechar(52)/Type Null/Null Key/Key Default/Default Extra/Extra /ROW ROW ... ... 3. install Perl DBI and DBD-Mysql and use my program (formatted for your needs) : #!perl -w # --- # Describe2xml # Author : Mathias FATENE # Date : April, 24 2005 # --- use DBI; my $userid='root'; my $password=''; my $dbname='world'; my $dsn = DBI:mysql:database=$dbname;host=localhost; my $dbh = DBI-connect($dsn,$userid, $password,{'RaiseError' = 1}); # --- # describe country table and print it in XML format # --- my $table=country; $sth = $dbh-prepare(describe $table); $sth-execute(); print \table name=\$table\\\n; while (my @ref = $sth-fetchrow_array()) { print \column name=\$ref[0]\ required=\true\ type=\$ref[1]\; print primaryKey=\true\ if ($ref[3] eq PRI) ; print /\\n; } $sth-finish(); print \/table\\n; # Disconnect from the database. $dbh-disconnect(); C:\Mysqlperl desc.pl country table name=country column name=Code required=true type=char(3) primaryKey=true/ column name=Name required=true type=char(52)/ column name=Continent required=true type=enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America')/ column name=Region required=true type=char(26)/ column name=SurfaceArea required=true type=float(10,2)/ column name=IndepYear required=true type=smallint(6)/ column name=Population required=true type=int(11)/ column name=LifeExpectancy
MySQL to XML
Hi list, does it possible for MySQL to generate XML in the followin format: table name=ServiceType column name=idTipoServicio primaryKey=true required=true type=VARCHAR size=10/ column name=nombre required=true type=VARCHAR size=255/ column name=costo required=true type=FLOAT size=9/ column name=idGrupo required=true type=INTEGER/ column name=activa required=true type=BOOLEANINT/ foreign-key foreignTable=Grupo onUpdate=none onDelete=none reference foreign=idGrupo local=idGrupo/ /foreign-key /table This XML is the structure of the ServiceType table, I'll hope that you can help me Thnx in advanced Greetings P.S. Any suggestions (tools) will be appreciated -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Master-Slave bin-logs problem
Hi list, I have 2 MySQL servers ver. 3.23.58, one is the master and the other one the slave, the slave was working until I modified the following lines in the master my.cnf file: log-bin = /mnt/binlogs/masterBinLogs/sauron-bin the directory and files have the following attributes: drwxr-xr-x2 mysqlmysql masterBinLogs -rw-rw1 mysqlmysql sauron-bin.387 Now when I restart the slave I have the following error: Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'sauron-bin.387' at position 712121279 Error reading packet from server: Could not find first log (server_errno=65535) Did I miss something in the my.cnf file of each server?, When I give the SHOW MASTER LOGS command displayed this info: +-+ | Log_name | +-+ | sauron-bin.387 | | sauron-bin.388 | | sauron-bin.389 | +-+ Thanks in advanced for your help, an I hope you can help me guys. Mikel _ Platica con tus amigos en linea con T1msn Messenger http://messenger.t1msn.com.mx/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Handling threads
Yes I can ping my server, the server still alive, I have a monitor that displays all the active connections, the hostname.err file doesn't log new lines, do I have to check out something else?... Thanks in advance Mikel From: Victor Pendleton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Handling threads Date: Thu, 1 Apr 2004 15:23:29 -0600 When this happens are you able to ping the MySQL server? The literal error message is Resource temporarily unavailable Have you looked in the hostname.err file to see if anything else is being logged? On Thu, 01 Apr 2004, Mikel - wrote: Hi list, I'm having the following problem when I tried to connect to MySQL server through terminal mysql client it displayed Can't create thread errno (11) , I worked around the variables thread_stack and thread_cache_size, its initial value was 64KB for thread_stack and 20 for thread_cache_size; I read on different mysql lists and the official documentation about this variables and I guessed that incrementing the values of these variables could solve my problem, so I incremented the thread_stak to 128KB and the thread_cache_size to 50, after restarting MySQL worked pretty fine but it lasted 20 hours to displayed me the same error Can't create thread errno (11) the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. Thanks in advanced Greetings Mikel The system features are: - MySQL server 3.23.55 - Linux version 2.4.22 - Red Hat Linux 7.3 2.96-110 #3 SMP - 4GB RAM - 4 Xeon processors _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- 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] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Handling threads
Yes it is, it shows the threads_created, threads_cached, threads_active, Do I need to check out another variable, Greetings and thanx in advanced From: Victor Pendleton [EMAIL PROTECTED] To: 'Mikel - ' [EMAIL PROTECTED],Victor Pendleton [EMAIL PROTECTED],'[EMAIL PROTECTED] ' [EMAIL PROTECTED] Subject: RE: Handling threads Date: Fri, 2 Apr 2004 10:36:22 -0600 You say you have a monitor that is logging active connections. Is this monitor reporting that all available connections are used? -Original Message- From: Mikel - To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: 4/2/04 10:29 AM Subject: Re: Handling threads Yes I can ping my server, the server still alive, I have a monitor that displays all the active connections, the hostname.err file doesn't log new lines, do I have to check out something else?... Thanks in advance Mikel From: Victor Pendleton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Handling threads Date: Thu, 1 Apr 2004 15:23:29 -0600 When this happens are you able to ping the MySQL server? The literal error message is Resource temporarily unavailable Have you looked in the hostname.err file to see if anything else is being logged? On Thu, 01 Apr 2004, Mikel - wrote: Hi list, I'm having the following problem when I tried to connect to MySQL server through terminal mysql client it displayed Can't create thread errno (11) , I worked around the variables thread_stack and thread_cache_size, its initial value was 64KB for thread_stack and 20 for thread_cache_size; I read on different mysql lists and the official documentation about this variables and I guessed that incrementing the values of these variables could solve my problem, so I incremented the thread_stak to 128KB and the thread_cache_size to 50, after restarting MySQL worked pretty fine but it lasted 20 hours to displayed me the same error Can't create thread errno (11) the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. Thanks in advanced Greetings Mikel The system features are: - MySQL server 3.23.55 - Linux version 2.4.22 - Red Hat Linux 7.3 2.96-110 #3 SMP - 4GB RAM - 4 Xeon processors _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- 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] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Handling threads
Hi list, I'm having the following problem when I tried to connect to MySQL server through terminal mysql client it displayed Can't create thread errno (11) , I worked around the variables thread_stack and thread_cache_size, its initial value was 64KB for thread_stack and 20 for thread_cache_size; I read on different mysql lists and the official documentation about this variables and I guessed that incrementing the values of these variables could solve my problem, so I incremented the thread_stak to 128KB and the thread_cache_size to 50, after restarting MySQL worked pretty fine but it lasted 20 hours to displayed me the same error Can't create thread errno (11) the question is, do I have to increment those values or I'll have to increment other variables, or if you know any urls that I could use I really appreciate. Thanks in advanced Greetings Mikel The system features are: - MySQL server 3.23.55 - Linux version 2.4.22 - Red Hat Linux 7.3 2.96-110 #3 SMP - 4GB RAM - 4 Xeon processors _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Too slow recovering mysqldump files
I'll set up those parameters in my.cnf and try again the recovery from the dump file. I'll hope these changes make faster the recovery. Thanks again Heikki, Mikel P.S. Do you recommend the innodb hot backup tool, does it do faster than the other options, or is a combination of both? From: Heikki Tuuri [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Wed, 21 Jan 2004 05:10:27 +0200 Mikel, it is apparently disk-bound. I recommend setting innodb_buffer_pool_size as high as 1.4 GB during such big import. Adjust innodb_log_file_size accordingly, and make key_buffer smaller during the big import. Help is coming: Marko Mäkelä is writing a compressed InnoDB table format, which can squeeze a typical table to 1 / 4 the size of a normal InnoDB table. I believe the compressed format will be available in October 2004. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Mikel - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:32 AM Subject: Re: Too slow recovering mysqldump files Here we are my options: set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M I follow the example that came here: http://www.mysql.com/doc/en/InnoDB_start.html; Greetings and best regards Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Mon, 19 Jan 2004 22:44:50 +0200 Mikel, have you set the size of the InnoDB log files as recommended in the manual? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Mikel - [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, January 19, 2004 7:25 PM Subject: Too slow recovering mysqldump files Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ dump file size: 2.5 GB ibdata: 11GB innodb tables key_buffer=850M innodb_buffer_pool_size=850M table_cache=1500 _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- 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] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Too slow recovering mysqldump files
Thanks for your fast response, I'll adjust the autocommit parametr, too, and I'll will let you know if this improves the restore of my data base. Greetings Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Wed, 21 Jan 2004 21:21:18 +0200 Mikel, - Original Message - From: Mikel - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 7:19 PM Subject: Re: Too slow recovering mysqldump files I'll set up those parameters in my.cnf and try again the recovery from the dump file. I'll hope these changes make faster the recovery. Dr. Ullrich suggested that you should set innodb_flush_log_at_trx_commit=0 during the big import, or wrap the big import inside a transaction. Otherwise, the speed may be restricted to 1 row / disk rotation = 100 rows/second. Thanks again Heikki, Mikel P.S. Do you recommend the innodb hot backup tool, does it do faster than the other options, or is a combination of both? InnoDB Hot Backup takes a BINARY backups of your database. If you need to restore from a backup taken with InnoDB Hot Backup, you do not need to import table dumps. Thus restoration is much faster than if you use table dumps as a backup (table dump = LOGICAL backup). Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ From: Heikki Tuuri [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Wed, 21 Jan 2004 05:10:27 +0200 Mikel, it is apparently disk-bound. I recommend setting innodb_buffer_pool_size as high as 1.4 GB during such big import. Adjust innodb_log_file_size accordingly, and make key_buffer smaller during the big import. Help is coming: Marko Mäkelä is writing a compressed InnoDB table format, which can squeeze a typical table to 1 / 4 the size of a normal InnoDB table. I believe the compressed format will be available in October 2004. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Mikel - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:32 AM Subject: Re: Too slow recovering mysqldump files Here we are my options: set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M I follow the example that came here: http://www.mysql.com/doc/en/InnoDB_start.html; Greetings and best regards Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Mon, 19 Jan 2004 22:44:50 +0200 Mikel, have you set the size of the InnoDB log files as recommended in the manual? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Mikel - [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, January 19, 2004 7:25 PM Subject: Too slow recovering mysqldump files Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ dump file size: 2.5 GB ibdata: 11GB innodb tables key_buffer=850M innodb_buffer_pool_size=850M table_cache=1500 _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- 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] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http
Re: Too slow recovering mysqldump files
Here we are my options: set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M I follow the example that came here: http://www.mysql.com/doc/en/InnoDB_start.html; Greetings and best regards Mikel From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Too slow recovering mysqldump files Date: Mon, 19 Jan 2004 22:44:50 +0200 Mikel, have you set the size of the InnoDB log files as recommended in the manual? Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Mikel - [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Monday, January 19, 2004 7:25 PM Subject: Too slow recovering mysqldump files Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ dump file size: 2.5 GB ibdata: 11GB innodb tables key_buffer=850M innodb_buffer_pool_size=850M table_cache=1500 _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- 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] _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Too slow recovering mysqldump files
Hi list, does anyone know a faster way to recover a mysqldump file cause When I recovered one dump file it took 26 hours ! to finish, I think it's too slow. Thnx in advanced, greetings MySQL server 3.23.58 RedHat 7.3 4GB RAM 2 scsi disk via fiber channel (333GB each) 2 processor Xeon 1.6GHZ dump file size: 2.5 GB ibdata: 11GB innodb tables key_buffer=850M innodb_buffer_pool_size=850M table_cache=1500 _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
threading limit
Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
threading support
Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: thread problem
I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. Is This information ok?, or I'm missing something. Greetings Mikel _ MSN Fotos: la forma más fácil de compartir e imprimir fotos. http://photos.msn.es/support/worldwide.aspx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thread problem
Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent Greetings Mikel _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: thread problem
I'm using linux, Red Hat 7.3 Linux version 2.4.22, and 3.23.55-Max-log. does This information is ok?, or I'm missing something. Greetings From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Mikel - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: thread problem Date: Fri, 3 Oct 2003 14:16:39 -0700 On Fri, Oct 03, 2003 at 02:37:27PM -0500, Mikel - wrote: Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent What OS are you using? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 19 days, processed 719,013,228 queries (418/sec. avg) _ MSN. Más Útil Cada Día http://www.msn.es/intmap/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thread problem
Hi list, I have the following problem and here is the message that displays the console when I try to connect Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent Greetings Mikel _ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.microsoft.com/es -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: TCP/IP Security for Remote Access of MySQL DBs...for newbie
Hi Rich, Just so I understand you correctly; 1. Are you trying to use the replication features of MySql for this communication? Or 2. Are you talking on the client side application, like PHP, Java, Perl...? How about encrypting the data itself and skipping the whole channel issue? cheers, Mikel Rich Fortnum wrote: Hi there. I have a need to reach into a remote database and write to their tables from my tables. Or have them reach into my tables and read from mine. Either way, data will travel over the net. I need that data secure and I don't know how I can make that secure. It's not a permissions thing, because that's straight forward...it's the communications I'm worried about. Can anybody comment on how remote security can be established between SQL databases? Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.com - 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 - 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: [PHP-DB] any good web hosting with php and mysql support? (OT)
Starting @ $20.00/month http://www.ocsny.com -- Original Message -- From: Gurhan Ozen [EMAIL PROTECTED] Date: Mon, 14 Jan 2002 13:17:59 -0500 Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a company for which someone can vouch. I did started hosting my web site at a webhoster that promised 99.99% uptime and my site is hardly ever up and running. They don't answer my emails either. IS there anyone who have web sites hosted at webhosting service for a reasonably long time without any problems? IF yes, can you please contact me and tell me about it? This might be kind of off-topic for both lists, and i apologize to both lists, so you might want to reply to my email rather than sending it to list(s). Thank you very much. Gurhan - 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: mysqldump - basic question
Rory, Take a look at the shell scripts for mysqlbackup here http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain things quite nicely. Cheers, m! ROry O'Connor wrote: this is an absolute newbie question - but when i try to run mysqldump with a cron (like with a shell script) i can't because mysqldump utility stops to ask for a password. how can I either embed the password or set up mysqldump to not ask for one if, for instance, root is running the shell script? thanks, rory - 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 - 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: Need help with SELECT and JOIN pls
I'm no expert in this in fact I just recently started playing with joins, but here's one that I actually used for a recent shopprt cart piece. I appologise if it wraps but the output is long...content conatins the basic content info but product contains the list of prices. Yes I could have just as easily put the price in the content tbl, but I wanted the admin to pull the predefined prices from one source and make a selectable option rather than a type in value. I also figured from a maintenance standpoint when the price goes up it's one change etc... Ok so in any even I joined the two tbls on c.product_id and p.id. If I read you question correctly you should be able to perform smething similar on eventlog.id and crossref.id... mysql select c.*, p.cost from content as c, product as p where c.product_id = p.id ; ++-+-+---+--++-+--+ | id | filename| thumbnail | sdescr| ldescr | product_id | publish | cost | ++-+-+---+--++-+--+ | 3 | sample.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 1 | y | 5.95 | | 1 | sample2.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | | 2 | sample.mov | OCSLogo.png | Silly Apple Comercial | came with the streaming server. | 2 | y | 2.95 | ++-+-+---+--++-+--+ 3 rows in set (0.00 sec) I hope this helps... cheers, Mikel Jaime Teng wrote: Hi, I have two tables: mysql describe eventlog; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(10) unsigned | | PRI | NULL| auto_increment | | timestamp | int(10) unsigned | | MUL | 0 || | description | char(100)| | MUL | || +-+--+--+-+-++ mysql describe crossref; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | word| char(20) | | MUL | || | id | int(10) unsigned | | MUL | || +-+--+--+-+-++ Table 'eventlog' is a table of sentence and a unique 'id'. Table crossref is simply a table of single words and an index 'id'. an entry contains a word and an id where said word can be found on the table 'eventlog'. It is common that a: SELECT * from crossref where word = 'HELLO'; would have multiple results. My question here is I would like to do a search wherein I would like to know which sentence contains the words 'HELLO' and 'DAY' and 'WORLD'. take note that the sentence SHOULD contain ALL the three words not just one or two. I think this is a 'JOIN' question but I am not familiar how to use JOIN. can you show me the syntax? thanks for your help. Jaime - 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 - 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: ALTER TABLE error
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: Can anyone tell me why I am receiving the following error? I am connecting to a remote server via ssh, and accessed the mysql prompt by typing: mysql The following is the screen contents after trying to use the ALTER TABLE command; 'dbname' has been sub'd for actual database name. screen contents start Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1451062 to server version: 3.23.43 Type 'help' for help. mysql connect dbname Connection id:1451083 Current database: dbname mysql ALTER TABLE Advertisers PACK_KEYS=0; ERROR 2000: Access denied for user: '@localhost' to database 'dbname' screen contents end Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - 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 - 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: Image's
tryt constructing a URL like file:///images/110101/yourpic.jpg out of the location... [EMAIL PROTECTED] wrote: Either the coffee is flat or someone switched to decafe on me. What is the proper way to retrive an image that is stored as a path in a field name with SQL? My path would be something like Table=YPEOPLE field=pictures with the path like this c:\images\110101\yourpic.jpeg Also is there a way to do this. I have an aging DOS FoxPro database (see above) that is still in constant use. I imported the tables into MySQL, 200+ Tables and some 200,000 rows, and I would like to update just the New info. Reason. They flat will not give up the monster in accounting. Period. So to make Win users happy I have a small GUI for searchs and stuff,,all read only. Off in seach of a Starbucks. M;) - 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 - 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: conceptual question.
Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - 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 - 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: question
Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... Wells, Kenneth L wrote: How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal Error, Quitting.. Snort: no process killed - 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 - 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: How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box
well for starters you should look into updating your grants table, to allowe the remote server to access the db. Don't forget to properly set the userid, password, and perms for this...Highly encourage to grant this id read only access...but that's your call. Then on the prospective webserver make sure the mysql client is installed and try logging into the db from the clilike this: myslq -h some.host.com -u whoami -pMYPASSWD DBNAME if you get in then you've follow the instructions in the mysql handbook properlyRemember to use mysqladmin to reload the new grants before you try the remote connection...or you'll be left with some rather frustrating troubleshooting and quite probably the jitters from that extra few doses of coffee... cheers, m! [EMAIL PROTECTED] wrote: Can someone pls advise me on how to make a website running in an apache webserver on a Linux box connect to a remote mySQL database on a separate Sun box? Thank you. - (on foxtrot) Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the WPP Group shall be understood as neither given nor endorsed by it. - - 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 - 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: FreeBSD server help
Kyle, Need a bit more info, what version of mysql? Have you granted the other host(s) permission to use mysql? are you using mysqladmin to stop and start the daemon? cheers, m! Kyle B wrote: Hi all, I am going to try and describe my problem as best as possible. here it goes. Am running FreeBSD v3.0 I can connect to mysql when i telnet to localhost I cannot connect to mysql from another loacation When i try and shut down mysqld it tells me: Segmentation fault (core dumped) It is running on port 2201. I cannot telnet to that port mysql.sock is there whenever i try to run anything to do with mysqld it gives me the error: Segmentation fault (core dumped) Any ideas how to get mysql up and running correctly? Thanks a lot for your time. Kyle B. - 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 - 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: Unix Shell Auth from MySQL
checkout pam_mysql under the ports collection in fBSD...;) cheers, Mikel Chris Aitken wrote: Hi, Something ive been thinking about for a while but havent been able to come up with a definitive answer is this... Is there a system out there which can take over from the normal (unix based... FreeBSD/Linux type) telnetd method of authenticating a login off /etc/master.passwd and instead using a MySQL database for auth. It sounds like a bit of a pipe dream but I figured i'd ask here because I havent been able to find anything on this. Thanks Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ # ln -s /dev/null /bin/laden If you don't like my typing, all flames to /bin/laden - 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 - 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: Expect Script accessing MySQL
I'm not up on expect, but I would assume that since you can use sh then you should ber able to use expect. Generally speaking in sh you can do the following: #!/bin/sh MYSQLCMD=/usr/local/bin./mysql USER=me' HOST=some.host.com PASSWD=whatever QUERY=SELECT userId FROM thisTable WHERE id=1 RESULT='${MYSQLCMD} -h ${HOST}-u ${USERID} -p${PASSWD} -e ${QUERY} -s thisDB' echo ${RESULT} Let me know if you can get expect to work in sh's place... Cheers, m! Chris Aitken wrote: At 11:36 PM 23/09/2001, Neil Zanella wrote: It is possible and not very hard at all. But why would you need expect? Why not just use a shell script? Because the task I need the script to do is best done using Expect (its interfacing with a serial port doing things with some data pulled out of a database). A psuedo flow of what it does is - * Fire off the expect script * The expect script grabs fields of data from mysql * The expect script uses that data and interfaces with a device hanging off a serial port. * The script ends with the result based on whether the interaction with the serial device succeeds or not. Thats why Im wanting to use expect... and thats why I am trying to find a way to get mysql data into an expect script. Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching it. - 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 - 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: ACT2 Conversion
Hi guys, Are we talking about Symantec's ACT product? Cheers, Mikel Rolf Hopkins wrote: I've never heard of ACT2 but if you can export the data to a delimited text file, you could import it into mysql. You may have to edit the file a bit though. - Original Message - From: James McLaughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 01, 2001 4:03 Subject: ACT2 Conversion Has anyone had any luck or seen any HOWTO docs for converting a ACT2 DB to MySQL? We are moving away from prop windows software and into web based DB administration. Any help would be terrific. THanks Kat - 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 - 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 - 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: Migration Oracle = MySQL
I'm not sure how this happend but Mikel didn't write that. Could some one kindly forward me the original for the snippet below, including the headers...? Thanks, Mikel Ray Cote wrote: At 4:44 PM -0400 4/26/01, Mikel wrote: I'm trying to create a perl script that just produces a MySQL compliant SQL file based on the tables from Oracle, but I can't get everything work, like indexes etc.. Do you mean you cannot figure out how to find the index definitions from Oracle? If so, head on over to CPAN and check out a package with the name something like Oracle-DDL. This little package will export whatever pieces of your schema you need: tables, indexes, views, etc. Ray -- --- Raymond Cote, President Appropriate Solutions, Inc. www.AppropriateSolutions.com [EMAIL PROTECTED] 603.924.6079(v) POB 458, Peterborough, NH 03458603.924.8668(f) - 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: Migration Oracle = MySQL
just curious but can't you do a SQL dump of oracle...and if so (since I'm not up on it) whats' the correct syntax, especially from the command line... Cheers, Mikel Johan Andersson wrote: Anybody tried this? and hopefully got some good ideas of how to do it properly? I'm trying to create a perl script that just produces a MySQL compliant SQL file based on the tables from Oracle, but I can't get everything work, like indexes etc.. Someone? // Johan Andersson - 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 - 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 commands from Linux shell
yes absolutely...look into mysqlbackup (http://www.ocsny.com/main/index.ocs?url=osl ) for an example. Cheers, Miekl Fabio Galarraga wrote: Hi to all: I have a linux script and I need it can execute some mysql commands. Is it possible? If possible, how? Best regards, Fabio Galarraga [EMAIL PROTECTED] - 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 - 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: Run time version of MySQL
My sugesstion is that you get yourself a decent old workstation, one that you would probably consider ready for retirement if it were to still be running MS something...Like say a p200ish machine with a couple of gig on the disk and say 32 but prefereably 64M of ram. Slap a cheap NIC, like the SMC1211tx, in it and get that thing up on the net. Now get fBSD loaded on it and install MySql from the ports. If you don't have a good inet connection then shell out the $30 dollars for the fBSD CD set, then you can have everything up and running in less than 3 hours, seriously. Now you are ready to give it a test drive and providing you've used old gear, I'd estimate you've spent a grand total of $50. You can now give pretty much all of the free DB's a try and decide for yourself. of course if you've a good inet connection you can download everything for free and you've spent a whaping $0. Cheers, Mikel johnd wrote: Hi, We are planning to move on to MySQL. Could you send us your opinions about MtSQL. It will greatly help us to make decision and to use MySQL. Thanks. Regards, John Ding - 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 performances?
Well what exactly do you consider big? Mohamed Sadok MOUHA wrote: Hi, does any one used MySQL in real environment with big databases and a big number of connections? If yes, what's the hardware config? Thanks -- - 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 - 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: Once again... quotas...
At the company I work for we decided to try and implement reverse quotas. rather than limit said user to x we keep track of their usage and compare it to x. If they should happen to exceed that values then they are billed for the overage. It's very muhc like how UU bills us on our bandwidth for the burstable circuits. Cheers, Mikel Tristan 'Minty' Colgate wrote: Hi There, I have recently been asked to implement per database quotas for mysql for a large scale shared webhosting environmnet, from the lists it seems pretty obvious that mysql cant achieve this at the moment (without using filesystem quotas), file system quotaing is pretty awkward with our environment. Ive been asked to investigate the possibility of implementing this and my boss has agreed that we can release the code back to the community if we decide to do it. I found one posting that mentioned that someone at MySQL had some ideas on how you would like this implemented, if this is still the case could they post them to me, if it can fit in our timeframe Id be more than happy to do it. It really would be a nice feature. -- Tristan 'Minty' Colgate [EMAIL PROTECTED] | ICQ #645908 --- "You can get all you daily vitamins from 43 pints of guinness and a glass of milk" - 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 - 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: taxes
guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - 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 - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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 - 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: taxes
Most of my clients get around this problem by incorperating the web side of the business under a different name. There have typically been two reasons for this; 1. it circumvents the tax issue. 2. if the web business encounters legal troubles et cettera...they can go belly up w/o affecting the core storefront locations...Anyway that's how they do it...not how everyone else does...this make good sense if your host is located in one state...;) ok I think we've veer far enough off course... cheers, mikel Mike Wexler wrote: Mikel King wrote: guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. Actually it gets complicated for two reasons. On the web site I run http://www.tias.com/ we have vendors in all 50 states. Second, if you have a business presence in the state the customer is located in, then you need to calculate the tax for *their* locality. So in the normal case where you are calculating the taxes for just 1 vendors. Who has only one location, then things can be simplified by dealing with only the rules of the state (and the localities within the state). cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - 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 - 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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com - 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 Before posting, please check: http://www.mysql.com/manual.php
Re: taxes
Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.com - 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 - 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: Shell Shocking
Problem is that most ISPs can't afford a competent DBA...;( clay bond wrote: On Tue, 13 Feb 2001, Donald Korth wrote: The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . If your db is anywhere near critical, I would change to an ISP with a competent DBA, if I were you. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - 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: Shell Shocking
Absolutely this is nothing short of bad adminingIbet you could scag in their passwd file and has root access in short order...;( And of course the ISP will blame mysql if anything happens to them though...lazy bad ISP cheers, mikel Donald Korth wrote: Hello The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . Regards Donald - 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: Port 3306
fwcmd=/sbin/ipfw... on BSD usage like so ${FWCMD} add deny all from any to any via ${oif} Have to make a new kernel to support ipfw though cheers, mikel [EMAIL PROTECTED] wrote: What OS? If Linux or *BSD, they have firewall software (ipchains on linux, don't recall what it is on BSD) I'm new to MySQL, this may be a simple question; How do I turn off listen on port 3306?, I don't want to serve MySQL on the net, I only need it for local (server side) access. Can someone point to docs or notes dealing with this issue. - 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 - 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: GUI for Linux mySQL
Marko, Check out... http://www.freebsd.org/cgi/url.cgi?ports/databases/mysql-navigator/pkg-descr Also there are a few php as wellas python driven utils out there that make it entirely web based Cheers, Mikel Marko Sarunac wrote: Is there a GUI for mySQL that will run on either linux server it self or on a remote machine I found Mascon but that doesn't seem to be able to connect to the remote server Please reply to [EMAIL PROTECTED] Tahnk you - 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 - 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: Problem for localhost connection.....
did you edit /etc/resolv.conf? dyu wrote: Dear all, i m running mysql on freebsd webserver and using our own DNS server. Everything run fine with database and web serving. However, i m trying to change the DNS ip addresses to our isp's DNS server instead of ours on this webserver. Then i got the following error: st 'localhost.isp.net' is not allowed to connect to this MySQL server at /usr/local/stronghold/cgi-bin/xxx.cgi line 30 [Mon Jan 29 12:11:06 2001] [error] Died at /usr/local/stronghold/cgi-bin/xxx.cgi line xx. = Does anyone have any idea to solve this problem? i really appreciated. Thanks Derrick - 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 - 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: OT - Cron
Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - 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 - 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: Changing a Table name
Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - 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 - 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: Corrupted tables
I've had some db corruption on a few occasions, and luckily I was running the following in a nightly cron...it has since first install saved my butt on many an occasion. http://www.ocsny.com/main/index.ocs?url=mysqlbackup It doesn't do anything magickal just uses mysqldump and a basic routine to auto discover the databases in your db and print them into straight sql...I have another cron job that runns shortly after that tars the data to tape and then they can be erased from disk... cheers, mikel "Kissandrakis S. George" wrote: Hello I have mysql 3.23.31 on x86 linux Some big tables .ISM get corrupted without any crash or shutdown of mysqld Any suggestions? -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Tel/Fax: (+30 892) 24450/23206 Phaistos Networks S.A. - A DOL Digital Company - 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 - 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: Starting MySQL
Yes stop the old and start the new...on a side note...should have bought DuBios's book...ISBN: 0-7357-0921-1 Found it to be an invaluable source on this sort of stuff. In any event safe_mysqld seems to be default on most sytems...Yes please get you security straight...if the app is colocated on the same server you can get away with localhost, however; if not then you must make an entry for each domain... Cheers, Mikel Carlos Corzo wrote: Hello, I bought MySQL by O'reilly. This thing is just as tough to read as the manual but I am trying and utilizing both. When we installed MySQL on our server, it seems to already be running. I was able to create a database and everything so I assume that it is running. The book says to run mysql in safe mode because it would restart the mysql server automatically if it goes down. Does everyone out there use safe_mysqld when running their servers? Do I need to stop the current server and restart it as safe_mysqld? That is the part I am most confused by, what to do now that I had already started it regularly. If anyone can help, that would be great. Also, if you just create a table as root and do not do anything with security and permissions, would a perl program written on any domain name on that server be allowed to access the database, or do I need to give special permission to that domain name. I am curious if I just give a host, "www.test.com", full access. I just get confused between the host and the user. Is the user just the name being used to log in to host? If so, when someone just executes the perl script from a call from the browser, do I have to specify any specific permissions there. They will not be running the script as the user I specify. I have read about the wildcard "%" option but that seems a little unsafe. Any help would be appreciated. I did my research before asking! Thanks. Isn't there a sample program out there that is simple, and quick that you could create a database and test your interface to make sure that you can start hacking away at some MySQL queries? This book has some and they are huge with no CD. - 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 - 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: Please read the manual
In order to conserver bw I'll only through my $0.01 in...;) I do believe that if you search the list you will see that many of us who are not on the devteam do answer questions. Although I do whole heartedly believe in RTFM; I agree with you about the power of the people, and feel it is important for all of us to help by giving back to our community...;D Cheers, Mikel Neff Patrick K wrote: Maybe it is the lack of coffee this morning talking or maybe it is the fact that I have spent 4 days trying to get mysql up and running on linux(a platform I am unfamiliar with) but I assumes this mailing list would allow me to have contact with other users who have been thru the same issues I have had. Apparently I was wrong. You see I am a newbie too and what turned me on to mysql ,linux and the open source movement was the fact that it seems to focus on the power of people and there combined knowledge. I am not stupid and I can read in fact I have look over this manual about 100 times now the last four evenings. I apologize for wasting anyone's time but before I can become a valid contributor to a group dealing with a specific software I first have to be able to get the thing running. I in fact finally got mysql up and running last night but not one word in your manual helped me do it. So in fact all the reading in the world would have left me sitting in the same position. I am sorry to rant and rave but maybe if some seasoned user on this mailing list (not the developers) would help us newbies then we could all work together to. That is my two cents sorry to waste your time with it. -Original Message- From: Tnu Samuel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 4:58 PM To: [EMAIL PROTECTED] Subject: Please read the manual Maybe it is my depression and I see everything in black but please read manual before posting questions in this list. Manual covers at least 90% questions asked here. If manual does not cover them, we will put new chapters in it. This is all because what we do in this list can be called FREE support. As much I know, most of our developers are spending 2..4 hours per day just reading all related groups and answering questions "Error 2002: Can't connect via socket /tmp/mysql.sock". Also I wanted to ask everyone who gets revenue from MySQL still buy support contract. While MySQL is free to users there are people behind it who eat, buy books, pay for internet connection get hardware and buy icecream to kids. This is not about home users. There are companies on NASDAQ who use heavily different open source software for their success and have never paid a penny. For that money you get guaranteed answers. MySQL is free, support in this list is partially free but do not abuse it, then it can stay free in future. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ -- - Please check "http://www.mysql.com/documentation/manual.php" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to: [EMAIL PROTECTED] If you have a broken mail client that cannot send a message to the above address (Microsoft Outlook), you can use: http://lists.mysql.com/php/unsubscribe.php - 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 - 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