This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
commissies:gamescom:manual_phpmyadmin [2009/03/10 11:05] willem Aangepast: 2.1. Create + Pictures |
commissies:gamescom:manual_phpmyadmin [2009/03/10 11:41] (current) willem |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| ===== 2. Databases ===== | ===== 2. Databases ===== | ||
| - | This chapter will handle the creation of databases and ... | + | This chapter will explain certain options you can do with a database. \\ |
| + | In the example screenshots we will always use the username '//1username//' with password '//0123456789x//'. | ||
| ==== 2.1. Create ==== | ==== 2.1. Create ==== | ||
| Line 64: | Line 65: | ||
| ==== 2.3. Import ==== | ==== 2.3. Import ==== | ||
| + | PhpMyAdmin gives you the possiblity to import sql files into already excisting databases. Again, in order to do this you should login as the user with the correct database privileges (for this manual that would '//1username//' again). The left side of the phpmyadmin screen in the browser shows all the current databases the user has access to. Next to that it also shows the amount of tables the database is setup with. In the example screenshot to the right you will be able to see several databases for the user with 0 tables. \\ | ||
| + | \\ | ||
| + | {{http://img23.imageshack.us/img23/6573/pmadbimport01.jpg?180x135 }} {{ http://img21.imageshack.us/img21/8184/pmadbimport02.jpg?180x135}} | ||
| + | There are several ways of accessing a databse. In this manual I will just use a simple example and go from there. We will be using the database called '//1username_hlx//' as an example.\\ | ||
| + | First it is important to select the database you want to update. This can be done by simply using your mouse to hover over the name, in phpmyadmin, on the left side of the screen and clicking on the database name (screen left). \\ | ||
| + | \\ | ||
| + | This will open a new screen, with the current database selected on the left side. On the right, click on the tab that is called '//Import//'. This will show you a screen with several import options (screen right). Click the browse button (or w/e it might be called in your language) and select the .sql file you wish to import into the current database. After selecting the file and pressing '//Go//' you will get a screen with all the sql commands it executed. \\ | ||
| + | \\ | ||
| + | Congrats! You have just imported a sql file into the database '//1username_hlx//'. | ||
| ===== 3. Other... ===== | ===== 3. Other... ===== | ||
| Line 72: | Line 81: | ||
| Used Pictures: \\ | Used Pictures: \\ | ||
| Create user: [[http://img25.imageshack.us/img25/821/pmausers01.jpg|1 ]] [[http://img18.imageshack.us/img18/2638/pmausers02.jpg|2 ]] [[http://img9.imageshack.us/img9/2452/pmausers03.jpg|3 ]] [[http://img9.imageshack.us/img9/4681/pmausers04.jpg|4 ]] \\ | Create user: [[http://img25.imageshack.us/img25/821/pmausers01.jpg|1 ]] [[http://img18.imageshack.us/img18/2638/pmausers02.jpg|2 ]] [[http://img9.imageshack.us/img9/2452/pmausers03.jpg|3 ]] [[http://img9.imageshack.us/img9/4681/pmausers04.jpg|4 ]] \\ | ||
| - | Create database: [[http://img4.imageshack.us/img4/7237/pmadbcreate01.jpg|5 ]] [[http://img16.imageshack.us/img16/4499/pmadbcreate02.jpg|6 ]] | + | Create database: [[http://img4.imageshack.us/img4/7237/pmadbcreate01.jpg|5 ]] [[http://img16.imageshack.us/img16/4499/pmadbcreate02.jpg|6 ]] \\ |
| + | Import database: [[http://img23.imageshack.us/img23/6573/pmadbimport01.jpg|7 ]] [[http://img21.imageshack.us/img21/8184/pmadbimport02.jpg|8 ]] \\ | ||