backup

In MySQL, what are the practices to backup databases?

I am using mysql How often do you back up your database? How do you normally backup your database? Export all data into sql or cvs format and keep it in a folder?? ...

Compressing a directory of files with PHP

I am creating a php backup script that will dump everything from a database and save it to a file. I have been successful in doing that but now I need to take hundreds of images in a directory and compress them into one simple .tar.gz file. What is the best way to do this and how is it done? I have no idea where to start. Thanks in ad...

Suggestions for backing up php site and mysql db

Hi, do you have any good suggestions how to backup remote php site and mysql, and upload it to another remote ftp? I do have shell access and it is linux system. Kind of lame question when I post it like that, but I assume some script would have to be run on remote server with site, that would do this. If you don't mind sharing your i...

How does backup work in SQL server?

Hi, Let's say I have a very large database. Its backup starts at midnight and finishes at 02:00 am. When I recover that backup am I gonna have the state of the database at midnight or 02:00 (or something else)? Going one step further, let's say that I have multiple databases which contain references to each other's elements. If I back...

Does restoring a backup of IIS6 restore the GAC?

I was wondering: if I have some DLLs in the GAC - will they get restored if I restore a backup of IIS6 on a fresh Windows 2003 box? Or will I need to backup/rebuild the GAC separately from IIS? ...

How to take backup of BugTracker.net ?

Hi All, I want to take backup of BugTracker.Net hosted on my local and restore it to a new machine ? Has any one clue about this ? Thanks ...

How critical are transaction logs after a full backup of a SQL2005 database?

How critical are transaction logs after a full backup of a SQL2005 database? Example: I have a database called Test and I don't care about point in time recovery using transaction logs except that I might want to revert back to the database version taken at the time of the last FULL backup. Now, in the backups directory I have a FULL b...

How to take complete backup of mysql database using mysqldump command line utility

Hi All, Can anyone provide any input on how to take complete backup of mysql database using mysqldump. when I am taking backup my tables from specified database are only getting backed up not the procedures and functions. Here's the backup command I am using : Operating system i am working on Windows Vista mysqldump -u username -p db1...

How to restore mysql database

Hi All, I have taken the backup of mysql database but when I am trying to restore it my stored procedures are not getting restored. Is there any way like for backup we use --routines in mysqldump command. Can we do any such thing in mysql. If I am using mysqldump then it is just dumping mysql tables but if I am using mysql command to ...

FTP - Only want to keep latest 10 files - delete LRU

Hey everyone, I have created a shell script to backup my webfiles + database dump, put it into a tar archive and FTP it offsite. Id like to run it X times per week however I only want to keep the latest 10 backups on the FTP site. How can I do this best? Should I be doing this work on the shell script side, or is there an FTP command t...

How to backup SQL Server Agent jobs?

How can I backup and restore SQL Server 2005 Agent job schedules? ...

Want to create a script that takes backup of entire database and downloads it

Hi guys, I've built a simple cms with an admin section. I want to create something like a backup system which would take a backup of the information on the website, and also a restore system which would restore backups taken. I'm assuming backups to be SQL files generated of the tables used. I'm using PHP and MySQL here - any idea how ...

need to implement versioning in Online backup tool.

Hi Guys, I am working on the developement of a application that will perform online backup of the files and folder in the PC, automatically or manually. Currently, I was keeping only the latest version of the file at the server.Now, I have to implement the versioning so that only the changes can be transfered to the online server and us...

[SOLVED] How to copy a SQL 2005 database to another computer?

I'm trying to rebuild a web server in a virtual pc. Installed required software and Microsoft SQL Server 2005. I've had full backups of my databases but it is not possible to restore from those backups in this new installation. By the way, backups are fine, i can restore from them on original server. In summary, how can I copy whole dat...

Are CLR DLLs mirrored when using SQL Server Mirroring?

I have a SQL Server database (2008) within which I have some CLR DLLs that SQL uses for various things. Are these DLLs mirrored when I use SQL Mirroring? Our DBA says not, but I find this crazy and cannot find much info on it online. Is it possible to mirror the CLR DLLs? ...

SQL Server 2005 Perform "RECOVERY" on database restored with "NORECOVERY"

I have full weekly backups, daily differential backups and hourly transaction log backups. To restore the database, I restore the full backup, then the last dif backup then all the transaction log backups specifying NORECOVERY on all the restores except the last one. My question is. If I accidently restore my last transaction log with ...

VBS Script: Copy directories listed in web file from Windows machine to Unix/Samba Share

[Outline] Hello Folks. In the home here we have five windows PC's running various editions of XP and Vista. As a backup solution, we have a file server with ample space for backups to be made too. Some of the users are not very competent at remembering to back their files up. I'd like to run a script on shutdown of a machine to fetch a ...

RAR Each folder in directory.

Hi All, Im only new to liux commands and spend most of my time in VB, after searching the web its hard to find a solution in google. Anyway...... Everyday I backup my Shares folder and ends up being 183 GIG, I tried many ways of backing it up and come to the conclusion that using rar was the best option for my enviroment. So this is th...

Does Amazon S3 make any sort of guarantees on your data?

I've read over the agreements several times, and I can't find anything that guarantees Amazon will not lose or corrupt your data. Do they make any such guarantees? Can I trust S3 as my long term backup storage? ...

Backup Through LAN network

I tried to take a SQL Server 2008 database backup from the server which has the following features: server: windows server 2008 os to the client which has the following features: client:windows xp service pack 3 os through lan network, but I couldn't achieve it and i am getting the following error: **Msg 3201, Level 16, State 1, Lin...