Nikola, :D moja greska, malo mi je komplikovano da pratim ko sta pise forumski sw je user friendly kao unix aplikacije od pre 20 godina :( tako da nisam svatio ko sta pise ...
Citat:
krstak84: a gde da ukucam taj kod?
pise ti u postu, ako imas "ispravan mysql" dakle mysql koji radi, zakacis se na isti mysql koristeci bilo koji klijent i izvrsis taj upit, on ce ti vratiti nesto ovako:
Code:
mysql> SHOW VARIABLES LIKE '%data%';
+----------------------------+------------------------+
| Variable_name | Value |
+----------------------------+------------------------+
| character_set_database | latin1 |
| collation_database | latin1_swedish_ci |
| datadir | /M/data/ |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| max_length_for_sort_data | 1024 |
| myisam_data_pointer_size | 6 |
| skip_show_database | OFF |
| updatable_views_with_limit | YES |
+----------------------------+------------------------+
9 rows in set (0.00 sec)
mysql>
dakle, u ovom primeru, baze se nalaze u /M/data
tabele (one koje nisu innodb) se nalaze u /M/data/<imebaze>/*
innodb tabele se nalaze u innodb tablespace-u koji se na ovom testu sastoji od jednog fajla /M/data/ibdata1
ako nemas MySQL server koji radi .. on ne moze sam da ti kaze "gde su mu podaci" tako da onda moras da se snalazis drugacije .... mysql uvek ima bazu mysql (dakle trazi na disku direktorijum koji se zove mysql) i u toj bazi ima par tabela ... tako da trazi te fajlove .. evo ti primer kako izgleda sadrzaj mysql direktorijuma, (ovo je za 5.1, u 5.0 ne postoje neke od ovih tabela)
Code:
[arhimed@gedora10 data]$ ls -al mysql
total 584
drwx------ 2 arhimed arhimed 4096 2009-01-28 13:23 .
drwxr-xr-x 5 arhimed arhimed 4096 2009-02-03 21:18 ..
-rw-rw---- 1 arhimed arhimed 8820 2009-01-28 13:21 columns_priv.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 columns_priv.MYD
-rw-rw---- 1 arhimed arhimed 4096 2009-01-28 13:21 columns_priv.MYI
-rw-rw---- 1 arhimed arhimed 9582 2009-01-28 13:21 db.frm
-rw-rw---- 1 arhimed arhimed 880 2009-01-28 13:21 db.MYD
-rw-rw---- 1 arhimed arhimed 5120 2009-01-28 13:21 db.MYI
-rw-rw---- 1 arhimed arhimed 10223 2009-01-28 13:21 event.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 event.MYD
-rw-rw---- 1 arhimed arhimed 2048 2009-01-28 13:21 event.MYI
-rw-rw---- 1 arhimed arhimed 8665 2009-01-28 13:21 func.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 func.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 func.MYI
-rw-rw---- 1 arhimed arhimed 35 2009-01-28 13:21 general_log.CSM
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 general_log.CSV
-rw-rw---- 1 arhimed arhimed 8776 2009-01-28 13:21 general_log.frm
-rw-rw---- 1 arhimed arhimed 8700 2009-01-28 13:21 help_category.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 help_category.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 help_category.MYI
-rw-rw---- 1 arhimed arhimed 8612 2009-01-28 13:21 help_keyword.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 help_keyword.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 help_keyword.MYI
-rw-rw---- 1 arhimed arhimed 8630 2009-01-28 13:21 help_relation.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 help_relation.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 help_relation.MYI
-rw-rw---- 1 arhimed arhimed 8770 2009-01-28 13:21 help_topic.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 help_topic.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 help_topic.MYI
-rw-rw---- 1 arhimed arhimed 9510 2009-01-28 13:21 host.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 host.MYD
-rw-rw---- 1 arhimed arhimed 2048 2009-01-28 13:21 host.MYI
-rw-rw---- 1 arhimed arhimed 8716 2009-01-28 13:23 ndb_apply_status.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:23 ndb_apply_status.ndb
-rw-rw---- 1 arhimed arhimed 8898 2009-01-28 13:21 ndb_binlog_index.frm
-rw-rw---- 1 arhimed arhimed 108992 2009-01-28 13:28 ndb_binlog_index.MYD
-rw-rw---- 1 arhimed arhimed 59392 2009-01-30 10:38 ndb_binlog_index.MYI
-rw-rw---- 1 arhimed arhimed 8810 2009-01-28 13:23 ndb_schema.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:23 ndb_schema.ndb
-rw-rw---- 1 arhimed arhimed 8586 2009-01-28 13:21 plugin.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 plugin.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 plugin.MYI
-rw-rw---- 1 arhimed arhimed 9996 2009-01-28 13:21 proc.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 proc.MYD
-rw-rw---- 1 arhimed arhimed 2048 2009-01-28 13:21 proc.MYI
-rw-rw---- 1 arhimed arhimed 8875 2009-01-28 13:21 procs_priv.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 procs_priv.MYD
-rw-rw---- 1 arhimed arhimed 4096 2009-01-28 13:21 procs_priv.MYI
-rw-rw---- 1 arhimed arhimed 8838 2009-01-28 13:21 servers.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 servers.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 servers.MYI
-rw-rw---- 1 arhimed arhimed 35 2009-01-28 13:21 slow_log.CSM
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 slow_log.CSV
-rw-rw---- 1 arhimed arhimed 8976 2009-01-28 13:21 slow_log.frm
-rw-rw---- 1 arhimed arhimed 8955 2009-01-28 13:21 tables_priv.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 tables_priv.MYD
-rw-rw---- 1 arhimed arhimed 4096 2009-01-28 13:21 tables_priv.MYI
-rw-rw---- 1 arhimed arhimed 8636 2009-01-28 13:21 time_zone.frm
-rw-rw---- 1 arhimed arhimed 8624 2009-01-28 13:21 time_zone_leap_second.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 time_zone_leap_second.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 time_zone_leap_second.MYI
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 time_zone.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 time_zone.MYI
-rw-rw---- 1 arhimed arhimed 8606 2009-01-28 13:21 time_zone_name.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 time_zone_name.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 time_zone_name.MYI
-rw-rw---- 1 arhimed arhimed 8686 2009-01-28 13:21 time_zone_transition.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 time_zone_transition.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 time_zone_transition.MYI
-rw-rw---- 1 arhimed arhimed 8748 2009-01-28 13:21 time_zone_transition_type.frm
-rw-rw---- 1 arhimed arhimed 0 2009-01-28 13:21 time_zone_transition_type.MYD
-rw-rw---- 1 arhimed arhimed 1024 2009-01-28 13:21 time_zone_transition_type.MYI
-rw-rw---- 1 arhimed arhimed 10466 2009-01-28 13:21 user.frm
-rw-rw---- 1 arhimed arhimed 252 2009-01-28 13:21 user.MYD
-rw-rw---- 1 arhimed arhimed 2048 2009-01-28 13:21 user.MYI
[arhimed@gedora10 data]$