Backup Of Website

PHP MySQL Website Backup
I've found tantalizing scripts that purport to do exactly what I want (daily DB, weekly website backups) However, through may lack of familiarity with perl and **nix Each one has failed.

Is there a way to use a PHP script to compress the entire website (and the dB on a seperate occasion) into a tar.gz? The zlib functions seem to be for zipping individual files. I can see FTP functions in PHP that should make executing the move. Creating the file seems to be the hard part.

Or is there a way to execute the **nix command line looking stuff from the middle of a PHP script?

Naturally the web-host guys know less than I do about this stuff (comforting). But I can schedule cron jobs and have been successful pointing at a file (which just gives me an error).

---

Change Website To Php,mysql Data-driven Website
At the moment this site is not completely php. How can I make the content of the pages be from a mysql database? and how do I make the nav buttons work correctly connecting to the mysql database and displaying the correct content, ?

---

How To Upload File From Website To My Website?
I want to make upload page. I could upload file from computer to my website. But I don't know how to upload file from website to my website? How can I make it?

---

Automatic Backup Of SQL
I'ved maked a bacup sistem that saves a specific databases in a dir/ BACKUP .. on submiting a button from a form.

Now I want to make it automatic ... the specific file when is written saves the date and time is saved . PHP Code:

---

Backup And Restore
I backed up all of my databases at once into a single file by using the alldatabases argument of mysqldump. Now I don't know how to restore them. Does anybody have an idea?

---

Database Backup
Is there a function that backs up the mysql database you have? Or did the people who wrote phpmyadmin actually write a function for it.

---

Mysql Backup Via Php?
I am wanting to automatically do dump of a mysql database nightly
using cron and some kind of script that will email the whole db structure to
me (as an attachment or as plain text in my email) - including the data in
the db. So, if the db was ever lost, I could go to my email, find the dump
and copy and paste it into the mysql db again.

Does anyone know how to do this in PHP or of a premade (and free) script out
there, preferably written in PHP?

---

MySQL Backup
I've got a feeling that I may have asked this before but I can't find the
answer if there was one offered so apologies for that...

I've written a little content management system and I want to give the user
the ability to back up their database. I've looked at the relevant pages in
PHPMyAdmin but I'm not any closer to an answer. I just want something very
simple where they click on a link and it displays a complete dump of the
tables and the inserts for them to copy and paste into a .txt file.

---

Mysql Backup Help Please
I hope this question isn't too far off topic....I'm almost at my wits
end trying to figure this out.

I have a Mysql database and I wish to automate the backup of the
database because I don't wish to rely on the web host doing so. I am
using the "dbsender.php" script, which is written for this exact
purpose (available at hotscripts.com). If I execute the script via my
browser, the database is emailed to me in a 'gzip' format, which is
perfect.....the script works just great. However, when I set a cron
job to automate this task, I get an empty '.gz' file attached to the
email instead of a ".gz" file containing my database.

Seeing as the scipt works properly when executed via the browser, the
script is fine. The cron job does it's task on time, and the empty .gz
attachment even has the correct name to it so I'm sure the command
path is correct.....but the attached .gz file is empty.

What on earth could be wrong? I have tried other scripts with
exactly the same result.

I'll past the code below in case some kind soul can shed some light on
this frustrating problem.

dbsender.php script below

#!/usr/local/bin/php
<?php
// configure your database variables below:
$dbhost = 'localhost' // Server address of your MySQL Server
$dbuser = 'cookie_neil' // Username to access MySQL database
$dbpass = 'airbourne' // Password to access MySQL database
$dbname = 'cookie_shop' // Database Name

// Optional Options You May Optionally Configure

$use_gzip = "yes"; // Set to No if you don't want the files sent in
..gz format
$remove_sql_file = "yes"; // Set this to yes if you want to remove the
..sql file after gzipping. Yes is recommended.
$remove_gzip_file = "no"; // Set this to yes if you want to delete the
gzip file also. I recommend leaving it to "no"

// Configure the path that this script resides on your server.

$savepath =
"/home/cookie/domains/mydomain.co.nz/public_html/dbsender"; // Full
path to this directory. Do not use trailing slash!

$send_email = "yes"; // Do you want this database backup sent to your
email? Fill out the next 2 lines
$to = "my@email.co.nz"; // Who to send the emails to
$from = "database@mydomain.co.nz"; // Who should the emails be sent
from?

$senddate = date("j F Y");

$subject = "MySQL Database Backup - $senddate"; // Subject in the
email to be sent.
$message = "Your MySQL database has been backed up and is attached to
this email"; // Brief Message.


$use_ftp = "no"; // Do you want this database backup uploaded to an
ftp server? Fill out the next 4 lines
$ftp_server = "localhost"; // FTP hostname
$ftp_user_name = "ftp_username"; // FTP username
$ftp_user_pass = "ftp_password"; // FTP password
$ftp_path = "/"; // This is the path to upload on your ftp server!

// Do not Modify below this line! It will void your warranty!

$date = date("mdy-hia");
$filename = "$savepath/$dbname-$date.sql";
passthru("mysqldump --opt -h$dbhost -u$dbuser -p$dbpass
$dbname >$filename");

if($use_gzip=="yes"){
$zipline = "tar -czf ".$dbname."-".$date."_sql.tar.gz
$dbname-$date.sql";
shell_exec($zipline);
}
if($remove_sql_file=="yes"){
exec("rm -r -f $filename");
}

---

Auto Backup
how will i take auto backup mysql database table data after 6 hours daily? i know that this is very easy to take backup database table or full database manualy by using mysql dump syntax but i need to take it autometicaly daily after 6 hours.

---

Doing Database Backup
I have this site where I runs on 2 server. One is for backup purposes and one is the main server. I have a portal running and therefore, there are heaps of changes going on my database. the question now is, how can i ensure that both have the up-to-date data?

if either one does an update, i would like to have both databases being updated as well. never done this before and i don't even have a single clue on how to start.

---

Backup With Mysqldump
I use Windows XP and Apache.

I am trying to backup a database on my local computer with the
following php code:

$dbname = 'ol'
$dbhost = 'localhost'
$dbuser = 'root'
$dbpass = 'password'
$backupFile = $dbname .'-' .date("Y-m-d-H-i-s") . '.sql'
$command = "mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname >
$backupFile";
if (!system($command, $retval)){die('Backup failed.);}

It does produce a file like C:Program Filesxampphtdocs
onlinelearningol-2007-06-20-13-31-09.sql, but it is empty.

mysqldump.exe is at C:Program Filesxamppmysqlinmysqldump.exe and
the script is sitting in the folder C:Program Filesxampphtdocs
onlinelearning.

When I put a copy of mysqldump.exe in the folder C:Program Filesxampp
htdocsonlinelearning I get a black sreen saying 'Enter password:'.
When I give the password I get a file like this:

-- MySQL dump 10.10
--
-- Host: localhost Database: ol
-- ------------------------------------------------------
-- Server version5.0.18

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

---

---

Backup Script
I am atempting to make a very very simple MySql Backup page. I have the following code and the backup.sql is blank I have tryed doing the backup in the shell and the mysqldump dosent send anything. where am i going wrong? or is there a script that works that any one has i can use :

<?php

$dbhost = 'localhost';
$dbuser = 'root'; 
$dbpass = '';
$dbname = 'call_log'; 
$filename = "backup.sql";
passthru("mysqldump --opt -h $dbhost -u $dbuser -p $dbpass $dbname > $filename");

?>

---

Backup A Webpage
Is there a way with php to backup/mirror a page? I know that I can use file_get_contents() to get the HTML from the page, however how can I get the images etc to be downloaded and stored on the server?

---

MySQL Backup
I`m using the following code to list the tables, adding a checkbox next to the tables so I can select what tables I want to back up.

However after submitting the form, I`m having this error.

Warning: Invalid argument supplied for foreach() in C:Serverhtdocsadminincfunctions.php on line 6228
That line is:
foreach ($tables as $table)in the performExport($tables) function.

I`ve stared at this for hours now and I can`t see a problem. Code:

---

BackUp And Email DB Using PHP
I have a DB which needs to be backed up regularly. It is on a shared server.  I need to write a php script that a)backs up the DB and b) kindly emails me the backed up file. I would be happy with a non compressed .sql (text) file.

---

Backup Script
From this page, I have this. It isn't working, and I don't know why. It downloads the zip file but says the archive is damaged, and it has zero bytes.

And this for backing up the database. Also not working, also no idea why. Any ideas? Kind of desperate for assistance here.

---

Mysqldump Backup/restore
I have been trying to get a backup/restore Script working for some time but have had little luck. Is it possible that i can:

1) Have a script that will backup my database and structure to a file, i.e: backup_current_date_and time.sql

2) Make a PHP script that will let me view all the sql files in a directory on my webserver and restore the one i select?

---

Automating PHP / MYSQL Backup
I am using php exec to run mysqldump and take a backup of my database, it runs just fine, but someone mentioned that I could get CRON (or something) to automate the running of my backup.php script. My script is called backup.php3 and is located in the ../../web/database directory.

My site is hosted by a ISP, I can run perl, php, mysql, etc but I have absolutely no idea how to set up a CRON script to call a PHP script (I don't know what a cron script is come to that!? All I need is something (simple and easy!) to call and run the backup.php3 script, the php will do the rest!

---

Backup PostgreSQL With PHP Or Perl
I need to backup a postgres database from a web page so I either have to use PHP or PERL. I'm familiar with backing up and restoring via the shell. Does anyone have an idea on how to do this?

---

MySQL Database Backup
I'm looking at using PHP and MySQL for a particular website application.
However, I was a bit concerned that if a PHP script went wrong then it would
be possible to accidentally delete or overwrite large chunks of the data in
the database which presumably would then be lost. What is the usual
procedure for these situations?. Is it possible to back up a database
somehow so that data from a previous time can be retrieved?.

---

Backup MySQL Database
How does one go about using cron jobs to create a MySQL database dump each evening?

I have cPanel with my hosting and when i go to cron jobs i have a 'Command to run:

---

Mysql Backup Connection In PHP
I notice with PHP if a connection cannot be established to a mysql
server with mysql_connect() PHP will timeout and never try the backup
server. In this example:

$db = mysql_connect('db1.local.net', 'username', 'password');
if (!$db) {
$db = mysql_connect('db2.local.net', 'username', 'password');
}

This works great and connects to the 2nd database if the 1st one
rejects the connection completely; however, if the 1st db is under high
load and doesn't respond for 10+ seconds it never jumps to the 2nd one.
Curious if there's a better way to accomplish this. If the 1st db
doesn't respond in 1 second max I'd like to hop to the 2nd one.

---

MySQL, Backup A Table In PHP
Assuming the table MYTABLE, i want to run a script to backup the table.
But there does not seem to be a straight forward function in MySQL to
achieve it,

Something like
COPY TABLE MYTABLE, bkpMYTABLE;

What would be the easiest way to do that using php?

I know that i can create a table bkpMYTABLE and INSERT the data from MYTABLE
to bkpMYTABLE but the problem is that i will be using the script to run
updates so i will not always know the structure of the data that the user is
copying, (because the script(s) will be precisely used to update the
structure of the table).

Maybe there is a function to retrieve the current structure and then copy
the data?

Also is there a way of testing if a table exists? and to test if a field
within that table exists?

---

MYSQL Backup & Restore Using PHP ?
I'm looking for a script that will allow users/admins to have a one
click backup solution for a MYSQL Database..

'BACK DATABASE' button, click and its done...

The a restore option, that shows all current backups, and restores the
selected one with one click...

---

MySQL Backup W/o Dump?
is there some free script that exports a whole database to a file similar
to mysqldump but without using mysqldump?
It should not be embedded too deeply into an application since I want to
include it into another open-source project without having to disassemble a
major other script such as phpMyAdmin.

---

Problem With MySQL Backup Script
I am having problems with the following script:

<BLOCKQUOTE>
<font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
<?
$db_user = "extremeforums";
$db_password = "password";
$db_host = "localhost";
$db_name = "extremeforums";
$backup_dir = "/www/extremeforums/backup";
$date = date("Y_m_d");
$command = `mysqldump -u$db_user -p$db_password $db_name | gzip > $backup_dir/$db_name$date.gz`;
if (exec($command) == 0) {
echo "Backup Successfull!";
}else {
echo "Backup Failed!";
}
?>

It will successfully create the archive but it doesnt contain anything. Its total size is like 20 kb.

The funny this is the command will work from telnet but when fed thru this script it just chokes.

---

Using System/exec, How To Backup Database?
system("mysqldump --opt myDatabase > backup.sql");

here are my problems,

i don't think it works on the webserver. next, where exactly the file, backup.sql be place if it does succeed.

i believe we just can't execute commands on the webserver can we?

i also tried using the sql query BACKUP TABLE ... TO .. but i'm guessing the problem lies with the TO... how do i know what directory shall i place it therE?

for instance, my pages are placed in,

home/myname/public_html/...

i tried to put
home/myname/public_html/backup in the TO but nothing happens.

---

Need To Restore Phpmyadmin Mysql Backup
I have a 650 meg SQL file (!) that I need to dump back into one of our databases. However when I try to run it as a file phpmyadmin just says "Document contains data" which I guess it because the document contains too much data. Any suggestions on how to get around this? I really need to get the DB back up and running - our server got hacked.

---

Restoring A Mysql Backup From File
I have a .sql backup of my entire database, and I want to have a php page that will restore that file to a certain database, the query I am using is this:

mysql_select_db("test_forum");

$tableName  = 'test_forum';
$backupFile = 'test_forum.sql';
$query = "LOAD DATA LOCAL INFILE '$backupFile' INTO TABLE $tableName";
$result = mysql_query($query) or die("Failed: ".mysql_error());
I can see the problem in this code too, its right here:

INTO TABLE $tableName

I don't want to restore into a table, I want to restore the entire database.  Is there something I'm missing, or is this not possible?

---

Restore MySQL Database Backup File Through PHP?
I wrote a PHP script to backup my complete database and send it through email. When I import the file through PHPMyAdmin, everything works. However, when I try to restore the database through PHP (I found similar code on several sites), it doesn't do anything:

$restore = "mysqlimport -u $dbuser -p $dbpass $dbname $location";
$importFile = system($restore, $return);

This is what $restore contains: mysqlimport -u user12345 -p pass12345 database12345 tempdata/backuprestore/mp_database_15-09-2007.sql

I also tried shell_exec instead of system aswell, but this didn't work either. Does anyone know how I can do this with PHP? I need this for my admin panel.

PS: mysqlimport is used to import data into a already existing database, right? Since that's what I need.

---

PHP Based File/folder Backup Script
Does anyone know of any OSource scripts to read the file/dir structure and then compress it into one zip/tar/gzip file to then be deliverd to the end user via http/https download.

---

Php Program To Backup/restore Mysql Database?
I'm looking for a PHP program to backup and restore a mysql database.

I'm using Godaddy to host a forum. Their mysql control panel will only
restore a database of two megabytes or less. My database is over 13
megabytes in size.

---

I Have 100 Servers Which Need A New Backup Server Added To A Text File,
This seems easy but I have been asking tcl and python IRC chat all day
and no one gave an answer.
I have 100 servers which need a new backup server added to a text file,

and then the backup agent restarted.
If I have a list of the servers, all with same root password, and the
connection is ssh.
How do I connect to the server, cat the line to the config file, stop
adn start the agent, and then do same to next server in list and
iterate through the 100 servers.

---

Making A Database Backup To Local Server And Upload Files To Another?
I want to make a script that backups the *.frm and *.MYD files to my server and I also want to upload those files to another server via FTP? I have a copy of the database files in the directory, that works fine. But my ftp part doesn't! PHP Code:

---

Easiest Way To Backup Your MySQL Database On Multiple FTP Servers For FREE!
Here's the only tool you need to do scheduled backups of your MySQL database
on multiple FTP servers! It PHP based so there's no lengthy installation
process involved. Extract the file on any directory of your choice, edit the
configuration file and you're good to go! And best of all.... IT"S FREE!!!

Visit: http://sourceforge.net/projects/myphpdumptool/

---

Automatic Scheduled MySQL Backup (MySQL Dump)
Is it possible to configure a UNIX/LINUX server to do a MySQL Dump for a database on an automatic schedule and then to email the dump file to me (the administrator)?

I want to be able to have my database automatically backed up every week and emailed to me for storage purposes without any action on my part.

---

PHP Website
Is the php website down.

I am unable to access the documentation.

www.php.net

---

RSS To Website
I have a client who has given me a link to some other websites RSS Feed , he want to display the data in his website from RSS FEED. Hoe to make this. Is it like reading the xml and displaying or is there some other way to do this.

---

Get Website URL
I've seen scripts which get the exact url to the path where I'm using this script. It gets the full website url with sub folders, etc.: http://www.test.com/...

How can I do this in php?

---

Where To Get 'website Spider' Bot For PHP?
Hi, I have a somewhat weird request, but I have a legit reason. My new CMS is having performance problems, and we are trying to resolve the issue by implementing a bot or spider that grabs the HTML of the site every 30s.

I was wondering if you guys could kindly tell me where to get such bots. The program will be installed on another server with cronjob to run every 15s.

The 'website performance' check services out there are limited to 2 minute interval. I need something that hits the target site in question more frequently.

---

PHP Website Security
We have developed an ads network script for running ads network site. Can someone please guide us on security features that we must implement to prevent hecking and exploits...?

We have looked into major security problems commonly known like image uploads checks but I would like to know more on other security checks that are generally over looked.

---

Set Two Cookies For The Same Website, But Not For The Same Url.
It is possible to set two cookies for the same website, but not for the same url? What i means is: you have 1 login form. Out of that loginform, two cookies should be set. One cookie should be set for yoursite.com. The other cookie should be set for subdomain.yoursite.com (like forum.yoursite.com). The information in this cookies will be different.

---

Maintaining Your Website With Php
I've heared of a script (on this board) of a script that allowed you to easily update stuff on your site with this PHP script.

---

Website Picture From PHP
does anyone of you know a save method on PHP to relyably, maybe using other
programs create scrennshots (thumbnails) of websites?

I am the administrator of the open source project (at SourceForge) "TSEP -
The Search Engine Project" (http://tsep.sf.net) and we might want to show
pictures of the website our search engine has found. The generation process
of the thumbnails should be pretty automatic (as much as possible)

My tries to find an "optimal" solution did not bring any good results yet,
so I am hopeing for better information here.

---

PHP Website Management
I have just bought a small website written with php & html. The
vendors advised me that once I uploaded it to my website I could
customise all the templates to give it whatever look I wanted.

As a novice, I had no idea how difficult this would be - due to the
fact that a php website is very disjointed.

Can anyone tell me of any software I can download that will enable me
to manage my website so that I can see the structure in it easily and
make changes simply.

(I thought I was buying 60 sets of templates but what I bought was a
site with 60 pages).

---

How Can I Download A Website
I am not sure if this qustion is just for php expert:
How can I download a website including all html, javascript, gifs, etc.

---

XML RSS Reader With BBC Website..
I have made an RSS reader and am testing on the BBC website, and I use
this code to grab the contents of the XML file, however when I look at
the contents grabbed by my function, and the HTML source of the bbc
website XML, they are different... how is that even possible?

Anyone have an XML parser that they could test this on please? Heres a
sample link and my code:
http://newsrss.bbc.co.uk/rss/sporto...ootball/rss.xml

$ch = curl_init($feed);
$fp = fopen($rss_name, "w");

curl_setopt($ch, CURLOPT_FILE, $fp);
curl_setopt($ch, CURLOPT_HEADER, 0);

curl_exec($ch);
curl_close($ch);
fclose($fp);

---

Script To Log Into Website
I'm looking for a script that will attempt to log into a website (ex. Gmail) and report back if it suceeded or not. I don't know if this can be done with PHP or another language.

---