tried it already

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

the issue is not with gunzip, but with mysql.exe

if I run

gunzip -f  < allbackup.sql.gz 

it works

how to force overwrite in mysql.exe?





>>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
>
>
>https://forums.fedoraforum.org/showthread.php?176619-overwrite-gzip-file-without-confirmation