> > ... > mysql -h localhost -u myusername -p > select * from lter10_arthropods_production.sites; > > mysql -h localhost -u myusername -p -D lter10_arthropods_production > select * from sites; > > I have a similar config in my vimrc for for the MySQL localhost, here > trying naming the database explicitly and not doing so. Also tried with and > without passing a password. > > let g:dbext_default_profile_mysql_local = 'type=MYSQL:host=localhost: > port=3306:user=myusername' > > let g:dbext_default_profile_mysql_local_arthropods = > 'type=MYSQL:host=localhost:port=3306:user=myusername: > dbname=lter10_arthropods_production' > > With either connection setting, running the above query with or without > identifying the database name, I get the same result: man page details of > MySQL, connection settings, and the query. I have attached a truncated > version. > > You can run: :DBSetOption display_cmd_line=1 :DBSetOption delete_temp_file=0
Then execute your statement to see the command line dbext is executing. Then you can cut and paste that command line into a terminal / command prompt and see what happens when you execute the exact same command outside of Vim. If you do get an error executing the command, fiddle the command until it works outside of Vim, then we can figure out how to tweak the profile in dbext. David -- -- You received this message from the "vim_use" maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php --- You received this message because you are subscribed to the Google Groups "vim_use" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
