Mysql

mysql

back to database

getRemoteDb.sh

#!/bin/sh
echo "getting database $1"
read -p "Enter Your Password: "  pwd
echo "Welcome $pwd!"

mysqldump -h sitebuilt.net -uroot -p$pwd --opt $1 > $1.sql
mysql -uroot -p$pwd $1 < $1.sql

setup MYSQL

1. in phpmyadmin create the databases

2. put the databases in /var/backups/my. go there and run

  mysql -p -u root sitebuil_wikidb < sitebuil_wikidb.sql
  mysql -p -u root sitebuil_wrdp1 < sitebuil_wrdp1.sql
  mysql -p -u root sitebuil_wuffdb < sitebuil_wuffdb.sql
  mysql -p -u root taxplans < taxplans.sql
  mysql -p -u root webeshoppin < webeshoppin.sql
  mysql -p -u root pathbost_h211 < pathbost_h211.sql
  mysql -p -u root pathbost_h311 < pathbost_h311.sql
  mysql -p -u root pathbost_h409 < pathbost_h409.sql
  mysql -p -u root pathbost_h409 < pathbost_h409.sql