auto mysql backup without cron

They have: 18 posts

Joined: Apr 2006

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

Busy's picture

He has: 6,151 posts

Joined: May 2001

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

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's picture

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

They have: 18 posts

Joined: Apr 2006

so theres no automatic way??

timjpriebe's picture

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.

They have: 18 posts

Joined: Apr 2006

i really dont understand what your saying

timjpriebe's picture

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?

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.