0
I Use This!
Activity Not Available

Project Summary

SummaryA python script used to copy a MySQL database (including all relevant privileges) from one host to another, used as a wrapper around mysql and mysqldump.

For a full run down of usage instructions and options, run: mysql_copy_database -h

To test the script without making any changes, run: mysql_copy_database --dry-run

The script works roughly as follows:

You'll be prompted for source/destination host information, and the name of the DB to copy mysqldump will be used to dump the database to a temporary file The dumped database is re-created on the destination host The script will search for grants that appear relevant to the database on the source host You'll be prompted to apply each grant to the destination host

And that's it!

It's currently been tested on various linux and solaris systems, with MySQL versions 4 and 5.

To change any of the basic configuration settings, just edit them within the Settings class at the top of the file. All options should be documented within it.

Any comments/suggestions/feature requests are more than welcome.

RequirementsSoftwareMySQL client The script uses the mysql and mysqldump binaries, and looks for them in /usr/bin unless an alternative location is specified in the script's settings.

Python ModulesThe follow python modules are used by the script:

MySQLdb pexpect

Tags

command-line database mysql python utility

In a Nutshell, mysql-copy-database...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

GNU General Public License v3.0 or later
Permitted

Commercial Use

Modify

Distribute

Place Warranty

Use Patent Claims

Forbidden

Sub-License

Hold Liable

Required

Distribute Original

Disclose Source

Include Copyright

State Changes

Include License

Include Install Instructions

These details are provided for information only. No information here is legal advice and should not be used as such.

All Licenses

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    compare projects before you chose one to use
  • ...
    there are over 3,000 projects on the Open Hub with security vulnerabilities reported against them
  • ...
    learn about Open Hub updates and features on the Open Hub blog

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis