Database backup Error 400

[pafranklin]

Hi there, I seem to be unable to backup my database for some reason.

 

When I go to Tools, Database Backup and click on backup (no compression button hghlighted), I receive a 400 error (INTERNAL SERVER ERROR, An internal server error has occured! Please try again later.)

 

However when I look back on the page it appears as though a partial backup has been done (but not completely).

 

Please can someone help? I am very worried about loosing data and not being able to backup / restore. :'(

[usernamenone]

You will need to add the folder

 

backups

 

to your admin folder.

 

I known, it seems silly that oscommerce does not come with it as adding a blank folder is such an easy thing to add but what the heck just add the blank folder and the do your backup

[pafranklin]

You will need to add the folder

 

backups

 

to your admin folder.

 

I known, it seems silly that oscommerce does not come with it as adding a blank folder is such an easy thing to add but what the heck just add the blank folder and the do your backup

Hello, Thank you for the reply. I do have the backups folder and have tried changing the permissions to 700, 755 etc but this makes no difference. Any other ideas please?

[pafranklin]

Hello, Thank you for the reply. I do have the backups folder and have tried changing the permissions to 700, 755 etc but this makes no difference. Any other ideas please?

Help!! I still cannot backup the database. Any ideas please would be very gratefully received!!!

[Guest]

Help!! I still cannot backup the database. Any ideas please would be very gratefully received!!!

 

 

Hi Paul - your browser is timing out on you.

 

Use phpMyAdmin to back up your database. Just login to phpMyAdmin, select your db from the drop down list, hit Export, and click the checkbox to save the file locally.

 

 

If your data is critical to your business (stupid question of course) then you should be cronning this process anyway! :

http://www.dagondesign.com/articles/automa...-backup-script/

 

or :

http://sourceforge.net/projects/automysqlbackup/

http://mike.kruckenberg.com/archives/2006/...ysqlbackup.html

 

Corrie

[pafranklin]

Hi Paul - your browser is timing out on you.

 

Use phpMyAdmin to back up your database. Just login to phpMyAdmin, select your db from the drop down list, hit Export, and click the checkbox to save the file locally.

If your data is critical to your business (stupid question of course) then you should be cronning this process anyway! :

http://www.dagondesign.com/articles/automa...-backup-script/

 

or :

http://sourceforge.net/projects/automysqlbackup/

http://mike.kruckenberg.com/archives/2006/...ysqlbackup.html

 

Corrie

Hi again Corrie,

Many thanks for the reply which is very useful. I have a real problem setting up Cron jobs with my host as they do not provide a graphical interface and you can only seem to use Putty (which has me a little lost). I will have a look at the two Mysql back up options that you kindly listed links for and to date I have been using the MySQL export options on a weekly basis.

 

Is there anyway to adjust the browser Time out, so that I can use the backup facility within OSC. Currently my database is approximately 16mb.

 

As always, many thanks for the help!!

 

Paul.

:-)

[Guest]

Hi again Corrie,

Many thanks for the reply which is very useful. I have a real problem setting up Cron jobs with my host as they do not provide a graphical interface and you can only seem to use Putty (which has me a little lost). I will have a look at the two Mysql back up options that you kindly listed links for and to date I have been using the MySQL export options on a weekly basis.

 

Is there anyway to adjust the browser Time out, so that I can use the backup facility within OSC. Currently my database is approximately 16mb.

 

That's surprising - 16 meg is nothing. The time out is set server side - not client side.

 

For your cron, upload your backup script into a new direcotory - or if you are using a Perl script, you have to dump it into the cg-bin directory.

Login using Putty.

If you have permissions :

 

To run your cron once a week, just go :

 

$ crontab -e

30 4 * * 0 root /path/to/your/script

 

Then type :

wq

to save and quit your cron.

To make sure it is there, type :

crontab -l

 

To make chnages, write the cron to a file like this :

$ crontab -l > mycron

$ vi mycron

Then make your changes, and hit :

wq

to save and quit.

Then type :

$ crontab mycron

 

Post back with any questions - or you have my email address as well.

 

Corrina

[Guest]

Hi again Corrie,

Many thanks for the reply which is very useful. I have a real problem setting up Cron jobs with my host as they do not provide a graphical interface and you can only seem to use Putty (which has me a little lost). I will have a look at the two Mysql back up options that you kindly listed links for and to date I have been using the MySQL export options on a weekly basis.

 

Is there anyway to adjust the browser Time out, so that I can use the backup facility within OSC. Currently my database is approximately 16mb.

 

here are the codes to specify when you want your cron to run Paul :

http://en.wikipedia.org/wiki/Cron

 

Corrie