Updating a Prestashop SQL Database

[Joe Germann]

I am migrating from Prestashop version 1.5 to 1.6 which in itself is irrelevant other than the fact that the database is SQL.

I want to run a shell script that will:

* Open Old database
* Extract a named table to a local file
* Open New database
* Clear named table
* Import extracted Old table information into New

> Old database is always the same
> New database is always the same
> There will be many named tables I want to run this script for

I know I can do this within phpMyAdmin but it would be a pain in the neck especially since this will be repeated multiple times.

I am a SQL newbie and could use some starting guidance to do this.

Thank you,
Joe Germann