Forum: Rails deployment DB export, then import

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
018b3c8f428a528431a2ccd65b4d37e4?d=identicon&s=25 Thierry Delbart (thithi32)
on 2008-10-30 00:55
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
A82ba1167f4d4a8d1de63820e576a87f?d=identicon&s=25 Robby Russell (Guest)
on 2008-10-30 04:29
(Received via mailing list)
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
<ruby-forum-incoming@andreas-s.net> 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]
Ff803e4a435f1438fc928f41500b1ffa?d=identicon&s=25 Alex Malinovich (Guest)
on 2008-10-30 04:31
(Received via mailing list)
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-
C5c0e0499446b84fd3bcc61cf7862539?d=identicon&s=25 Thani Ararsu (thaniyarasu)
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 ?
018b3c8f428a528431a2ccd65b4d37e4?d=identicon&s=25 Thierry Delbart (thithi32)
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.
018b3c8f428a528431a2ccd65b4d37e4?d=identicon&s=25 Thierry Delbart (thithi32)
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.
2acb1896e3d9ff4061ce1fed2559500f?d=identicon&s=25 Songli Songli (songli)
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.
This topic is locked and can not be replied to.