Re: How to convert Acess 2007 ACCDB file to MySQL?

2008-12-30 Thread mos
At 11:12 PM 12/29/2008, you wrote: In the last episode (Dec 29), mos said: > Someone has given me an Access 2007 file *.ACCDB and I don't have Access > 2007. Is there a (preferably free) way to convert it to CSV or MySQL? Try the ODBC driver downloadable at "2007 Office System Driver: Data Conn

Re: On fighting with master-slave replication lag

2008-12-30 Thread Moon's Father
Yeah. You should use mk-heartbeat, it's the best tool for this situation that I have seen before. On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz wrote: > On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote: > > Slightly more complicated (and also probably more accurate- the time > > reported by

RE: On fighting with master-slave replication lag

2008-12-30 Thread xufeng
Hi Baron Schwartz, I have checked again your website and found out that I made a mistake on how your tool achieve this goal. I think it (mk-heartbeat) is a smart solution to this problem. Thank you so much. Yours Xu Feng > -Original Message- > From: baron.schwa...@gmail.com [mailto:baron.

Re: Changing port no of the server using command line method

2008-12-30 Thread Micah Stevens
On 12/30/2008 11:57 AM, Manish Sinha wrote: > lists-mysql wrote: >> in a *nix environment, restarting the mysql server is done with a >> system-level command and requires *system* root privileges, not >> something that the average db-admin is likely to have. also, >> changing the port a service is

Happy New Year

2008-12-30 Thread Arumugam K
* Hi All, New Year's Eve is the perfect time to bid goodbye to the year 2008 and welcome the New Year 2009. It's the time to rock and roll with friends and family Let the New Year brings with it new hopes and new opportunities to explore. ! Wishing you all a happy and a prosperous New Year! R

Re: Performance tips

2008-12-30 Thread Baron Schwartz
Hi Jim, On Tue, Dec 30, 2008 at 5:54 PM, Jim Lyons wrote: > On Sat, Dec 27, 2008 at 12:38 PM, Jake Maul wrote: > >> >> 3) Obviously it'd probably be faster if you weren't using >> SQL_NO_CACHE... guessing you just did that to show us what it's like >> that way? >> >> > Why would SQL_NO_CACHE slo

Re: Performance tips

2008-12-30 Thread Jim Lyons
On Sat, Dec 27, 2008 at 12:38 PM, Jake Maul wrote: > > 3) Obviously it'd probably be faster if you weren't using > SQL_NO_CACHE... guessing you just did that to show us what it's like > that way? > > Why would SQL_NO_CACHE slow it down? By not checking the cache or storing the resultset into cac

Re: Changing port no of the server using command line method

2008-12-30 Thread Manish Sinha
lists-mysql wrote: in a *nix environment, restarting the mysql server is done with a system-level command and requires *system* root privileges, not something that the average db-admin is likely to have. also, changing the port a service is listening on has potentially serious implications as you

Re: Changing columns descriptions...

2008-12-30 Thread Olaf Stein
Just use the same type as the column already has... Olaf On 12/30/08 12:40 PM, "Carlos Savoretti" wrote: > Hi all: > > Is it possible to change a column description > _without_ having to reset its type ? It is, > I has not to change its type, just its comment ... > > Example: > ALTER TABLE p

Changing port no of the server using command line method

2008-12-30 Thread Manish Sinha
Hi everybody, I am working on a small GUI tool for managing MySQL server. I would like to include one functionality to change the port number of the server and restart the server just after the change took place. Is there any command line tool which I can use to change the port number? e.g. fo

Trigger causes error in binlog

2008-12-30 Thread Olaf Stein
Hi all, I am having some issues with my replication setup which I have narrowed down to being a problem on the master, more specifically an issue with the binlog when using a trigger. I have a trigger on one of my tables that archives an entry before deleting it: DELIMITER // CREATE TRIGGER d_ad

Changing columns descriptions...

2008-12-30 Thread Carlos Savoretti
Hi all: Is it possible to change a column description _without_ having to reset its type ? It is, I has not to change its type, just its comment ... Example: ALTER TABLE products CHANGE COLUMNS product_id product_id INTEGER COMMENT 'Foo'; In Postgresql, it's done with: COMMENT ON COLUMN products

RE: How to convert Access 2007 ACCDB file to MySQL?

2008-12-30 Thread Jerry Schwartz
>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Monday, December 29, 2008 11:52 PM >To: mysql@lists.mysql.com >Subject: How to convert Acess 2007 ACCDB file to MySQL? > >Someone has given me an Access 2007 file *.ACCDB and I don't have Access >2007. Is there a (preferably

RE: How to convert Access 2007 ACCDB file to MySQL?

2008-12-30 Thread Jerry Schwartz
>-Original Message- >From: mos [mailto:mo...@fastmail.fm] >Sent: Monday, December 29, 2008 11:52 PM >To: mysql@lists.mysql.com >Subject: How to convert Acess 2007 ACCDB file to MySQL? > >Someone has given me an Access 2007 file *.ACCDB and I don't have Access >2007. Is there a (preferably

Re: How to convert Acess 2007 ACCDB file to MySQL?

2008-12-30 Thread Curtis Maurand
I'm not plugging the product, but I just ran into this: http://www.dbconvert.com/product.php It's $79.00. --Curtis Dan Nelson wrote: In the last episode (Dec 29), mos said: Someone has given me an Access 2007 file *.ACCDB and I don't have Access 2007. Is there a (preferably free) way to