Guest User

Untitled

a guest
Jun 3rd, 2018
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.90 KB | None | 0 0
  1. INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES (887,'0.0000'),191607,'1.0300');
  2.  
  3. INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES
  4. (887,'0.0000'),
  5. (191607,'1.0300');
  6.  
  7. #!/bin/bash
  8.  
  9. cd my_git_directory/
  10.  
  11. ARGS="--host=myhostname --user=myusername --password=mypassword --opt --skip-dump-date"
  12. /usr/bin/mysqldump $ARGS --database mydatabase | sed 's$VALUES ($VALUESn($g' | sed 's$),($),n($g' > mydatabase.sql
  13.  
  14. git fetch origin master
  15. git merge origin/master
  16. git add mydatabase.sql
  17. git commit -m "Daily backup."
  18. git push origin master
  19.  
  20. INSERT INTO `mytable` VALUES
  21. (r1c1value, r1c2value, r1c3value),
  22. (r2c1value, r2c2value, r2c3value),
  23. (r3c1value, r3c2value, r3c3value);
  24.  
  25. $ mysqldump -u my_db_user -p -h 127.0.0.1 --skip-extended-insert my_database > my_database.sql
  26. $ sed ':a;N;$!ba;s/);nINSERT INTO `[A-Za-z0-9$_]*` VALUES /),n/g' my_database.sql > my_database2.sql
  27.  
  28. mysqldump --tab=/path/to/serverlocaldir --single-transaction <database> table_a
  29.  
  30. LOAD DATA INFILE '/path/to/serverlocaldir/table_a.txt'
  31. INTO TABLE table_a FIELDS TERMINATED BY 't' ...
  32.  
  33. CREATE TABLE table_for_test LIKE table_a;
  34.  
  35. LOAD DATA INFILE '/path/to/serverlocaldir/table_a.txt'
  36. INTO TABLE table_for_test FIELDS TERMINATED BY 't' ...
  37.  
  38. mysqldump -u my_db_user -p -h 127.0.0.1 --skip-extended-insert my_database | php mysqlconcatinserts.php > db.sql
  39.  
  40. #!/usr/bin/php
  41. <?php
  42. /* assuming a mysqldump using --skip-extended-insert */
  43. $last = '';
  44. $count = 0;
  45. $maxinserts = 10000;
  46. while($l = fgets(STDIN)){
  47. if ( preg_match('/^(INSERT INTO .* VALUES) (.*);/',$l,$s) )
  48. {
  49. if ( $last != $s[1] || $count > $maxinserts )
  50. {
  51. if ( $count > $maxinserts ) // Limit the inserts
  52. echo ";n";
  53. echo "$s[1] ";
  54. $comma = '';
  55. $last = $s[1];
  56. $count = 0;
  57. }
  58. echo "$comma$s[2]";
  59. $comma = ",n";
  60. } elseif ( $last != '' ) {
  61. $last = '';
  62. echo ";n";
  63. }
  64. $count++;
  65. }
Add Comment
Please, Sign In to add comment