Cool Surfer Posted October 23, 2008 Posted October 23, 2008 It would be good if there is a task that can automatically create backups of sql, maybe on the same server, in a desired directory in a zip format n with a password. Right now I can almost guess the sql backup file name, and if you keep trying you will succeed. If there is a password protected zip file, it makes it more safe. N may be task overwrites the old sqls if allowed.
henke37 Posted October 23, 2008 Posted October 23, 2008 Password protection of zip files is hard. It involves big numbers, way big numbers.
Cool Surfer Posted October 23, 2008 Posted October 23, 2008 phpcoinhas this feature, and it can bea real life savr if you mess up you sql doing something.
X3773 Posted October 23, 2008 Posted October 23, 2008 Use .htaccess to password protect the folder its in. If you just password protect the .zip they have the data right there so its easy to get around the password. Also can't you use the Task Manager for this?
Cool Surfer Posted October 24, 2008 Posted October 24, 2008 Use .htaccess to password protect the folder its in. If you just password protect the .zip they have the data right there so its easy to get around the password. Also can't you use the Task Manager for this? Task manager how?
Cool Surfer Posted October 26, 2008 Posted October 26, 2008 You can create your own tasks. You know how to? The main thing is anything inbuilt in the official script is more stable and secure. I hope you understand. That way there are so many things we can do with the help of mods, or build mods for achieving the same end and remove those features from invision forum You canmake a mof to send pm's and remove PM system from forum script. you can create mod to send email notifications and emove it from forum script. you can even remove smileys and create a mod to link to the smileys. and convert forum script to a mere blog where u just post n walk off....
Lindsey_ Posted October 26, 2008 Posted October 26, 2008 While I do see the point of something like this, I think it would be better to do backups with PHPMYADMIN..
Cool Surfer Posted October 26, 2008 Posted October 26, 2008 While I do see the point of something like this, I think it would be better to do backups with PHPMYADMIN.. Phpmyadmin is ok for small db's. If you have a db > 1gb of text, then you are bound to get runtime error or something. And it always doesnt restore the db. This is my personal experience.
atomicknight Posted October 26, 2008 Posted October 26, 2008 Phpmyadmin is ok for small db's. If you have a db > 1gb of text, then you are bound to get runtime error or something. And it always doesnt restore the db. This is my personal experience.That's a limit in PHP, not in phpMyAdmin. Pretty much anything you can't do successfully in phpMyAdmin can't be done successfully in other PHP applications (short of running shell commands through PHP). So while such a feature would be useful for some people, it almost certainly won't work for larger installations without introducing potential security vulnerabilities in your system. Better to perform backups from a shell than via a web-facing application.
3DKiwi Posted October 26, 2008 Posted October 26, 2008 So why not use the backup tools provided in cPanel? Anyone running a large forum is most likely on a dedicated server. Just a matter of setting up automated backups in cPanel, assuming you are using cPanel on your server. 3DKiwi
bfarber Posted October 27, 2008 Posted October 27, 2008 If you can't do it in phpmyadmin, a script that has been developed and tweaked for years for the SOLE purpose of managing databases, big and small, I'm afraid it's not logical that WE are going to build in something better into a forum software. It's just not what our software is built to do, and it's not efficient for us to spend time trying to perfect such a feature. After all, that is what phpmyadmin is for. We have a simple database management tool (presently). I don't really foresee us expanding it THAT much.
akiratheoni Posted November 2, 2008 Posted November 2, 2008 I just use a crontab and a bash script for things like this, and I put it in a folder outside of the public_html on my server so people can only access it through FTP. It works for me, but my database is only like ~80MB so I don't know if it would work for you.
Jaggi Posted November 2, 2008 Posted November 2, 2008 i use mysql dump cus even phpmyadmin dies for me now. I don't think i've used ipb mysql backup in many years.
abobader Posted November 2, 2008 Posted November 2, 2008 [b]i use mysql dump[/b] cus even phpmyadmin dies for me now. I don't think i've used ipb mysql backup in many years. That the best/fast way to backup sql db.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.