[Php]
<? Php
Require_once ('configuration. php ');
$ Jconfig = new JConfig ();
$ Connect = mysql_connect ($ jconfig-> host, $ jconfig-> user, $ jconfig-> password );
$ Result = mysql_list_tables ($ jconfig-> db );
$ Tables = array ();
While ($ row = mysql_fetch_row ($ result )){
$ Tables [] = $ row [0];
}
Mysql_select_db ($ jconfig-> db );
$ SQL = '';
Foreach ($ tables as $ table ){
$ SQL. = backupTable ($ table );
}
$ R = file_put_contents ('tmp/backup _ '. date ('Y-m-d-H-I-S').'. SQL ', $ SQL );
If ($ r ){
Die ('success ');
} Else {
Die ('lala ');
}
Mysql_close ($ connect );
Function backupTable ($ table ){
$ Sqltxt = "drop table if exists $ table; \ n ";
$ Result = mysql_query ("show create table $ table ");
$ Row = mysql_fetch_assoc ($ result );
$ Createsql = $ row ['create table'];
$ Sqltxt. = $ createsql. "; \ n ";
$ Result = mysql_query ("SELECT * FROM $ table ");
$ Rows = array ();
While ($ row = mysql_fetch_assoc ($ result )){
$ Fields = array ();
Foreach ($ row as $ field ){
$ Fields [] = '\ ''. mysql_escape_string ($ field ).'\'';
}
$ Rows [] = '('. implode (',', $ fields ).')';
}
If (! Emptyempty ($ rows )){
$ Sqltxt. = "insert into '$ table 'values". implode (", \ n", $ rows). "; \ n ";
}
$ Sqltxt. = "\ n ";
Return $ sqltxt;
}
<? Php
Require_once ('configuration. php ');
$ Jconfig = new JConfig ();
$ Connect = mysql_connect ($ jconfig-> host, $ jconfig-> user, $ jconfig-> password );
$ Result = mysql_list_tables ($ jconfig-> db );
$ Tables = array ();
While ($ row = mysql_fetch_row ($ result )){
$ Tables [] = $ row [0];
}
Mysql_select_db ($ jconfig-> db );
$ SQL = '';
Foreach ($ tables as $ table ){
$ SQL. = backupTable ($ table );
}
$ R = file_put_contents ('tmp/backup _ '. date ('Y-m-d-H-I-S').'. SQL ', $ SQL );
If ($ r ){
Die ('success ');
} Else {
Die ('lala ');
}
Mysql_close ($ connect );
Function backupTable ($ table ){
$ Sqltxt = "drop table if exists $ table; \ n ";
$ Result = mysql_query ("show create table $ table ");
$ Row = mysql_fetch_assoc ($ result );
$ Createsql = $ row ['create table'];
$ Sqltxt. = $ createsql. "; \ n ";
$ Result = mysql_query ("SELECT * FROM $ table ");
$ Rows = array ();
While ($ row = mysql_fetch_assoc ($ result )){
$ Fields = array ();
Foreach ($ row as $ field ){
$ Fields [] = '\ ''. mysql_escape_string ($ field ).'\'';
}
$ Rows [] = '('. implode (',', $ fields ).')';
}
If (! Empty ($ rows )){
$ Sqltxt. = "insert into '$ table 'values". implode (", \ n", $ rows). "; \ n ";
}
$ Sqltxt. = "\ n ";
Return $ sqltxt;
}