Re: mysqlimport remote host problem

On Tue, Mar 10, 2009 at 7:16 PM, René Fournier wrote: > OK, I've managed to do the same thing with just the mysql command line > program: > >mysql -h 192.168.0.224 -u root -p alba2 < > /Backup/Latest/alba2_2009-03-10_00h45m.Tuesday.sql > > Works great. However, the sql file is normally gz

Re: mysqlimport remote host problem

Note the space after the -p , alba2 will be the defaut database *after* he is prompted and corrctly give the password for r...@whateverhishostis . As he did not give the password, and is not connecting to an that one could get to from the net he really has not given out particularly useful info

Re: mysqlimport remote host problem

Hi Rene, Just a head's up. You might want to keep your username/password credentials private. On Tue, Mar 10, 2009 at 10:16 PM, René Fournier wrote: > OK, I've managed to do the same thing with just the mysql command line > program: > >        mysql -h 192.168.0.224 -u root -p alba2 < > /Bac

Re: mysqlimport remote host problem

OK, I've managed to do the same thing with just the mysql command line program: mysql -h 192.168.0.224 -u root -p alba2 < /Backup/Latest/ alba2_2009-03-10_00h45m.Tuesday.sql Works great. However, the sql file is normally gzipped, so Can I ungzip the file on the fly (and without removi

Re: Concurrent Inserts with merged table

> On Sat, Mar 7, 2009 at 12:10 PM, wrote: > Another way to find out whether this is the problem (yes, I know, you > already answered this question ;-) is to set concurrent_insert=2 (see > http://dev.mysql.com/doc/refman/5.0/en/concurrent-inserts.html ). > No go. Setting concurrent_insert=2 appea

mysqlimport remote host problem

I'm writing script that, each night, copies a small database to my laptop on the local network. I'm having trouble getting it to work. Here's my syntax so far (run on the server): mysqlimport --host=192.168.0.224 --user=root --password alba2 alba2_2009-03-10_00h45m.Tuesday.sql Which produ

Re: using a subquery/self-join to recursively retrieve a tree

How can I do some recursion to get the UIDs of all the employees reporting up to a manager, regardless of how deep the tree is. I can do this usindg LDAP and/or PHP, but not sure how to do it as a mysql query. Examples & discussion at http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20

using a subquery/self-join to recursively retrieve a tree

Hello, I have following simplistic DB representing a hierarchy: ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | uid| int(10) | NO | PRI | 0 | | | nam

Re: When will MySQL support array datatype?

This is part of the SQL Standard. MySQL has a worklog open on it: http://forge.mysql.com/worklog/task.php?id=2081 On Sat, Feb 14, 2009 at 9:05 PM, Moon's Father wrote: > Hi. >   Who could tell me when the MySQL support array datatype? > Any reply will be appreciated. > > -- > I'm a MySQL DBA in

BSD/OS and 5.1

I mean MySQL 5.1 I compile MySQL 5.1.32 and on tests I got gmake -k test cd unittest && gmake test gmake[1]: Entering directory `/usr/src/contrib/mysql/mysql-5.1.32/unittest' perl unit.pl run mytap mysys ../storage/archive ../storage/blackhole ../storage/csv ../storage/example ../storage/feder

Re: When will MySQL support array datatype?

Moon, I'm not sure exactly what you are trying to do, but why don't you just serialize() or json_encode() your data into a column? On Tue, Mar 10, 2009 at 9:35 AM, Moon's Father wrote: > Thanks for your fast reply. > Then only temporary table can simulate array datatype. > > On Mon, Feb 16,

Re: InnoDB deadlocks

Hi there, well, thanks for the hints regarding transaction-serialization performance but, if you read my very first e-mail, I didn't mention any kind of performance trouble, I just sometimes (once a *month*) have to re-issue some db commands because of these "deadlocks", but 99.9% of the time I ha

RE: InnoDB deadlocks

>-Original Message- >From: Paul McCullagh [mailto:paul.mccull...@primebase.com] >Sent: Monday, March 09, 2009 6:34 PM >To: Mattia Merzi >Cc: MySql >Subject: Re: InnoDB deadlocks > >Hi Mattia, > >On Mar 9, 2009, at 6:21 PM, Mattia Merzi wrote: > >> Hi everyone, >> >> I've got some problems w

Re: When will MySQL support array datatype?

Thanks for your fast reply. Then only temporary table can simulate array datatype. On Mon, Feb 16, 2009 at 3:12 AM, Claudio Nanni wrote: > Complex datatypes are not compatible with the concept of relational > databases, > probably you want to refer to an Object-Oriented DBMS or Object-Relational

Message could not be delivered

óÁ¬FzÒ*ÀÛá5ÆÚö؃nMӽ̈́™)FéoêiìŽÜ*ýøZÕÆ°1è—DŽ–!ã•b3_Åê·Yè]Ý-ìgE^x¿7u]É0Îãü`~Ö!ònpáÈܞBôAŸo÷1×µdA­ô(Ràíë"»á7ÀÃóÇÔbÊmÃËr½ëôo­µý©‡ws$R¨Ðێ*éa#õ7ä¸ðŖ-Z*êj«*:£‹ìê͖–rnýè„×—d¹][Ð)#—K¹¿þþŠèØ羐¹ÖV»È)Zà¶s7£Ñoϱíóï Y²ìM}¡d\`ÎØJgИêîÔ(ßÂdœ`– ;Ï¿j#h…òóhò—ïj«ºÛ”ÑЃh(£In“.ïʖT”•p<±âžÀO2W½}VvŠf¸°~žQ.ÇüPas

Question about the code in check_routine_access?

Hi, all, I don't know if this is the right list to ask such naive question. I am analyzing some mysql code for my work. For the following code: sql/sql_parser.c:5247 bool check_routine_access(THD *thd, ulong want_access,char *db, char *name, bool is_proc, bool no_errors) { TABLE_LIST tables

Re: mysql behaviour

Hi Miguel, I think it would also be very useful to watch the django error log, just to be check any clue for the aborted_clients, that is clients which connections was closed not gracefully. De nada! Claudio 2009/3/10 Miguel > aparently, it says that the error log is in the syslog file but

Re: mysql behaviour

aparently, it says that the error log is in the syslog file but here I didnt find any errors. I will cofigure an exclusive log file for the slow connections and the errors. Thank you very much for your help. best regards, Miguel On Tue, 2009-03-10 at 00:41 +0100, Claudio Nanni wrote: > I do no