# How to dump and reload?

**URL:** <https://www.ruby-forum.com/t/how-to-dump-and-reload/84238>\
**Category:** Radiant CMS\
**Created:** [February 2, 2007, 5:47pm UTC](https://www.ruby-forum.com/t/how-to-dump-and-reload/84238 "2007-02-02T17:47:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anton\_J\_Aylward](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e495f1/32.png) [@Anton\_J\_Aylward](https://www.ruby-forum.com/u/Anton_J_Aylward)\
**Post date:** [February 2, 2007, 5:47pm UTC](https://www.ruby-forum.com/t/how-to-dump-and-reload/84238/1 "2007-02-02T17:47:52Z")

</div>

This is really a Rails question, I suppose, but in context its a Radiant  
problem

John graciously supplied us with a script  
script/set-up\_database  
that preloaded some templates, snippets and pages.

Its not quite a Rake task, but …  
it does load content from YAML files.

Now Rake out of the box can dump and load the schema and dump the  
database  
structure to a SQL file.

But what I need to do is dump a Sqlite3 database and restore a MySQL  
database.

Its like this:

I’ve put together a small site for a local club (aka non-profit) which  
has  
about 100 members. The idea is that the ‘board’ can keep it up to date  
since the kid who volunteered to run the site for them has fallen down  
on  
the job.

I’ve run up a demo on my laptop and they are happy with that.  
I now have to put up the live site on an ISP.

This means dumping the content of the database on my laptop (Sq lite3)  
and  
restoring it on the ISPs server (MySQL)

I’m a little surprised that Rails doesn’t have this. Or am I mistaken?  
What I’ve found on the web tells me it isn’t.

I did find code that has different patches for Sqlite, MySQL and  
Postgress,  
but doesn’t work with Sqlite3.  
[http://www.realityforge.org/articles/2005/12/14/dumping-database-to-yaml-fixtures](http://www.realityforge.org/articles/2005/12/14/dumping-database-to-yaml-fixtures)  
[http://www.realityforge.org/files/dump\_fixtures.rake](http://www.realityforge.org/files/dump_fixtures.rake)

> **[BigBold - Informasi Tentang Bisnis dan Marketing](http://www.bigbold.com)**
>
> BigBold ialah situs yang memberikan segala macam Informasi Tentang Bisnis dan Marketing

Am I missing something 'cos I’m not a RoR coder? I would have thought  
this  
a common and obvious task.

–  
Never criticise somebody until you have walked a mile in their shoes.  
That way, they’re a mile away, and you have their shoes.

---

<div class="post-metadata">

**Author:** ![Anton\_J\_Aylward](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/e495f1/32.png) [@Anton\_J\_Aylward](https://www.ruby-forum.com/u/Anton_J_Aylward)\
**Post date:** [February 14, 2007, 2:26am UTC](https://www.ruby-forum.com/t/how-to-dump-and-reload/84238/2 "2007-02-14T02:26:20Z")

</div>

I have a site developed on my laptop with Mental  
The two markup extensions are there in code and body and work.

I deploy to a server via FTP.  
Now the markup isn’t happening.  
The code is still there under /vendor/extensions

Running script/console tells me the extensions\_meta table is there and  
has  
entries the same as on the laptop, but the rendering isn’t happening.

In admin mode on the server the ‘extensions’ tab shows noting - which I  
have  
a problem reconciling.

Pressing ‘update’ causes a crash.

The code was FTP’d across from the laptop to the server.

Oh. The other thing. The “pages/snippets/templates” tabs are missing.

/a

–  
The plot was designed in a light vein that somehow became varicose.  
– David Lardner