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: 8/7/19 10:49 AM
entry to remove all files in /home/ folder that starts...
of important Types in Amazon Cloud Formation tool: IAM (User,...
codes used for classification: 1 SC 2 OBC 3 SBC...
8 important concepts of Shell scripting that everyone should know....
to be a useful tool to convert mysql or oracle...
install packetbeat, you may need to change the windows security...
import groupby s = 'abcccccbba' for w, v in groupby(s):...
Learning Here is the list of some of the modules...
search !pip install google from googlesearch import search for url...
datetime import datetime date_string = "21 June, 2018" date_object =...
will return the mixed datatypes but this can be slow....
1) Download the polyglot pickled marathi model wget http://bit.ly/12FI1xV mv...
stopped download of Input Tools package without giving any reason....
are important python objects and their methods int __mul__, __add__,...
how to read a JSON file into pandas dataframe. import...
is a high level Python library designed to execute shell...
easy to backup mysql users - wget percona.com/get/pt-show-grants; perl pt-show-grants
an object (class instances) 2 methods depends upon class of...
-d"-1 day ago" +'%b%d' equals to mysql -Bse"select date_format(date(date_add(now() ,...
You can write multi line comments in a stored procedure...
5 steps to add any API to your slack channel....
help to quickly access stack pages linking to current page...
create bucket aws s3 mb s3://johntest123/ #### rsync all files...
apache docker container does not start then make these changes......
If pip is not installed, then the following command will...
