database - recover data using ibdata1 file mysql -


how can recover data when have ibdata1 file backup.

i have tried instruction @ following link looks missing. http://blog.shiraj.com/2012/10/extract-data-from-mysql-ibdata1-data-file/

started mysqld-nt recovery option

c:\program files (x86)\mysql\mysql server 5.0\bin>mysqld-nt.exe --standalone --c onsole --innodb-force-recovery=6 innodb: user has set srv_force_no_log_redo on innodb: skipping log redo 130904  6:02:29  innodb: started; log sequence number 0 0 innodb: !!! innodb_force_recovery set 6 !!! 130904  6:02:29 [note] mysqld-nt.exe: ready connections. version: '5.0.90-community-nt'  socket: ''  port: 3306  mysql community edition (gpl) 

opened new console see of databases. doesn't show database looking for. guess 3 databases showing default one.

c:>mysql -u root -p enter password: **************** welcome mysql monitor.  commands end ; or \g. mysql connection id 2 server version: 5.0.90-community-nt mysql community edition (gpl)  type 'help;' or '\h' help. type '\c' clear current input statement.  mysql> show databases; +--------------------+ | database           | +--------------------+ | information_schema | | mysql              | | test               | +--------------------+ 3 rows in set (0.00 sec) 

can please suggest if missing something?


Comments

Popular posts from this blog

How to remove text and logo OR add Overflow on Android ActionBar using AppCompat on API 8? -

html - How to style widget with post count different than without post count -

url rewriting - How to redirect a http POST with urlrewritefilter -