The server that is currently hosting my fanfiction site has decided to, I guess, reboot the whole thing and we were given under 24 hours to backup all of our sites before they do this. Something about too many users on a server and how current active users will have priority or something. I'm not too sure as I can do some things online, but I'm not really that knowledgeable on all the details. Anyways, basically, I need to backup the entire site and I'm not quite sure how to do this and I need someone to help me asap. Here's what I've done already:
- I have downloaded all of the files from my FTP
- I used the backup database function in the Admin settings
- I have exported the SQL via phpMyadmin using the following settings checked:
selected all databases (information_schema and marfic_archive)
SQL
Structure
add DROP TABLE/DROP VIEW
add AUTO_INCREMENT valu
enclose table and field names with backquotes
data
Use hexadecimal for BLOB
save file with no compression
The following settings were unchecked:
enclose export in a transaction
disable foreign key checks
add IF NOT EXISTS
ad CREATE PROCEDURE / FUNCTION
creation/Update/Check dates
complete inserts
extended inserts
Use delayed inserts
use ignore inserts
I just want to make sure I do this right as I don't want to lose any of the data/stories/review/etc. So, if I've done everything correctly, please let me know. If I've missed something, please correct me. I really need an answer soon though. I'm really sorry about the rush. Please help me. Thank you!
When you back up your site, all you need to do is save the mysql database, and the text files on the server (if you save stories as files) and the config file (or dbconfig, I can't remember which one).
You can save the remote copy of eFiction if you want as well, but if you didn't modify it in anyway it should be the same as the one you get from here.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
Okay, I saved all the files just as a precaution so I don't miss anything but I definitely downloaded the stories and config file.
For the mysql database, are the settings I have correct? I've just never exported them before and I want to make sure they're right and backed up properly before my website gets erased from the server.
Thank you for your help!
When you export a database, leave the settings as they are, and check only "add drop table". Don't uncheck anything that's already checked.
When I go into my database with phpmyadmin, i just export the whole fanfiction database.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
I do the same as Jan_AQ, dont mess with any of the default settings either. Just straight export, save to disk.
Just moved server myself two weeks ago, and that method worked fine for me, set up a new database on the new server and imported the downloaded database, reuploaded my efic files and we were back to normal in no time. (did same for coppermine, cmpfetch, smf and tikiwik and out of all of those, the efiction was actually the easiest i found as i didnt have to mess with anything else eiather, except the dbconfig file)
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Alright. I'm uploading everything back in and importing the database. I'm crossing my fingers that this works. I'll let you know when I'm done.
Thank you for all the help. I really appreciate it. 😀
Everything worked perfectly! Thank you so much for all of your help! =D
Well, everything did work perfectly until I tried to upgrade. =/
A fatal MySQL error was encountered.
Query: SELECT author.penname as penname, co.uid FROM fanfiction_coauthors AS co LEFT JOIN fanfiction_authors as author ON co.uid = author.uid WHERE co.sid = '32'
Error: (1146) Table 'marfic_archive.fanfiction_coauthors' doesn't exist
That's the error I keep getting and I can't seem to fix it. =(
Why are you trying to upgrade?
You shouldn't do that at all if you are just backing up an archive, and then putting it back up.
If this is a new issue, then you need to start a NEW topic.
Whoever said nothing is impossible never tried slamming a revolving door.
url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word
