similar to: NOOB - How do I query other databases for data

See my screenshot of the command here. http://a.imagehost.org/0843/mysqladmin.png When I type the following: mysqladmin create <database_name> --user=root --password=xxxxxxxx Is my command executed simply by pressing "Enter" after the command? Am I missing some syntax? If the command has been executed , what directory can I find this database? How does this relate to MySQL

Ok, This sounds like it should be easy but I am having a hard time with it. I am making a website but I''m trying to make everything in it fairly database driven, this is really pretty much my first rails project. I have a table called ''nav_items'' to display the nav choices, but there is also other dynamic data on the homepage such as the ''events''

Here is a cautionary tale to help others avoid my folly! I kept running into bizarre problems with my rails app. I run the latest Rails with FastCGI, Oracle 10g and Apache 1.x. After moderate load the server would throw up application errors. Looking in the logs I noticed that my underlying Oracle DB was complaining that it had opened too many processes and won''t open any more. Hmm...

Hi, folks. <shameless plug for rsync> rsync has changed the way I handle mirroring tasks, and is a wonderful compliment to EMC's timefinder product. EMC handles their BCV mirror splits, and rsync handles files and hierarchies on non-EMC disk. I am quite happy with this arrangement. For small numbers of systems, rsync is far simpler than NIS+/LDAP for replicating certain types of

I want to show a users entries based on there login id. I have tried this: View: <div id="myfish"> <%= render :partial => ''myfish'', :locals => {:user => session [:user].id } %> </div> Partial: <% for entry in @entries %> <table border ="0" CELLSPACING="0"> <tr class="<%= alternate

Hi, I''ve been trying to update Will Sobel''s sybase-ctlib adapter to pass unit tests on Rails 1.0. It''s been a slow, sloggy process for me so far, as I''ve been learning Ruby, Rails, and Sybase administration all in one go. (c: It''s been a saving grace to have a good starting point (thanks Will!). http://dev.rubyonrails.org/ticket/2030

We''ve got a lot of existing legacy systems, and as a simple proof-of-concept I''m trying to get rails to work as an extension for these systems in a relatively transparent way. I''ve got rails running on another server with access to the same database as the legacy system. I''m simply popping up the rails in a frame on the legacy system, so the user can

Hello, I am not able to query Sybase IQ database from R using RODBC package. Check the below code R> sybaseiq.query <- function (sql, ..., as.is = FALSE) { connstr <- "Driver={Sybase IQ};UID=ajadhav2;PWD=*****;ServerName=PSGSESHR01A_IQ;CommLinks=SharedMemory,TCPIP{host=psgseshr01_iq.sg.csfb.com;port=3051}" chan <- odbcDriverConnect(connstr)

Hi, I am following the guide here: http://guides.rubyonrails.org/contributing_to_ruby_on_rails.html I have an ubuntu 11.04 VM setup, installed rvm, and ruby (ruby 1.8.7 (2011-06-30 patchlevel 352) [x86_64-linux]). Pulled down the rails from github and created a 3.0 branch: $ git branch --track 3-0-stable origin/3-0-stable $ git checkout 3-0-stable I can run the non-db tests ok, all pass

1. That was a part of a private email exchange. It has been suggested that more people may be interested. 2. I did use various databases (significant part of my job) for the last 15 years. Some with R for the last 3 years as a hobby. Some comments on the ones used below. Sorry, no links - I am time-constrained at the moment - please google if interested in details. The remarks are from the point

Hello. Using the ":include", which generates a "LEFT OUTER JOIN" SQL command, it is possible to eagerly preload second order data objects (children) for a given association. I wanted to know, if it is possible to eagerly preload and cache third order (or more) data objects, which are little-children or little-little-children. As I''ve seen. it is possible to add

I''m trying to write a football prediction game. I have a Matches table and a Predictions table. Each Match :has_many Predictions, and each Prediction :belongs_to a Match Each Match has (amongst other things) a Match.match_date field. Each Prediction has (amongst other things) a User_id field I''m trying to get a list of all Predictions a particular User has made which

Dear R-helpers, When I use sqlQuery in the package RODBC, I cannot break the line, but have to write the entire SQL Query on the same line. Is this expected behaviour? It is definitely workable, but makes the queries a slightly difficult to read and edit. I'm using R 1.9.1 and RODBC 1.0-4 on Windows Server 2003 and querying a Sybase database. Best wishes, Mikkel

I've added ODBC database logging to rsync, and was wondering what the procedure is to submit my code changes to be (hopefully) included into the main development branch of rsync. I've added everything in such a way that ODBC database logging is only included with a configure option, and otherwise not compiled in. Is there any interest in ODBC database logging for Rsync? If so should I

i realise that this goes against the basic idea of the MVC architecture, but i''ve found myself in a situation where i need to get information about the current user in a model & i''m not sure how to do it. Basically, we have a product where each customer has their own profile with data stored in a separate database. There are some tables in a common

Struggled a whole day, but still could not get DCOM working on my machine. What I did is: 1. Installed R 2.8.1 under folder "../R/R-2.8.1" 2. Installed R_Scilab_DCOM3.0-1B5 under folder ".. \R\(D)COM Server" 3. Installed packages: rscproxy_1.0-12, RExcelInstaller_3.0-10, rcom_2.0-4... 4. run the following commands: library(rscproxy) library(rcom)

Hi everyone, I was wondering what the common practice for handling multiple db users with fine grained privileges on multiple databases is. Against the often read guideline for rails users to keep with a single db as "more dbs don''t really make sense anyway", my opinion is that it DOES make sense to use more than one db schema for a number of reasons that I won''t

Dear R-help, I am trying to use routines written in C and Embedded SQL on Sybase in R using dyn.load(). I compiled a couple of test functions into a .so file which I tried to load with R's dynl.load(). This is what happened: > dyn.load("libRClib.so") Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library

Installed the freetds rpms from centos-extras, also tried the ones in rpmforge http://mirror.centos.org/centos/5/extras/x86_64/RPMS/freetds-0.64-11.el5.centos.x86_64.rpm http://mirror.centos.org/centos/5/extras/x86_64/RPMS/freetds-devel-0.64-11.el5.centos.x86_64.rpm Compiled python-sybase-0.39 by hand, and also via rpm.

Hi, Getting straight to the point: /usr/local/samba/bin/samba-tool domain classicupgrade --dbdir=/root/elara/samba/ --use-xattrs=yes --realm=mycompanyname.com.pl/root/elara.smb.conf After cleaning up all duplicate names and sutch I end up with: ldb: ldb_trace_request: (tdb)->search ldb: ldb_trace_response: ENTRY dn: CN=CONFIG cn: CONFIG upperBound: 4000000 lowerBound: None xidNumber: None