PHP - Backup Question

Ok. I managed to do something like this:

I used CreateZipFile classs from php classes!

Code: [Select]
<?php
include_once 'CreateZipFile.inc.php';

$createZip = new CreateZipFile;

$createZip->zipDirectory('binary', '');

$zipFileName = 'backup.zip';
$handle       = fopen($zipFileName, 'wb');
$out           = fwrite($handle, $createZip->getZippedFile());

fclose($handle);

$createZip->forceDownload($zipFileName);

@unlink($zipFileName);
?>

but there is still one small issue. The archive doesn't contain any empty folders within the binary folder.

How would I go about using PHP to export all the data in my SQL database to a .sql file? Also how can I then import that .sql file back into the database?

Thanks!

I looked into this everywhere,but the code does not make sense, is not properly documented and is outdated.


Ive been trying to achieve this for the past hour.

Anybody know how I can do this?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=314405.0

Can we create a backup of database entered data in PHPMYADMIN?

As you know if we are using locally any database through php then in case of system crash or the like our all the enterred saved data  in the database will gonna be lost
 i want to know that is it possible to create a back up for our saved data in the database and if is it possible then how can we do it????

hi all

i am looking for the quickest way to zip all files and folder of a website i am currently using the followning.

<?php
$date = date("F-j-Y-g-ia");

if(exec("cd /home/isd/public_html/bk/files;tar -cvpzf backup-$date.tar /home/isd/public_html")) {

echo "done";

 
 

}  

?>

This works but was just wondering if anyone can give me and insight on a better solution??

Thanks

Hi, I have a some online backup software call ahsay, I' am looing to create a API call with a form in PHP

Please check out this link www.123-backup.com/obs-admin-guide.pdf

this is the guide to create a api for the  online backup (page 69)

Would some be intrested in creating this api call and php form for me ?

p.s please see attached image this is something i'am looking for.

if so how much would it be please email me if you want more info!

Here is function that backup mysql database. It's working fine, but I want to download file instead of creating it.




/* backup the db OR just a table */
function backup_tables($host,$user,$pass,$name,$tables = '*')
{

$link = mysql_connect($host,$user,$pass);
mysql_select_db($name,$link);

//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}

//cycle through
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);

$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) 
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++) 
{
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}

//save file
$date= date("d-M-Y_h-i");
$handle = fopen('Backup-'.$date.'.sql','w+');
fwrite($handle,$return);
fclose($handle);
}


Usage:
Quote

backup_tables('HOST','USER','PASS','TABLE');

But this will create backup file on server.


I also tried to add following code in function (at the end):

echo $return;
header('Content-type: text/plain');
header("Content-Disposition: attachment; filename=\"$filename\"");


How to just download file, without showing it on screen instead of using fwrite/fclose function?

when in a form, I wish to build a conditional that if the response to a radio button is a value of 2 (female), it will display an input requesting for users maiden name. If not 2 goes to the next input statement.

Here is code I was experimenting with:


<html>
<body>
<form action="" name="test"  method='POST'>
<input type="radio" id="sex" value=1 checked><label>Male</label>
<input type="radio" id="sex" value=2><label>Femaleale</label>

    <?php
    $result = "value";
    if ($result == 2)
        echo "<input type='int' id='gradYear' size='3' required>";
        else
        echo "Not a female!"
    ?>

    <input type="submit" value="GO">
</form>
</body>
</html>


The code passes debug, however, Not a Female is displayed.

My question is - Can I do this and if so, what value do I test against id='sex' or value. I tried each one but gave the same results. I realize that $_POST[sex] would be used after the submit button is clicked. But this has me stumped.

Thanks for the assis in advance.

I have an issue with the below code

Code: [Select]
if ($gtype == "%24L" || $gtype == "$L")
The value actually starts with the dollar sign then L, but its being read as a variable that's not assigned so it showing as blank. so the question is how to I get to check and see if the value of gtype actually is $L in a way that it wont read $L as a variable and as a value instead?

hi php people,

I am wondering will  if the code below will work when I call $C->getafoo() will I get foo;  I keep getting an error at this point  return $this->A->a(); saying  the method is not there

Code: [Select]
class A{
  public function a(){
    return "foo";
  }
}

class B {
  public $A;

  function __construct($A) {
    $this->A = $A;   

  }

  public function geta(){
    return $this->A->a();
  }
}


class C extends B{
  public function getafoo(){
   return geta();
 }

}
$C = new C(new A());

echo $C->getafoo();

i have took a test that i think it has some errors:

can you please confirm or infirm that A is the right answer?



Question:    

The default value for __FILE__ is _______________________________.

 
   
A.    

the complete path of the currently executing script

B.    

the relative path of the currently executing script

C.    

a magical constant; it does not have a default value

D.    

the complete path of the previous executed script

E.    

the relative path of the previous executed script

Correct Answer:    C
User Answer:    A
Explanation:    The PHP engine stores the full path and filename of the currently executing script within the __FILE__ constant.

Code: [Select]
    /*** a new dom object ***/
    $dom = new domDocument;

    /*** load the html into the object ***/
    @$dom->loadHTML($file);

    /*** discard white space ***/
    $dom->preserveWhiteSpace = false;

    /*** the table by its tag name ***/
    $tables = $dom->getElementsByTagName('table');

    /*** get all rows from the table ***/
    $rows = $tables->item(0)->getElementsByTagName('tr');

    /*** loop over the table rows ***/
    foreach ($rows as $row)
    {
        /*** get each column by tag name ***/
        $cols = $row->getElementsByTagName('a');
        /*** echo the values ***/
        echo $cols->item(0)->nodeValue.'<br />';
    }
Hi, Is there a way to start to echo from 43?
thanks.

Hello. I'm trying to pull information out of an xml file. However I'm a bit lost in getting the actual value.

Code: [Select]
$url="http://ws.audioscrobbler.com/2.0/?method=artist.getimages&artist=Dr%20Feelgood&limit=1&autocorrect=1&api_key=c107c9b5c09cb5693b6c19409dd984c1";

$xml = simpleXML_load_file($url,"SimpleXMLElement",LIBXML_NOCDATA);

$largesquare=$xml->images->sizes->size[2];
Is what I have but its not pulling the information. The above url will give you the link to a set xml file for this example. And I want to get the info for the

Code: [Select]
<size name="largesquare" width="126" height="126">http://userserve-ak.last.fm/serve/126s/43173899.jpg</size>
I'm sure I'm doing something wrong that's a simple fix but I am lost here. In the sizes there are 6 different size options each with different names and I have no idea how to pull the one with the correct name that I need.

Thank you to who ever can help me sort this out.

I'm considering getting a VPS, but I'm not entirely sure what this would be able the handle. The specs doesn't look that good to me, but my friend swears it will handle running apache/php/mysql handling large websites and databases without a problem. I want to run multiple databases that just store statistics and I'm a bit worried about the RAM and the company doesn't even mention a cpu.

Here's the specs:
256MB RAM
300GB HDD
10Mbps unmetered
1 IP Address

My friend runs two counter-strike: source servers off his VPS (same stats).. so I'm actually considering this, but it just seems like it's not powerful enough.

Oh.. forgot the most important part.. it's only $9.