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 =

RE: innodb on nt4

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

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]]

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

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

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

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

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

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

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

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

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