MySQL Server

##Details

server: itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com

Endpoint: nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com:3306
UserID : nimbumirchidb
Passwd : nm#db0516

user: bailoo

password: not mentioned

database: itrack

DB Connect -MAIN

mysql -u nimbumirchidb -h nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p
mysql -u nimbumirchidb -h nimbumirchi2.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p

DB Connect -ITC

mysql -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p
mysql -u bailoo -h itrackdb2.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p

DB Connect -CCE

mysql -u ingenccedb -h ingencce.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p

EXPORT

mysqldump -u nimbumirchidb -h nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta > iespl_vts_beta_2016_08_06.sql

mysqldump -u nimbumirchidb -h nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p nimbu_mirchee_db > nimbu_mirchee_db_2016_12_26.sql

mysqldump -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta > iespl_vts_beta_2015_08_07.sql

mysqldump -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta > iespl_vts_beta_2016_05_23.sql

mysqldump -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_itc_beta > iespl_itc_beta_2016_05_23.sql

mysqldump -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_itc_beta trigger_log> trigger_log_2016_05_23.sql

EXPORT MYSQL QUERY RESULT (AWS SERVER)

mysql -u nimbumirchidb -h nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta -B -e "Query" | sed "s/'/'/;s/\t/","/g;s/^/"/;s/$/"/;s/\n//g" > /mnt/upload/query_detail.csv

mysql -u HOST -p --database=dbtest -e "select concat(field1,',',field2,',',field3) FROM tabletest" > tabletest.csv

mysql -e "select * from myTable" -u myuser -pxxxxxxxxx mydatabase
http://stackoverflow.com/questions/9536224/exporting-table-from-amazon-rds-into-a-csv-file

EXPORT WITH NO DATA

mysqldump -u user -h localhost --no-data -p database > database.sql

IMPORT

mysql -u nimbumirchidb -h nimbumirchi.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_proto < iespl_vts_proto_2016_05_24.sql

mysql -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta < transporter_chilling_plant_assignment.sql
mysql -u bailoo -h itrackdb.c4pqfsdaiccz.us-east-1.rds.amazonaws.com -p iespl_vts_beta < invoice_mdrm.sql

##Configuration

###Java

###PHP
/mnt/itrack/beta/setup/mysql.php
/mnt/itrack/beta/src/php/util_php_mysql_connectivity.php

CREATE INDEX -mysql

create index ime ON last_data(IMEI);
create index dt ON last_data(DateTime);

php -m | grep mysql

LOCAL DATABASE

user : root Pass : mysql

CHANGE PASSWORD

$ mysql -u root -p
mysql> use mysql;
mysql> update user set password=PASSWORD("NEWPASSWORD") where User='nixcraft';
mysql> flush privileges;
mysql> quit