Web Entwicklung - Versionsgeschichte

F: /* mysql */

2020-07-01T08:28:35Z

mysql

← Nächstältere Version		Version vom 1. Juli 2020, 08:28 Uhr
Zeile 119:		Zeile 119:

	== mysql ==		== mysql ==
			[[mysql]]
	~~=== Datenbank&Benutzer anlegen ===~~
	~~<source lang="bash">~~
	mysql ~~-u root -p~~
	~~</source>~~
	~~<source lang="sql">~~
	~~create database DATABASE;~~
	~~create user 'USERNAME'@'localhost' identified by 'PASSWORD';~~
	~~grant all on DATABASE.* to 'USERNAME'@'localhost';~~
	~~</source>~~

	~~=== Datenbank&Benutzer anzeigen ===~~
	~~<source lang="bash">~~
	~~mysql -u root -p~~
	~~</source>~~
	~~<source lang="sql">~~
	~~show databases;~~
	~~SELECT User,Host FROM mysql.user;~~
	~~SHOW GRANTS FOR 'bloguser'@'localhost';~~
	~~</source>~~

	~~=== Datenbank&Benutzer löschen ===~~
	~~<source lang="bash">~~
	~~mysql -u root -p~~
	~~</source>~~
	~~<source lang="sql">~~
	~~delete database DATABASE;~~
	~~REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';~~
	~~DROP USER 'bloguser'@'localhost';~~
	~~</source>~~

	~~=== export import ===~~
	~~<source lang="bash">~~
	~~# export~~
	~~mysqldump --single-transaction --default-character-set=utf8 -u _username_ -p _databasename_ > mysql.yyyymmdd.sql~~
	~~# import~~
	~~mysql -u _username_ -p _databasename_ < mysql.yyyymmdd.sql~~
	~~</source>~~


	~~=== drop all tables per bash ===~~

	~~<source lang=bash>~~
	~~#!/bin/bash~~
	~~MUSER="$1"~~
	~~MPASS="$2"~~
	~~MDB="$3"~~
	~~MHOST="$4"~~

	~~# Detect paths~~
	~~MYSQL=$(which mysql)~~
	~~AWK=$(which awk)~~
	~~GREP=$(which grep)~~

	~~if [ $# -ne 4~~ ]
	~~then~~
	~~echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name}"~~
	~~echo "Drops all tables from a MySQL"~~
	~~exit 1~~
	fi

	~~TABLES=$($MYSQL -u $MUSER -h $MHOST -p$MPASS $MDB -e 'show tables' \| $AWK '{ print $1}' \| $GREP -v '^Tables' )~~

	~~for t in $TABLES~~
	do
	~~echo "Deleting $t table from $MDB database..."~~
	~~$MYSQL -u $MUSER -h $MHOST -p$MPASS $MDB -e "drop table \`$t\`"~~
	~~done~~

	~~</source>~~
	* http://www.cyberciti.biz/faq/how-do-i-empty-mysql-database/

F: /* Datenbank&Benutzer löschen */

2019-04-21T09:07:05Z

Datenbank&Benutzer löschen

← Nächstältere Version		Version vom 21. April 2019, 09:07 Uhr
Zeile 145:		Zeile 145:
	</source>		</source>
	<source lang="sql">		<source lang="sql">
	delete ~~databases~~;		delete database DATABASE;
	REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';		REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bloguser'@'localhost';
	DROP USER 'bloguser'@'localhost';		DROP USER 'bloguser'@'localhost';

F: /* Datenbank&Benutzer anlegen */

2019-04-21T09:06:32Z

Datenbank&Benutzer anlegen

@@ Zeile 128: / Zeile 128: @@
 create user 'USERNAME'@'localhost' identified by 'PASSWORD';
 grant all on DATABASE.* to 'USERNAME'@'localhost';
 </source>

F: /* drop all tables per bash */

2016-08-08T12:25:21Z

drop all tables per bash

← Nächstältere Version		Version vom 8. August 2016, 12:25 Uhr
Zeile 168:		Zeile 168:
	done		done

	</~~bash~~>		</source>
			* http://www.cyberciti.biz/faq/how-do-i-empty-mysql-database/

F: /* mysql */

2016-08-08T12:23:22Z

mysql

← Nächstältere Version		Version vom 8. August 2016, 12:23 Uhr
Zeile 137:		Zeile 137:
	mysql -u _username_ -p _databasename_ < mysql.yyyymmdd.sql		mysql -u _username_ -p _databasename_ < mysql.yyyymmdd.sql
	</source>		</source>


			=== drop all tables per bash ===

			<source lang=bash>
			#!/bin/bash
			MUSER="$1"
			MPASS="$2"
			MDB="$3"
			MHOST="$4"

			# Detect paths
			MYSQL=$(which mysql)
			AWK=$(which awk)
			GREP=$(which grep)

			if [ $# -ne 4 ]
			then
			echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name}"
			echo "Drops all tables from a MySQL"
			exit 1
			fi

			TABLES=$($MYSQL -u $MUSER -h $MHOST -p$MPASS $MDB -e 'show tables' \| $AWK '{ print $1}' \| $GREP -v '^Tables' )

			for t in $TABLES
			do
			echo "Deleting $t table from $MDB database..."
			$MYSQL -u $MUSER -h $MHOST -p$MPASS $MDB -e "drop table \`$t\`"
			done

			</bash>

F: /* php4 nogoes in php5 */

2014-07-14T17:14:41Z

php4 nogoes in php5

@@ Zeile 36: / Zeile 36: @@
 $this->fields.="`".$val['key']."`";
 $this->values.="".$val['value']."";
 </source>

F: /* php */

2014-07-14T16:59:06Z

php

← Nächstältere Version		Version vom 14. Juli 2014, 16:59 Uhr
Zeile 20:		Zeile 20:

	== php ==		== php ==

			=== php4 nogoes in php5 ===
			==== fehlende Hochkommatas in Arrays ====
			* php4
			<source lang="php">
			if ($quote)
			$val[value]="'".addslashes($val[value])."'";
			$this->fields.="`$val[key]`";
			$this->values.="$val[value]";
			</source>
			* php5
			<source lang="php">
			if ($quote)
			$val['value']="'".addslashes($val['value'])."'";
			$this->fields.="`".$val['key']."`";
			$this->values.="".$val['value']."";
			</source>

	=== pear ===		=== pear ===

F: /* svg */

2014-03-26T19:42:34Z

svg

← Nächstältere Version		Version vom 26. März 2014, 19:42 Uhr
Zeile 1:		Zeile 1:
	==svg==		==svg==
	http://www.mediaevent.de/2013/04/svg-in-html-seiten/		* http://www.mediaevent.de/2013/04/svg-in-html-seiten/
			* http://stackoverflow.com/questions/6793312/how-to-use-jquery-in-svg-scalable-vector-graphics

	== apache ==		== apache ==
	Installation		Installation

F am 26. März 2014 um 17:26 Uhr

2014-03-26T17:26:09Z

← Nächstältere Version		Version vom 26. März 2014, 17:26 Uhr
Zeile 1:		Zeile 1:
			==svg==
			http://www.mediaevent.de/2013/04/svg-in-html-seiten/
	== apache ==		== apache ==
	Installation		Installation

F: /* mysql */

2013-12-04T21:11:32Z

mysql

← Nächstältere Version		Version vom 4. Dezember 2013, 21:11 Uhr
Zeile 66:		Zeile 66:
	== mysql ==		== mysql ==

	=== Datenbank&Benutzer anlegen		=== Datenbank&Benutzer anlegen ===
	<source lang="bash">		<source lang="bash">
	mysql -u root -p		mysql -u root -p