Subversion Repositories SmartDukaan

Rev

Rev 13497 | Rev 13501 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13497 Rev 13498
Line 63... Line 63...
63 
 
 63 
 
64 
mysqldump -uroot -pshop2020 catalog --tables similaritems source sourceitempricing category voucheritemmapping freebieitem entitytag amazonlisted storepricing brandinfo privatedeals iteminsurermapping > ${MYSQL_DUMP}
 64 
mysqldump -uroot -pshop2020 catalog --tables similaritems source sourceitempricing category voucheritemmapping freebieitem entitytag amazonlisted storepricing brandinfo privatedeals iteminsurermapping > ${MYSQL_DUMP}
65 
 
 65 
 
66 
if [ -z $a1 ]
 66 
if [ -z $a1 ]
67 
then
 67 
then
- 
 
 68 
	echo "a1 is empty"
68 
else
 69 
else
69 
	mysqldump -uroot -pshop2020 catalog item --replace --no-create-info --where="id in ($a1)" >> ${MYSQL_DUMP}
 70 
	mysqldump -uroot -pshop2020 catalog item --replace --no-create-info --where="id in ($a1)" >> ${MYSQL_DUMP}
70 
	if [ "$1" == "PROD" ]
 71 
	if [ "$1" == "PROD" ]
71 
	then
 72 
	then
72 
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem AS (SELECT * FROM item)"
 73 
		mysql -uroot -pshop2020 catalog -e "truncate tmpitem;insert into tmpitem AS (SELECT * FROM item)"