{"id":113,"date":"2014-02-01T10:35:40","date_gmt":"2014-02-01T11:23:30","guid":{"rendered":"https:\/\/daa7fftp-backup-script.jpg"},"modified":"2016-07-04T00:34:07","modified_gmt":"2016-07-04T06:34:07","slug":"funcion-para-hacer-un-respaldo-de-mysql-y-php","status":"publish","type":"post","link":"https:\/\/emanuelpaxtian.com\/blog\/funcion-para-hacer-un-respaldo-de-mysql-y-php\/","title":{"rendered":"Funcion para hacer un respaldo de Mysql y php"},"content":{"rendered":"<p>Aqui les traigo una funion para hacer resplado de la base de datos de mysql con php<\/p>\n<p>Solo deberemos incluir la funci\u00f3n a nuestros proyecto y luego llamar la funci\u00f3n donde le deberemos indicar los datos de acceso y especificar la tabla a respaldar o solo especificar los datos de conexi\u00f3n para respaldar todo<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\nfunction respaldo($host,$user,$pass,$name,$tables = '*')\r\n{\r\n   $link = mysql_connect($host,$user,$pass);\r\n   mysql_select_db($name,$link);\r\n   \r\n   \/\/ obtener todas las tablas\r\n   if($tables == '*')\r\n   {\r\n      $tables = array();\r\n      $result = mysql_query('SHOW TABLES');\r\n      while($row = mysql_fetch_row($result))\r\n      {\r\n         $tables&#x5B;] = $row&#x5B;0];\r\n      }\r\n   }\r\n   else\r\n   {\r\n      $tables = is_array($tables) ? $tables : explode(',',$tables);\r\n   }\r\n   \r\n   \/\/cycle through\r\n   foreach($tables as $table)\r\n   {\r\n      $result = mysql_query('SELECT * FROM '.$table);\r\n      $num_fields = mysql_num_fields($result);\r\n      \r\n      $return.= 'DROP TABLE '.$table.';';\r\n      $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));\r\n      $return.= &quot;\\n\\n&quot;.$row2&#x5B;1].&quot;;\\n\\n&quot;;\r\n      \r\n    for ($i = 0; $i &amp;lt; $num_fields; $i++)\r\n      {\r\n         while($row = mysql_fetch_row($result))\r\n         {\r\n            $return.= 'INSERT INTO '.$table.' VALUES(';\r\n            for($j=0; $j&amp;lt;$num_fields; $j++) \r\n            {\r\n               $row&#x5B;$j] = addslashes($row&#x5B;$j]);\r\n               $row&#x5B;$j] = ereg_replace(&quot;\\n&quot;,&quot;\\\\n&quot;,$row&#x5B;$j]);\r\n               if (isset($row&#x5B;$j])) { $return.= '&quot;'.$row&#x5B;$j].'&quot;' ; } else { $return.= '&quot;&quot;'; }\r\n               if ($j&amp;lt;($num_fields-1)) { $return.= ','; }\r\n            }\r\n            $return.= &quot;);\\n&quot;;\r\n         }\r\n      }\r\n      $return.=&quot;\\n\\n\\n&quot;;\r\n   }\r\n   \r\n   \/\/save file\r\n   $handle = fopen('db-backup-'.time().'-'.(md5(implode(',',$tables))).'.sql','w+');\r\n   fwrite($handle,$return);\r\n   fclose($handle);\r\n}\r\nrespaldo(&quot;localhost&quot;,&quot;root&quot;,&quot;admin&quot;,&quot;base&quot;);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Aqui les traigo una funion para hacer resplado de la base de datos de mysql con php Solo deberemos incluir la funci\u00f3n a nuestros proyecto y luego llamar la funci\u00f3n&hellip;<\/p>\n","protected":false},"author":1,"featured_media":655,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,5],"tags":[],"class_list":["post-113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-php"],"_links":{"self":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":0,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media\/655"}],"wp:attachment":[{"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emanuelpaxtian.com\/blog\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}