Warning: file_exists(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin/wp-content/uploads/2019/07) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1613

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin/wp-content/uploads/2019) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin/wp-content/uploads) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin/wp-content) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu/domains) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home/malkeu) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/home) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: is_dir(): open_basedir restriction in effect. File(/) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-includes/functions.php on line 1618

Warning: file_exists(): open_basedir restriction in effect. File(/home/malkeu/domains/malkowski.eu/public_html/marcin/wp-content/uploads/wptouch-data) is not within the allowed path(s): (/home/eumalkowsk/:/tmp/:/var/tmp/:/usr/local/php72/lib/:/usr/local/php72/lib/:/usr/local/php56/lib/:/usr/local/lib/php/) in /home/eumalkowsk/domains/malkowski.eu/public_html/marcin/wp-content/plugins/wptouch/core/config-functions.php on line 32
IT Blog » Archiwum » Grrr InnoDB nie daje mi żyć

Grrr InnoDB nie daje mi żyć

Kurcze, dlaczego to tak jest, że mam bazy w MyISAM na MySQL i nie ma problemów, a to dobre i kochane InnoDB zawsze grymasi ?

No dobra a teraz do konkretów, jak się okazuje jedynym dobrym sposobem żeby uszkodzoną bazę w InnoDB przywrócić jest …….. usunięcie jej i utworzenie na nowo -0 chore ale co poradzić.

Kroki są proste:

1) W my.cnf dajemy innodb_force_recovery = 4 – wartość 4 jest używana przeze mnie, natomiast mysql.com bardziej dokładnie definiuje co jak i dlaczego.

2) Dla cpanela service mysql restart, dla innych po prostu restart MySql

3) Dla ludzi kochających Cpanel polecam bloknąć konto na czas recovery czyli – /scripts/suspendacct nazwa_konta

4) Linia komend mysqldump baza tabela > plik.sql albo mysqldump baza > plik.sql

5) Dropujemy tabelę lub bazę

6) Dajemy # przed innodb_force_recovery w my.cnf

7) Restartujemy MySQL

8) Wrzucamy dumpa [root] # mysql nazwa_bazy < plik.sql

I pomyśleć cholera, że w MyISAM wystarczy dać REPAIR TABLE, bleh ale cóż 🙂



Napisz odpowiedź

Musisz być zalogowany aby dodać komentarz.