Author |
Message |
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Tue Dec 23, 2008 7:35 am Post subject: Automatic Database saving |
|
|
I want a MOD for auto saving my databaase daily, archive it, and send it to me by mail. I remember that I've seen something like this not long ago, but I'm not sure it worked. I would like somethign that someone tryed, because I want to know it's working.
Sometimes I forget to take a dump. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
Posted: Tue Dec 23, 2008 10:16 am Post subject: Re: Automatic Database saving |
|
|
You can use Ashe script coupled with cron. See http://webcron.org/ for further informations. |
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Tue Dec 23, 2008 11:56 am Post subject: Re: Automatic Database saving |
|
|
Is there an English version of that? _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
Posted: Tue Dec 23, 2008 11:57 am Post subject: Re: Automatic Database saving |
|
|
For the cron or the Ashe script? |
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Tue Dec 23, 2008 11:59 am Post subject: Re: Automatic Database saving |
|
|
I would assume both. Since most of us can't read whatever language that link was in. LOL _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Tue Dec 23, 2008 12:06 pm Post subject: Re: Automatic Database saving |
|
|
Looks to me like you have to pay for that one. Yes?
There should be a script out there some where that can do this for free I think... _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
Posted: Tue Dec 23, 2008 12:08 pm Post subject: Re: Automatic Database saving |
|
|
You just have to search "cron" in google |
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Tue Dec 23, 2008 12:19 pm Post subject: Re: Automatic Database saving |
|
|
I think there is a free add on for firefox that runs macros that would probably archive the same effect. That might be worth looking into also. _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
drathbun Board Member
Joined: 24 Jul 2008
Posts: 729 Location: Texas
|
Posted: Tue Dec 23, 2008 12:20 pm Post subject: Re: Automatic Database saving |
|
|
First make sure you can set up cron jobs via your host control panel. Then see if you have access to the command "mysqldump". Finally, you also need the ability to send email attachments via a cron job. Your host should be able to help you with all three of these options if you are not familiar with them.
This isn't really a MOD, as it's not going to be part of the phpBB code. _________________ phpBBDoctor Blog |
|
Back to top |
|
|
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Tue Dec 23, 2008 1:58 pm Post subject: Re: Automatic Database saving |
|
|
Ram wrote: | You can use Ashe script coupled with cron. See http://webcron.org/ for further informations. |
It's no good, I have to pay for it...
Code: | Only € 0.0001 Per Cron launch (30sec.) |
I do not understand very well what is a cron job... probably a nice tutorial would be helpful because I guess all of us wants to protect their work.
I would like something like... Daily, at... let's say 3a.m., a database to be saved as gzip and emailed to me. Drathbun was saying about MySQL dump, but if I'm not wrong, if you take a dump from your phpMy Admin is different from the one take from the Administrator Panel. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
Posted: Tue Dec 23, 2008 2:50 pm Post subject: Re: Automatic Database saving |
|
|
Some free are existing, just google it |
|
Back to top |
|
|
drathbun Board Member
Joined: 24 Jul 2008
Posts: 729 Location: Texas
|
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Tue Dec 23, 2008 3:15 pm Post subject: Re: Automatic Database saving |
|
|
This is the Firefox add on I was speaking of.
Yes its an external program from phpbb2 but it should still work and its free.
[FireFox Add On] IMacros for FireFox
It claims to be able to automate any function. _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Tue Dec 23, 2008 5:15 pm Post subject: Re: Automatic Database saving |
|
|
@ Drathbun: I did not know that. So if I have MODs, the database from AP isn't good enough. But if I save it from My SQL, I still need the files?
@ Cowboy: I have to try it out, but I guess my computer has to be opened and maybe even the browser, so I can't take automatic saves at 3 am. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
|