I know this is going to sound like an incredibly stupid question, but when backing up my database the download tries to save as a .txt file. The original file extension is .sql. Since it's trying to save as a .txt, I forced it to save as .sql by using quotes. (ex. "'Fikushon_no_Nanashi07-10-2008.sql") It's now showing as the .sql. Is this the correct way to make it save or have I corrupted the file? I don't want to try to upgrade without that backup to fall back on, as I always have issues with things that should be "idiot proof."
Thank you and sorry for the dumb question.
Are you talking about backing up the database while you are in MyPHPAdmin? Because it gives you the option of saving as an sql file.
If you re talking about using the Admin->Administrative Maintenance->Backup Database in efiction, it does save as .sql by default. (earlier versions of efic saved as txt but that hasn't been for a while now).
But to answer your question, I don't think it corrupts the information if it's save as txt. When you need to upload the information back into the database you change the file extension from .txt to .sql and it should work.
******************************************
Mucking around in eFiction since circa 2001 (ver. 1.0)
Now running v.3
It was through Admin->Administrative Maintenance->Backup Database. I blame the .txt thing on my computer not the software. It's a '99, running on Windows98. Thank you for the answer. I checked the file properties and it did say that it was a SQL file, I just wanted to double check.
Thanks again!
Even if it's saved as .txt you can usually just copy and paste the contents in through phpMyAdmin.
