Difference between revisions of "Setup MYSQL"
From Wiki2
(→mysql) |
(→mysql) |
||
| Line 1: | Line 1: | ||
==mysql== | ==mysql== | ||
back to [[database]] | back to [[database]] | ||
====getRemoteDb.sh==== | |||
<code> | |||
#!/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 | |||
</code> | |||
====setup MYSQL==== | ====setup MYSQL==== | ||
1. in phpmyadmin create the databases | 1. in phpmyadmin create the databases | ||
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
