RE: backup InnoDB db to another server
Jeff: Mysqldump don't back up your index, that's your data only. Osvaldo Sommer -Mensaje original- De: Jeff Mckeon [mailto:[EMAIL PROTECTED] Enviado el: Viernes, 30 de Noviembre de 2007 03:24 p.m. Para: 'David Campbell'; mysql@lists.mysql.com Asunto: RE: backup InnoDB db to another server -Original Message- From: David Campbell [mailto:[EMAIL PROTECTED] Sent: Friday, November 30, 2007 11:29 AM To: mysql@lists.mysql.com Subject: Re: backup InnoDB db to another server Jørn Dahl-Stamnes wrote: On Friday 30 November 2007 17:12, Jeff Mckeon wrote: Ok, so what would be the command to get a mysqldump of DB1 from 10.10.0.1 into file DB1backup.sql on 10.10.0.2? What about running mysqldump on 10.10.0.2? or scp dump.sql [EMAIL PROTECTED]:. Onliner mysqldump DB1 -uroot -ppassword dump.sql | ssh 10.10.0.2 cat dump.sql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The Mysqldump has finished but I've only got a 10gig .sql file. The db is about 65gig in raw size. Does this sound right? Is there a filesize limit for mysqldump .sql files? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.10/1160 - Release Date: 29/11/2007 08:32 p.m. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem INNODB error 995
Heikki: All servers have the auto upgrade on, so all the windows upgrade has been install. We have a raid 5 on all servers. Could that give a random error? We can try a give a low format to the disks. Osvaldo Sommer -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sent: Lunes, 06 de Marzo de 2006 11:50 p.m. To: mysql@lists.mysql.com Subject: Re: Problem INNODB error 995 Osvaldo, - Original Message - From: Osvaldo Sommer [EMAIL PROTECTED] Newsgroups: mailing.database.myodbc Sent: Tuesday, March 07, 2006 12:58 AM Subject: Problem INNODB error 995 --Boundary_(ID_PMYElD1sU13Il0ENO4J+aw) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit We have 4 windows 2003 server with mysql 4.0.12 install in each one. They have been working for about 1.5 years with no problem. Two weeks ago, in one server we lost the mysql service, and when we look the .err file it report a 995 error. We can star the service again and it works. In the two weeks the service has stop in the same server about 10 times, but none in the other server. We have the same applications working in each server. What can we do to stop the error? We even thought that we have a problem with windows, so we reinstall it, but the problem continue. Please help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/debug/base/ system_error_codes__500-999_.asp ERROR_OPERATION_ABORTED 995 The I/O operation has been aborted because of either a thread exit or an application request a few InnoDB users have reported this error number in the past 2 years. I have suspected that it is some bug in Windows or its device drivers, since InnoDB does not request aborts of I/O requests, nor do InnoDB's threads exit in the middle of an I/O operation. Did you upgrade the OS in that server before you started getting this error? Is the server identical to the other servers where mysqld works ok? The error might actually be a hardware problem. I have noticed that a hardware fault can produce strange error numbers in Linux. The same might hold for Windows. Osvaldo Sommer Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 06/03/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem INNODB error 995
We have 4 windows 2003 server with mysql 4.0.12 install in each one. They have been working for about 1.5 years with no problem. Two weeks ago, in one server we lost the mysql service, and when we look the .err file it report a 995 error. We can star the service again and it works. In the two weeks the service has stop in the same server about 10 times, but none in the other server. We have the same applications working in each server. What can we do to stop the error? We even thought that we have a problem with windows, so we reinstall it, but the problem continue. Please help Osvaldo Sommer
Upgrade from 4.0.12 to 4.0.25
Hi List I look up on the online manual for directions for this kind of upgrade but i found nothing. Is there something I have to do extra or the upgrade so smoth? Osvaldo Sommer -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.18/86 - Release Date: 8/31/2005
RE: Upgrade from 4.0.12 to 4.0.25
Thanks, but that link is for 4.1.x and not for 4.0.x Osvaldo Sommer -Original Message- From: Nuno Pereira [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 7:38 AM To: Osvaldo Sommer Cc: mysql@lists.mysql.com Subject: Re: Upgrade from 4.0.12 to 4.0.25 Osvaldo Sommer wrote: Hi List I look up on the online manual for directions for this kind of upgrade but i found nothing. Is there something I have to do extra or the upgrade so smoth? Osvaldo Sommer See http://lists.mysql.com/mysql/186726 -- Nuno Pereira -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.18/86 - Release Date: 8/31/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.18/86 - Release Date: 8/31/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem With Mysql Ms Access with Time
Hi: I have this data: ventas_encabezado_historico_sat Query VEH_EMPRESA VEH_TIENDA VEH_FECHA VEH_STATUS VEH_TOTAL VEH_HORA DLC T01 6/1/2003 V 30 8:31:05 AM DLC T01 6/1/2003 V 114.28 8:38:44 AM DLC T01 6/1/2003 V 63.2 8:41:13 AM DLC T01 6/1/2003 V 8.75 8:42:47 AM dlc T01 6/1/2003 V 12.35 8:50:59 AM dlc T01 6/1/2003 V 63.97 8:53:10 AM DLC T01 6/1/2003 V 10 8:54:24 AM DLC T01 6/1/2003 V 50.65 8:57:54 AM DLC T01 6/1/2003 V 36 9:01:04 AM Where veh_fecha is type date, veh_hora is type date and veh_total is double And I have this code where I try to get the # of registres and a sum in a specific date for a specific time interval (15 minutes) but the select do not work, it returns 0 o the result of the full day, what Im doing wrong? HORA_INICIO = TimeSerial(7, 0, 0) '7:00 am Do Cantidad_Ventas = 0 VALOR_VENTAS = 0 'voy a calcular los valores de atención strSQL = select Count(*) as Cantidad, Sum(veh_total) as Valor from _ ventas_encabezado_historico_sat where _ veh_empresa=' EMP ' and _ veh_tienda=' Tienda ' and _ veh_fecha= MakeUSDate(MAX_ESTADISTICA) and _ Veh_hora= MakeUSTime(HORA_INICIO) And _ veh_hora MakeUSTime(HORA_INICIO + TimeSerial(0, 15, 0)) Set RST = DB.OpenRecordset(strSQL) 'ya tengo calculado los valores, los tengo que guardar Cantidad_Ventas = RST!Cantidad If IsNull(RST!valor) = True Then VALOR_VENTAS = 0 Else VALOR_VENTAS = RST!valor End If RST.Close Set RST = DB.OpenRecordset(Select * from estad_atencion where 1=0) RST.AddNew RST!est_empresa = EMP RST!est_tienda = Tienda RST!est_fecha = MAX_ESTADISTICA RST!est_hora = HORA_INICIO RST!est_atencion = Cantidad_Ventas RST!est_valor = VALOR_VENTAS RST.Update RST.Close HORA_INICIO = HORA_INICIO + TimeSerial(0, 15, 0) Loop Until HORA_INICIO TimeSerial(22, 0, 0) Function MakeUSDate(X As Variant) As String If Not IsDate(X) Then Exit Function MakeUSDate = # Month(X) / Day(X) / Year(X) # End Function Function MakeUSTime(X As Variant) As String If Not IsDate(X) Then Exit Function MakeUSTime = # Hour(X) : Minute(X) : Second(X) # End Function -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.10 - Release Date: 4/14/2005
RE: How to import data from Dbase3?
If you have ms access you can import the db3 into access and then export thru odbc to MySql Osvaldo Sommer -Original Message- From: BG Mahesh [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 22, 2005 10:33 PM To: mysql@lists.mysql.com Subject: How to import data from Dbase3? hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ -- __ IndiaInfo Mail - the free e-mail service with a difference! www.indiainfo.com Check out our value-added Premium features, such as an extra 20MB for mail storage, POP3, e-mail forwarding, and ads-free mailboxes! Powered by Outblaze -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.0 - Release Date: 3/21/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Problem with a repeated select from MS Access
This is the code: Public Sub Graba_Recibido(texto As String) 277On Error GoTo Manejo_Error 278Dim db As Database 279Dim rec As DAO.Recordset 281texto = Mid(texto, 2, 2) Mid(texto, 7, Len(texto) - 7) 282texto = Mid(texto, 1, Len(texto) - 1) 284Set db = CurrentDb 285Set rec = db.OpenRecordset(select * from BALANZA_RECEPCION where 1=0, dbOpenDynaset, dbSeeChanges, dbOptimistic) ' abro la tabla 286rec.AddNew ' Agrego uno nuevo 287rec!rc_data = texto 288rec!rc_fecha = CDbl(Date) 289rec!rc_procesado = N 290rec.Update ' Actualizo información 291rec.Close ' cierro cursor 292Set db = Nothing 296Exit Sub 297 Manejo_Error: 298Set db = Nothing 299Procesa_Error DibalTimer - Funciones Locales - Graba_Recibido, True End Sub And this is the error report i got -*-*-*-*-*-*-*-*-*-*-*-* -* Fecha: 02/03/2005 Hora: 11:43:22 AM Error en DibalTimer - Funciones Locales - Graba_Recibido: Error #3151 (Línea: 285) (Source: DAO.Database) ODBC--connection to '{MySQL ODBC 3.51 Driver}dellserver' failed. Usuario Conectado: Administrator In MSDN the error 3151 is: ODBC - connection to name failed. (Error 3151) The ODBC connection to the specified ODBC database or table could not be made. If the ODBC database is accessed via a network connection, make sure the network is available, and then try the operation again. It's failing in the OpenRecordset, but all the tables are linked, and if we open the table, we can see the data. The problem not allways occours Osvaldo Sommer -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 8:26 PM To: Osvaldo Sommer; mysql@lists.mysql.com Subject: Re: Problem with a repeated select from MS Access Osvaldo Sommer wrote: Daniel: The program is an interfase for a weigth system in a Retail environment. The program query the weigth system for new data every 200 miliseconds, if new data is received it has to be stored in the database. The table has automatic correlative, the data in ascii, the date and time and a Timestamp. When we run the program it start well and the data gets processed and stored. But after a while we start getting error 3151 ODBC can't connect to mysql server. We have MySql 4.0.12 and odbc 3.51.6, all the tables are linked to the msaccess program. What else you need of info? Osvaldo Sommer How about some code examples? How are you inserting the data? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 3/8/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.0 - Release Date: 3/8/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with a repeated select from MS Access
I have a msaccess program reading the serial port every 200 mili sec. Each time it has to record the data from the port to a linked mysql table. I run the program and run fine but after a while ( not the same elapsed time) I start getting that the odbc fail to connect to the server error 3151. What I can do to fix the problem? Osvaldo Sommer -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005
RE: Problem with a repeated select from MS Access
Daniel: The program is an interfase for a weigth system in a Retail environment. The program query the weigth system for new data every 200 miliseconds, if new data is received it has to be stored in the database. The table has automatic correlative, the data in ascii, the date and time and a Timestamp. When we run the program it start well and the data gets processed and stored. But after a while we start getting error 3151 ODBC can't connect to mysql server. We have MySql 4.0.12 and odbc 3.51.6, all the tables are linked to the msaccess program. What else you need of info? Osvaldo Sommer -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 08, 2005 6:29 PM To: Osvaldo Sommer; mysql@lists.mysql.com Subject: Re: Problem with a repeated select from MS Access Osvaldo Sommer wrote: I have a msaccess program reading the serial port every 200 mili sec. Each time it has to record the data from the port to a linked mysql table. I run the program and run fine but after a while ( not the same elapsed time) I start getting that the odbc fail to connect to the server error 3151. What I can do to fix the problem? Osvaldo Sommer Provide more details. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.4 - Release Date: 3/7/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Where's my ODBC icon?
David: If you have windows XP go: Start/Control Panel in ther choose Administrative Tools and in there is Data Sources (ODBC) where you can define your dsn. Osvaldo Sommer -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Sunday, February 13, 2005 12:46 PM To: mysql@lists.mysql.com Subject: Where's my ODBC icon? I just installed MySQL's ODBC program, but I can't figure out how to launch it. I see no reference to ODBC when I go to Start Programs. The only thing resembling an executable icon I can find is in my Add/Remove programs directory. I did a Windows search and found many files named ODBC, most of them in Windows/Prefetch and Windows/system32, but none of them appear to be executable programs. I posted a message on MySQL's ODBC forum but haven't received any replies. Does anyone know of a way to locate ODBC's executable file and create a desktop icon? Thanks. __ Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. http://info.mail.yahoo.com/mail_250 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Transactions - working but unsure about steps
You have a problem, what if the first insert give a error, then you don't know. You have to check each statement for error and if no error if found in all the statements then issue a commit if not a rollback Osvaldo Sommer -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Saturday, October 16, 2004 7:19 AM To: [EMAIL PROTECTED] Subject: Transactions - working but unsure about steps My statements are all working but I'm not sure if things are set up correctly. I say this because at one point the first $query failed, yet the rest of inserts wre committed. Now I believe I need to set autocommit to 0 , yet the query failed due to a syntax error. Hence the rule about 0 records effected wouldn't be the case here. Here is what I have: //Create these functions - function begin() { mysql_query(BEGIN); } function commit() { mysql_query(COMMIT); } function rollback() { mysql_query(ROLLBACK); } connection statement with error checking... begin(); // transaction begins $query = INSERT INTO firsttable.//first query $result = mysql_query($query); // process first query $query = INSERT INTO secondtable...//second query $result = mysql_query($query); // process second query $query = INSERT INTO thirdtable//third query $result = mysql_query($query); // process third query then: if(!$result) { echo mysql_errno($link) . : . mysql_error($link). \n; rollback(); // transaction rolls back exit; } else { commit(); // transaction is committed echo your insertion was successful; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.778 / Virus Database: 525 - Release Date: 10/15/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.778 / Virus Database: 525 - Release Date: 10/15/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migrating Access Tables -- Empty Columns, Date and Time
Why don't you use the export utility in ms access to load the data into mysql. The export will create the table in the database. All you need is a dsn connection and the mysql odbc. Osvaldo Sommer -Original Message- From: Robert L Cochran [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 8:21 PM To: [EMAIL PROTECTED] Subject: Migrating Access Tables -- Empty Columns, Date and Time I'm migrating a Microsoft Access 2002 (Service Pack 3) table constructed by my wife to a corresponding table in MySQL 4.0.20. Some columns in most of the 3000+ rows are empty. Some of these are contiguous empty columns. I don't know if Access considers them NULL or not, but when you export an Access row containing empty columns to a comma separated values file, the empty column will be represented by a sequence of placeholder commas. Here is a part of the first table row exported by Access: WEEKEND,,8,1,,0,,,at,,,2/12/1998 0:00:00,11/27/1998 0:00:00,,MB Based on recent experience with loading a simpler Access table, these empty columns will be imported as is by both mysqlimport and LOAD DATA LOCAL INFILE, but with warnings. I have 2 questions associated with this: 1) How do I make mysqlimport or LOAD DATA LOCAL tell me the text of each warning? By default they print a summary count of warnings but don't issue actual warning messages. The default log files show nothing. mysqlimport -v does not do it. 2) When consecutive commas (meaning at least 1 empty column, sometimes several) are seen, what does mysqlimport/LOAD DATA do to the corresponding column entrie(s)? Will it set them to NULL? Or to the default specified in the CREATE TABLE statement? Should I explicitly set these to NULL where permitted by the column type? Last of all, look at this date and time stamp exported by Access: ,2/12/1998 0:00:00, Will mysqlimport choke on this, since MySQL likes dates to be in ccyy-mm-dd format? Will I need to reformat the date with a sed script? Thanks Bob Cochran Greenbelt, Maryland, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 6/27/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.712 / Virus Database: 468 - Release Date: 6/27/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: autoincrement problem
For your problem, you need to create a table with a pool of availables key, and when you use one, you delete from this table and when you don't need it, return it here. Osvaldo Sommmer -Original Message- From: Nitin [mailto:[EMAIL PROTECTED] Sent: Saturday, June 12, 2004 3:44 AM To: MySQL Mailing List Subject: autoincrement problem Hi all, What will be the best way to implement auto increment field. I dont want to use auto increment feature, as it only appends the numbers but doesn't check for the values deleted. Suppose, following are the values in table 1abc 2bcd 3cde .. .. .. 9xyz now if 2nd and 3rd rows are deleted, an autoincrement field will still assign 10, 11, 12 to the new values, while I want it to assign the values deleted from the table first. What will be the best way to implement it? Thanks in advance Nitin --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Getting Oriented: Political versus Ecological Geography
Yeap, that's the idea. That's call normalization. If you are interested in database design, you need to read Codd's book in database. If you want, you I can help you looking at the database you build and give you some pointers. Osvaldo Sommer -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, May 29, 2004 9:39 PM To: [EMAIL PROTECTED] Subject: RE: Getting Oriented: Political versus Ecological Geography Hm... I think you were an even bigger help than I anticipated! If I understand correctly, I need to fix the tables I've already created. Consider three tables - Continents, Nations and States - which look something like this: CONTINENTS North America | New World | West [Hemisphere] | cna (code for North America) NATIONS United States | Washington, D.C. | us (code for the U.S.) | cna (links U.S. to North America in the Continents table) STATES Alaska | Juneau | ak (code for Alaska) | us (links Alaska to the U.S. in the Nations table) If I understand correctly, it would be smarter to create FOUR tables, that look like this: CONTINENTS North America | New World | West [Hemisphere] | cna (code for North America) NATIONS United States | Washington, D.C. | us STATES Alaska | Juneau | ak FOURTH TABLE (Links everything together) cna | us | ak (North America U.S. Alaska) cna | us | az (North America U.S. Arizona) cna | us | hi (North America U.S. Hawaii) cna | us | wy (North America U.S. Wyoming) cna | ca | ab (North America Canada Alberta) caf | ken | (NULL) (Africa Kenya) caf | tan | (NULL) (Africa Tanzania) This table would have just four fields (columns) and would begin with about 250 rows - one for each nation - with another 50 rows for the fifty U.S. states, then more rows for Canada's provinces, Mexico's states, etc. If I'm on the right track, then I could also add U.S. counties to the mix... North America United States States Counties However, since there are roughly 3,000 counties, it might be better to put them in a separate table, with rows that might look like this: cna (North America) | sd (South Dakota) | Tripp (county) cna | sd | Melette cna | sd | Sioux cna | sd | Belle Fourche Or would you advise adding the counties to the Fourth Table, which would look something like this?: cna | us | sd | Belle Fourche ccna | us | sd | Sioux cna | us | sd | Trippe cna | ca | ab | (NULL) ceu | fra | (NULL) caf | ken | (NULL) | (NULL) The top row = North America U.S. South Dakota Belle Fourche County The last row = Africa Kenya, with the rows corresponding to states/provinces and U.S. counties left NULL. I just thought of one problem, though - there are several U.S. counties that have the same name. For example, several states have a Washington County. But maybe I could just give all the counties numerical codes, or something like this - tx-1 (for Texas' first county). I wish I'd thought about this earlier. It sounds a lot better than my original plan! Thanks. --- Osvaldo Sommer [EMAIL PROTECTED] wrote: For what i understand, what you need to do is create this structure: Characteristic K Char_Code Char_Description Continent K Con_Code Con_Description Country K Cot_Code Cot_Description Cot_Continent ( This is the code of a continent in the table continent) Country_Charact K Des_Country ( This is the code of a country in the table country) K Des_Characteristic ( This is the code of a characteristic in the table characteristic) This way you can define the characteristics 1 time and assign to a country as many or as few as you need. You may want to use innob tables to create the foreing key and to help them inforce them. Hope this is usefull Osvaldo Sommer -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, May 29, 2004 5:57 PM To: [EMAIL PROTECTED] Subject: Re: Getting Oriented: Political versus Ecological Geography --- Peter Brawley [EMAIL PROTECTED] wrote: In the states table, should I list Colorado's regions in three cells... Great Plains | Rocky Mountains | Colorado Plateau, or group them in one cell, like this: Colorado | state | grasslands, Rocky Mountains, Colorado Plateau | co | cna | 5 It gets even trickier, because I may link Colorado to several regions, including ecological regions, physiographic provinces and political. Codd's first axiom is that all values shall be atomic (yes, mysql sets enums break that rule). Putting your little set 'grasslands, mountains, plateau' in one column would make queries on those items awkward. You might want to bone up on normalisation (viz links at http://www.artfulsoftware.com/dbresources.html). Thanks for the link. I've been studying some of the resources. I have an idea for another approach. If putting grasslands, forests, mountains in one cell is bad practice, then I may wind up with a table with hundreds
RE: Getting Oriented: Political versus Ecological Geography
For what i understand, what you need to do is create this structure: Characteristic K Char_Code Char_Description Continent K Con_Code Con_Description Country K Cot_Code Cot_Description Cot_Continent ( This is the code of a continent in the table continent) Country_Charact K Des_Country ( This is the code of a country in the table country) K Des_Characteristic ( This is the code of a characteristic in the table characteristic) This way you can define the characteristics 1 time and assign to a country as many or as few as you need. You may want to use innob tables to create the foreing key and to help them inforce them. Hope this is usefull Osvaldo Sommer -Original Message- From: David Blomstrom [mailto:[EMAIL PROTECTED] Sent: Saturday, May 29, 2004 5:57 PM To: [EMAIL PROTECTED] Subject: Re: Getting Oriented: Political versus Ecological Geography --- Peter Brawley [EMAIL PROTECTED] wrote: In the states table, should I list Colorado's regions in three cells... Great Plains | Rocky Mountains | Colorado Plateau, or group them in one cell, like this: Colorado | state | grasslands, Rocky Mountains, Colorado Plateau | co | cna | 5 It gets even trickier, because I may link Colorado to several regions, including ecological regions, physiographic provinces and political. Codd's first axiom is that all values shall be atomic (yes, mysql sets enums break that rule). Putting your little set 'grasslands, mountains, plateau' in one column would make queries on those items awkward. You might want to bone up on normalisation (viz links at http://www.artfulsoftware.com/dbresources.html). Thanks for the link. I've been studying some of the resources. I have an idea for another approach. If putting grasslands, forests, mountains in one cell is bad practice, then I may wind up with a table with hundreds of fields. Imagine one field filled with the names of the world's nations. Then imagine another field for tropical cloud forests, with three South American nations checked. A few northern nations are checked in the Tundra field, and so on. Obviously, there are going to be vast numbers of cells with no values at all. But what if I instead created several tables, one for each continent and listing only ecological regions associated with that continent. For example, the North America table might have just three rows, for the U.S., Canada and Mexico, with the following fields: tundra | boreal forest | eastern forests | Rocky Mountain forests | eastern grasslands | Great Plains | Sonora desert | California coastal | Pacific Northwest (there are actually a lot more.) The Africa table would have far more rows, for nations from Algeria to Zimbabwe, with fields that might look something like this: Sahara Desert | Sahel | Ethiopian mountains | tropical forest | woodlands | savanna Thus, North America and Africa will share no fields in common. However, North America and Eurasia will both share at least two fields - Tundra and Boreal Forest. So, if I create such tables for each continent, will I later be able to make a join that pulls up tundra in North America, Eurasia and Antarctica? Can I pull up the general term grasslands for all continents, or pull up Great Plains grasslands for just North America? Thanks. __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.692 / Virus Database: 453 - Release Date: 5/28/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Inserting blob
I found a place that say MYSQL has a limit for the size off the packet in relation with blob field. They say that you need to put this in the my.cnf set-variable = max_allowed_packet=15M. With that you increase the size to 15 mb You can go and check the code in http://www.mysql-hispano.org/page.php?id=20pag=2 Osvaldo Sommer -Original Message- From: Marco Paci [mailto:[EMAIL PROTECTED] Sent: Friday, April 09, 2004 3:41 AM To: [EMAIL PROTECTED] Subject: Inserting blob Env: Win2003 Server, MySql 4.17 I've the following table CREATE TABLE TabellaTipi ( id int unsigned NOT NULL AUTO_INCREMENT, intero int, lungo bigint, decimale decimal(20,10), data datetime, stringa varchar(100), booleano tinyint unsigned, blobDati longblob, primary key (id) )TYPE=InnoDB; With a .Net application I'm developing I'm not able to insert a blob bigger than 500Kb in the table. I connected to MySql both natively and through ODBC but the result is always the same. I think the problem should be in the configuration of MySql service. Any suggestion? TIA Marco Paci Marco Paci Divisione Gestionale Tecnologia PASSEPARTOUT s.a. Via Monaldo da Falciano, 3 - 47891 Falciano (Rep. San Marino) Tel. 0549.877910 From Abroad. +378 877910 [EMAIL PROTECTED]www.passepartout.sm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.648 / Virus Database: 415 - Release Date: 3/31/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Using Access as client all fields are marked #Deleted
What type of connection are you using? Linked table or you connect on demand? Osvaldo -Original Message- From: Patrick Kirk [mailto:[EMAIL PROTECTED] Sent: Thursday, April 01, 2004 7:32 AM To: Osvaldo Sommer Subject: Re: Using Access as client all fields are marked #Deleted Osvaldo Sommer wrote: Hi 1.- Does all your tables have a primary key? 2.- add a field type timestamp to all your tables and don't touch it. The problem is that access does not know if anyone has modify the record Osvaldo Sommer Thanks but it seems to make no difference. Here's a small table example that requires me to do a hard refresh whenever I add a new record. CREATE TABLE `tblFolders` ( `F_ID` tinyint(255) unsigned NOT NULL auto_increment, `NAME` varchar(30) NOT NULL default '', `TITLE` varchar(30) NOT NULL default '', `BODY` mediumtext NOT NULL, `CLASS` tinyint(10) NOT NULL default '1', `TIMESTAMP` timestamp(14) NOT NULL, PRIMARY KEY (`F_ID`) ) TYPE=MyISAM COMMENT='THIS IS FOR PEOPLE WHO WANT TO BROWSE BY FOLDER' AUTO_INCREMENT=10 ; Does that timstamp need some kind of tweaking? --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 3/22/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.639 / Virus Database: 408 - Release Date: 3/22/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Possible drawbacks of suggested mysql install?
Hi, we started with tha same configuration you have, and tune the MS Sql and MySQL for the memory the server (windows NT smallbusiness 4.0), and started to try our aplications against the two off them. All work really nice the two server with the same database and the same data and MySQL work faster that MS Sql. So, if you are doing it to get you people the feeling off working outside ms sql, that's a great start. Osvaldo Sommer -Original Message- From: Defryn, Guy [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 03, 2004 7:51 PM Cc: [EMAIL PROTECTED] Subject: Possible drawbacks of suggested mysql install? Hi there, I would like to know some professional opinions on the following: -Are there any drawbacks on installing Mysql on a windows server? Would it be possible to install it on the same server that hosts SQL server? Can they coexist properly? I do not expect too much usage of the Mysql server. We want to provide the MySQL service to our staff but might not be able to justify seperate servers. Are there any good articles available on this matter Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.608 / Virus Database: 388 - Release Date: 3/3/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.608 / Virus Database: 388 - Release Date: 3/3/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: More on indexes?
Hi Eve: Indexing is use to speed up search in the tables. You can have Primary Key Index to force unique key ( Ex: Client_Cod), or normal index in columns you use to get data in an alternate way(Ex: Client_Name). If you have very little data in your tables, the speed will not notice the speed but as data grows, you start to notice the gain in the searches. You need to read a book on Relational Database. Osvaldo Sommer -Original Message- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 8:42 PM To: [EMAIL PROTECTED] Subject: More on indexes? Hi, I've been following the list to get a better grip on MySQL, and have been hearing a lot about indexing. I'm beginning to think I should have indexed some of my tables in the past. Can anyone point me in the right direction as to the purpose of indexes, why they are used, the benefits, and when one should index? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.605 / Virus Database: 385 - Release Date: 3/1/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.605 / Virus Database: 385 - Release Date: 3/1/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]