Skip to content

Instantly share code, notes, and snippets.

@alassek
Created July 24, 2009 18:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save alassek/154457 to your computer and use it in GitHub Desktop.
Save alassek/154457 to your computer and use it in GitHub Desktop.
export:
foreach ($n in (1..15)) { cmd.exe /c "mysqldump -u root --password={password here} s88franchise$n > s88franchise$n.sql" }
import:
foreach ($n in (1..15)) { cmd.exe /c "mysql -u root --password={password here} s88franchise$n < s88franchise$n.sql" }
import (bash):
for n in `seq 0 60`
do
echo "Importing Franchise #$n... "
mysql -u root --password={password here} -e "create database s88franchise$n"
mysql -u root --password={password here} s88franchise$n < s88franchise$n.sql
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment