/* * Copyright (C) 2007-2012 Argeo GmbH * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.argeo.maintenance.backup.vfs; import org.apache.commons.vfs2.FileObject; /** Backups a MySQL database using mysqldump. */ public class MySqlBackup extends OsCallBackup { private String mysqldumpLocation = "/usr/bin/mysqldump"; private String dbUser; private String dbPassword; private String dbName; public MySqlBackup() { } public MySqlBackup(String dbUser, String dbPassword, String dbName) { this.dbUser = dbUser; this.dbPassword = dbPassword; this.dbName = dbName; init(); } @Override public void init() { if (getName() == null) setName(dbName + ".mysql"); super.init(); } @Override public void writeBackup(FileObject targetFo) { if (getCommand() == null) setCommand(mysqldumpLocation + " --lock-tables --add-locks --add-drop-table" + " -u ${dbUser} --password=${dbPassword} --databases ${dbName}"); getVariables().put("dbUser", dbUser); getVariables().put("dbPassword", dbPassword); getVariables().put("dbName", dbName); super.writeBackup(targetFo); } public void setDbUser(String dbUser) { this.dbUser = dbUser; } public void setDbPassword(String dbPassword) { this.dbPassword = dbPassword; } public void setDbName(String dbName) { this.dbName = dbName; } public void setMysqldumpLocation(String mysqldumpLocation) { this.mysqldumpLocation = mysqldumpLocation; } }