Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = 'DB_Host'; // Database Host
- $dbuser = 'DB_User'; // Database User
- $dbpass = 'DBUser_Password'; // Database User Password
- $db='DB_Name'; // Database Name
- $i=0;
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- mysql_select_db($db);
- if(! $conn ) {
- die('Could not connect: ' . mysql_error());
- }
- $sql= "SHOW TABLES from $db";
- $result = mysql_query( $sql, $conn );
- while ($row=mysql_fetch_array($result)) {
- echo $table_name= $row[0];
- echo "</br>";
- $i++;
- $backup_file = getcwd() .$table_name .'.sql';
- $sql1 = "SELECT * INTO OUTFILE '$backup_file' FROM $table_name";
- $retval = mysql_query( $sql1, $conn );
- if(! $retval ) {
- die('Could not take data backup: ' . mysql_error());
- }
- echo "Eport " . $table_name . " Successfully</br>";
- }
- echo "Number of tables: " . $i . "</br>";
- mysql_close($conn);
- ?>
Add Comment
Please, Sign In to add comment