Mysql – How to restore a MySQL database after formatting the hard drive

If the mysql service is up right now, shut it down

C:\> net stop mysql

You need to create my.ini

Go to C:\Program Files\MySQL\MySQL Server 5.5

You should see a bin folder and the data folder you have in your question

Create my.ini in C:\Program Files\MySQL\MySQL Server 5.5

I noticed you have

• ibdata1
• 3 innodb log files
• binary logs that start with mysql-bin

Make sure you have these options in my.ini

[mysqld]
innodb_data_file_path=ibdata1:10M:autoextend
innodb_log_files_in_group=3
innodb_log_file_size=256M
innodb_buffer_pool_size=768M
log-bin=mysql-bin

You need to start the service manually

C:\> cd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
C:\> net start mysqld

By default, when starting up mysqld like this, mysqld.exe expects the my.ini to initially be in its parent directory.

If mysql starts successfully, you should see mysqld.exe in the processlilst of the Task Manager and the file clarinet.err should have today's date. You can shut it down using:

C:\> cd "C:\Program Files\MySQL\MySQL Server 5.5\bin"
C:\> mysqladmin -uroot shutdown

Now configure mysql service so that it uses C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld.exe

This is no SQL code:

"mysqldump -u root -proot Isys-TMS(EEI1) > isystms.sql;"

It is a commandline program like mysql.exe. You seem to run this in Query Browser or mysql cmd - this is wrong!

You can create a backup in Query Browser with the tool itself: http://www.siteground.com/tutorials/php-mysql/mysql_gui_tools.htm

or by running the mysqldump commandline from C:\Program Files (x86)\MySQL\MySQL Server 4.1\bin as:

mysqldump -u root -proot Isys-TMS(EEI1) -r isystms.sql

Please read this too (avoid \n / \r\n conversion): http://dev.mysql.com/doc/refman/5.1/de/mysqldump.html

Restore: http://www.siteground.com/tutorials/php-mysql/mysql_gui_tools.htm#restore