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