Revision 12007
Added by Aaron Marcuse-Kubitza almost 11 years ago
| index.htm | ||
|---|---|---|
| 1151 | 1151 |
</DL><p> |
| 1152 | 1152 |
<DT><a name="MySQL" href="#MySQL"><H3 ADD_DATE="1346354953">MySQL</H3></a> |
| 1153 | 1153 |
<DL><p> |
| 1154 |
<DT><a name="`mysql`" href="#`mysql`"><H3 ADD_DATE="1390517329">`mysql`</H3></a> |
|
| 1155 |
<DD>for interactive formatting (including echoed queries) when inputting from a file: |
|
| 1156 |
(this format is slightly different than the actual interactive format because the queries are echoed with lines before and after) |
|
| 1157 |
$ mysql --table --verbose --verbose <file |
|
| 1158 |
|
|
| 1159 |
for raw formatting when inputting from the console: |
|
| 1160 |
(unfortunately does not display prompt) |
|
| 1161 |
$ mysql --batch |
|
| 1162 |
</DD> |
|
| 1163 |
<DL><p> |
|
| 1164 |
</DL><p> |
|
| 1154 | 1165 |
<DT><a name="doc" href="#doc"><H3 ADD_DATE="1368223591">doc</H3></a> |
| 1155 | 1166 |
<DL><p> |
| 1156 | 1167 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" name="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" ADD_DATE="1364880853" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax</A><a name="MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax" href="#MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax" style="margin-left: 0.5em;">¶</a> |
| ... | ... | |
| 1304 | 1315 |
<DT><A HREF="http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format" name="http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format" ADD_DATE="1364930621" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>linux - How to output MySQL query results in csv format? - Stack Overflow</A><a name="linux - How to output MySQL query results in csv format? - Stack Overflow" href="#linux - How to output MySQL query results in csv format? - Stack Overflow" style="margin-left: 0.5em;">¶</a> |
| 1305 | 1316 |
<DT><A HREF="http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137" name="http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137" ADD_DATE="1366748108" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow</A><a name="mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow" href="#mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow" style="margin-left: 0.5em;">¶</a> |
| 1306 | 1317 |
<DT><A HREF="http://dba.stackexchange.com/questions/13083/cant-remove-grant-usage" name="http://dba.stackexchange.com/questions/13083/cant-remove-grant-usage" ADD_DATE="1369920700" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - can't remove "GRANT USAGE" - Database Administrators Stack Exchange</A><a name="mysql - can't remove "GRANT USAGE" - Database Administrators Stack Exchange" href="#mysql - can't remove "GRANT USAGE" - Database Administrators Stack Exchange" style="margin-left: 0.5em;">¶</a> |
| 1318 |
<DT><A HREF="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" name="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" ADD_DATE="1374878990" ICON_URI="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow</A><a name="mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" href="#mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" style="margin-left: 0.5em;">¶</a> |
|
| 1307 | 1319 |
<DT><A HREF="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html" name="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html" ADD_DATE="1361398908" ICON_URI="http://blog.tsheets.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.tsheets.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL – Extract or Restore a Single Table From a Huge mysqldump File</A><a name="MySQL – Extract or Restore a Single Table From a Huge mysqldump File" href="#MySQL – Extract or Restore a Single Table From a Huge mysqldump File" style="margin-left: 0.5em;">¶</a> |
| 1308 | 1320 |
<DD>page's description: A while back, I wrote an article that explained some awk magic for extracting the restore information for a single table from a mysqldump file. Since then I've created a Perl script that accomplishes the same thing, but is a little more flexible. |
| 1309 | 1321 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/show.html" name="http://dev.mysql.com/doc/refman/5.5/en/show.html" ADD_DATE="1370079565" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax</A><a name="MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax" href="#MySQL :: MySQL 5.5 Reference Manual :: 13.7.5 SHOW Syntax" style="margin-left: 0.5em;">¶</a> |
| ... | ... | |
| 1318 | 1330 |
<DT><A HREF="http://mysql-python.sourceforge.net/MySQLdb.html" name="http://mysql-python.sourceforge.net/MySQLdb.html" ADD_DATE="1323978074" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQLdb</A><a name="MySQLdb" href="#MySQLdb" style="margin-left: 0.5em;">¶</a> |
| 1319 | 1331 |
<DT><A HREF="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" name="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" ADD_DATE="1366897937" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow</A><a name="Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow" href="#Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow" style="margin-left: 0.5em;">¶</a> |
| 1320 | 1332 |
<DT><A HREF="http://drupal.org/node/306156" name="http://drupal.org/node/306156" ADD_DATE="1364875790" ICON_URI="http://drupal.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://drupal.org/misc/favicon.ico" style="margin-right: 0.5em;"/>What's the opposite of mysqldump to load data back into a database? | drupal.org</A><a name="What's the opposite of mysqldump to load data back into a database? | drupal.org" href="#What's the opposite of mysqldump to load data back into a database? | drupal.org" style="margin-left: 0.5em;">¶</a> |
| 1321 |
<DT><A HREF="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" name="http://stackoverflow.com/questions/11940027/mysqldump-returning-unknown-variable-sql-mode-error" ADD_DATE="1374878990" ICON_URI="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow</A><a name="mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" href="#mysql - mysqldump returning unknown variable sql-mode error - Stack Overflow" style="margin-left: 0.5em;">¶</a> |
|
| 1322 | 1333 |
</DL><p> |
| 1323 | 1334 |
<DT><a name="SQLite" href="#SQLite"><H3 ADD_DATE="1367832799">SQLite</H3></a> |
| 1324 | 1335 |
<DL><p> |
| ... | ... | |
| 1768 | 1779 |
</DD> |
| 1769 | 1780 |
<DL><p> |
| 1770 | 1781 |
</DL><p> |
| 1771 |
<HR> </DL><p>
|
|
| 1782 |
</DL><p> |
|
| 1772 | 1783 |
<DT><a name="10.9 Mavericks upgrade" href="#10.9 Mavericks upgrade"><H3 ADD_DATE="1390420258">10.9 Mavericks upgrade</H3></a> |
| 1773 | 1784 |
<DL><p> |
| 1774 | 1785 |
<DT><a name="whether to upgrade" href="#whether to upgrade"><H3 ADD_DATE="1390420313">whether to upgrade</H3></a> |
| ... | ... | |
| 1802 | 1813 |
|
| 1803 | 1814 |
Much better. I'd say that I'm getting an extra 45 minutes from a charge, which isn't bad at all." |
| 1804 | 1815 |
</DL><p> |
| 1805 |
<HR> </DL><p>
|
|
| 1816 |
</DL><p> |
|
| 1806 | 1817 |
<DT><a name="MacFusion" href="#MacFusion"><H3 ADD_DATE="1367739060">MacFusion</H3></a> |
| 1807 | 1818 |
<DL><p> |
| 1808 | 1819 |
<DT><A HREF="http://code.google.com/p/macfuse/wiki/OPTIONS" name="http://code.google.com/p/macfuse/wiki/OPTIONS" ADD_DATE="1367738659" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>OPTIONS - macfuse - Commonly useful mount-time options available in MacFUSE - The Easiest and Fastest Way to Create File Systems for Mac OS X - Google Project Hosting</A><a name="OPTIONS - macfuse - Commonly useful mount-time options available in MacFUSE - The Easiest and Fastest Way to Create File Systems for Mac OS X - Google Project Hosting" href="#OPTIONS - macfuse - Commonly useful mount-time options available in MacFUSE - The Easiest and Fastest Way to Create File Systems for Mac OS X - Google Project Hosting" style="margin-left: 0.5em;">¶</a> |
| ... | ... | |
| 2163 | 2174 |
$ cd <parent_dir_of_checkout> |
| 2164 | 2175 |
$ time git svn clone --stdlayout https://<svn-url> & # runtime: 15 min ("12m24.338s") |
| 2165 | 2176 |
# note that it appears to spend 10 min thinking about it, and then at the very end, very quickly downloads your entire repo |
| 2177 |
to `svn update`: |
|
| 2178 |
$ git svn fetch |
|
| 2166 | 2179 |
</DD> |
| 2167 | 2180 |
<DL><p> |
| 2168 | 2181 |
<DT><A HREF="http://john.albin.net/git/convert-subversion-to-git" name="http://john.albin.net/git/convert-subversion-to-git" ADD_DATE="1390256214" ICON_URI="http://john.albin.net/sites/all/themes/johnalbin/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://john.albin.net/sites/all/themes/johnalbin/favicon.ico" style="margin-right: 0.5em;"/>(some steps in this article are incorrect) Converting a Subversion repository to Git, (7 steps to migrate a complete mirror of svn in git) | JohnAlbin</A><a name="(some steps in this article are incorrect) Converting a Subversion repository to Git, (7 steps to migrate a complete mirror of svn in git) | JohnAlbin" href="#(some steps in this article are incorrect) Converting a Subversion repository to Git, (7 steps to migrate a complete mirror of svn in git) | JohnAlbin" style="margin-left: 0.5em;">¶</a> |
Also available in: Unified diff
web/links/index.htm: updated to Firefox bookmarks: `mysql`: added commands to get interactive formatting (including echoed queries) when inputting from a file, and to get raw formatting when inputting from the console. git: added equivalent to `svn update`.