RE: innodb on nt4
Hi, For windows systems, you can install mysql-max-3.23.39, that has support for both BDB and InnoDB. For InnoDB you need to change my.cnf and include these lines: # For Innodb Databases # change D:\WebApp\mysql\innodb and the other parameters to fit your # needs innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata innodb_data_file_path = ibdata1:20M;ibdata2:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Then you use mysql\bin\mysqld-max-nt --install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - 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: innodb on nt4
Hi, Actually both (ibdata and iblogs) are folders in ibdata. The files are written by InnoDB in these folders automatically. Just create yourself the folders: /some_dir/innodb/ibdata /some_dir/innodb/iblogs and it should work fine []s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 17:07 To: Crercio Osmaildo da Silva Cc: [EMAIL PROTECTED] Subject: Re: innodb on nt4 Hi, have a question about the inno_data_home_dir line on mysql-max3.23 do I create a file called ibdata cause it's not in any directory by default by default. innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata Pete - 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: exel to mysql
Hi, Use DBTools (http://dbtools.vila.bol.com.br) to convert/import from Access, Excel, DBF, ODBC and TXT. You can also generate csv files and import them into mySQL with LOAD DATA INFILE. []'s Crercio O. Silva -Original Message- From: jake williamson 28 [mailto:[EMAIL PROTECTED]] Sent: quarta-feira, 4 de julho de 2001 07:18 To: [EMAIL PROTECTED] Subject: exel to mysql hello, does anyone know how/are there any help programs to convert a excel spreadsheet into a mysql database? i can get the spreadsheet into access - would it be a case of i can then export that to mysql?? any ideas oh guru's???!! cheers, jake 28 23a great queen street london wc2b 5bb t 020 7404 4828 f 0870 164 3109 [EMAIL PROTECTED] m 07931 507 442 - 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: Data
Ola Ricardo, Não sei ao certo se o formato padrao do MySQL voce consegue mudar. Entretanto voce pode resolver o problema utilizando o DATE_FORMAT no select. Veja o exemplo abaixo: SELECT DATE_FORMAT(NOW(), d/m/Y) AS DATA; []'s Crercio O. Silva -Original Message- From: Ricardo Ferrari (SPO-LAB) [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 18 de junho de 2001 14:01 To: MySQL (Correio eletrônico) Subject: Data ola como faço p/ mudar a data padrao do mysql?? ele esta como -dd-mm eu gostaria de mudar p/ dd-mm- falow valeu - 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
New DBTools version (1.0.9) Available
I'm glad to let you all know that there is a new version of DBTools available. Go to our website http://dbtools.vila.bol.com.br to download it. What´s new: - Fixed bug when Importing from MSSQL Server using ODBC in tables that has IDENTITY (autoincrement) property - Added XML support to Dump Database/Table wizard - Fixed bug in the Import Wizard when converting MSAccess. Now when a column has null values it will be imported with blanks instead - Removed Column/Index icons from the TreeView. This improves the load time - Created a new Table Manager integrated with column and index properties in the same Dialog with support to table types, all column types available in MySQL and all databases and tables will be visible at the same time. Structure print is also available from the Table Manager - Added support for FIRST/BEFORE column creation - Fixed bug when creating new user with both connection privileges (localhost and everywhere) - Added tip support. I'm building the tip file to contain most of the useful tips - Lots of new features in the Query Editor =Now it is a modeless dialog, you can navigate between =DBTools and Query Editor. Because of that server refresh cannot be automatically anymore =Added better support for SQL documents (Create, Load, Save, detect changes) =Added better support for fonts, it will be saved in the user profile and loaded in the next use =Added support for parameters. Se the example: SELECT * FROM mytable WHERE mycolumn = @Param@ AND othercol = @Value@ Before running the query DBTools will ask you for the values and substitute them by the entered values. =You can now export the results in HTML or XML documents - Added support to choose a database in the connection dialog. Now you can fill the database edit box and see only this one in the view Enjoy it. []'s Crercio O. Silva - 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: Importing spreadsheet data into MySQL
Hi, Yes, you can DBTools for Windows (http://dbtools.vila.bol.com.br) that imports from MsAccess, Clipper, Dbase, FoxPro, Paradox, MSExcel and ODBC databases. []'s Crercio O. Silva -Original Message- From: Chris L. Gray [mailto:[EMAIL PROTECTED]] Sent: quarta-feira, 6 de junho de 2001 10:15 To: [EMAIL PROTECTED] Subject: Importing spreadsheet data into MySQL Is it possible to import spreadsheet data (Excel) into MySQL? I have data on about 2,500 retail locations that I must place into a database on the web and I do not want to type them by hand if I can avoid it. Thanks, Chris Gray --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.256 / Virus Database: 129 - Release Date: 5/31/2001 - 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: convert microsoft sql
Hi, You can use DBTools (for windows http://dbtools.vila.bol.com.br)) to convert the structure (without indexes) and data to mySQL by using ODBC DSN, or you can dump the data into a TXT file and then import it into mysql with LOAD DATA ... I'm working on a wizard to convert a completely structure/data from MSSQL to mySQL, since many people have requested that, but I have no idea yet how much time I will spend to finish this job. []'s Crercio O. Silva -Original Message- From: Christian Schäfer [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 5 de junho de 2001 12:03 To: [EMAIL PROTECTED] Subject: convert microsoft sql hi there, my client has some databases on a m$ sql server and wants them to be converted to mysql (to use on a cheaper provider). has anyone ever done this before? are there many differences in the syntax or would it be easy to translate? maybe there's tool? thanks for your help! christian _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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: MySQL front end tool
Hi, Try DBTools ( http://dbtools.vila.bol.com.br http://dbtools.vila.bol.com.br ). It's a Win32 client for mySQL, free, and has lot of features, including an Import/Export Wizard to help you convert other sources to mySQL. []'s Crercio O. Silva -Original Message- From: Alice [mailto:[EMAIL PROTECTED]] Sent: sexta-feira, 25 de maio de 2001 00:14 To: [EMAIL PROTECTED] Subject: MySQL front end tool Hi, i am a win2k professional user, and i would like to get a mySQL front end tools which can make mySQL to be work more user friendly. currently i am using MySQL-Front, for those who had tried out others this kind of tools, pls recommend any others tools that u think is more powerful, efficient and effective to me. by the way, i am just looking for those freeware product. thanx !
RE: Porting Access to MySQL
Hi, You can use DBTools (http://dbtools.vila.bol.com.br). It's free, for Win32 and imports from MSAccess, Paradox, xBase and ODBC databases. []'s Crercio O. Silva -Original Message- From: Mitchell [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 22 de maio de 2001 19:43 To: [EMAIL PROTECTED] Subject: Porting Access to MySQL Hi, I have a user who want to move there database from Access to MySQL. Are there tools available to make the conversion simple, or what is the best way of going about this? 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: count(*) on different tables
I had the same problem to solv before, and this is what I did. PS: I don't know if this is the right way to do it, but it worked for me. mysql CREATE TABLE Test.myTempTable (myTable VARCHAR(20), nrows AS INTEGER); mysql INSERT INTO Test.myTempTable SELECT Table1, COUNT(*) FROM Table1; // 10 rows mysql INSERT INTO Test.myTempTable SELECT Table2, COUNT(*) FROM Table2; // 265 rows mysql SELECT * FROM Test.myTempTable; ++--+ | myTable| nrows| ++--+ | Table1 | 10 | | Table2 | 265 | ++--+ 2 rows in set (0.00 sec) mysql DROP TABLE Test.myTempTable; // Finally drop the temp table It is a little hard to code it in a application since you need to RUN 4 statements and treat each result in a separated row. But you can use this to count any quantity of tables. []'s Crercio O. Silva - 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: import - date format
Hi, If you use DBTools (http://dbtools.vila.bol.com.br), using the import text wizard you have a lot of parameters to set, including date format and separators. Unfortunatelly, runs only on windows platforms. []'s Crercio -Original Message- From: Kevin Xin Lin [mailto:[EMAIL PROTECTED]] Sent: quinta-feira, 5 de abril de 2001 17:12 To: [EMAIL PROTECTED] Subject: import - date format Hi there, I have many files need import into mysql database. Unfortunately, the date format in my csv file is mm/dd/, so is there a wordaround that I don't need write another script to convert all my files? Thanks. Kevin - 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
New DBTools version Available
There is a new version of DBTools (1.0.8) available for download. For a complete list of changes and download go to http://dbtools.vila.bol.com.br. - This new version comes with an install script. I'd like to thank all the 3rd part effort to make this happens. - Fixed a serious bug in the new mySQL data access object. - Added support for updateable queries. The Query Editor will check if you are using only one table in the query. If you used more than one table in the same query DBTools won't allow to update or delete records. - Added support for ENUM/SET column types in the column manager - Added some more HTML help pages in the HTML Help System - Added the contributors page to DBTools Website. This is something that really matters to me. I'd like to thank all the contributions I've got so far. If I forgot to mention anybody, please, just let me know and I will provide the fix immediately. If you'd like to help the DBTools project, just send me an email telling me in what way you would like to help. []'s Crercio O. Silva / DBTools Development - 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