SQLinfo.ru - Все о MySQL

Форум пользователей MySQL

Задавайте вопросы, мы ответим

Вы не зашли.

#1 05.08.2008 04:26:43

polecat
Участник
Зарегистрирован: 05.08.2008
Сообщений: 1

Восстановление innodb из файлов

Проблема в слудующем:
Рухнула винда. На ней работала база mysql. Очень нужно восстановить базу. Дампы не делались.
Есть только полностью папка от старой БД (Mysql 4.1.16). Таблицы в innodb.

Неактивен

 

#2 05.08.2008 15:30:34

rgbeast
Администратор
MySQL Authorized Developer and DBA
Откуда: Москва
Зарегистрирован: 21.01.2007
Сообщений: 3880

Re: Восстановление innodb из файлов

Поставить винду, поставить mysql желательно той же версии. Скопировать ей каталог с БД и прописать в my.cnf файле те же настройки innodb (размер файла, если общее хранилище или опция one-file-per-table). Желательно иметь старый my.cnf файл.

Неактивен

 

#3 22.11.2009 10:36:18

binary
Участник
Зарегистрирован: 22.11.2009
Сообщений: 7

Re: Восстановление innodb из файлов

Та же проблема, но я не знаю, в чем у меня таблицы структура папки data такова:

24.10.2009  15:19                 5 binary.pid
04.11.2009  16:45    <DIR>          dimon
04.11.2009  16:45    <DIR>          hostl
28.01.2009  15:21        10 485 760 ibdata1
24.10.2009  16:01        25 165 824 ib_logfile0
14.06.2009  16:08        25 165 824 ib_logfile1
04.11.2009  16:45    <DIR>          mysql

если просто скопировать все это на новую винду, потом запустить сервер, то старые базы не появляютса(


в логах вот такое написано при старте:

091122  9:49:03  InnoDB: Error: page 7 log sequence number 0 9413927
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:03  InnoDB: Error: page 1 log sequence number 0 9412724
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:03  InnoDB: Error: page 2 log sequence number 0 9417258
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:03  InnoDB: Error: page 11 log sequence number 0 9417285
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:04  InnoDB: Error: page 5 log sequence number 0 9479119
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 6 log sequence number 0 9480826
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 45 log sequence number 0 9480036
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 523 log sequence number 0 9480826
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 8 log sequence number 0 9414092
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 0 log sequence number 0 9469611
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 10 log sequence number 0 9417258
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 320 log sequence number 0 7026364
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 12 log sequence number 0 7135592
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 9 log sequence number 0 9416567
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 50 log sequence number 0 6819464
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 51 log sequence number 0 6820838
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Started; log sequence number 0 44233
091122  9:49:05  InnoDB: Error: page 52 log sequence number 0 6822234
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 53 log sequence number 0 9411345
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 54 log sequence number 0 6823624
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 55 log sequence number 0 6825016
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 56 log sequence number 0 6826337
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 57 log sequence number 0 9265742
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 58 log sequence number 0 9265757
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 59 log sequence number 0 9265772
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 60 log sequence number 0 9265787
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05 [Note] Event Scheduler: Loaded 0 events
091122  9:49:05  InnoDB: Error: page 61 log sequence number 0 7193269
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05 [Note] c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.41-community'  socket: ''  port: 3306  MySQL Community Server (GPL)
091122  9:49:05  InnoDB: Error: page 62 log sequence number 0 7193308
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.
091122  9:49:05  InnoDB: Error: page 63 log sequence number 0 7197437
InnoDB: is in the future! Current system log sequence number 0 44233.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/ … overy.html
InnoDB: for more information.

Отредактированно binary (22.11.2009 10:43:34)

Неактивен

 

#4 23.11.2009 08:39:25

paulus
Администратор
MySQL Authorized Developer and DBA
Зарегистрирован: 22.01.2007
Сообщений: 6757

Re: Восстановление innodb из файлов

Файлик my.ini надо тоже скопировать, разумеется.

Неактивен

 

Board footer

Работает на PunBB
© Copyright 2002–2008 Rickard Andersson