I was wondering if there was a module that quickly backed up the whole PN DB into a executable .sql file, simmilar or exzactly tha same 2 tha 1 in PHPNuke. Thanks =)

There is. Find a module called MySQL Tools - do a search in modules. It will dump the whole PN DB and save it to disk for you.

Alf

thanks arefsum
great module indeed, I just downloaded, tested, installed in PN723 and works perfectly fine :D , now a doubt: how I do to restore the backup if something goes wrong? the file that makes the "Save DB" button has no extension, so I don't know... my knowledge of MySQL is as good as my PHP knowledge... low, painfully low... :? but I'm imporoving... :)
have a nice day
Ddx

Have a look in the file :). It is basically an sqldump of your database. You would have to use a tool like phpMyAdmin to "dump" the data back into to the PN database again. If you are uncertain about how it works, I would try it out a few times, so that in case anything goes wrong, then you know how to fix it. Ie, no panic time, just business as usual. :D The biggest problems with backup systems are not that they do not work, it is that the people using them do not know how they work.

Alf

phpMyAdmin can take a backup of the database as well. To do this click the export link and check structure and data and click download (or whatever it is)

basically best to know exactly what you are doing so that if your site goes down you can restore a backup immediatley.

Also backup your PN file structure, incase you run the wrong Delete command ;), and finally a test site for new modules etc. in the same conditions is good for testing new modules

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide

Thanks everyone for all your help :D:D

I'm making a backup module at the moment, it's called pnBackup and I'll release it as soon as i get my website back up. It's about 40% in production

there is also a module called MyDBbackup

sounds good, have a featurelist?

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide

Where can I download these backup tools from? I looked on the main mods.postnuke.com site
and couldn't find them. I don't want to download them from a thirds-party site if I'm not sure I'm getting the latest version. I am running Postnuke v0.723RC3.

Thanks

Sometimes it is better to go to a so-called third-party site and download it from there, since it is highly likely that the developers are from that site. Not all tools are developed by the PN team :)

Alf

Can send you MyDBBackup if you want, but I am not sure if its a good idea as its developer site is dead...

pnBackup is 95% complete! All I need to do is clean up the code and make the manual.

All my modules and themes are of the highest quality and are always being upgraded so if it says that it's made by me then you know it should work. ;) The only draw-back is that I don't have a website anymore . Oh well, keep no checking me temp site at http://vistra.dview.net and get ready for the pnBackup release!

it wouldnt happend to be because your site went down that you are creating pnBackup would it? lol

Very few modules are developed by the PN team, it is this that makes for PN's huge selection of modules for users to choose from. If a site is listed in an article on mods.postnuke.com, then that is the place to get the latest version of that module

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide

Styric-

Please let me know when you finish your backup module. I'd be interested in trying it out.

thanks

HammerHead, I've been planning the module since I found out that there wasn't a backup module for Postnuke.

pnBackup is finished and is downloadable at http://vistra.dview.net.

there is one though :)

Don't know if you mod can do this (Dump screen of MyDBbackup):

http://www.eastsource.net/MyDBbackup.gif

Does anyone know if such modules are likely to be affected by future PN releases? (from DB point of view, assuming they are comliant)

I've just run this on a test site and ot worked just fine. Great job. ;)


FYI, since the topic is Backing Up database. Most, if not all servers you try and do a restore of a database on via phpMyAdmin, it wont work. There is a time limit and most sites of larger sizes, the DB is too big and will time out.

Small site? Sure no problem. If that DB is over 2MB forget it. You'll have to do it (if you use phpMyAdmin to restore) by pasting into the SQL query small pieces at a time.


All was fine - no errors. ;)

ah well in that case we ought to hope that the PN database never gets deleted, or i think we really will be done for.

Whats with the time limit? is it a security measure?

Ill have a look at the backup module shortly

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide

No, the DB can be restored with root access by server admin here quite easy. But thats another story all together.

ah well in that case i can sleep easy at night ;)

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide

No worries mate, Drak is on the case and doing a fine job! :)

as always, he must spend 1/2 his life with the postnuke site

--
itbegins.co.uk - Zikula Consulting

birtwistle.me.uk - Personal Blog


Please read the Support Guide