Where is data from users stored?
LuxVera
New
Can someone provide the path e.g. vanilla/folder/filename where user input is actually stored?
e.g. I make a Category entitled "Symphonies" - where is "Symphonies" stored?
A user discussion talks about "Mozart" - where is "Mozart" stored? Thanks very much!
Best Answers
-
whu606
MVP
The database is stored separately to your Vanilla installation files. Check with your host; normally, a tool like phpMyAdmin is provided to give you access to your databases.
It is the database which is the essence of your forum (discussions, posts, user details etc.) so you must work out how to make sure you have regular, secure back ups. This may be done by your host, but make sure you check, and I would still recommend working out how to save local copies.
If you lost your Vanilla installation files in a crash, you could have a working forum in a few minutes if you can access the database.
If you lose your database, you have lost all content from your forum.
3 -
LuxVera
New
Thank you for spelling this out so clearly, whu606, and thanks to R_J for the link! Perhaps this is somewhere in the Vanilla documentation and I missed it. There's so much for us newcomers to learn, and help like yours is invaluable! Anyway, now I found the MySQL database for Vanilla in cPanel with simple backup and restore options, so I will be sure to make regular backups. Thanks again
5
Answers
all data is stored in the database
Thank you, but I've been looking for a "database" and don't see it. Could you please give me the file path, like: vanilla/folder/subfolder/filename?
http://www.mkyong.com/mysql/where-does-mysql-stored-the-data-in-my-harddisk/
@LuxVera
The database is stored separately to your Vanilla installation files. Check with your host; normally, a tool like phpMyAdmin is provided to give you access to your databases.
It is the database which is the essence of your forum (discussions, posts, user details etc.) so you must work out how to make sure you have regular, secure back ups. This may be done by your host, but make sure you check, and I would still recommend working out how to save local copies.
If you lost your Vanilla installation files in a crash, you could have a working forum in a few minutes if you can access the database.
If you lose your database, you have lost all content from your forum.
Thank you for spelling this out so clearly, whu606, and thanks to R_J for the link! Perhaps this is somewhere in the Vanilla documentation and I missed it. There's so much for us newcomers to learn, and help like yours is invaluable! Anyway, now I found the MySQL database for Vanilla in cPanel with simple backup and restore options, so I will be sure to make regular backups. Thanks again
@LuxVera
It's also worth learning how to export a database via phpMyAdmin, so that you can keep backups on your own PC/storage system.
Relying solely on your host is risking losing everything.
Yep, I'll definitely keep backups on my own PC. And then backups from my PC to an external drive. One can't be too careful