Difference between revisions of "Setup MYSQL"
From Wiki2
(Created page with "====setup MYSQL==== in phpmyadmin create the databases mysql --user=tim --password=n hsc mysql -p -u root sitebuil_wikidb < sitebuil_wikidb.sql mysql -p -u root siteb...") |
|||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==mysql== | |||
back to [[database]] | |||
====getRemoteDb.sh==== | |||
<pre> | |||
#!/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 | |||
</pre> | |||
====setup MYSQL==== | ====setup MYSQL==== | ||
in phpmyadmin create the databases | 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_wikidb < sitebuil_wikidb.sql | ||
mysql -p -u root sitebuil_wrdp1 < sitebuil_wrdp1.sql | mysql -p -u root sitebuil_wrdp1 < sitebuil_wrdp1.sql | ||
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
