Category Archives: Uncategorized

How to Automatically Backup phpMyAdmin

full backup, sql backup job, Uncategorized

The fact is that hosting your website on a shared hosting most probably means that the only way to access your MySQL database would be through phpMyAdmin. Moreover, regular backups are still the most efficient way to protect your data, and making this process automatic with phpMyAdmin will make this routine much easier.

The good news is that SQLBackupAndFTP allows its users to backup their MySQL Server databases by connecting not only directly via TCP/IP, but also via the web interface of phpMyAdmin. Now, this process allows it to work for practically every website, including with the cheapest shared hosting. Continue reading How to Automatically Backup phpMyAdmin →

How to Backup MySQL to Google Drive

full backup, how to backup, Uncategorized

Considering that today Google giant provides its users with a reasonably priced storage space featuring a user-friendly interface, why not consider backing up your MySQL Backups to Google Drive. The question here is that it is not at all convenient and efficient to continue sending your MySQL database backups made with mysqldump to Google Drive manually. But don’t worry, the solution is closer than you think – try using SQLBackupAndFTP. Continue reading How to Backup MySQL to Google Drive →

SQL Server Backup to Backblaze B2 Cloud Storage

full backup, SQL Server, Uncategorized

backblaze logoWith SQLBackupAndFTP you can schedule automatic SQL Server backups and send them to Backblaze B2 Cloud Storage just in a few clicks. Backblaze B2 offers affordable pricing for storing your backups: just $0.005/Gb for storage and $0.02/Gb for download. This is about 3 times cheaper than to store in Amazon S3, Microsoft Azure, or Google Cloud. Continue reading SQL Server Backup to Backblaze B2 Cloud Storage →

Backup SQL Server on the network

differential, sql backup job, Uncategorized

SQLBackupAndFTP creates standard *.bak files when it runs locally on the same computer where SQL Server is. For remote SQL Server computer backups SQLBackupAndFTP creates backup script files (*.sql). Whenever possible, you should always opt for *.bak backups against *.sql backup files.

Here we will show you how to backup a SQL Server on the network to the standard *.bak file even when SQLBackupAndFTP runs on a different computer from where the SQL Server is. The main requirement, in this case, is that both SQL server and SQLBackupAndFTP have access to the same shared network folder.

Continue reading Backup SQL Server on the network →

How to Make SugarCRM Backup

amazon, network drive, Uncategorized

sugarcrm logoToday over 50,000  companies use SugarCRM globally for their customer management, sales automation, and other CRM needs. SugarCRM can be installed as an on-premise solution or as a SaaS (Software-as-a-Service) solution. Managing SugarCRM means that you have to work with a huge flow of information that is stored in large databases. Clearly, when working with databases one has to take care of their security, and that implies making backups on a regular basis. Now let’s check how to use SQLBackupAndFTP for regular SugarCRM backups.
Continue reading How to Make SugarCRM Backup →

How to set up SQL Server Email Job Notifications

Database Backup, sqlbackupandftp, Uncategorized, ,

As a DBA, automating your various jobs on SQL Server – taking backups, truncating logs, updating statistics, etc – is a good idea because it makes sure you don’t have to depend on your feeble memory for these important tasks. And it leaves you free for more vital tasks such as sleeping and bingeing on whatever new Netflix series is out. But to make sure your automated tasks are still running, you need a good notification method, and it should also be automated. And foolproof. So how do you do this? Continue reading How to set up SQL Server Email Job Notifications →

Top 2014 News of Database – the fall of Microsoft Azure SQL Prices

security, Uncategorized

Microsoft has not ceased in its bid to attract more and more enterprise customers onto their Azure cloud computing system, with all their databases in tow of course. This came shortly after the company disclosed to the public a preview of Azure’s enhanced security auditing feature. With the fall, the company announced its intention to change its cloud-based computing and database offering to make it more affordable. Continue reading Top 2014 News of Database – the fall of Microsoft Azure SQL Prices →