I guess I was tired yesterday, my message wasn’t very clear.
The databases I’m using are sqlite3.
So looking for “How to create a dump with sqlite3”, I fund and executed:
sqlite3 mydb > mydb.dump
Well, it worked out fine. Watching inside the mydb.dump file I realized
there’s a bunch of CREATE TABLE so I deleted them manually since I
already executed ‘rake db:migration’ on the server.
I just couldn’t finish the migration because my Unix server tells me
that I have to install sqlite3 when I’m trying to do
cat mydb.dump | sqlite3 mydb_unix.sqlite3
The strange thing is sqlite3 was supposed to be installed on the server
and the site seems to work… I’ll have to find that out.
Thanks for all the answers.