@donna
The iTSec plugin Database Backup feature does not add a “create database …” statement to the backup file.
It only adds the following 3 types of statements to the backup file:
- DROP TABLE IF EXISTS …
- CREATE TABLE …
- INSERT INTO …
So on restore you would normally need to create the database yourself and then import the database backup file into that database.
dwinden
Uhhhh, didn’t I already “say” that? I am pretty certain that I did.
It was a suggestion. I know that it’s possible…because the export that phpMyAdmin does (and other backup progams/plugins as well) creates a database file with a “create database” query in it…and then goes on to create the existing database that I backed up, complete with proper database name, username, password, table prefixes, etc etc.
To go back and “manually” have to re-create the database, complete with name, passwords, etc etc…means you have to go and look up all that stuff (providing you are experienced enough to have saved it, I am, but not everyone is…there are a lot of newbies using WordPress these days) which is time consuming at the least, and significantly detracts from the quality of the backup your program generates. I was merely making a suggestion for improvement…which it COULD use, no matter how much you waddle around the subject.
Unfortunately, my iThemes DB backup was the most recent one, but I won’t make that mistake again.
OK, so perhaps I shouldn’t have said “no good” …because it was of “some” use…just not completely useful.
Dwinden. you are NOT even the author of the plugin! what the heck are you posting here for?? I’m not a friggin idiot…all you did was repeat what I said…I know what is in the file…I edited it and fixed it and made it work. Go be useful somewhere else…if you can.
Some people should check if they have anything ‘useful’ before they post. This was NOT a post soliciting help from the community, it was to the author, and the author only. (because nobody else adds features to their software, so if they “read” correctly, should realize there is nothing for them to input here)
…although it would be useful for a newer person to read…it would help them realize maybe why the restore of this database backup isn’t working for them…
@donna
Thank you for that clarification. Apparently it was necessary …
I guess putting that clarification in your first post would have contributed to a better understanding of this topic …
Also instead of using the 2-words-only topic title “Bad backups” it would have been better to use something like:
Feature request: Add create DB info to Database Backup
Anyway I guess I’m the idiot and you’re perfect 😉
dwinden
