"drop" vs "no drop" backups | Old Forum | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
sp_LogInOut Log In
Lost password?
sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Go to Bottom
The forums are currently locked and only available for read only access
sp_TopicIcon
"drop" vs "no drop" backups
July 10, 2006
12:00 am
Avatar
swimmrguy
Guest
Guests
Go to Top
1sp_Permalink sp_Print

I apologize for a newbie question...

I have noticed that the clones I have made automatically using a cron process have "no drop" in the file name. However, the ones I manually do have "drop" in the file name. I suspect it has to with whether or not "Drop Syntax" is checked.

My question: What is drop syntax? And what are the advantages/disadvantages in using one vs. the other?

Thanks in advance,
Bob

July 10, 2006
12:00 am
Avatar
admin
Guest
Guests
Go to Top
2sp_Permalink sp_Print

The drop syntax is used in the mysql importing, when importing each table and if the drop syntax is enabled, then we will drop any original table(with same name) and insert the new one instead!

Ovidiu

sp_Feed All RSS
Go to top
Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10048
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Gayira Duncan
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0