Ezilon.com - Target Your Audience, be Seen in Your Region

auto mysql backup without cron

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

They have: 21 posts

Joined: Apr 2006

hi, is there anyway to make automatic mysql backups without using cron jobs?

Busy's picture
Modrater

He has: 6,157 posts

Joined: May 2001

Does manually count?
could do it thru sql command or with phpmyadmin etc

They have: 21 posts

Joined: Apr 2006

not really, i really want to get it done automaticlly, if not whats the easiest manual way?

Busy's picture
Modrater

He has: 6,157 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

<?bhb if(broken){ echo("It wasn't me Smiling "); } ?>
Learn HTML the ez way - EzHTML.net

Some people are like slinkies, they dont really serve any purpose but they still bring a smile to your face when you push them down the stairs ...

They have: 21 posts

Joined: Apr 2006

so theres no automatic way??

timjpriebe's picture
DeveloperModeratorSponsor

He has: 2,666 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.

They have: 21 posts

Joined: Apr 2006

i really dont understand what your saying

timjpriebe's picture
DeveloperModeratorSponsor

He has: 2,666 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?