Share Pastebin
Guest
Public paste!

fishfucker

By: a guest | Jul 25th, 2007 | Syntax: None | Size: 0.45 KB | Hits: 79 | Expires: Never
Copy text to clipboard
  1. #!/bin/bash
  2.  
  3. user="root"
  4. pass="foobar"
  5. base="/var/www/development/sql"
  6.  
  7. function SqlDumpData {
  8.     mysqldump -u $user -p$pass --no-create-info --skip-opt --comments=0 $1 | \
  9.       egrep -v "INSERT INTO \`(accesslog|cache|search_index|sessions)\`" | sort >$2
  10. }
  11.  
  12. function SqlDumpStructure {
  13.     mysqldump -u $user -p$pass --no-data $1 >$2
  14. }
  15.  
  16. cd $base
  17.  
  18. # drupal
  19. SqlDumpData example example_data.sql
  20. SqlDumpStructure example example_structure.sql