This seems to be a useful tool to convert mysql or oracle schema to redshift. select queries can also be migrated easily using...
... Link (0 comments) ... Comment
$ # As of March 2009, the latest version was 3.6.11.
$ wget www.sqlite.org
$ tar xzf sqlite-amalgamation-3.6.11.tar.gz
$ cd sqlite-3.6.11
$ ./configure && make
$ sudo make install
... Link (0 comments) ... Comment
When there is maintenance work to be carried on the database server, you can simply skip networking so that no connection from any other server from the network will be accepted.
Simply enter the following in /etc/my.cnf:
[mysqld]
Prevent network access to MySQL.
skip-networking
... Link (0 comments) ... Comment
mysql -e"SELECT CONCAT('OPTIMIZE TABLES ', GROUP_CONCAT(TABLE_SCHEMA, '.', TABLE_NAME ORDER BY TABLE_SCHEMA, TABLE_NAME SEPARATOR ',')) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname' GROUP BY TABLE_SCHEMA\G
" | awk -F: '{print $2}' | mysql
... Link (0 comments) ... Comment
Last modified: 4/12/20 2:01 PM
| August 2020 | ||||||
|---|---|---|---|---|---|---|
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
| 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 | |||||
| April | ||||||
caudatus: rajgira. 2. Amaranthus tricolor: Math. (Chhoti Chulai- Hindi, Cheera-...
seems to be a good site for handy references of python...
This code will change the standard out to a file...
command line tool While creating amazon config file in a...
is how to set the colors in pandas mapper =...
show global variables; show engine innodb status\G show full processlist;...
python Amazon API gateway allows us to host server-less API's...
old days, the glacier class used to have different layers....
steps to install perconal utility... yum install perl-DBI perl-Data-Dumper perl-DBD-MySQL wget...
generating AWS API gateway a) Method Execution - Get Method...
is how to change the color of negative values to...
the common holidays celebrated in India (Mumbai) during 2016 -...
MySQL Here are the steps to be followed while changing...
Table does not exist 1054 column does not exist 1062...
ipython in cluster mode ipcluster start -n 4 from IPython.parallel...
this message if you have DEBUG = True in your...
following commands to clear unwanted stuff from the /tmp partition...
IST If you need to change your server clock to...
email address If you have root access to the server...
of the first five fields, you can use any one...
not able to install latest version of Libre office. I...
a sample shell script while loop while read mydb do echo...
is poor man's schema compare using good old diff command......
"error" error_log |awk -F[ {'print $4'} \ | sort |...
SET @rank = 0, @prev_val = NULL; SELECT rank, correct...
