kpunderground.com

mysql --user=[username] --password=[password]--host=[computer]

mysql --user=root --password=mypassword--host=VMYSQL01

show databases;

mysql --user=root --password=mypassword --database=DB1< myscript.sql

#!/bin/sh
# http://kedar.nitty-witty.com
#SPLIT DUMP FILE INTO INDIVIDUAL TABLE DUMPS
# Text color variables
txtund=$(tput sgr 0 1)    # Underline
txtbld=$(tput bold)       # Bold
txtred=$(tput setaf 1)    # Red
txtgrn=$(tput setaf 2)    # Green
txtylw=$(tput setaf 3)    # Yellow
txtblu=$(tput setaf 4)    # Blue
txtpur=$(tput setaf 5)    # Purple
txtcyn=$(tput setaf 6)    # Cyan
txtwht=$(tput setaf 7)    # White
txtrst=$(tput sgr0)       # Text reset
 
TARGET_DIR="."
DUMP_FILE=$1

mysqldump --opt --user=[username] --password=[password] --no-data [database] [table] > [filename]
.
.

mysqldump --opt --user=[username] --password=[password] --no-data --xml [database] [table] > [filename]
.
.

UPDATE content_type_geshinode AS g
INNER join zztemp AS z ON z.nid = g.nid
SET g.field_object_type_value = z.field_object_type_value