Project

mysql_rake_tasks

0.0
No commit activity in last 3 years
No release in over 3 years
mysql_rake_tasksgregors/mysql_rake_tasksHomepageDocumentationSource CodeBug TrackerWiki
A collection of rails rake tasks for mysql.
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
2022
2023
2024
 Popularity
Downloads
26,219
Stars
5
Forks
0
Watchers
1
 Releases
Current version
1.0.0
Total releases
8
First release
2011-09-05
Latest release
2020-07-18
 Development
Primary Language
Ruby
Licenses
MIT
Average date of last 50 commits
2013-04-15
Reverse Dependencies
0

 Dependencies

Development

mocha
~> 0.9.12
rake
~> 13.0
test-unit-rails
~> 6.0

Runtime

mysql2
>= 0.2.7
 Project Readme

mysql_rake_tasks

A collection of rails rake tasks for mysql

  1. create_users - creates localhost mysql user accounts for each database listing in the database.yml
  2. stats - database stats - table size

Install

  1. Add mysql_rake_tasks to your gem file

gem 'mysql_rake_tasks', '~> 0.1.0'

  1. Run the bundle command

bundle install

Examples

create_users

To create mysql users in interactive mode run:

rake db:mysql:create_users mysql user: root mysql pass:

You can also specify your root username and password on the command line:

rake db:mysel:create_users[root,mypassword]

stats

To display database stats:

  rake db:mysql:stats
  +--------------------------------+---------------+-----------+----------+------------+
  | Table Name                     |          Rows | Data Size | IDX Size | Total Size |
  +--------------------------------+---------------+-----------+----------+------------+
  | fish                           |  1.41 Million |   93.6 MB |  41.1 MB |     135 MB |
  | birds                          |             0 |     16 KB |  0 Bytes |      16 KB |
  | cats                           |            14 |     16 KB |  0 Bytes |      16 KB |
  | schema_migrations              |             7 |     16 KB |  0 Bytes |      16 KB |
  | users                          |             5 |     16 KB |    32 KB |      48 KB |
  +--------------------------------+---------------+-----------+----------+------------+
  |                                                                       |     135 MB |
  +--------------------------------+---------------+-----------+----------+------------+
  Database: mydb_development  MySQL Server Version: 5.1.58

License

MIT

Credits

Author: Gregory Ostermayr gregory.ostermayr@gmail.com

Contributed code and/or ideas:

Kevin Woods

Travis Herrick