the command-line way to dump data base
backup
----------
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
restore to mysql (possibly similar way for DB2 ????)
--------
mysql -u [username] -p [password] [database_to_restore] < [backupfile.sql]
saji
* Aitor Garay-Romero <[EMAIL PROTECTED]> [2007-10-18 16:35:54 +0200]:
> Did you migrate the database from MYSQL to DB2?
>
> For testing, initialize new new database in DB2 by running "rake
> production db:bootstrap". Radiant should work, albeit without any data.
>
> If it works and you want your old data from MYSQL, then you must dump it
> from MYSQL and import it in DB2. Then do a "rake production db:migrate" to
> migrate the schema to the new radiant version. Or do this in MYSQL before
> dumping the data.
>
> AFAIK, there is somewhere a Radiant extension that exports/imports the
> DB in YAML. Search the mailing list for it.
>
> /AITOR
>
>
>
> On 10/16/07, Clark Kent <[EMAIL PROTECTED]> wrote:
> >
> > Hello people,
> >
> > I am a newbie and I developed a running application with radiant 0.6.1
> > that used at the beginning MySQL as database.
> >
> > However, after changing the database from MYSQL to DB2, if I click on
> > "add a new page" botton in radiant admin it
> >
> > return this error:
> >
> >
> > ActionView::TemplateError (undefined method `filter_id' for
> > nil:NilClass) on line #69 of vendor/radi
> > ant/app/views/admin/page/edit.rhtml:
> > 66: }
> > 67: return false;
> > 68: }
> > 69: var last_filter = "<%= default_filter_name %>";
> > 70: function load_filter_reference(part) {
> > 71: filter_type = $F("part[" + part + "][filter_id]");
> > 72: popup = $('filter-reference-popup');
> >
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/helpers/capture_helper.rb:93:in
> > `content_f
> > or'
> > #{RAILS_ROOT}/vendor/radiant/app/views/admin/page/edit.rhtml:69:in
> > `_run_rhtml_47vendor47radiant
> > 47app47views47admin47page47edit46rhtml'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/helpers/capture_helper.rb:108:in
> > `call'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/helpers/capture_helper.rb:108:in
> > `capture_
> > erb_with_buffer'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/helpers/capture_helper.rb:67:in
> > `capture'
> > (eval):1:in `content_for'
> > #{RAILS_ROOT}/vendor/radiant/app/views/admin/page/edit.rhtml:1:in
> > `eval'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/helpers/capture_helper.rb:93:in
> > `content_f
> > or'
> > #{RAILS_ROOT}/vendor/radiant/app/views/admin/page/edit.rhtml:1:in
> > `_run_rhtml_47vendor47radiant4
> > 7app47views47admin47page47edit46rhtml'
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/base.rb:326:in
> > `send'
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/base.rb:326:in
> > `compile_and_render_templat
> > e'
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/base.rb:301:in
> > `render_template'
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_view/base.rb:260:in
> > `render_file'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:806:in
> > `render_file'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:738:in
> > `render_with_no_layou
> > t'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:863:in
> > `render_without_layou
> > t'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:798:in
> > `render_action'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:748:in
> > `render_with_no_layou
> > t'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/deprecation.rb:44:in
> > `silence'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:747:in
> > `render_with_no_layou
> > t'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/layout.rb:244:in
> > `render_without_ben
> > chmark'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
> > `render'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/1.8/benchmark.rb:293:in
> > `measure'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:50:in
> > `render'
> >
> >
> > #{RAILS_ROOT}/vendor/radiant/app/controllers/admin/page_controller.rb:19:in
> > `new'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:1095:in
> > `send'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:1095:in
> > `perform_action_with
> > out_filters'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:632:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
> > `call'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
> > `call'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
> > `call'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
> > `call_filter'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:619:in
> > `perform_action_wi
> > thout_benchmark'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
> > `perform_actio
> > n_without_rescue'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/1.8/benchmark.rb:293:in
> > `measure'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:in
> > `perform_actio
> > n_without_rescue'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in
> > `perform_action'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:430:in
> > `send'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:430:in
> > `process_without_filt
> > ers'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:624:in
> > `process_without_s
> > ession_management_support'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in
> > `proces
> > s'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:330:in
> > `process'
> > #{RAILS_ROOT}/vendor/rails/railties/lib/dispatcher.rb:41:in
> > `dispatch'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/rails.rb:
> > 78:in `process'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/rails.rb:
> > 76:in `synchronize'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/rails.rb:
> > 76:in `process'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:618:in
> > `process_client'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:617:in
> > `each'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:617:in
> > `process_client'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:736:in
> > `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:736:in
> > `initialize'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:736:in
> > `new'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:736:in
> > `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:720:in
> > `initialize'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:720:in
> > `new'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel.rb:720:in
> > `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/configura
> > tor.rb:271:in `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/configura
> > tor.rb:270:in `each'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/configura
> > tor.rb:270:in `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/bin/mongrel_rails:127
> > :in `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/lib/mongrel/command.r
> > b:211:in `run'
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/gems/1.8/gems/mongrel-
> > 1.0.1-mswin32/bin/mongrel_rails:243
> >
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
> > `load'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
> > `load'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
> > `new_constant
> > s_in'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:488:in
> > `load'
> > #{RAILS_ROOT}/vendor/rails/railties/lib/commands/servers/mongrel.rb:60
> >
> >
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
> > `gem_origi
> > nal_require'
> >
> >
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
> > `require'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
> > `require'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in
> > `new_constant
> > s_in'
> >
> >
> > #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
> > `require'
> > #{RAILS_ROOT}/vendor/rails/railties/lib/commands/server.rb:39
> >
> >
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
> > `gem_origi
> > nal_require'
> >
> >
> > E:/dbbiblio/InstantRails/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
> > `require'
> > script/server:3
> >
> >
> > Is there anybody who can help me??
> >
> > I tried to update radiant 0.6.1 to 0.6.3 version, but when I run the
> > update rake task "rake radiant:update" I got
> >
> > back this error:
> >
> > "rake aborted! Don't know how to built task 'radiant:update'"
> >
> >
> > Best regards and many thanks!
> > --
> > Posted via http://www.ruby-forum.com/.
> > _______________________________________________
> > Radiant mailing list
> > Post: [email protected]
> > Search: http://radiantcms.org/mailing-list/search/
> > Site: http://lists.radiantcms.org/mailman/listinfo/radiant
> >
> _______________________________________________
> Radiant mailing list
> Post: [email protected]
> Search: http://radiantcms.org/mailing-list/search/
> Site: http://lists.radiantcms.org/mailman/listinfo/radiant
--
Saji N. Hameed
APEC Climate Center +82 51 668 7470
National Pension Corporation Busan Building 12F
Yeonsan 2-dong, Yeonje-gu, BUSAN 611705 [EMAIL PROTECTED]
KOREA
_______________________________________________
Radiant mailing list
Post: [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site: http://lists.radiantcms.org/mailman/listinfo/radiant
