Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

No Format
mysql -uroot -p

UNLOCK TABLES TABLES;

Export:

No Format
cat << 'EOL'>export.sh
#!/bin/bash
pass=

db=power
mysqldump -u root -p$pass --skip-create-options $db > $db.sql
db=money
mysqldump -u root -p$pass --skip-create-options $db > $db.sql
tar zcvf sql.skip.create.options.tgz *.sql
scp sql.skip.create.options.tgz root@server:/root/ 
EOL

...