Page 1 of 1
Import/Export database content
Posted: Mon Jun 01, 2009 12:12 pm
by 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
Re: Import/Export database content
Posted: Mon Jun 01, 2009 12:23 pm
by 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.
Re: Import/Export database content
Posted: Mon Jun 01, 2009 12:29 pm
by 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
Re: Import/Export database content
Posted: Mon Jun 01, 2009 12:39 pm
by alby
artheus wrote:
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?)
artheus wrote:
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