Forum posts for mysqld-nt.exe

recover data using ibdata1 file mysql

How can I recover the data when I have ibdata1 file backup.

I have tried instruction at following link but looks like something is missing.
http://blog.shiraj.com/2012/10/extract-data-from-mysql-ibdata1-data-file/

Started mysqld-nt with recovery option

C:Program Files (x86)MySQLMySQL Server 5.0in>mysqld-nt.exe --standalone --c
onsole --innodb-force-recovery=6
InnoDB: The 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 is set to 6 !!!
130904 6:02:29 [Note] mysqld-nt.exe: ready for connections.
Version: '5.0.90-community-nt' socket: '' port: 3306 MySQL Community Edition
(GPL)


opened a new console to see of the databases. It doesn't show the database I am looking for. I guess all 3 databases its showing are the default one.

C:>mysql -u root -p
Enter password: ****************
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.0.90-community-nt MySQL Community Edition (GPL)

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
3 rows in set (0.00 sec)


Can you please suggest if I am missing something?

View complete forum thread with replies

Other posts related to mysqld-nt.exe

See Related Forum Messages: Follow the Links Below to View Complete Thread

mysqld-nt.exe exist in task list,but actually it's not running?
taskkill Mysql from .ASPX — Permission Problems?
how to get around The '--' operator works only on variables or on properties
MySQL stops working every five to six hours
Mysql server not starting in xampp
recover data using ibdata1 file mysql
Getting error 2003 when trying to connect to MySQL server after reboot
What's the difference between IN and INNER JOIN in my case?