Web Hosting Forum | Lunarpages

Author Topic: Site and MySQL backups via cron  (Read 125571 times)

Offline scanman20

  • Senior Moderator
  • Über Jedi
  • *****
  • Posts: 1549
    • http://www.notonebit.com
Site and MySQL backups via cron
« Reply #30 on: February 05, 2005, 06:21:37 AM »
Are you running this script on your LP account or from another server? Where is the FTP server you're uploading tha backup to? The first issue seems to be that your backup is never created. I'd begin there.
Even a broken clock is right twice a day.
NotOneBit.com
MCSE - MCSA - MCP (<- unused since 2006!)

Offline mnemonik23

  • Trekkie
  • **
  • Posts: 11
Site and MySQL backups via cron
« Reply #31 on: February 05, 2005, 09:20:21 AM »
LP account, server: krypton. Uploading to the same place(my LP account on krypton).

I'm trying to test it from browser(before cron) and I see those errors on the screen...

Offline scanman20

  • Senior Moderator
  • Über Jedi
  • *****
  • Posts: 1549
    • http://www.notonebit.com
Site and MySQL backups via cron
« Reply #32 on: February 05, 2005, 01:26:53 PM »
Does krypton have the ability to run exec()? I'm guessing it doesn't which is why the zipped file isn't created.
Even a broken clock is right twice a day.
NotOneBit.com
MCSE - MCSA - MCP (<- unused since 2006!)

Offline mnemonik23

  • Trekkie
  • **
  • Posts: 11
Site and MySQL backups via cron
« Reply #33 on: February 05, 2005, 05:47:43 PM »
I see.

Thanks!

Offline canadian psycho

  • Newbie
  • *
  • Posts: 1
    • http://www.maddoxmania.com
Site and MySQL backups via cron
« Reply #34 on: March 10, 2005, 05:41:30 PM »
hey hola and howdy,

This script is super perfect for what I and the people who visit the site I am administrating need.  A nightly backup of our web forum that just gets plopped on to the FTP....but...as perfect as I am assuming this is for our needs, I have even less then no idea how to implement it.  I know next to nothing about cron jobs and I'm not even sure how to set up the variables in the script.  So far as I can tell it would be the first of the three scripts listed that i would need but...yah...how would I implement it?  Can anyone help me on this one?

Cheers

Offline fambi

  • Spacescooter Operator
  • *****
  • Posts: 46
    • http://www.smscomms.com/
Site and MySQL backups via cron
« Reply #35 on: March 12, 2005, 11:51:20 AM »
Fantastic! Thanks scanman (and Danielle ofcourse).
Lunarpages provided us with the first ever server for our sms gateway.

Offline JohninLA

  • Spacescooter Operator
  • *****
  • Posts: 35
Site and MySQL backups via cron
« Reply #36 on: April 23, 2005, 08:25:09 AM »
Alright, I am trying to run this script, and having problems.

Here is what I entered into my script file:

$filename= "home/public_html/pphbb/backup/Full_Account_Backup-$datestamp.tar";
$filename = "home/public_html/pphbb/backup/" . $filename . ".gz";(This is the path to my backup script and folder.)

Then the command I entered to run the script is:

php -q home/MY LP USERNAME/public_html/pphbb/backup/database_backup.php

I keep getting errors that "No input file is specified."

What am I doing wrong? And last, before I continue trying to get this to run, does anyone know if you can run the exec command on the LEO server?

Thanks for any help.

Danielle

  • Guest
Site and MySQL backups via cron
« Reply #37 on: April 23, 2005, 10:17:58 AM »
That path doesn't include your cPanel username in it:

home/cPanelusername/public_html/phpbb/backup/

Did you actually have /home/public_html as the beginning of the path?

Also, Leo has exec() disabled, so if you need to use as you would for this script, you'd need to go to a server like Deneb instead.

Offline JohninLA

  • Spacescooter Operator
  • *****
  • Posts: 35
Site and MySQL backups via cron
« Reply #38 on: April 23, 2005, 12:11:42 PM »
Thanks Danielle, since Leo is disabled, I guess it doesn't matter too much.  So, it's not possible to automate the backup procedure on Leo? I could just do it manually as I have been, but it was nice to not have to worry about it.

I did have my cpanelusername listed as I showed above, in the job command run, but not in the file itself. I was confused as to exactly how to list the filenames in the script itself. So to run the script itself, I was using:

php -q home/cpanelusername/public_html/pphbb/backup/database_backup.php

Is this not correct? And what exactly do I list as the "filename" in the script itself?

Thanks!

Offline JohninLA

  • Spacescooter Operator
  • *****
  • Posts: 35
Site and MySQL backups via cron
« Reply #39 on: June 05, 2005, 07:02:28 PM »
Hi Danielle, I have been having the same problem that I wrote about several months ago. I am using the script provided above, "Site Backup via Cron." I am receiving error messages that "exec" is disabled.

I would also like to back daily backups, but am not sure how to go about it. Someone had suggested to me that I ask that my site be moved to another server where exec is enabled, but that doesn't seem easy.

How can I create a cron job to do a daily backup of my site that will work on the "leo" server?

Thanks.

Danielle

  • Guest
Site and MySQL backups via cron
« Reply #40 on: June 05, 2005, 11:47:39 PM »
Hi JohninLA,

It is actually easy to move to another server. Just email support@lunarpages.com and provide the last 4 digits of your card on file with us (no charges apply) and your cPanel username along with authorization to perform the move and why you want to move (for exec()).

scanman's script requires exec() so you cannot run it unless you are on a server with that. We do the move for you and there is nothing on your end you would need to do other than make a backup in cPanel if you'd prefer before you moved (click on Backup in cPanel, then on "Generate/Download a Full Backup" to ensure you have a copy of the account.  We keep a copy on Leo even after the move to the new server as well for 4-5 days. Again, I'm not sure why it wouldn't be easy to move. We do moves all the time (most staff doing from 5-20 moves per day).

Thanks.

Offline wip3ouT

  • Space Explorer
  • ***
  • Posts: 9
Site and MySQL backups via cron
« Reply #41 on: June 21, 2005, 02:15:34 AM »
Hi Danielle,

My site is on electra, and I was wondering if I ask to lunar staff to move me to an "exec()" enabled server, whether I will have to change some of my website settings. For example: i have smtp settings pointing to electra.lunarpages.com? What will happen? Do I have to change those settings?

Regards,

Wip3ouT.

Danielle

  • Guest
Site and MySQL backups via cron
« Reply #42 on: June 21, 2005, 03:30:43 AM »
Hi wip3ouT,

Yes, you would have to change those settings to the new server's name instead since you wouldn't be on Electra anymore.  I would suggest, however,  to your domain name instead in the format domain.com for POP3 and SMTP.

Thanks.

Offline wip3ouT

  • Space Explorer
  • ***
  • Posts: 9
Site and MySQL backups via cron
« Reply #43 on: June 21, 2005, 12:57:21 PM »
Thanks a mil' Danielle :thumb:

Danielle

  • Guest
Site and MySQL backups via cron
« Reply #44 on: June 21, 2005, 01:35:03 PM »
You're very welcome wip3ouT  :D

 

Share |