Thank you Brooke, This information is helpful. All the best, Diego El día 24 de febrero de 2012 20:38, Brooke Rhead <[email protected]> escribió: > Hi Diego, > > I don't have any specific information for you about using the -A flag with > the OBDC Driver. The -A flag in MySQL is equivalent to --no-auto-rehash or > -skip-auto-rehash. Perhaps one of the longer-form options would work for > you? However, if you are not experiencing an excessively long startup time, > there is no reason to use the flag at all. Here is the description of > auto-rehash from the MySQL man page: > > --auto-rehash > > Enable automatic rehashing. This option is on by default, which enables > database, table, and column name completion. Use --disable-auto-rehash > todisable rehashing. That causes mysql to start faster, but you must issue > the rehash command if you want to use name completion. > > To complete a name, enter the first part and press Tab. If the name is > unambiguous, mysql completes it. Otherwise, you can press Tab again to > see the possible names that begin with what you have typed so far. > Completion does not occur if there is no default database. > --- > > I hope this helps. If you have further questions, please feel free to > contact us again at [email protected]. > > > -- > Brooke Rhead > UCSC Genome Bioinformatics Group > > > Diego Pereira wrote on 2/23/12 7:02 PM: > >> Thank you for your answer Brooke >> Yes, I'm connecting that way. >> The -A flag seems to be the problem. >> I tried using MySQL workbench and MSAccess using the OBDC driver and >> any of them recognize the -A flag. >> Strangely I had to restart my PC to get the error message. >> The genomep without the -A flag works well, but as far as I understand >> is slower. >> May I ask you to indicate me how should I put the -A flag to be used >> with the OBDC driver? >> Or should I keep using the other type of connectivity when trying to >> connect via OBDC? >> Thanks, >> Diego >> >> El día 23 de febrero de 2012 21:08, Brooke Rhead<[email protected]> >> escribió: >>> >>> Hi Diego, >>> >>> There are no problems with our MySQL server that we are aware of. (One >>> person contacted us earlier today about a connection problem, but it >>> turned >>> out to be a temporary problem on their network.) Can you give us an >>> example >>> of the errors you are seeing? Are you connecting with this command: >>> >>> mysql --user=genome --host=genome-mysql.cse.ucsc.edu -A >>> >>> (from http://genome.ucsc.edu/FAQ/FAQdownloads.html#download29)? >>> >>> -- >>> Brooke Rhead >>> UCSC Genome Bioinformatics Group >>> >>> >>> >>> On 2/23/12 5:55 PM, Diego Pereira wrote: >>>> >>>> >>>> Dear all, >>>> I've been trying to connect today through MySQL to perform some simple >>>> queries unsuccessfully. >>>> May I ask you if you are having troubles with your server/connection >>>> or other related issues that may explain my lack of connectivity? >>>> Thanks >>>> Diego >>>> _______________________________________________ >>>> Genome maillist - [email protected] >>>> https://lists.soe.ucsc.edu/mailman/listinfo/genome > >
_______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
