similar to: How to get the whole mysql dump from the UI

I need export an registers of a data base from command line. It is possible with mysqldump? for example: mysqldump -u user -ppass db "select *from users where id=20" ??? thank

I have following line in route.rb #event info for an event name map.connect ''event/:name_url'',:controller => ''home'',:action => ''event_info'' It causes a URL like http://localhost:3000/event/_jewels_exhibition_ to be sent to the home controller with action as ''event_info''. I am trying to test this action. My first

I am switching to a composite primary key (string and user ID) from the Rails conventional auto-incrementing integer primary ID. The table is large (2.5 million records) and I''d rather not discard the contents. The composite_primary_key gem doesn''t appear to support altering the table with a migration to do its magic, only creating a table from scratch. So I dumped the table

About 10 days ago my debian server started crashing quite regularly. Aparently it was crashing when cron was attempting to run mysqldump. I was not 100% sure that this was the cause, but it looked mysql related. The really bad part was that some tables needed repair, and that was not a very pleasant thing, since some data was lost in the process. After the server rebooted 3 nights in a row, I have

validates_presence_of :fname results in the error message "Fname can''t be blank". What I want is "First Name can''t be blank". I could do this def validate errors.add_to_base("First Name can''t be blank") if fname.blank? end I find this clunky and I have to put everyrhing in the validate method. Is there an easy to get what I want. I

In the ''basecamp'' product from 37signals if I search for ''ruby'' the I get a bunch of results. In the search result page the search term (ruby in this case) is highlighted. I was wondering how to accomplish the same. How to highlight the ''search term'' in the search result? Is there any already existing utility that I could use? Thanks.

I intend to override pagination_links method. I added following lines of code in application_helper.rb module ActionView module Helpers def pagination_links(paginator, options={}, html_options={}) raise("boom!!") end end end But my code is not executing my code. The view is still using the method pagination_links from rails. What''s the correct way to override

How do I best migrate the data? For small databases I can text-edit the dump file from MySQL. The postgresql compatibility switch doesn''t help on mysqldump. Any ideas. Can MySQL export CSV that postgresql can import ? W Fred -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi, I installed login generator using gem. It''s installed and it''s working fine. I wanted to browse the source code of login generator installed by gem. I couldn''t find the source code anywhere. Thanks. -=- Neeraj _______________________________________________ Rails mailing list Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

class Event < ActiveRecord::Base belongs_to :venue belongs_to :category end class Venue < ActiveRecord::Base belongs_to :city end class City < ActiveRecord::Base belongs_to :state end I want to retrieve all event records belonging to a state. Coming from hibernate background I tried something like this: def self.list_for_a_state(state_id) find_by_sql(["select e.*

For discussion... I was talking about with a colleague the other day, the single biggest problem with replacing traditional client/server apps, is the lack of a unified front end UI library. Rails is absolutely fantastic and a breath of fresh air, for doing back end work and AJAX. RJS rocks for transforming HTML elements, but one of the big stumbling blocks will be how do I simply, drop a

Hello, We have MySQL running as a master which is replicating to a single slave server. We are, however, considering what is required when a 'disaster' of some sort happens to either server. By disaster, this could be some event which requires the entire server to be rebuilt, and which would usually include restoring from nightly backups directories such as '/var/lib/mysql' and

Hi all. I usally make backups of databases mysql. I make buckups of all datbase for example: mysqldump -u user -ppassword name_db > backups.sql also I make backups just its schema for example mysqldump -u user -ppassword name_db --no-data > backups.sql but now I need a backups incrementals, because the size of DB is very big (500 mb) How to make this? regards -- *Atte.

we have multiple servers approx 10 and each has about 100 GB of data in the /var/lib/mysql dir , excluding tar , mysqldump and replication how do we take backup for these databases on to a remote machine and store them datewise , ( the remote machine is a 2TB HDD ) currently tar is not feasible as the data is too huge and the same goes with mysqldump suggestion will be of great help --

Le''s say that I have a table called people and the column middle_name is nullable. If the user enters say blank or empty space then in the database it is recorded as empty space. I would like in all my models all empty spaces to be recorded as null. I guess I can write a plugin which will do so for all the models but I''m sure something like that should already be existing.I

My code is something like this. class FirstController < ApplicationController def foo #some processing render (:controller => ''second'', :action => ''index'') end end I tried using both render and redirect but it seems it''s not possible to send the control from within a controller to some other controller. Am I missing something

Not really a rails question but someone on here may be able to help.. I have been backing up a MySQL database for a Rails app for several years with the command: mysqldump myDatabaseName -u root > myBackupFile.sql The backups have appeared to work fine... I then wanted to restore one of the backups to a different named database so I did: mysql myNewDatabaseName -u root < myBackupFile.sql

Has anybody used the Yahoo UI library successfully with rails? I am particulary interested in some of the ratings tools they used (like 4 out of 5 stars thing rating a post). Curious to see if anyone out there has worked with this at all. adam -------------- next part -------------- An HTML attachment was scrubbed... URL:

I'm posting this as I'm trying to evaluate DEFAULT versus UI. As it stands right now, the use of the UI directive means that DEFAULT is effectively ignored from the command line. If you specify UI and DEFAULT and use (vesa)menu.c32, (vesa)menu.c32 will use DEFAULT unless a MENU DEFAULT option exist in the current context. If the attempt to execute a command fails, returning you to the

G'day, I'm backing up production MySQL database servers. The tables are almost all MyISAM. My plan is to use MySQL binary logging and then rsync the binary logs offsite hourly. The binary log files are only appended to, with new queries logged at the end of the file. So I'm assuming the rsync algorithm will be highly effective at reducing the bandwith required to transfer these