RE: Import from Quicken 2004 Mac?
The QIF file includes a lot of data aside from basic transactions, what exactly are you trying to end up with at the end of the day? Simply a copy of your QB data in Mysql? -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:15 PM To: mysql@lists.mysql.com Subject: Import from Quicken 2004 Mac? I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching this, so feel free to RTFM me -- with a proper reference, of course! I'll be wanting to set up a process to do this periodically (and hopefully, automagically) for new transactions. QB 2010 Mac appears to only export .IIF format, which appears to be a variant of the older .QIF format, and Google didn't turn up really anything for getting IIF/QIF files into MySQL. The best I could find would be importing them into Excel first, then CSV out of Excel into MySQL, which sounds like a lot of bother and not readily scriptable for routine use. I find it hard to believe I'm the first one to ever attempt this! IIF/QIF seems to be a rather unusual format. Lacking a one-step MySQL import tool, does anyone know of good parsers and translators for IIF/QIF that may be useful? Thanks in advance for any advice offered! Science uses mathematics to predict the future; economics uses statistics to predict the past. -- Jeff Barton Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Import from Quicken 2004 Mac?
I don't think I have ever heard of anyone directly importing a QIF into any relational database, you would have to translate the resulting data into a delimited txt file and then import. You may want to check to see if Quickbooks has an API that you can use to access the data natively rather than trying to move it around from platform to platform. -Original Message- From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:37 PM To: David Brian Chait Cc: mysql@lists.mysql.com Subject: Re: Import from Quicken 2004 Mac? On 11 Aug 11, at 14:17, David Brian Chait wrote: The QIF file includes a lot of data aside from basic transactions, what exactly are you trying to end up with at the end of the day? Simply a copy of your QB data in Mysql? That would be a good start. We don't need a complete duplicate, but in my experience, it's easier to get it all and winnow out the bits you don't want than to selectively import. That said, we really only need the basic transaction info: date, payee, amount, memo, category, account from, account to. This is to reconcile the chart of accounts (in Quick Books) with project management (in MySQL). From: Jan Steinman [mailto:j...@bytesmiths.com] Sent: Thursday, August 11, 2011 2:15 PM To: mysql@lists.mysql.com Subject: Import from Quicken 2004 Mac? I'm looking for ways to import QuickBooks 2010 Mac. I've only just started researching this, so feel free to RTFM me -- with a proper reference, of course! I'll be wanting to set up a process to do this periodically (and hopefully, automagically) for new transactions. QB 2010 Mac appears to only export .IIF format, which appears to be a variant of the older .QIF format, and Google didn't turn up really anything for getting IIF/QIF files into MySQL. The best I could find would be importing them into Excel first, then CSV out of Excel into MySQL, which sounds like a lot of bother and not readily scriptable for routine use. I find it hard to believe I'm the first one to ever attempt this! IIF/QIF seems to be a rather unusual format. Lacking a one-step MySQL import tool, does anyone know of good parsers and translators for IIF/QIF that may be useful? Thanks in advance for any advice offered! Science uses mathematics to predict the future; economics uses statistics to predict the past. -- Jeff Barton Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com Always do right. This will surprise some people and astonish the rest. -- Mark Twain Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: URGENT: Change Default Location of where Database Files get written?
Add: datadir=/path/to/datadir/mysql to your my.cnf file and restart mysql. -Original Message- From: Tina Matter [mailto:ti...@umich.edu] Sent: Friday, May 13, 2011 8:22 AM To: mysql@lists.mysql.com Subject: URGENT: Change Default Location of where Database Files get written? I have a MySQL question that I'm hoping someone can help answer. We have a linux machine which has MySQL 5.5.8 installed. It is currently installed in this location:/opt/mysql When creating a new database, a folder (with the name of the databas) gets created in this location: /opt/mysql/data Is there any way to change the location of where data is stored? The database that I need to create is going to have over a billion records in it, so it needs to be in a specific place. I want the database folder to get created here: /science/databases/databasename Thanks for any help. Tina -- Tina Matter Web Applications Developer University of Michigan Department of Epidemiology 1415 Washington Heights, Suite 4605 Ann Arbor, MI 48109 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: problem starting server
Go to the cmd line and type ps -ef , do you see mysqld listed? If so then it is already running. -Original Message- From: Gergely Buday [mailto:gbu...@gmail.com] Sent: Tuesday, April 26, 2011 5:56 AM To: mysql@lists.mysql.com Subject: problem starting server Hi there, I installed a mysql server on my Mac using homebrew. $ mysql --version mysql Ver 14.12 Distrib 5.0.91, for apple-darwin10.0 (i386) using EditLine wrapper When trying to start it I get $ mysql.server start Starting MySQL .. ERROR! The server quit without updating PID file (/usr/local/var/mysql/dbxserver.lan.pid). What should I do to start MySQL? - Gergely -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: centos server's mysql version's problem
-Original Message- From: Yang Yang [mailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:29 PM To: Johnny Withers Cc: mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem thanks johnny what about 5.1,did it performance better than 5.0 on centos when it has large traffic? 5.1 is newer,but i know not newer is better How much traffic is large traffic? How large is your database? How is it structured? What type of hardware are you using? -David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: centos server's mysql version's problem
Just so I am clear here, you have 8 different DB servers hosting the same data that is being accessed and potentially modified simultaneously? You may want to consider the replication issues involved in that sort of arrangement with mysql. Aside from that, I am currently hosting an 18gb mysql database that is passing roughly 6gb/hr without any issue utilizing a single Dell R710 and mysql 5.0.77. Your mileage may differ based on the low end hardware/storage that you plan to use, the number of writes and the amount of data that you can cache in memory. From: Yang Yang [mailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:38 PM To: David Brian Chait Cc: Johnny Withers; mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem about 8,000,000 visit,and about 40,000,000 sql do about 2g database,and the large table who aften use about 400m 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2x Intel Xeon Nehalem e5520 - 2.26GHz 1TB SATAII(*4 raid 10) 8gb ram thanks 2x Intel Xeon Nehalem e5520 - 2.26GHz 500 GB SATAII 2011/2/28 David Brian Chait dch...@invenda.commailto:dch...@invenda.com -Original Message- From: Yang Yang [mailto:dapiy...@gmail.commailto:dapiy...@gmail.com] Sent: Sunday, February 27, 2011 12:29 PM To: Johnny Withers Cc: mysql@lists.mysql.commailto:mysql@lists.mysql.com Subject: Re: centos server's mysql version's problem thanks johnny what about 5.1,did it performance better than 5.0 on centos when it has large traffic? 5.1 is newer,but i know not newer is better How much traffic is large traffic? How large is your database? How is it structured? What type of hardware are you using? -David
RE: Replacing MS SQL with MySql
No, what he is suggesting is that you use Access or MSSQL, and link Mysql to either platform via ODBC so that you can use it indirectly. All databases are not the same in terms structure and capabilities..you most likely will not be able to swap one out for another and make it work directly with your app. If there is an absolute requirement to use Mysql then you may be better off finding a different front end software that supports it, if not then embrace the fact that you will in all likelihood be maintaining a MS DB server for it. Not that it is such a bad thing, most corporate environments are heterogeneous these days, not geared toward one platform vs. another. -David -Original Message- From: Y z [mailto:yan...@hotmail.com] Sent: Wednesday, February 09, 2011 8:32 AM To: vegiv...@tuxera.be Cc: mysql@lists.mysql.com Subject: RE: Replacing MS SQL with MySql Thanks. The developer cheerily informs me that Access is 'deprecated' and will be phased out. So, SQL it is. I'm not sure what you mean by 'passthrough'. Do you mean MYSQL | ODBC | Win app ? If so, where do I go to learn how to configure MySQL and ODBC to dance together nicely, and talk to the app? Thanks! No way to do that directly; however, using the MySQL ODBC connector you can get at least a) and c) to play passthrough. Performance will likely suffer, though; especially Access' Jet Engine has a tendency to pull in full remote datasets instead of passing through the query. On Wed, Feb 9, 2011 at 6:36 AM, Y z wrote: I have a windows app that wants to talk to either a) an access database, b) a MS Sql Express database, or c) a MS Sql 2008 database. Can anyone please point me in the direction of configuring My Sql to imitate any of the above? Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=dch...@invenda.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Replacing MS SQL with MySql
To borrow your line of reasoning, translators can be rather slow and unreliable. Adding the extra overhead and complexity is certainly not worth the potential gains. -Original Message- From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: Tuesday, February 08, 2011 10:54 PM To: Reindl Harald Cc: Y z; mysql@lists.mysql.com Subject: Re: Replacing MS SQL with MySql On Wed, Feb 9, 2011 at 7:18 AM, Reindl Harald h.rei...@thelounge.netwrote: Am 09.02.2011 06:36, schrieb Y z: I have a windows app that wants to talk to either a) an access database, b) a MS Sql Express database, or c) a MS Sql 2008 database. Can anyone please point me in the direction of configuring My Sql to imitate any of the above? no way if the application has no abstraction-layer you can not easy switvh from one rdbms to another because in a closed source app you will even not can connect after connect there are hughe differences in many details so if a application does not support a specific rdbms you can not use it Remember, TIMTOWTDIhttps://secure.wikimedia.org/wikipedia/en/wiki/TIMTOWTDI:-) If someone you want to talk to knows only one language, find an interpreter. MS Access apparently speaks the same language as his app; and using ODBC it can also talk MySQL. Link the tables in Access and let the app use them as if they were regular tables. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How do increase memory allocated to MySQL?
Yannis, How is the data structured? Can you give us an example of the queries that you are trying to run? Do you have indexes in place? A very inefficient query, or poorly structured database can lead to this type of timeout issue on the type of low end hardware that you are using. Thanks, David -Original Message- From: Yannis Haralambous [mailto:yannis.haralamb...@telecom-bretagne.eu] Sent: Thursday, February 03, 2011 5:43 PM To: mysql@lists.mysql.com Cc: y...@mpi-inf.mpg.de Subject: How do increase memory allocated to MySQL? Hi everybody, I have loaded a very big amount of data in my MySQL database (coming from the YAGO project): -rw-rw 1 yannis admin 65 3 fév 16:07 db.opt -rw-rw 1 yannis admin 6392030392 3 fév 21:35 wasfoundin.MYD -rw-rw 1 yannis admin 11085793280 4 fév 04:54 wasfoundin.MYI -rw-rw 1 yannis admin 8668 3 fév 16:09 wasfoundin.frm as you can see the MYI file is 11Gb and the MYD file 6.4Gb. Whenever I try to send a query through phpmyadmin, it crashes and I get returned to the initial page of phpmyadmin. When I send an SQL query directly, it works, but it takes many minutes (a simple SELECT will take about 10 minutes). I'm using the latest version of MAMP under MacOS X (on a MacBook Pro 2.6 GHz Intel Core 2 with 4Gb of RAM). What can I do to make phpmyadmin work? Is it a chance to gain more speed when interacting through regular SQL queries, or is it hopeless? Where can I find more information about using MySQL with such big tables? Thanks in advance -- --- Yannis Haralambous Directeur d'études ADRESSE TEMPORAIRE : University of Aizu Aizu-Wakamatsu, Fukushima-ken 965-8580, Japon ADRESSE PERMANENTE : Institut Télécom, Télécom Bretagne Département Informatique UMR CNRS 3192 Lab-STICC Technopôle Brest Iroise CS 83818, 29238 Brest Cedex 3, France Tel: +33 2 29 00 14 27 Fax: +33 2 29 00 12 82 Email: yannis.haralamb...@telecom-bretagne.eu Internet: http://omega.enstb.org/yannis ICBM address: 48°21'31.57N 4°34'16.76W Twitter: y_haralambous --- ...pour distinguer l'extérieur d'un aquarium, mieux vaut n'être pas poisson ...the ball I threw while playing in the park has not yet reached the ground Es gab eine Zeit, wo ich nur ungern über Schubert sprechen, nur Nächtens den Bäumen und Sternen von ihm vorerzählen mögen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: How do increase memory allocated to MySQL?
That is exactly what I was worried about. He could try restructuring the data, increasing the timeouts to compensate for the long run time, or find better hardware. Any other ideas? From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J. Wang Sent: Thursday, February 03, 2011 7:20 PM To: Yannis Haralambous Cc: David Brian Chait; mysql@lists.mysql.com; y...@mpi-inf.mpg.de Subject: Re: How do increase memory allocated to MySQL? You're query is doing a full table scan. 2011/2/3 Yannis Haralambous yannis.haralamb...@telecom-bretagne.eumailto:yannis.haralamb...@telecom-bretagne.eu just a single table with an ID field (primary index) and three data fields (indexed): id bigint(20) NO PRI NULLauto_increment yagoid varchar(32) NO UNI NULL yagoleftvarchar(32) NO MUL NULL yakoright varchar(255)NO NULL what am I doing wrong? the query was just SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' Le 4 févr. 2011 à 11:14, David Brian Chait a écrit : Yannis, How is the data structured? Can you give us an example of the queries that you are trying to run? Do you have indexes in place? A very inefficient query, or poorly structured database can lead to this type of timeout issue on the type of low end hardware that you are using. Thanks, David -Original Message- From: Yannis Haralambous [mailto:yannis.haralamb...@telecom-bretagne.eumailto:yannis.haralamb...@telecom-bretagne.eu] Sent: Thursday, February 03, 2011 5:43 PM To: mysql@lists.mysql.commailto:mysql@lists.mysql.com Cc: y...@mpi-inf.mpg.demailto:y...@mpi-inf.mpg.de Subject: How do increase memory allocated to MySQL? Hi everybody, I have loaded a very big amount of data in my MySQL database (coming from the YAGO project): -rw-rw 1 yannis admin 65 3 fév 16:07 db.opt -rw-rw 1 yannis admin 6392030392 3 fév 21:35 wasfoundin.MYD -rw-rw 1 yannis admin 11085793280 4 fév 04:54 wasfoundin.MYI -rw-rw 1 yannis admin 8668 3 fév 16:09 wasfoundin.frm as you can see the MYI file is 11Gb and the MYD file 6.4Gb. Whenever I try to send a query through phpmyadmin, it crashes and I get returned to the initial page of phpmyadmin. When I send an SQL query directly, it works, but it takes many minutes (a simple SELECT will take about 10 minutes). I'm using the latest version of MAMP under MacOS X (on a MacBook Pro 2.6 GHz Intel Core 2 with 4Gb of RAM). What can I do to make phpmyadmin work? Is it a chance to gain more speed when interacting through regular SQL queries, or is it hopeless? Where can I find more information about using MySQL with such big tables? Thanks in advance -- --- Yannis Haralambous Directeur d'études ADRESSE TEMPORAIRE : University of Aizu Aizu-Wakamatsu, Fukushima-ken 965-8580, Japon ADRESSE PERMANENTE : Institut Télécom, Télécom Bretagne Département Informatique UMR CNRS 3192 Lab-STICC Technopôle Brest Iroise CS 83818, 29238 Brest Cedex 3, France Tel: +33 2 29 00 14 27 Fax: +33 2 29 00 12 82 Email: yannis.haralamb...@telecom-bretagne.eumailto:yannis.haralamb...@telecom-bretagne.eu Internet: http://omega.enstb.org/yannis ICBM address: 48°21'31.57N 4°34'16.76W Twitter: y_haralambous --- ...pour distinguer l'extérieur d'un aquarium, mieux vaut n'être pas poisson ...the ball I threw while playing in the park has not yet reached the ground Es gab eine Zeit, wo ich nur ungern über Schubert sprechen, nur Nächtens den Bäumen und Sternen von ihm vorerzählen mögen. -- --- Yannis Haralambous Directeur d'études ADRESSE TEMPORAIRE : University of Aizu Aizu-Wakamatsu, Fukushima-ken 965-8580, Japon ADRESSE PERMANENTE : Institut Télécom, Télécom Bretagne Département Informatique UMR CNRS 3192 Lab-STICC Technopôle Brest Iroise CS 83818, 29238 Brest Cedex 3, France Tel: +33 2 29 00 14 27 Fax: +33 2 29 00 12 82 Email: yannis.haralamb...@telecom-bretagne.eumailto:yannis.haralamb...@telecom-bretagne.eu Internet: http://omega.enstb.org/yannis ICBM address: 48°21'31.57N 4°34'16.76W Twitter: y_haralambous --- ...pour distinguer l'extérieur d'un aquarium, mieux vaut n'être pas poisson ...the ball I threw while playing in the park has not yet reached the ground Es gab eine Zeit, wo ich nur ungern über Schubert sprechen, nur Nächtens den Bäumen und Sternen von ihm vorerzählen mögen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=w...@singerwang.com -- The best compliment you could give Pythian for our service is a referral.