DB backup extension, size, droptable questions.

Hi Antonio,

1) The Db backup filename has no “.sql” extension. Is it normal?

It should have a .sql.gz extension. That means it is a gzip-compressed .sql file.

2) It’s size is slightly smaller (5,040kb vs. 5,055kb) from my “manual” phpMyAdmin backup, is it normal?

That’s a 0.3% difference, which is normal. Different amounts of padding and comment included int he SQL can account for that.

3) Doing manual Db backups I usually enable DROPTABLE option (leaving all other option by default), is this the default setting for UpdraftPlus?

Yes – you can open up the database file and read it to verify that.

David

Thanks for the reply David,

the file is inside a compressed (.gz). Once opened it, the file inside has no extension at all. I’ve checked by adding a “.gz” extension, but winwar does not open it.

It’s quite odd indeed. Is it possible it is a “.sql” file even if it has no extension? is there a way to check with no damage?

As you see, the file weight is compatible with the “original” .sql.

Let me know what you think.

P.S. Please note that the file inside the “.gz” file, has a very long file name.

Hi Anthyx,

.gz files are not archives… 7-zip (https://7-zip.org/) is one program you can use to decompress them.

Best wishes,
David

David excuse me,

the Db backup file I get in Dropbox is this:

backup_2014-04-11-1127_WebFoodCulturecom_Food_and_Cul_f47a58c7e1f8-db.gz

opening it using 7-zip I get this file:

backup_2014-04-11-1127_WebFoodCulturecom_Food_and_Cul_f47a58c7e1f8-db

as you see, no extension at all.

Is it normal? is it .sql file anyway, compatible with the “restore” function of UpdraftPlus?

I’m sorry, this is probably a stupid question, but I’m a novice and it’s not clear.

Thanks a lot.

Hi,

Sorry, I confused you earlier. It is a compressed SQL file. The extension does not matter.

David

Ah! Perfect!

Many many thanks and, again, congratulations for your good job!

Ciao

Antonio