Tips and Tricks

Efficient Backup of MySQL Databases

phpMyBackupPro

By Catalin Bocanu, Web News Editor

6th of March 2008, 15:35 GMT

Adjust text size:

There are many types of applications running on server side and driven by MySQL databases. In case you need to update a certain application or change the web host, you will

have to perform a backup of the MySQL database.

For example, any MySQL database management program allows you to run a mysqldump command and, as a consequence, a backup file will be created. But this method of backup for MySQL databases could not be so easy to implement for beginners.

phpMyBackupPro is a multiuser backup tool for MySQL databases made in PHP that requires only a personal computer having support for PHP applications and a web browser Javascript enabled. It is operating system independent and provides to beginner webmasters an intuitive alternative for MySQL database backup in a visual manner by using a web-browser-based user interface.

The phpMyBackupPro application is also very easy to install: you just have to extract the distribution archive contents to in the public html directory of your web server. The next step is to configure the MySQL user details by calling in your browser address bar the config.php file and give 0777 permissions to directory export and global_conf.php file. In the application installation notes there is also indicated how to secure the phpMyBackupPro installation.

phpMyBackupPro provides interesting backup options, like the simultaneous backup of two or more databases, scheduled backups at various time intervals, the possibility of receiving the backup files in email and so on. You will be able to select, from the export alternatives such as entire database content, only the database table structure and more. When you need to restore one ore more databases, the Import menu must be used. Even simple sql queries could be performed through the phpMyBackupPro interface.

In essence, this tool is very easy to use by beginners and provides multiple features and configuration options for MySQL databases backup. It is recommended to leave the default values of Extended Configuration and System Variables parameters unchanged, in order to avoid unnecessary errors. phpMyBackupPro will save you a lot of time of organizing strategies of MySQL databases backup.

TAGS:

MySQL Database Backup | MySQL Backup | Database Management | Database Tools | MySQL Server

SEARCH THE NEWS ARCHIVE :

Today's News | Yesterday's News | News Archive

User opinions:

No user comments yet.

Be the first to express your opinion using the form below!

Share your opinion:

SUBMIT PROGRAM \| ADVERTISE \| GET HELP \| SEND US FEEDBACK \| RSS FEEDS \| ENTER NEWS SITE \| ENGLISH BOARD \| ROMANIAN FORUM
© 2001 - 2008 Softpedia. All rights reserved. Softpedia™ and the Softpedia™ logo are registered trademarks of SoftNews NET SRL.	Copyright Information \| Privacy Policy \| Terms of Use \| Update your software \| Archive

NEWS CATEGORIES: