I'm using VFP9 with MySQL database.

I want to restore MySQL database, if I'm using command:

mysql.exe -umyuser -pmypassw  store1 < allbackup.sql

it works fine

but if I'm using gunzip

gunzip  < allbackup.sql.gz  | mysql.exe -umyuser -pmypassw  store1

I get error message: table mytable1 already exist.

how can I force overwrite the database if using gunzip?

Thanks in advance