Hello and welcome to the Webmasters Forums!. This is the best place to get webmasters resources for free. Get $2 for free today, read more - Make your payment today. Download premium and professional templates for free. Get free web hosting without ads, read more. You can get lot more by simply join with this forum. To gain full access to the forums you must sign up for a free account.
Posts: 995
Group: Forum Team
Joined: Sep 2006
Status: Online
Make money from now. You can make money just for posting on this forum. Every discussions on this community gives you more money. $2 minimum payout. So get your payment today, SignIn with this forum.
HI ALL,
I WANT A SQL BACKUP SCRIPT SO THAT I CAN TAKE BACK UP OF MY SQL EASILY COZ I USE FREE SERVERS AND phpmyadmin REALY SLOW SO I M NOT ABLE TO TAKE THE BACK UP ... SO PLS SUM1 PROVIDE ME THAT SCRIPT I LL B VERY THANK FULL TO HIM ...
Script Name: PHP MySql Multiple Database Backup 1.0
Description: This script allows you to make a backup of your MySql databases in sql or gz format allowing you to restore in case of a server crash. The output sql is already compacted. You can download the backup from the server as sql or gzip. Very easy to use. No tables can be selected. The whole database will be backed-up. Contains fulltxt fields as option. Works with windows/apache too, special changes for windows time-out.
Description: Designed to create a daily snapshot of the dynamic data on your website. (e.g. content management systems, forums, guestbooks etc.) Some of the features include: - Backup multiple databases and servers with different users and passwords. - Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems). - Create daily, weekly and monthly snpashots of your database. - Keep the daily, weekly and monthly backups for a user-specified time. - Archive and compress the SQL files (*.tar.gz). - Creates a detailed report of everything that has been done. - Reports can be mailed to you or any other user-specified email-address, saved to disk or displayed in browser. - Generated SQL files can be mailed to you or any other user-specified email-address. - Generated SQL files can be uploaded by FTP to any user-specified FTP server. - Choose to create SQL files for each table or one for each database - No system calls, everything in 100% pure PHP.
Description:
This class can be used to backup large MySQL databases into multiple files. It can list the tables of a given MySQL database and generate SQL statements to create and insert records with the current values of the table rows, as if it was creating a new database. The class stores the generated SQL statements in files. A full backup process can be split in multiple iterations to not exceed PHP default script execution time limit. Each iteration dumps a limited number of table rows. An iteration can be executed by a script that redirects the page request to itself at the end to proceed to the next iteration.
But iven bro what this backup for
i mean when we shift from one to another server,our database names also changes
so how we can restore that to original?
But iven bro what this backup for
i mean when we shift from one to another server,our database names also changes
so how we can restore that to original?
No problem with your script if you changed the database name. The database is just using as a reference. You just want to connect your scripts to the database. The important part is the data stored in that database. Its structure should remains intact.
if you have cpanel you can do a full backup of your site, if you are wanting to basically move from one site to another...
full backups require the server admin to install it for you.
if you are just wanting your database then you can go into backup and choose the database that you are wanting to transfer...