Advertisement
Guest User

Untitled

a guest
Feb 15th, 2016
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. --ignore-table=view1 --ignore-table=view2 --ignore-table=view3
  2.  
  3. SELECT CONCAT('mysqldump -u username -ppassword -h host [some options here] `',`TABLE_SCHEMA`,'` `',
  4. `TABLE_NAME`,'` > ',`TABLE_NAME`,'.sql') AS `sql`
  5. FROM `INFORMATION_SCHEMA`.`TABLES`
  6. WHERE `TABLE_TYPE` != 'VIEW'
  7. AND `TABLE_SCHEMA` NOT IN ('INFORMATION_SCHEMA', 'PERFORMANCE_SCHEMA','mysql');
  8.  
  9. php mysqldump.php mydatabase myusername mypassword > myoutputfile.sql
  10.  
  11. <?php
  12.  
  13. if (is_array($argv) && count($argv)>3) {
  14. $database=$argv[1];
  15. $user=$argv[2];
  16. $password=$argv[3];
  17. }
  18. else {
  19. echo "Usage php mysqdump.php <database> <user> <password>n";
  20. exit;
  21. }
  22.  
  23. $link = mysql_connect('localhost', $user, $password);
  24.  
  25.  
  26. if (!$link) {
  27. die('Could not connect: ' . mysql_error());
  28. }
  29.  
  30. $source = mysql_select_db('$database', $link);
  31. $sql = "SHOW FULL TABLES IN `$database` WHERE TABLE_TYPE LIKE 'VIEW';";
  32. $result = mysql_query($sql);
  33. $views=array();
  34. while ($row = mysql_fetch_row($result)) {
  35. $views[]="--ignore-table={$database}.".$row[0];
  36. }
  37. //no views or triggers please
  38. system("mysqldump -u root --password="$password" $database --skip-triggers ".implode(" ",$views));
  39.  
  40. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement