Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES (887,'0.0000'),191607,'1.0300');
- INSERT INTO `coupon_gv_customer` (`customer_id`,`amount`) VALUES
- (887,'0.0000'),
- (191607,'1.0300');
- #!/bin/bash
- cd my_git_directory/
- ARGS="--host=myhostname --user=myusername --password=mypassword --opt --skip-dump-date"
- /usr/bin/mysqldump $ARGS --database mydatabase | sed 's$VALUES ($VALUESn($g' | sed 's$),($),n($g' > mydatabase.sql
- git fetch origin master
- git merge origin/master
- git add mydatabase.sql
- git commit -m "Daily backup."
- git push origin master
- INSERT INTO `mytable` VALUES
- (r1c1value, r1c2value, r1c3value),
- (r2c1value, r2c2value, r2c3value),
- (r3c1value, r3c2value, r3c3value);
- $ mysqldump -u my_db_user -p -h 127.0.0.1 --skip-extended-insert my_database > my_database.sql
- $ sed ':a;N;$!ba;s/);nINSERT INTO `[A-Za-z0-9$_]*` VALUES /),n/g' my_database.sql > my_database2.sql
- mysqldump --tab=/path/to/serverlocaldir --single-transaction <database> table_a
- LOAD DATA INFILE '/path/to/serverlocaldir/table_a.txt'
- INTO TABLE table_a FIELDS TERMINATED BY 't' ...
- CREATE TABLE table_for_test LIKE table_a;
- LOAD DATA INFILE '/path/to/serverlocaldir/table_a.txt'
- INTO TABLE table_for_test FIELDS TERMINATED BY 't' ...
- mysqldump -u my_db_user -p -h 127.0.0.1 --skip-extended-insert my_database | php mysqlconcatinserts.php > db.sql
- #!/usr/bin/php
- <?php
- /* assuming a mysqldump using --skip-extended-insert */
- $last = '';
- $count = 0;
- $maxinserts = 10000;
- while($l = fgets(STDIN)){
- if ( preg_match('/^(INSERT INTO .* VALUES) (.*);/',$l,$s) )
- {
- if ( $last != $s[1] || $count > $maxinserts )
- {
- if ( $count > $maxinserts ) // Limit the inserts
- echo ";n";
- echo "$s[1] ";
- $comma = '';
- $last = $s[1];
- $count = 0;
- }
- echo "$comma$s[2]";
- $comma = ",n";
- } elseif ( $last != '' ) {
- $last = '';
- echo ";n";
- }
- $count++;
- }
Add Comment
Please, Sign In to add comment