Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore database
Message
 
To
15/02/2018 05:10:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01658123
Message ID:
01658125
Views:
44
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform