Difference between revisions of "Setup MYSQL"
From Wiki2
(→mysql) |
|||
| Line 2: | Line 2: | ||
back to [[database]] | back to [[database]] | ||
====getRemoteDb.sh==== | ====getRemoteDb.sh==== | ||
< | <pre> | ||
#!/bin/sh | #!/bin/sh | ||
echo "getting database $1" | echo "getting database $1" | ||
| Line 10: | Line 10: | ||
mysqldump -h sitebuilt.net -uroot -p$pwd --opt $1 > $1.sql | mysqldump -h sitebuilt.net -uroot -p$pwd --opt $1 > $1.sql | ||
mysql -uroot -p$pwd $1 < $1.sql | mysql -uroot -p$pwd $1 < $1.sql | ||
</ | </pre> | ||
====setup MYSQL==== | ====setup MYSQL==== | ||
1. in phpmyadmin create the databases | 1. in phpmyadmin create the databases | ||
Latest revision as of 16:21, 31 August 2019
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
