tspires@peqtest64:~/sql$ cat temp.sh
#!/bin/bash
dump_table() {
  MYHOST=x2
  MYUSER=y
  MYPASS=z
  MYDB=zz
  MYPATH=./export
  MYTABLE=$1
  ID_FLD=$2
  MYFILE=$3
  CHAR_NAME=$4

  SQL="select id from character_data where name IN ('${CHAR_NAME}')";
  #echo SQL: ${SQL}
  CHAR_ID=$(echo ${SQL} | mysql -h ${MYHOST} -u ${MYUSER} -p${MYPASS} ${MYDB} | grep -v "id");
  #echo CHAR_ID: ${CHAR_ID}
  if [ "${CHAR_ID}x" != "x" ]; then
    WHERE="${ID_FLD}=${CHAR_ID}"
    /usr/bin/mysqldump --replace --single-transaction -t --complete-insert --where="${WHERE}" -h ${MYHOST} -u ${MYUSER} --password=${MYPASS} ${MYDB} ${MYTABLE}  > ${MYPATH}/${MYFILE}
  fi
}

dump_char () {
  CHAR=$1

  dump_table character_data id character_data_${CHAR}.sql ${CHAR}
  dump_table character_activities charid character_activities_${CHAR}.sql ${CHAR}
  dump_table character_alt_currency char_id character_alt_currency_${CHAR}.sql ${CHAR}
  dump_table character_alternate_abilities id character_alternate_abilities_${CHAR}.sql ${CHAR}
  dump_table character_bandolier id character_bandolier_${CHAR}.sql ${CHAR}
  dump_table character_bind id character_bind_${CHAR}.sql ${CHAR}
  dump_table character_buffs character_id character_buffs_${CHAR}.sql ${CHAR}
  dump_table character_currency id character_currency_${CHAR}.sql ${CHAR}
  dump_table character_disciplines id character_disciplines_${CHAR}.sql ${CHAR}
  dump_table character_enabledtasks charid character_enabledtasks_${CHAR}.sql ${CHAR}
  dump_table character_inspect_messages id character_inspect_messages_${CHAR}.sql ${CHAR}
  dump_table character_item_recast id character_item_recast_${CHAR}.sql ${CHAR}
  dump_table character_languages id character_languages_${CHAR}.sql ${CHAR}
  dump_table character_leadership_abilities id character_leadership_abilities_${CHAR}.sql ${CHAR}
  dump_table character_material id character_material_${CHAR}.sql ${CHAR}
  dump_table character_memmed_spells id character_memmed_spells_${CHAR}.sql ${CHAR}
  dump_table character_pet_buffs char_id character_pet_buffs_${CHAR}.sql ${CHAR}
  dump_table character_pet_info char_id character_pet_info_${CHAR}.sql ${CHAR}
  dump_table character_pet_inventory char_id character_pet_inventory_${CHAR}.sql ${CHAR}
  dump_table character_potionbelt id character_potionbelt_${CHAR}.sql ${CHAR}
  dump_table character_skills id character_skills_${CHAR}.sql ${CHAR}
  dump_table character_spells id character_spells_${CHAR}.sql ${CHAR}
  dump_table character_tasks charid character_tasks_${CHAR}.sql ${CHAR}
  dump_table character_tribute id character_tribute_${CHAR}.sql ${CHAR}
  dump_table char_recipe_list char_id char_recipe_list_${CHAR}.sql ${CHAR}
  dump_table inventory charid inventory_${CHAR}.sql ${CHAR}
  dump_table faction_values char_id faction_values_${CHAR}.sql ${CHAR}
}

dump_char Athrogate
dump_char Ezekeil
dump_char Abdeel
dump_char Harumaph
dump_char Melchizedek
dump_char Micaiah
dump_char Mishael
dump_char Obadiah
dump_char Shem
dump_char Perez
dump_char Zerah
dump_char Cadderle
dump_char Gershon
dump_char Kohath
dump_char Merari
dump_char Nadab
dump_char Amminadab
dump_char Ashpenaz
dump_char Belteshazzar
dump_char Azariah
dump_char Nahum
dump_char Onesimus
dump_char Joash
dump_char Hosea
dump_char Isiah
dump_char Ibzan
dump_char Jephthah
dump_char Othneil
dump_char Shamgar
dump_char Yedaiah
dump_char Hezekiah
dump_char Elon
dump_char Gibeon
dump_char Hananiah
dump_char Totom
dump_char Zalmon