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