Drop Table

Hi again,

I need if possible another info: UpdraftPlus exports DB in a file called:
“backup_2014-11-07-0954…_8b4a400fe5d0-db” .. is this a “.sql” file?

Eventually, if I need to import it in phpMyAdmin, can i rename this file and compress in in a “.sql.zip” file?

Many thanks in advance.

Antonio

Hi Anthyx,

It can be imported in phpMyAdmin directly; you don’t need to do anything with it. See this FAQ: https://updraftplus.com/faqs/what-format-are-backups-made-in-is-it-nasty-and-proprietary/

Yes, it has “DROP TABLE” commands – which you can verify by decompressing it and reading it (use 7-zip from 7-zip.org).

Best wishes,
David