You could set it up via a page, have the page called cron.php (or whatever) and include/require the page in one of your sites pages.
Depending on how often you need it done and how busy your site is as to which page.
It's semi automatic.
Manually, depends on the size of the database, if it's really big you may have to do each table seperatly
Sure, there's an automatic way. I have a Perl script I wrote that backs up our database here to another database. (ie Our live DB is backed up to our development DB) Just throw it in there as a chron job, and you're good to go.
Do you have any scripting skills, dani190? If not, I'm sure one specific to your needs could be found somewhere online.
Edit: Just reread your message and saw that you can't have chron jobs. There has to be something to trigger the process. As long as the process doesn't take too long, you could include something in the main page of your site that triggered it. Just make sure it also checks to see if it's been done that day already.
That way, as long as anyone visited your site that day, it would be executed.
Trying to do it without chron jobs is like taking a person who naturally oversleeps and trying to get them to wake up in the mornings without an alarm clock. You still will need something to wake them up. Maybe a friend could call them on the phone, maybe someone can come over and knock on their door.
The same thing applies to backing up your database. If you don't have it on a chron job, you still have to have something that tells it to back up. However, anything other than a chron job is likely to take a bit of programming skills.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.
Busy posted this at 22:50 — 1st April 2006.
He has: 6,151 posts
Joined: May 2001
Does manually count?
could do it thru sql command or with phpmyadmin etc
dani190 posted this at 22:57 — 1st April 2006.
They have: 18 posts
Joined: Apr 2006
not really, i really want to get it done automaticlly, if not whats the easiest manual way?
Busy posted this at 10:29 — 2nd April 2006.
He has: 6,151 posts
Joined: May 2001
You could set it up via a page, have the page called cron.php (or whatever) and include/require the page in one of your sites pages.
Depending on how often you need it done and how busy your site is as to which page.
It's semi automatic.
Manually, depends on the size of the database, if it's really big you may have to do each table seperatly
dani190 posted this at 15:01 — 2nd April 2006.
They have: 18 posts
Joined: Apr 2006
so theres no automatic way??
timjpriebe posted this at 12:46 — 3rd April 2006.
He has: 2,667 posts
Joined: Dec 2004
Sure, there's an automatic way. I have a Perl script I wrote that backs up our database here to another database. (ie Our live DB is backed up to our development DB) Just throw it in there as a chron job, and you're good to go.
Do you have any scripting skills, dani190? If not, I'm sure one specific to your needs could be found somewhere online.
Edit: Just reread your message and saw that you can't have chron jobs. There has to be something to trigger the process. As long as the process doesn't take too long, you could include something in the main page of your site that triggered it. Just make sure it also checks to see if it's been done that day already.
That way, as long as anyone visited your site that day, it would be executed.
Tim
http://www.tandswebdesign.com
dani190 posted this at 03:08 — 7th April 2006.
They have: 18 posts
Joined: Apr 2006
i really dont understand what your saying
timjpriebe posted this at 14:12 — 7th April 2006.
He has: 2,667 posts
Joined: Dec 2004
Trying to do it without chron jobs is like taking a person who naturally oversleeps and trying to get them to wake up in the mornings without an alarm clock. You still will need something to wake them up. Maybe a friend could call them on the phone, maybe someone can come over and knock on their door.
The same thing applies to backing up your database. If you don't have it on a chron job, you still have to have something that tells it to back up. However, anything other than a chron job is likely to take a bit of programming skills.
Does that make a bit more sense?
Tim
http://www.tandswebdesign.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.