Problems with float() fields during migration to MySql 5

2005-07-14 Thread Nico Alberti
Hi everybody. During the migration of our mysql test server to version 5 I noticed a problem when I tried to import a table that I dumped from our 4.1 production machine. The table has some fields defined as float(31,30) (they came from an old Access table converted with DBTools Manager). When I

Re: [Newbie] Slow slave update.

2005-06-14 Thread Nico Alberti
2005/6/10, Atle Veka [EMAIL PROTECTED]: software has much to do with this, the biggest problem is your disk. :) Don't understimate what a McAfee VirusScan can do on your pc's performance :-), however, you are probably right. -- Ciao Nico -- MySQL General Mailing List For list archives:

Re: [Newbie] Slow slave update.

2005-06-10 Thread Nico Alberti
2005/6/10, Atle Veka [EMAIL PROTECTED]: The speed of the drive will have a lot to say on how long the queries run. You haven't said anything about what type of master you have, OS, mysqld Thank you all for your answers. As I said before, I was only curious, as fortunately I don't have to rely

[Newbie] Slow slave update.

2005-06-09 Thread Nico Alberti
Hi everybody. Is it normal that, after a massive number (300.000) of INSERTs on the master server (that however did not take more than some minutes), my laptop that acts as a slave needs hours to catch up? The logfile was almost instantly transferred, but the INSERTs at the slave server seem to

Re: phpMyAdmin 2.5.4 login in ERROR!

2005-04-05 Thread Nico Alberti
That is as follow: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client Hi Zhu, have a look at http://dev.mysql.com/doc/mysql/en/old-client.html Basically, you should keep on using the pre 4.1 authentication mechanism if you have to

Tables shortcuts?

2004-12-23 Thread Nico Alberti
Hi everybody. I am rather new to MySQL (and to dba in general), so sorry for the lame question (and for my English). Our company is migrating several Access database to MySQL by now with good results. This process sometimes brings to a reorganization of some key tables that are used by many

Re: Tables shortcuts?

2004-12-23 Thread Nico Alberti
On Thu, 23 Dec 2004 11:30:34 -0500, Rhino [EMAIL PROTECTED] wrote: It is always best if you post followup questions/remarks back to the list. Sorry, wrong button. -- Ciao Nico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Tables shortcuts?

2004-12-23 Thread Nico Alberti
On Thu, 23 Dec 2004 11:54:30 -0500, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Yes, it should be possible to 'alias' an entire table through a view Thank you all for your help. Of course the production server is 4.1, but I will start immediately to test version 5 -- Ciao Nico -- MySQL