Backup all your databases on your server at once using php
I‘ve altered a php script which I found on the php classes website, to backup all your databases at the touch of a button. The databases have to reside on the same server though. I‘ll change this when I find some spare time. You can download these files below. It includes a folder with a number of files. To use this method of database backup, you first of all have to make a database which contains all your database information like:
- db login (e.g. root)
- db password(e.g. root)
- db host(e.g. localhost)
- db database(e.g. mydatabase)
Just import the sql dump in phpMyadmin or whatever database tool you use to create this database. Then change the file connection_details.csv with your database connection information.
database/#localhost
username:password:db_backup
Do that again in the connectdb.php file and you‘re set. Navigate to the index.php file and click the backup button. A sql dump with a timestamp will be created in the database folder. Make sure you chmod 777 the folder otherwise it won‘t be able to write the files. If you find an error or if you‘re having trouble getting it to work, just contact me at steven@webfizz.be
Images
Posted on 16-04 by steven dobbelaere
Ok I'll look in to it thanks for letting me knowPosted on 16-04 by steven dobbelaere
I looked in to it, but didn't find any errors. Are you sure, you made a database db_backup with the SQL dump that I included and added an existing database to the table websites? Maybe your connection data for the database isn't correct in the connectdb.php file.Posted on 16-04 by Alexander
Hi, goting this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource ****db_backup.php on line 8