$ftp_user_name = "ftp_username"; // FTP username $ftp_user_pass = "******"; // FTP password $ftp_path = "/"; // This is the path to upload on your ftp server! // Do not Modify below this line! It will void your warranty! $date = date("mdy-hia"); $filename = "{$dbname}-{$date}.sql"; $scriptname = "mysqldump -R --add-drop-table --skip-extended-insert --add-locks --quote-names --lock-tables -h {$dbhost} -P {$port} -u {$dbuser} -p{$dbpass} {$dbname} -q> {$filename}"; echo $scriptname; passthru($scriptname); # sleep for a few seconds to enable the script to complete under load sleep(5); # remove the definer statements from the views $result = $s->removeMySQLViewDefinerInformation($filename); if ($result) { # no errors echo "Removed definer information from script"; } else { echo $result; } # sleep for a few seconds to enable the script to complete under load sleep(5); if ($use_gzip == "yes") { $zipline = "tar czf " . $dbname . "-" . $date . "_sql.tar.gz {$dbname}-{$date}.sql"; shell_exec($zipline); } if ($remove_sql_file == "yes") { exec("rm -r -f {$filename}"); }