Paweł P. filozof
Temat: skillowałem mysqld i pma_baza i tabele poszły w /dev/full
Czy ktoś ma jakiś pomysł co zrobić, żeby mieć to z powrotem? :D backup katalogu /var/lib/mysql nie istnieje :D :E Czy PhpMyAdm jest na tyle "mądry", że sobie odtworzy tabele? Jakaś procedura przywracania? ;-)dokumentacja troche pomoze ale mam jeszcze takie cos:
[3] => Array
(
[0] => pdftk_php
[1] => ip2country
[2] => pma_column_info
[3] => pma_designer_coords
[4] => pma_pdf_pages
[5] => pma_relation
[6] => pma_table_coords
[7] => pma_table_info
[8] => users
)
Paweł P. edytował(a) ten post dnia 30.03.11 o godzinie 23:01
[3] => Array
(
[1] => Array
(
[0] => Array
(
[Type] => string
[Size] => 15
[Name] => ipst
[Flag] => not_null binary
)
[1] => Array
(
[Type] => string
[Size] => 15
[Name] => ipop
[Flag] => not_null binary
)
[2] => Array
(
[Type] => string
[Size] => 20
[Name] => some1
[Flag] => not_null binary
)
[3] => Array
(
[Type] => string
[Size] => 20
[Name] => some2
[Flag] => not_null binary
)
[4] => Array
(
[Type] => string
[Size] => 2
[Name] => ipcntr
[Flag] => not_null binary
)
)
[2] => Array
(
[0] => Array
(
[Type] => int
[Size] => 5
[Name] => id
[Flag] => not_null primary_key unsigned auto_increment
)
[1] => Array
(
[Type] => string
[Size] => 64
[Name] => db_name
[Flag] => not_null multiple_key binary
)
[2] => Array
(
[Type] => string
[Size] => 64
[Name] => table_name
[Flag] => not_null binary
)
[3] => Array
(
[Type] => string
[Size] => 64
[Name] => column_name
[Flag] => not_null binary
)
[4] => Array
(
[Type] => string
[Size] => 255
[Name] => comment
[Flag] => not_null
)
[5] => Array
(
[Type] => string
[Size] => 255
[Name] => mimetype
[Flag] => not_null
)
[6] => Array
(
[Type] => string
[Size] => 255
[Name] => transformation
[Flag] => not_null binary
)
[7] => Array
(
[Type] => string
[Size] => 255
[Name] => transformation_options
[Flag] => not_null binary
)
)
[3] => Array
(
[0] => Array
(
[Type] => string
[Size] => 64
[Name] => db_name
[Flag] => not_null primary_key binary
)
[1] => Array
(
[Type] => string
[Size] => 64
[Name] => table_name
[Flag] => not_null primary_key binary
)
[2] => Array
(
[Type] => int
[Size] => 11
[Name] => x
[Flag] =>
)
[3] => Array
(
[Type] => int
[Size] => 11
[Name] => y
[Flag] =>
)
[4] => Array
(
[Type] => int
[Size] => 4
[Name] => v
[Flag] =>
)
[5] => Array
(
[Type] => int
[Size] => 4
[Name] => h
[Flag] =>
)
)
[4] => Array
(
[0] => Array
(
[Type] => string
[Size] => 64
[Name] => db_name
[Flag] => not_null multiple_key binary
)
[1] => Array
(
[Type] => int
[Size] => 10
[Name] => page_nr
[Flag] => not_null primary_key unsigned auto_increment
)
[2] => Array
(
[Type] => string
[Size] => 50
[Name] => page_descr
[Flag] => not_null
)
)
[5] => Array
(
[0] => Array
(
[Type] => string
[Size] => 64
[Name] => master_db
[Flag] => not_null primary_key binary
)
[1] => Array
(
[Type] => string
[Size] => 64
[Name] => master_table
[Flag] => not_null primary_key binary
)
[2] => Array
(
[Type] => string
[Size] => 64
[Name] => master_field
[Flag] => not_null primary_key binary
)
[3] => Array
(
[Type] => string
[Size] => 64
[Name] => foreign_db
[Flag] => not_null multiple_key binary
)
[4] => Array
(
[Type] => string
[Size] => 64
[Name] => foreign_table
[Flag] => not_null binary
)
[5] => Array
(
[Type] => string
[Size] => 64
[Name] => foreign_field
[Flag] => not_null binary
)
)
[6] => Array
(
[0] => Array
(
[Type] => string
[Size] => 64
[Name] => db_name
[Flag] => not_null primary_key binary
)
[1] => Array
(
[Type] => string
[Size] => 64
[Name] => table_name
[Flag] => not_null primary_key binary
)
[2] => Array
(
[Type] => int
[Size] => 11
[Name] => pdf_page_number
[Flag] => not_null primary_key
)
[3] => Array
(
[Type] => real
[Size] => 12
[Name] => x
[Flag] => not_null unsigned
)
[4] => Array
(
[Type] => real
[Size] => 12
[Name] => y
[Flag] => not_null unsigned
)
)
[7] => Array
(
[0] => Array
(
[Type] => string
[Size] => 64
[Name] => db_name
[Flag] => not_null primary_key binary
)
[1] => Array
(
[Type] => string
[Size] => 64
[Name] => table_name
[Flag] => not_null primary_key binary
)
[2] => Array
(
[Type] => string
[Size] => 64
[Name] => display_field
[Flag] => not_null binary
)
)
[8] => Array
(
[0] => Array
(
[Type] => int
[Size] => 4
[Name] => id
[Flag] => not_null primary_key auto_increment
)
[1] => Array
(
[Type] => string
[Size] => 65
[Name] => firstname
[Flag] => not_null
)
[2] => Array
(
[Type] => string
[Size] => 65
[Name] => lastname
[Flag] => not_null
)
)