Backup
SyncBack 3.2.26- Backup and synchronization software
SyncBack has established itself as world-class in the field of backup and synchronization software. Whether you’re a beginner or advanced user, at home or work, SyncBack ensures your most valuable asset, data, remains protected. Backup – Protect your data Restore – Recover your lost files easily Copy Open Files – Backup live documents Versioning – Keep previous versions Incremental [...]
Macrium Reflect – Backup and Hard Disk Imaging for Windows
A complete disaster recovery solution for your home and office. Protect your personal documents, photos, music and emails. Upgrade your hard disk or try new operating systems in the safe knowledge that everything is securely saved in an easily recovered backup file. Create a single backup file of one or more folders on your hard [...]
How to Backup the entire Mysql Server Databases
To backup the entire database of a Mysql Server use the mysqldump command, Please look at the below stated command.In that we are backing up the entire database to a file called dump_file21102009 mysqldump -u root -p –all-databases –master-data=2 > dump_file21102009
Easeus Todo Backup Performs Backups for Free
Back up entire partitions, restore partitions and individual files for free with the highly useful Easeus Todo Backup. More: continued here
How to Compress your Backup file on the Fly – MySQL
Since mysqldump sends its output to the console, we can pipe the output through gzip or bzip2 and send the compressed dump to the backup file. Here’s how you would do that with bzip2 and gzip respectively. mysqldump –all-databases | bzip2 -c >databasebackup.sql.bz2 mysqldump –all-databases | gzip >databasebackup.sql.gz
How to Backup Multiple Databases in MySQL
How about backing up all the databases in the server? That’s an easy one, just use the –all-databases parameter to backup all the databases in the server in one step. mysqldump –all-databases> alldatabases.sql
How to Backing up only the Database Structure in MySQL
Most developers need to backup only the database structure to while they are developing their applications. You can backup only the database structure by telling mysqldump not to back up the data. You can do this by using the –no-data parameter when you call mysqldump. mysqldump –no-data –databases Customers Orders Comments > structurebackup.sql
How to Backing up only specified tables in MySql
The syntax is as Follows mysqldump –add-drop-table -u sadmin -p pass21 Customers customer_master customer_details> custback.sql So the syntax for the command to issue is: mysqldump -u [username] -p [password] [databasename] [table1 table2 ....] [tables] – This is a list of tables to backup. Each table is separated by a space.
How to configure backup and restore Cisco Routers switches using a FTP Server
To backup a Cisco Router or Switch to a FTP server, the FTP server should be reacheable from the router or switch. Logon to the Router/switch and enter the Privilege Exec mode using the enable password. Enter Global Configuration mode ciscorouter# conf term Configure FTP User ciscorouter(config)# ip ftp username confback ciscorouter(config)# ip ftp password [...]
How to Backup and Restore Mysql Databases
Sometimes you may want to backup only one or more tables from a database. There are some practical reasons for wanting to do this. You may have a message board / forums application that uses MySQL to store its data and you want to create a brand new forum with the same users as the [...]
How To Grant/Deny Access to Particular Web Files Using Apache
When browsing web files and directory, most bots, without consideration to .htaccess restrictions, have the capability to crawl and sniff files and folders located under your web root folder, even if these files and folders were not visually displayed from your web pages. Take for an example, you displayed a file under http://domain.com/folder1/folder2/folder3/page.html Most bots [...]
Script to backup all mysql database and upload to FTP
In this howto I will show you a simple bash script that dump ALL mysql databases on your server compressed to GZIP and then make a nice tar.gz file with them and upload it to the FTP of your choice.
Database Replication in MySQL – Step by Step Guide
Replication enables data from one MySQL database server (called the master) to be replicated to one or more MySQL database servers (slaves). Replication is asynchronous – your replication slaves do not need to be connected permanently to receive updates from the master, which means that updates can occur over long-distance connections and even temporary solutions [...]