-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.html
105 lines (89 loc) · 5.31 KB
/
index.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
<!doctype html>
<!-- paulirish.com/2008/conditional-stylesheets-vs-css-hacks-answer-neither/ -->
<!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7" lang="en"> <![endif]-->
<!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8" lang="en"> <![endif]-->
<!--[if IE 8]> <html class="no-js lt-ie9" lang="en"> <![endif]-->
<!-- Consider adding a manifest.appcache: h5bp.com/d/Offline -->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en"> <!--<![endif]-->
<head>
<meta charset="utf-8">
<!-- Use the .htaccess and remove these lines to avoid edge case issues.
More info: h5bp.com/b/378 -->
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>MySQL Bulk Table Renamer</title>
<meta name="description" content="Bulk Rename MySQL table names from a mysqldump">
<!-- Mobile viewport optimized: h5bp.com/viewport -->
<meta name="viewport" content="width=device-width,initial-scale=1">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/gh-buttons.css">
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,700' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="css/screen.css">
</head>
<body>
<div id="header">
<h1>MySQL Bulk Table Renamer</h1>
<p>Bulk Rename MySQL table names from a mysqldump. This helps with the case (in)sensitivity issue when moving tables between Windows and Linux.</p>
</div>
<div id="qua">
<div class="grad">
<a href="https://github.com/joshatjben/MySQLTableCaseChange" style=""><img style="position: absolute; top: 0; right: 0; border: 0;" src="https://a248.e.akamai.net/assets.github.com/img/71eeaab9d563c2b3c590319b398dd35683265e85/687474703a2f2f73332e616d617a6f6e6177732e636f6d2f6769746875622f726962626f6e732f666f726b6d655f72696768745f677261795f3664366436642e706e67" alt="Fork me on GitHub"></a>
<button id="whatButton" class="button pill">What is it?</button>
<button id="howButton" class="button pill">How Do I Use it?</button>
</div>
<div id="what" class="desc">
<div class="title">What is it? <a class="closeDesc" href="javascript:void(0)">hide</a></div>
<div class="content">
<p>Ever have trouble with MySQL table names while moving between Windows and Linux environments. Specifically involving case (in)sensitivity? This app can take sql from mysqldump and change all the table names to either all upper or lower case names. </p>
<p><strong>Disclaimer:</strong> <em>A bulk change to all your table names can be crippling in some cases. Make sure you first back up your db in a safe location!</em></p>
<p><a class="button icon arrowright" href="https://github.com/joshatjben/MySQLTableCaseChange" target="_blank">Show me the source </a></p>
</div>
</div>
<div id="how" class="desc">
<div class="title">How Do I Use it? <a class="closeDesc" href="javascript:void(0)">hide</a></div>
<div class="content">
<span> Change the case of all your table names from a mysqldump output. </span>
<ol>
<li>Open a console and run <code><a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html" target="_blank">mysqldump</a> -h[host] -u[userName] -p[password] --add-drop-table --add-drop-database [dbname].</code></li>
<li>Copy and paste the results below.</li>
<li>Click on Convert Tables.
<li>The resulting sql will replace the text you pasted in. Simply copy and paste and run.</li>
</ol>
<p><strong>Note:</strong> <em>This will work with all scripts not just ones generated through mysqldump. However it will only update table's that are being created in the provided script. <code>DROP TABLE IF EXISTS</code> is optional but a good idea.</em></p>
</div>
</div>
</div>
<div id="main" role="main">
<div id="conv">
<button id="convertButton" class="button big">Convert Tables</button>
<span class="noWrap"><input type="radio" id="rUpper" name="case" value="upper" checked="checked" /><label for="rUpper">To all UPPER case</label></span>
<span class="noWrap"><input type="radio" id="rLower" name="case" value="lower" /><label for="rLower">To all lower case</label></span>
<span id="status" class="status"> </span>
<textarea id="io" rows="20" cols="100"></textarea>
</div>
</div>
<footer>
</footer>
<script type="text/javascript">
/*<![CDATA[*/
var _gaq = _gaq || [];
_gaq.push(['_setAccount', 'UA-28174908-1']);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
/*]]>*/
</script>
<script src="js/jquery-1.7.1.min.js"></script>
<!-- scripts concatenated and minified via build script -->
<script defer src="js/index.js"></script>
<!-- end scripts -->
<!-- Prompt IE 6 users to install Chrome Frame. Remove this if you want to support IE 6.
chromium.org/developers/how-tos/chrome-frame-getting-started -->
<!--[if lt IE 7 ]>
<script defer src="//ajax.googleapis.com/ajax/libs/chrome-frame/1.0.3/CFInstall.min.js"></script>
<script defer>window.attachEvent('onload',function(){CFInstall.check({mode:'overlay'})})</script>
<![endif]-->
</body>
</html>