Setup MYSQL - Revision history

Tim: /* getRemoteDb.sh */

2019-08-31T20:21:58Z

getRemoteDb.sh

← Older revision		Revision as of 16:21, 31 August 2019
Line 2:		Line 2:
	back to [[database]]		back to [[database]]
	====getRemoteDb.sh====		====getRemoteDb.sh====
	<~~code~~>		<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
	</~~code~~>		</pre>

	====setup MYSQL====		====setup MYSQL====
	1. in phpmyadmin create the databases		1. in phpmyadmin create the databases

Tim: /* mysql */

2019-08-31T20:21:26Z

mysql

@@ Line 1: / Line 1: @@
 ==mysql==
 back to [[database]]
 ====setup MYSQL====
 . in phpmyadmin create the databases

Tim: /* mysql */

2015-12-27T18:39:35Z

mysql

← Older revision		Revision as of 14:39, 27 December 2015
Line 1:		Line 1:
	==mysql==		==mysql==
			back to [[database]]
	====setup MYSQL====		====setup MYSQL====
	1. in phpmyadmin create the databases		1. in phpmyadmin create the databases

Tim: /* setup MYSQL */

2015-12-27T18:38:51Z

setup MYSQL

← Older revision		Revision as of 14:38, 27 December 2015
Line 1:		Line 1:
			==mysql==
	====setup MYSQL====		====setup MYSQL====
	1. in phpmyadmin create the databases		1. in phpmyadmin create the databases

Tim: /* setup MYSQL */

2013-12-31T18:08:30Z

setup MYSQL

← Older revision		Revision as of 14:08, 31 December 2013
Line 1:		Line 1:
	====setup MYSQL====		====setup MYSQL====
	in phpmyadmin create the databases		1. in phpmyadmin create the databases
	~~mysql --user=tim --password=n hsc~~
			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

Tim: 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..."

2013-12-31T18:04:33Z

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..."

New page

====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 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