Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted February 11, 20169 yr Hi, i would sugest to reintroduding some features in IPS4 like IPB3 in order, backup complete database (a function that checks whether shell_exec() and system() are available on the host to backup with mysqldump otherwise use the default engine like ipb3) and option for export single table and manage DB's (with checkbox) in SQL Toolbox (this app that have present in IPS4) you think is such a thing possible? below i has upload many screenshot the features of which I speak
February 12, 20169 yr Hello, The very warning portrayed(and summarily ignored) in your first screenshot should provide a hint. However, for clarity, making backups(and the other options listed there) is not something that should be handled at the web script level, as large databases/tables will time out attempting such operations through a web interface.
February 12, 20169 yr 2 hours ago, Marcher Technologies said: as large databases/tables will time out attempting such operations through a web interface. As soon as there is a function which interrupts the process and starts it again from that point it shouldn't be a problem.
February 12, 20169 yr Theoretical you're right, but the script doesn't know when it will be killed. The only great method to create backups is to export them on the SQL console or use specialised software like the MySQLDumper (wouldn't be customized for PHP 7 - development has been stopped end of Jan.).
February 12, 20169 yr Author I have seen the throttle option on xtrabackup or limit traffic rate on mysqldumper... this could be useful to backup also large database but obviously the time to end backup is long.
February 12, 20169 yr Management As Jacboy said - it's best to use proper CLI tools (preferably) or a dedicated web utility such as MySQLDumper (less ideal) to obtain backups. The amount of resources to replicate that sort of thing in something like IPS4 makes such functionality a losing proposition for us. The backup in v3 on all but average and small tables was atrocious. Stick with utilities intended to do what you're looking for... let us do what we were meant to do.
February 12, 20169 yr I know this is none of your job but a guide of howto backup-restore ips dbs (especially big ones) would be a good help for people (like me) that don't know but have access to ssh.
February 12, 20169 yr For example, I am using SequelPro on my Mac for accessing the database (a few months ago I've wrote an customer area system for my clients and it has no admin panel - managed everything with SQLPro), you could probably do backups with this, too (didn't tested it). Note: Access from outside to the SQL server is needed, could be a security issue in some networks. Please consider your adminstrator.
February 12, 20169 yr The safest method I have found is accessing the cpanel - phpmyadmin - database - export to my backup file on my machine. Done. For those who do not have access may consider having the host admin take care of this. If not then it is time to either jump on the IPS Cloud or get a different host. Current Database backups are extremely important in case of a failure.
February 12, 20169 yr There's the same problem as internal backup methods in IP.B 3.x --> it would probably ran into an timeout after a defined amount of time.
February 12, 20169 yr The best way to backup databases is on the server level, i.e. bash script or similar. If you don't have ssh access but phpmyadmin then that is the way to go and if you don't have access to any of these then it's your hosters job to keep up2date backups (ask them if they do, if they don't consider changing hosts). Personally, I either use VPS' or dedicated servers with root access so I can manage everything on my own with no restrictions on any level.
February 12, 20169 yr IPS staff in one topic or another mentioned a neat utility called Adminer. It's more or less like phpMyAdmin except it's a single file and feels somewhat easier to use to me. Certainly easier to install and usable without cPanel or similar access. I use it now even on sites where I do have panel access.
Archived
This topic is now archived and is closed to further replies.