11/12/2008, 07:41
|
|
Respuesta: script dump base de datos erros de sintaxis Código PHP: <?php @set_time_limit( 0 ); echo( "- Base de Datos: '$db_name' en '$db_server'.<br>" ); $error = false; $tablas = 0; if( !@function_exists( 'gzopen' ) ) { $hay_Zlib = false; echo( "- Ya que no está disponible Zlib, salvaré la Base de Datos sin comprimir, como '$filename'<br>" ); } else { $filename = $filename . ".gz"; $hay_Zlib = true; echo( "- Ya que está disponible Zlib, salvaré la Base de Datos comprimida, como '$filename'<br>" ); } if( !$error ) { $dbconnection = @mysql_connect( $db_server, $db_username, $db_password ); if( $dbconnection) $db = mysql_select_db( $db_name ); if( !$dbconnection || !$db ) { echo( "<br>" ); echo( "- La conexion con la Base de datos ha fallado: ".mysql_error()."<br>" ); $error = true; } else { echo( "<br>" ); echo( "- He establecido conexion con la Base de datos.<br>" ); } } if( !$error ) { // MySQL versión $result = mysql_query( 'SELECT VERSION() AS version' ); if( $result != FALSE && @mysql_num_rows($result) > 0 ) { $row = mysql_fetch_array($result); } else { $result = @mysql_query( 'SHOW VARIABLES LIKE \'version\'' ); if( $result != FALSE && @mysql_num_rows($result) > 0 ){ $row = mysql_fetch_row( $result ); } } if(! isset($row) ) { $row['version'] = '3.21.0'; } } if( !$error ) { $el_path = getenv("REQUEST_URI"); $el_path = substr($el_path, strpos($el_path, "/"), strrpos($el_path, "/")); $result = mysql_list_tables( $db_name ); if( !$result ) { print "- Error, no puedo obtener la lista de las tablas.<br>"; print '- MySQL Error: ' . mysql_error(). '<br><br>'; $error = true; } else { $t_start = time(); if( !$hay_Zlib ) $filehandle = fopen( $filename, 'w' ); else $filehandle = gzopen( $filename, 'w6' ); // nivel de compresión if( !$filehandle ) { $el_path = getenv("REQUEST_URI"); $el_path = substr($el_path, strpos($el_path, "/"), strrpos($el_path, "/")); echo( "<br>" ); echo( "- No he podido crear '$filename' en '$el_path/'. Por favor, asegúrese de<br>" ); echo( " que dispone de privilegios de escritura.<br>" ); } else { $tabledump = "-- Dump de la Base de Datos\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); setlocale( LC_TIME,"spanish" ); $tabledump = "-- Fecha: " . strftime( "%A %d %B %Y - %H:%M:%S", time() ) . "\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "--\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "-- Version: " . Str_VERS . ", del " . Str_DATE . ", [email protected]\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "-- Soporte y Updaters: http://insidephp.sytes.net\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "--\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "-- Host: `$db_server` Database: `$db_name`\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "-- ------------------------------------------------------\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $tabledump = "-- Server version ". $row['version'] . "\n\n"; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); $result = query( 'SHOW tables' ); while( $currow = fetch_array($result, DBARRAY_NUM) ) { fetch_table_dump_sql( $currow[0], $filehandle ); fwrite( $filehandle, "\n" ); if( !$hay_Zlib ) fwrite( $filehandle, "\n" ); else gzwrite( $filehandle, "\n" ); $tablas++; } $tabledump = "\n-- Dump de la Base de Datos Completo."; if( !$hay_Zlib ) fwrite( $filehandle, $tabledump ); else gzwrite( $filehandle, $tabledump ); if( !$hay_Zlib ) fclose( $filehandle ); else gzclose( $filehandle ); $t_now = time(); $t_delta = $t_now - $t_start; if( !$t_delta ) $t_delta = 1; $t_delta = floor(($t_delta-(floor($t_delta/3600)*3600))/60)." minutos y " .floor($t_delta-(floor($t_delta/60))*60)." segundos."; echo( "- He salvado las $tablas tablas en $t_delta<br>" ); echo( "<br>" ); echo( "- El Dump de la Base de Datos está completo.<br>" ); echo( "- He salvado la Base de Datos en: $el_path/$filename<br>" ); echo( "<br>" ); echo( "- Puede bajársela directamente: </strong><a href=\"$filename\">$filename</a>" ); $size = filesize($filename); $size = number_format( $size ); $size = str_replace( ",",".",$size ); echo( " <small>($size bytes)</small><br>" ); } } } if( $dbconnection ) mysql_close(); echo( "</strong><br><br><hr><center><small>" ); setlocale( LC_TIME,"spanish" ); echo strftime( "%A %d %B %Y - %H:%M:%S", time() ); echo( "<br>©2005 <a href=\"mailto:[email protected]\">Inside PHP</a><br>" ); echo( "vers." . Str_VERS . "<br>" ); echo( "</small></center>" ); echo( "</BODY>" ); echo( "</HTML>" ); //------------------------------------------------------------------------------------------ // END ?> |