MySQL Forums
Forum List  »  Newbie

Re: Need a SIMPLE and COMPLETE Backup Tool
Posted by: Peter Brawley
Date: April 18, 2013 01:39PM

> I go away shaking my head in disbelief that there is not a high level tool that does not require much knowlege from the user.

If there were a big demand for such a GUI tool you so fervently believe ought to exist, probably someone would have written it.

Why isn't there such a demand? Perhaps because the concept of administering an RDBMS without adequate technical knowledge is oxymoronic, also perhaps because DBAs tend to find GUI interfaces for backing up databases frustrating.

MySQL WorkBench offers a GUI "Data Export" interface, but it requires informed user choices.

You could automate backups by customising something like this ...

@echo off
if exist %1\mysqlbak.sql del %1\mysqlbak.sql
"%mysql_home%\bin\mysqldump" -uUSR -pPWD -A --add-drop-database -K -E -R >%1\mysqlbak.sql
dir %1\mysqlbak.sql

substituting your username & password, adding error reporting, and putting a link to the script on your desktop.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.