Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Backing up Database


grantjm

Recommended Posts

Hello,

 

I would like to install some of the contributions. But before I embark on this seemingly daunting task - I would like to "backup " my Database etc.

 

I went here "

]http://www.oscommerce.com/community/contri...ons,847"[/url]

and found the contribution to do the backup.

 

My question is it says:

 

# this mod allows you to keep a defined number of old backups

# this should be run from a crontab

What is a "crontab"?

BG

 

Making the internet community better. Knowledge is power.

Link to comment
Share on other sites

You can run a backup from your admin section of the Catalog. You will need to go to Tools > Database Backup. You will find the first time you do this, you will get some errors. You will need to edit your configure.php in admin/includes/ and setup the backup directory. You will then need to create that directory in your admin folder:

 

Line 39

define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

This means I have a directory structure like this

/home/web/catalog/admin/backups
See what I'm doing?

You will then need to set the permissions on this, im not sure what you would need to do in Windows (i'm pure Linux) but in Linux you would need to do

chmod 644 backups/
I believe 644 is the correct number. Then go to create your backup. You will know when it works, cos you can download the backups. I always download the backups. I find it more safer that way. That is why my directory is CHMOD 777 because I just use it as a jail to create the backup.

 

Crontab:

A crontab is a Linux/Unix script that will do an action that you ask. If you don't understand them, I would suggest that you don't try to use them. They can be very difficult.

FYI the command to create a crontab is

crontab -e
as a user in your Linux/UNIX system.

 

Hope this helps :)

Kindest Regards,

 

Carl Pickering

 

If there is light at the end of the tunnel, switch it off. I have to save on my electricity bill

Link to comment
Share on other sites

Thank you. It looks like it worked.

 

Another thing,

 

How can I test the integrity of the "backed up" Database?

BG

 

Making the internet community better. Knowledge is power.

Link to comment
Share on other sites

Thank you. It looks like it worked.

 

Another thing,

 

How can I test the integrity of the "backed up" Database?

 

Look at the size I guess. I don't believe there is any way. What the backup does it run a standard MySQL server command mysqldump. That command is very good. So in all honesty, I don't know!. *shrug* Try it, see what happens.

Kindest Regards,

 

Carl Pickering

 

If there is light at the end of the tunnel, switch it off. I have to save on my electricity bill

Link to comment
Share on other sites

You could restore the backup to a test site. You can look at the backup in wordpad just make sure it at least looks like text.

In olden times the men were made of iron and the ships were made of wood; now it's the other way around. :wink:

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...