Hi guys:
I'm looking for a way to automate (or more to the point, use wget) the grabbing of the backup sql file generated by the admin-maint page from the backend. The problem I'm running into is that it asks for credentials, and I can't find a way for wget to put those in within someone sitting at the keyboard every time.
Any ideas on how to accomplish this?
Thanks!
Archive: Ad Astra Star Trek Fanfiction Archive
Version: 3.5.3
Skin: One of Kali's, but I'm not sure. It's been heavily modded.
PHP: 7.4.27
MySQL: 5.7.36
Cronjobs!
It might be well to read up on them.
I can't really tell you how to set them up, because how you set yours up may differ from mine ... but this is my cronjob, nonetheless:
mysqldump -ce --user=table_username --password=user_password table_name | gzip | uuencode nameofbackup.gz | mail your e-mail
It sends the e-mail a gzip.
There are some others that save it to a directory.
archive:
site:
Available for skin/mod commission! 🙂
What if... it's on a shared hosting account such as GoDaddy?
Archive: Ad Astra Star Trek Fanfiction Archive
Version: 3.5.3
Skin: One of Kali's, but I'm not sure. It's been heavily modded.
PHP: 7.4.27
MySQL: 5.7.36
Hm what about a PHP backup script? Here's one that I found:
http://www.dwalker.co.uk/phpmysqlautobackup/
phpMySQLAutoBackup automates the backup of MySQL databases (you will need PHP hosting to use it - or reseller hosting if you host lots of websites). The PHP scripts export your database (data and structures), compresses it into gzip format and emails it to you. Schedule it to run every day/week by adding it to a cron job, or use the excellent phpJobScheduler
New features include the ability to select separate tables for backup, and limit the backup to start and stop at pre-set table row numbers, this will now allow a section of a large table (with millions of records) to be selected for backup. Read more here for details on how to import and export LARGE MySQL databases (see other MySQL PHP related links).
Protecting your MySQL data has never been easier, once setup your backups will be sent to you automatically like clockwork.
http://www.noupe.com/php/10-ways-to-automatically-manually-backup-mysql-database.html
I am rebuilding efiction! Join us on irc! #efiction at
What if... it's on a shared hosting account such as GoDaddy?
Hm I think I might have read that GoDaddy does offer SSH support and there should be a way to do so, you might just have to google SSH tutorials as per Jenny's suggestion.
