Ok, I just started playing around with mysql and databases on a localhost to try and learn.
Question about the database .sql file
The database .sql file first gets created when you first install SMF, correct?
I did not make a backup copy of the .sql file on my localhost before I started playing around with the tables so I'm wondering if there is a place here on SMF that I can download a copy of the .sql database file or should I simple reinstall smf 1.1.4 on my localhost and make a backup of the .sql file before i start playing around this time. :)
you can find the sql in the full install package. keep in mind that the sql file(s) can only be run with the install.php or upgrade.php scripts.
Thanks for the reply,
ok, sure enough there it is...install_1-1.sql
Lainaakeep in mind that the sql file(s) can only be run with the install.php or upgrade.php scripts
Not sure just what that means yet...
If I screw up the database .sql file when playing around with smf 1.1.4 can I just delete it's database and upload the install_1-1.sql database, then rename it to the name of the database I had been working with to get smf 1.1.4 working again.
Edited to add: after asking the question I asked myself, 'self, why don't you just try it and see if it work like that?' and so I did and it worked. :)
After all this is why I decided to set up a localhost and play around with smf databases, so i could learn by doing. :)
Lainaus käyttäjältä: ApplianceJunk - elokuu 27, 2011, 09:51:07 AP
Lainaakeep in mind that the sql file(s) can only be run with the install.php or upgrade.php scripts
Not sure just what that means yet...
It means that you can run it any time by importing it into phpMyAdmin, but that's a bad idea since you don't know what you're doing. Running it from install or upgrade is doing it in a more controlled and safe manner.
Lainaa
If I screw up the database .sql file when playing around with smf 1.1.4 can I just delete it's database and upload the install_1-1.sql database, then rename it to the name of the database I had been working with to get smf 1.1.4 working again.
You're very confused. install_1-1.sql is a
file used to set up the tables in a database and fill them with data to start SMF. Unless you deliberately overwrite this file, nothing will happen to it. You can use it over and over to set your SMF database back to its initial condition. If you're worried about mangling it, use your hosting file manager to make it "read only" (e.g., 444 permissions). If you want to reset SMF, you can erase any member attachments and run the .sql file to wipe out the old tables and create fresh copies. You would not need to "delete" the whole database -- that's just unnecessary work for you.
By the way, you're not
really on 1.1.4, are you? That is so ancient and unsafe! The current version is 1.1.
14.
Lainaa
Edited to add: after asking the question I asked myself, 'self, why don't you just try it and see if it works
When I talk to myself like that, other people start mumbling something about a jacket with very long sleeves...
Ment, 1.1.14
Thanks for the info..