phpBB2 by Przemo

[Matteo]

When you enter to phpmyadmin, you must choose a database on the left side.
[ Screen 1 ]

On the left and right side you have content viewyour database. You can see name of tables your database.
[ Screen 2 ]

If you want edit content your table, click on it's name on the left side. Now you should see structure of your table.
[ Screen 3 ]

If you pull over the bottom, you could perform various operations on tables. If you want optimize, or repair a table - select it and choose correct operation from menu on the right side.
[ Screen 4 ]

On the top you have inscription Browse, click on it. Now you will see what a data conceals in the table.
[ Screen 5 ]

If you want edit some of record in the table - click on pencil icon, near record. Now you can change table contents.
[ Screen 6 ]

Example you can change username. Just that in field username you change value Matteo to Test then click on Go.
[ Screen 7 ]

If you click on red cross then you will delete record. You can't back this operation, unless you have backup of database.
[ Screen 8 ]

Always on the top in phpMyAdmin you have pop-up menu. If you want send SQL query ex.:

Kod:

UPDATE phpbb_users SET user_style = 1 WHERE user_style = 4

Click on the SQL
This brings you something like that:
[ Screen 9 ]

To blank field write SQL query and click Go. phpMyAdmin perform operation on database and results show above the window.
[ Screen 10 ]

Truncate - delete from tables ALL records, but leave all structure of table. After this operation we have empty table, which can supplemented by new records.
Drop - delete table. You can't add to this table none records, couse simply you don't have this table. Be careful.

(original content)

---

1eng.png [ Screen 1 ]

Plik ściągnięto 64 raz(y) 57,66 KB

2eng.png [ Screen 2 ]

Plik ściągnięto 64 raz(y) 115,76 KB

3eng.png [ Screen 3 ]

Plik ściągnięto 66 raz(y) 86,96 KB

4eng.png [ Screen 4 ]

Plik ściągnięto 66 raz(y) 101,01 KB

5eng.png [ Screen 5 ]

Plik ściągnięto 63 raz(y) 70,74 KB

6eng.png [ Screen 6 ]

Plik ściągnięto 68 raz(y) 66,36 KB

7eng.png [ Screen 7 ]

Plik ściągnięto 66 raz(y) 63,74 KB

8eng.png [ Screen 8 ]

Plik ściągnięto 62 raz(y) 60,08 KB

9eng.png [ Screen 9 ]

Plik ściągnięto 67 raz(y) 56,45 KB

10eng.png [ Screen 10 ]

Plik ściągnięto 70 raz(y) 50,8 KB

[Gadatliwa Kasia]