$backuptime = "DB_Backup_".DB_NAME."-".time().".sql"; //$backuptime = DB_NAME.".sql"; $data["db_file_name"] = $backuptime; $insert = $CommonObj->insert_query("db_backup",$data); $str = ""; $show_tables = "show tables from ".DB_NAME; $tables = $db->query($show_tables); if($tables){ while($row = mysql_fetch_assoc($tables)){ $table = $row["Tables_in_".DB_NAME]; $show_each_tables = "show create table ".$table; $each_tables = $db->query($show_each_tables); $each_tables = mysql_fetch_assoc($each_tables); $str .= $each_tables["Create Table"]; $str .= ";\n\n"; $show_column = "SHOW COLUMNS FROM $table"; $column = $db->query($show_column); $get_val_query = "select * from $table"; $get_val = $db->query($get_val_query); if($column && mysql_num_rows($get_val)>0){ $str .= "INSERT INTO `$table` ("; while($cols = mysql_fetch_assoc($column)){ $str .= '`'.$cols["Field"].'`, '; } $str = substr($str,0,-2); $str .= ") VALUES \n"; } if($get_val && mysql_num_rows($get_val)>0){ while($vals = mysql_fetch_assoc($get_val)){ $str .= "( "; foreach($vals as $k=>$v){ $v= mysql_real_escape_string($v); $str .= '"'.$v.'", '; } $str = substr($str,0,-2); $str .= "),\n"; } $str = substr($str,0,-2); } $str .= ";\n\n"; } } $handle = fopen(DIR_DB.$backuptime,'w+'); fwrite($handle,$str); fclose($handle);
Html, JAVA,DOTNET,Javascript, PHP, and JQuery Scripts and its issues with solutions
Showing posts with label php mysql backup class. Show all posts
Showing posts with label php mysql backup class. Show all posts
Thursday, 31 July 2014
How to export My Sql Database Backup in php?
Subscribe to:
Posts (Atom)
Feet/Inches to Meters Converter & Lbs to Kgs Converter
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Feet/Inches ⇄...
-
<?php $to = "somebody@example.com, somebodyelse@example.com"; $subject = "HTML email"; $message = " <h...
-
ISAIMINI.COM Download
-
document.onkeydown = myKeyDownHandler; function myKeyDownHandler(event){ alert(event.keyCode) }