Displaying 20 results from an estimated 30000 matches similar to: "How to get the whole mysql dump from the UI"
2014 Aug 11
2
Question about dump on MySQL
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
2006 Jul 05
2
How to write get functional test when there is no action by that name
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
2009 May 26
6
dump and import MySQL table w/ accents
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
2006 Mar 20
0
MYSql (possibly) crashing server
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
2006 Aug 09
6
How to change the error message easy way
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
2006 Jul 26
2
How to highlight the search term in the search result
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.
2006 Apr 27
2
How to override pagination_links method
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
2006 Apr 29
2
nuby migration question -- data migration, MySQL => postgresql
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:
2005 Oct 25
3
How to get the source code for login generator
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
2006 Jan 31
2
Relationship navigation issue
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.*
2006 Jun 15
1
UI Libraries/Frameworks + Rails
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
2014 Aug 13
2
MySQL - replication - how to restore master?
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
2014 Nov 10
3
backup incrementals on mysql
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.
2010 Aug 14
6
best ways to do mysql backup
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
--
2006 Nov 17
4
set empty values as null in the database
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
2006 Jan 14
3
How to render from a different controller
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
2010 Aug 16
0
Restoring blob fileds in Mysql
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
2006 Mar 03
5
Yahoo UI Library with Rails
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:
2010 Aug 28
1
DEFAULT versus UI
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
2008 Oct 01
1
Rsync efficiency on SQL dump files
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