MYSQL Guide

Revision as of 21:29, 3 August 2007 (view source) Gyffes (Talk | contribs) (New page: __NOEDITSECTION__ {{Disclaimer}} {{NeedsMore}} <br clear="all"> {{MainMenu|Roster}})		Revision as of 03:58, 10 February 2008 (view source) Zanix (Talk | contribs) Newer edit →
Line 1:		Line 1:
	__NOEDITSECTION__		__NOEDITSECTION__
	{{Disclaimer}}		{{Disclaimer}}
−	{{NeedsMore}}	+	{{Warning|Translation in Progress|This is still being translated from the original article [[MYSQL_Guide/de]]}}
−	<br clear="all">	+	{{MainMenu}}
−	{{MainMenu|Roster}}	+
		+	==PHPMyAdmin - Installation and Basic Operation==
		+	For those who have no idea how to administer your database can visit a small guide for the tool PHPMyAdmin.
		+
		+	PHPMyAdmin is a PHP script that allows you to access and modify your MySQL databases. With this tool, it is possible to add new databases (as long as your service provider allows), add/modify tables, and add/modify the data in databases.
		+
		+	The latest version is available here: http://www.phpmyadmin.net/home_page/index.php
		+
		+
		+
		+
		+
		+
		+
		+
		+
		+	===The installation===
		+	Installation is almost as simple as installing WoWRoster or UniAdmin<br>
		+	So once this is done, it's easy street!
		+	{{Note|Many times your web host will provide PHPMyAdmin via your control panel<br>We suggest you use this instead of installing it yourself}}
		+
		+	* Download the latest version from the link above
		+	* Unpack the download into a local folder
		+	* Upload all the files into a folder on your server (eg phpmyadmin or pma)
		+	* Set the folder in which you have loaded the script nor a folder "config". The setup script saves the configuration
		+	* Go to the setup script (e.g. <nowiki>http://www.[yoursite].com/pma/scripts/setup.php</nowiki>)
		+	* Under "Server" clicking on the button "ADD" to add your database server. The main areas are:
		+	** Server hostname = address of the database server (eg localhost or mysql.localhost)
		+	** Authentication Type "cookie"
		+	* Click on the "Save". A file with the name "config.inc.php" will be created in the "config" directory
		+	* Copy this file to the main PHPMyAdmin directory using FTP or another method
		+	* Sets the file to read-only
		+	* Now you can use PHPMyAdmin <nowiki>http://www.[yoursite].com/pma</nowiki>
		+
		+
		+	===Using PHPMyAdmin===
		+	PHPMyAdmin will show up in 3 sections when you first view it
		+
		+	{{Note|You may need to enter your MySQL username and password to access PHPMyAdmin<br>This can usually be found in the server control panel, and is usually given to you when you first got your server}}
		+
		+	# The left side
		+	#: The PHPMyAdmin Logo and a small button bar
		+	#: This shows all of the databases you have access to
		+	# The center
		+	#: Shows you information about the current server
		+	# The right side
		+	#: Displays information about PHPMyAdmin itself
		+	#: You can select a different server here, when multiple servers are defined
		+
		+
		+	The Left Side Buttons:
		+	* Button - Home (leads you to the entrance page)
		+	* Button - Exit. Logs you out of PHPMyAdmin
		+	* Button - Query Window (SQL). This opens a new window where you can directly enter SQL commands
		+	*: This also allows you to import .sql files
		+	* Button - PHPMyAdmin documentation
		+	* Button - MySQL Documentation
		+
		+	Among them you will find in most cases a drop-down list of all the databases on the current server. Once you have selected a database will include a list of tables in the database, and the right of the page loads.
		+
		+	As you can see right now the structure of the database (ie tables).
		+	You see the table name, an action bar, the number of entries in the table, the type of table, the Collation (?), The size of the table (including data), and possibly an overhang (data not assigned).
		+	If you deal with the mouse on a button in the action bar, get your ride a little Tooltyp with regard to its function.
		+	Will your data directly into a spreadsheet register clicks on the 4th Button in the action bar next to the name of the table.
		+	Will you all your data in the table view, clicking on the 1st Button in the action bar. This button is only available if data in the table.
		+	You can also add links to a table name click, then you get to see its structure. The structure consists of a table field names, polja, field size, etc.
		+	In this view, you can new fields in the table, to give below the table structure, the number fields, which you want to add and how these are to be added (at the beginning, at the end or after a given field).
		+	Will your only data in the table above, click on Insert and you will get a query with all field name of the table, then you will wear the appropriate information.
		+
		+
		+	===When you change data have you two options:===
		+	* Your clicking on ads and searching for the appropriate entry by hand and clicks the pen at the beginning (depending on the number of data is a tedious work)
		+	Or
		+	* Your clicks on search and gets, again with a query to all fields. Give the appropriate box your search term and clicking on OK. Then should you a list of all the entries received your search term. Here you can then return to the pen button to edit an entry.
		+
		+	To select multiple items at once to deal marks the checkbox in front of the entries to edit your want and clicking on the pen next to the word "marked".
		+
		+	So this should be a short introduction to the basic operating range. More extensive information can be found in the documentation or on http://wiki.cihar.com/ PHPMyAdmin.

---

Revision as of 03:58, 10 February 2008

Contents 1 Main Page 2 PHPMyAdmin - Installation and Basic Operation 2.1 The installation 2.2 Using PHPMyAdmin 2.3 When you change data have you two options:

PHPMyAdmin - Installation and Basic Operation

For those who have no idea how to administer your database can visit a small guide for the tool PHPMyAdmin.

PHPMyAdmin is a PHP script that allows you to access and modify your MySQL databases. With this tool, it is possible to add new databases (as long as your service provider allows), add/modify tables, and add/modify the data in databases.

The latest version is available here: http://www.phpmyadmin.net/home_page/index.php

The installation

Installation is almost as simple as installing WoWRoster or UniAdmin
So once this is done, it's easy street!

• Download the latest version from the link above
• Unpack the download into a local folder
• Upload all the files into a folder on your server (eg phpmyadmin or pma)
• Set the folder in which you have loaded the script nor a folder "config". The setup script saves the configuration
• Go to the setup script (e.g. http://www.[yoursite].com/pma/scripts/setup.php)
• Under "Server" clicking on the button "ADD" to add your database server. The main areas are:
  • Server hostname = address of the database server (eg localhost or mysql.localhost)
  • Authentication Type "cookie"
• Click on the "Save". A file with the name "config.inc.php" will be created in the "config" directory
• Copy this file to the main PHPMyAdmin directory using FTP or another method
• Sets the file to read-only
• Now you can use PHPMyAdmin http://www.[yoursite].com/pma

Using PHPMyAdmin

PHPMyAdmin will show up in 3 sections when you first view it

1. The left side

   The PHPMyAdmin Logo and a small button bar

   This shows all of the databases you have access to

2. The center

   Shows you information about the current server

3. The right side

   Displays information about PHPMyAdmin itself

   You can select a different server here, when multiple servers are defined

The Left Side Buttons:

• Button - Home (leads you to the entrance page)
• Button - Exit. Logs you out of PHPMyAdmin
• Button - Query Window (SQL). This opens a new window where you can directly enter SQL commands

  This also allows you to import .sql files

• Button - PHPMyAdmin documentation
• Button - MySQL Documentation

Among them you will find in most cases a drop-down list of all the databases on the current server. Once you have selected a database will include a list of tables in the database, and the right of the page loads.

As you can see right now the structure of the database (ie tables). You see the table name, an action bar, the number of entries in the table, the type of table, the Collation (?), The size of the table (including data), and possibly an overhang (data not assigned). If you deal with the mouse on a button in the action bar, get your ride a little Tooltyp with regard to its function. Will your data directly into a spreadsheet register clicks on the 4th Button in the action bar next to the name of the table. Will you all your data in the table view, clicking on the 1st Button in the action bar. This button is only available if data in the table. You can also add links to a table name click, then you get to see its structure. The structure consists of a table field names, polja, field size, etc. In this view, you can new fields in the table, to give below the table structure, the number fields, which you want to add and how these are to be added (at the beginning, at the end or after a given field). Will your only data in the table above, click on Insert and you will get a query with all field name of the table, then you will wear the appropriate information.

When you change data have you two options:

• Your clicking on ads and searching for the appropriate entry by hand and clicks the pen at the beginning (depending on the number of data is a tedious work)

Or

• Your clicks on search and gets, again with a query to all fields. Give the appropriate box your search term and clicking on OK. Then should you a list of all the entries received your search term. Here you can then return to the pen button to edit an entry.

To select multiple items at once to deal marks the checkbox in front of the entries to edit your want and clicking on the pen next to the word "marked".

So this should be a short introduction to the basic operating range. More extensive information can be found in the documentation or on http://wiki.cihar.com/ PHPMyAdmin.