migration

meus caros, to iniciando em rails. montei minha app com sqlite e agora preciso passar o banco pra mysql.
dapra fzr isso usando migration e rake. se sim, como faço?

so achei ate agora rake:backup para mysql.

desde já agradeço.

tchers

Tu vai ter que modificar o seu database.yml e recriar o banco.

Agora, tu quer passar os dados também?

Eu faço o dump e importação em yaml. Inspiração:

http://blog.leetsoft.com/2006/5/29/easy-migration-between-databases

um backup mesmo, completo, com tabelas e dados.

acabei usando o sqlite localmente, agora quero upar no servidor e a tehospedo nao tem suporte a sqlite, so mysql e postgresql.

C:\InstantRails-2.0\rails_apps\depot>rake db:backup:write
(in C:/InstantRails-2.0/rails_apps/depot)
rake aborted!
C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: formal argument ca
nnot be a constant
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tCOLON2, expecting ‘\n’ or ‘;’
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tIDENTIFIER, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tIDENTIFIER, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tCONSTANT, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tCONSTANT, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tIDENTIFIER, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tCONSTANT, expecting kEND
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/lib/tasks/backup.rake:1: syntax error, unex
pected tIDENTIFIER, expecting $end
puts “Writing #{tbl}…”stantizelic_exceptions’].include?(tbl)

C:/InstantRails-2.0/rails_apps/depot/rakefile:10
(See full trace by running task with —trace)

Parece que tá com problema nas quebras de linha do arquivo (talvez tenha misturado com quebra de linha do windows – “\r\n”).