Re: different size under the two OS

2011-08-11 Thread Johnny Withers
du reports how much space the file takes on the disk. This # depends on the block size of each file system. On Aug 11, 2011 9:13 PM, "Feng He" wrote: Hello DBAs, Though this is not exactly a mysql problem, but I think this list may be helpful for my question. I have dumped a mysql data file, a

different size under the two OS

2011-08-11 Thread Feng He
Hello DBAs, Though this is not exactly a mysql problem, but I think this list may be helpful for my question. I have dumped a mysql data file, and scp it to another host. The current host is ubuntu-8.04, the remote host is ubuntu-9.10. As you can see below: The current host: $ md5sum fcm.0812.s

RE: Import from Quicken 2004 Mac?

2011-08-11 Thread David Brian Chait
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 tha

Re: Import from Quicken 2004 Mac?

2011-08-11 Thread Jan Steinman
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

RE: Import from Quicken 2004 Mac?

2011-08-11 Thread David Brian Chait
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: mys

Import from Quicken 2004 Mac?

2011-08-11 Thread Jan Steinman
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

error log rotation problem

2011-08-11 Thread Keith Murphy
Hey everyone, I have run across something that has me stumped. I have some systems that have very large error logs because we haven't moved from statement-based to mixed-based replication yet so they get a lot of warnings logged. I need to rotate the error logs and have started looking at it doing

mysql tables are lost for DDL of "alter table .. add column ..."

2011-08-11 Thread hiu
mysql tables are lost for DDL of "alter table .. add column ..." *1. mysqld's error.log* 110803 3:39:16 InnoDB: Warning: problems renaming 'feel_22/#sql-2635_23d3a8' to 'feel_22/feed_send_1451', 25000 iterations (first 25000,fil0fil.c:: fil_rename_tablespace) InnoDB: Warning: tablespace './fe

Tables are lost for DDL and different behaviors for alter table failed situation between innobase and innodb_plugin

2011-08-11 Thread hiu
*summary:* Recently we hit lost tables during DDL for online products, and after some observersion, we found some interesting hehaviors if fil_rename_tablespace failed as retry > 25. That might be another issue that not discussed here. THERE MUST BE SINGLE TABLESPACE Here is the steps to show