Hi, I'm developping a little application on my computer (Windows Vista). It works. I did put it on my Unix server (production) and started the ruby server. It works fine. But of course there's no data :). How can I export the data from my developpement DB (local Windows) to my production DB (distant Unix)? Thank you! Thierry
on 2008-10-30 00:55
on 2008-10-30 04:29
Thierry, You'll want to refer to your databases documentation for creating a dump and importing it. Robby On Wed, Oct 29, 2008 at 4:55 PM, Thierry Delbart <firstname.lastname@example.org> wrote: > production DB (distant Unix)? > > Thank you! > > Thierry > -- > Posted via http://www.ruby-forum.com/. > > > > -- Robby Russell Chief Evangelist, Partner PLANET ARGON, LLC design // development // hosting http://www.planetargon.com/ http://www.robbyonrails.com/ aim: planetargon +1 503 445 2457 +1 877 55 ARGON [toll free] +1 815 642 4068 [fax]
on 2008-10-30 04:31
It's different for every kind of database. Which database server are you using on your Vista machine? On Oct 29, 4:55 pm, Thierry Delbart <ruby-forum-incom...@andreas-
on 2008-10-30 05:00
Alex Malinovich wrote: > It's different for every kind of database. Which database server are > you using on your Vista machine? > > On Oct 29, 4:55ï¿½pm, Thierry Delbart <ruby-forum-incom...@andreas- what happened to sqldump ?
on 2008-10-30 11:42
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. Thierry.
on 2008-10-30 13:49
Sorry, the following line > sqlite3 mydb > mydb.dump should be sqlite3 mydb .dump > mydb.dump For the rest it worked out fine for me.
on 2008-12-20 01:40
This clock projects the time, date, or temp on the wall or ceiling http://www.liangdianup.com/clocks_1.htm some people call it a ceiling clock but I call it a digital projection clock. I got the black one because at the time that was the only color they had. But now they have them in black and also in white.