PhP Script Auto Backup

Whoaaaaa xD

Okay this is my Old script i used in my server long time ago for Backup My Database From My Phone xD yea its true because when i out i always backup the server using my phone xD but you can do with pc to without need to Login To Your server to open SQL Management and bla bla bla.. just with open a browser and execute 1 .php file and its done! whoa!! how is it going?
here is the explanation:

This Script Using FTP SERVER to Auto Upload The Packed Database Or The Un-Pack Version its depend what you will setting in there. :] its really easy to use :D :love: :love: hehehe..
You Can Easily change the setup of compress or not.
by using this

Quote:

---

$compress = false;

---

default is false :] if you set it true it will packed all your database and packed into .zip file and upload to your ftp server :].

phewww its a lot of tying and i already near typo xD.:grr::grr:
here is it :D. Use it wisely :) i release it for good :lol:

and lastly credit to who is give this script to me but its un-complete and i complete it very long time ago. but really sorry friend i already forgot what your name :tongue: since i think its already 2 or 3 years not meet with him. okay bye bye. use it wisely!

:)
bye!
any other problem please post in this thread.
you should configure this option before use :drool::drool:

Quote:

---

// Database details.
define ( 'server', 'YOUR SQL SERVER ADDRESS' );
define ( 'db_user', 'YOUR SQL SERVER USER' ); # sa works too. ;]
define ( 'db_pass', 'YOUR SQL SERVER PASSWORD' );

// FTP settings
$ftp['user'] = 'YOUR FTP USER'; #<- okay for this one is your ftp user
$ftp['pass'] = 'YOUR FTP PASSWORD LOL'; #<- your ftp pass
$ftp['host'] = 'www.thegamesz.com'; #<- your ftp ADDRESS. don't use mine xD change it xD xD
$ftp['path'] = '/database_backup/'; #<- Put Linux Server ROOT its for safety so Public cannot download yours :] or up to you where you want to put :P.

// Set local path where backups reside
$loc['path'] = 'C:\Server\DB\\'; #<- your DATABASE FOLDER =__="

// If compression is false, then it'll upload the DB as is..
// as opposed to compressed.
// If ZipArchive errors, its much easier to go without than install it >_<
$compress = false;

// If FTP is false, then it will not upload the backup to an external FTP source.
// However, it will still locally backup the database.
$ftp['state'] = true;

---

:mad::8::love::cool::sneaky2::(::blink::blush::)::thumbup1::laugh::closedeyes:

okay :) but please be caution run its once and wait until the browser load is finish usually i let the browser to run this script about 15minutes to 30minutes because if you run its multiple times its will backup many times and eat your hdd space and your ram :).


best regards,
Izz :D

Update:

Added RYL1 Support.

cool! but this day i use ipad to remote desktop to my server when i away. But cool anyway!! have to try!!!

Quote:

---

Originally Posted by dotdy

cool! but this day i use ipad to remote desktop to my server when i away. But cool anyway!! have to try!!!

---

I used iphone :P

working with RYL1?

Quote:

---

Originally Posted by RYLinspire

I used iphone :P

working with RYL1?

---

yeap its work with RYL1 just change this to RYL1 database name and remove other that no need.

Quote:

---

// Backup the Admintool DB
backup("Admintool");

// Backup the CharDelHistory DB
backup("CharDelHistory");

// Backup the Part2_Zodiac DB
backup("Part2_Zodiac");

// Backup the pay_gamemyth DB
backup("pay_gamemyth");

// Backup the RYLBillingDB_LOG DB
backup("RYLBillingDB_LOG");

// Backup the youxiCard DB
backup("youxiCard");

// Backup the youxiuser DB
backup("youxiuser");

---

:love:

Quote:

---

Originally Posted by izzdihar

yeap its work with RYL1 just change this to RYL1 database name and remove other that no need.

:love:

---

awesome , will try!!

okay :) but please be caution run its once and wait until the browser load is finish usually i let the browser to run this script about 15minutes to 30minutes because if you run its multiple times its will backup many times and eat your hdd space and your ram :).

did try , quite easy to use ,

but the way i did is remote desktop to open the browser on my server then let it run the back up , then i turn off the remote program.

when have time , back and check again and every works cool!

Quote:

---

Originally Posted by izzdihar

// Backup the Admintool DB
backup("Admintool");

// Backup the Part2_Zodiac DB
backup("winner1");

// Backup the pay_gamemyth DB
backup("pay_gamemyth");

// Backup the youxiCard DB
backup("youxiCard");

// Backup the youxiuser DB
backup("youxiuser");

---

:love::thumbup:

and you can open a browser and run the *.php script remotely also :) like http://<your server ip>.auto_backup.php :) . usually the backup progress is really fast is it? only the upload will take about 2 - 3 minutes :).

use SQLAgentServer more perfect :) ..
its also can backup database without any corrupt ..
you also can choose any format that you desire for ;)

this one can auto upload to your ftp server :) so there were no worry about losing the database :). And also can repack all of it to one archive ;).And i mentioned again this is design for portable device and i use this on my iPhone so i can always backup it even i am not on the pc ;) .

how can i excute this script? am i right? --> http://myserverIP/ auto_backup.php ?

Quote:

---

Originally Posted by BountyHunter

how can i excute this script? am i right? --> http://myserverIP/ auto_backup.php ?

---

yeap! that you were right. that were really easy way isn't it ? http://serverip/auto_backup.php or http://server1.yourdomain.com/autobackup.php

added separate version of RYL1 and RYL2 supported!get it now :P

Thanks izz i'll try it :thumbup1: