I'm working on a bash script to perform some mysqldump backups. I'n not very good at scripting.

I have:

```
#!/bin/bash
TNAMES="database1.tableA database2.tableD databaseN.tableZ"

```

I need to parse TNAMES to separate the database part from the table part to execute the mysqldump

```
for TABLE in $TNAMES
do
  mysqldump $OPTIONS $USER $PASSWORD $DB $TABLENAME > "some_file.sql"
  (some more actions here)
done

```

so in the first loop iteration the command will be:

```
mysqldump $OPTIONS $USER $PASSWORD database1 tableA > "some_file.sql"

```

Next:

```
mysqldump $OPTIONS $USER $PASSWORD database2 tableD > "some_file.sql"

```

Next:

```
  mysqldump $OPTIONS $USER $PASSWORD databaseN tableZ > "some_file.sql"

```

And so on.

Is there any easy way to do this with awk?