Interview Question in Backup and Recovery


 

Interview Question :: Is the database the thing that i look at on my ftp


Like is all the files on my FTP, is that my database?

or is it something different,

also i have a backup from my admincp called ''vbulletin'' which is an sql file, is this the backup of the database?

Im thinking the SQL file is a backup of my database, and the files inside my FTP are just vbulletin itself files

Thx
Answers to "Is the database the thing that i look at on my ftp"
RE: Is the database the thing that i look at on my ftp?

The things you see in your FTP is not your database. Those are only files on your host. I cannot guess as to where your database is. It seems that you are using vBulletin. If they backed up your database, it could be in the form of SQL files. Operative word here is 'could'.
 
Vote for this answer ::  
RE: Is the database the thing that i look at on my ftp?

dunno what system/database you are talking about, since I never heard the names you quote before.



but I can say one thing for sure.



an SQL file is a script that runs "on" a database and is definitely not a part of any database itself. The SQL script PERFORMS some action on the database when it's run on it.



Thks!

-----------------

Edit:



Tristan, if you are looking at this Q&A again, I would greatly appearicate if you can do a little more details on how a SQL file "could" store a database. I still think that's an impossibility(I am guessing, maybe you mean as a lot of INSERT INTO statements??)



Thanks

IP
 
Vote for this answer ::  
Update Alert Setting