Is it possible to generate a data dump of the EE database with the query form that’s built into EE?
Jeremy
This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
February 28, 2012 12:48am
Subscribe [2]#1 / Feb 28, 2012 12:48am
Is it possible to generate a data dump of the EE database with the query form that’s built into EE?
Jeremy
#2 / Feb 28, 2012 3:25am
I personally would say why re-invent the wheel and just use something like either PHPMyAdmin to do this or one of the backup add-ons listed on devot-ee.com or the fastest database backup utility I’ve ever come across which is - Sypex Dumper. That backs up one of our databases which is currently around 500MB in around 4 seconds!!!
Whilst you might be able to do it with the Query module I think you would have a massive amount of work ahead of you in doing so.
Hope that helps a bit.
Best wishes,
Mark
#3 / Feb 28, 2012 10:47pm
My problem is my server runs PHPMyAdmin through Plesk, but my install of Plesk is totally hosed and PHPMA is inaccessible as far as I can tell. The query is meant to be a workaround.
Sypex Dumper looks like a good alternative, so I’ll install it and go from there.
PS: Lisa Wess replied in an email that the query form isn’t really suitable for getting a database backup like this. FYI.
Jeremy