cardinal_pythonlib.tools.backup_mysql_database


Original code copyright (C) 2009-2022 Rudolf Cardinal (rudolf@pobox.com).

This file is part of cardinal_pythonlib.

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

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.


Command-line tool to back up a MySQL database to disk, via mysqldump.

cardinal_pythonlib.tools.backup_mysql_database.cmdargs(mysqldump: str, username: str, password: str, database: str, verbose: bool, with_drop_create_database: bool, max_allowed_packet: str, hide_password: bool = False) List[str][source]

Returns command arguments for a mysqldump call.

Parameters:
  • mysqldumpmysqldump executable filename

  • username – user name

  • password – password

  • database – database name

  • verbose – verbose output?

  • with_drop_create_database – produce commands to DROP the database and recreate it?

  • max_allowed_packet – passed to mysqldump

  • hide_password – obscure the password (will break the arguments but provide a safe version to show the user)?

Returns:

list of command-line arguments

cardinal_pythonlib.tools.backup_mysql_database.main() None[source]

Command-line processor. See --help for details.