RsD0p9BK
11/9/2015 - 8:20 AM

export__from_query.php

// export a SQL table without access to the server or phpMyADMIN

$file = 'backups/mytable.sql';
$result = mysql_query("SELECT * INTO OUTFILE '$file' FROM `##table##`");

$file = 'backups/mytable.sql';
$result = mysql_query("LOAD DATA INFILE '$file' INTO TABLE `##table##`");

// http://monitoring.tyumen-city.ru/myadm/sql.php?db=fulldb&table=narod_average_new#PMAURL-1:sql.php?db=fulldb&table=narod_average&server=1&target=&token=b61169628ee0077ce902c4fe97e725ca