Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost:3036';
  3. $dbuser = 'groundedbodyscru_lloyd';
  4. $dbpass = 'G2lGrWewB$[S';
  5.  
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  7.  
  8. if(! $conn ) {
  9. die('Could not connect: ' . mysql_error());
  10. }
  11.  
  12. $table_name = "wp_users";
  13. $backup_file = "users.sql";
  14. $sql = "SELECT * INTO OUTFILE '$backup_file' FROM $table_name";
  15.  
  16. mysql_select_db('test_db');
  17. $retval = mysql_query( $sql, $conn );
  18.  
  19. if(! $retval ) {
  20. die('Could not take data backup: ' . mysql_error());
  21. }
  22.  
  23. echo "Backedup data successfully\n";
  24.  
  25. mysql_close($conn);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement