Import/Export database content

[artheus]

Hi!

I've got a testingserver where I always store my unfinished productions.. And when I move them I have to export the tables in my database 1&1.. And that means a lot of extra work.. which ofcourse is not good for bussiness!

Soo.. Are there any modules built in features in CMS made simple, so I can easily move the CMS from my testingserver to another server?

Cheers,
Artheus

[Ziggywigged]

You can use mysqldump: http://dev.cmsmadesimple.org/projects/mysqldump
There are a few others I haven't used. Do a search in forge using the keyword 'dump'.

I typically just use phpMyAdmin and export as a sql file to import into the new db.

[artheus]

Yes... phpMyAdmin works... But It's a bit of a security breach... I don't want an html interface that is able to administrate the database on my server.. Even if i've got a good password and all.. there are always bots who can find it out... And I would'nt want that..

And I think that since the CMS:MS database tables seems to have a pretty static layout, right? So can't really see how there would be a problem to develop a module or something to do this.. I haven't got the time to do this myself soo... I thought maby there were some skilled kid out there who had done this already ^^ (?)

Cheers!
Artheus

[alby]

Yes... phpMyAdmin works... But It's a bit of a security breach... I don't want an html interface that is able to administrate the database on my server..

Right BUT it's for time necessary for restore only (about... 3 minutes?)

And I think that since the CMS:MS database tables seems to have a pretty static layout, right?

Where?
Have you search in forge for modules?
For example: http://dev.cmsmadesimple.org/projects/sitepusher

Alby