Pages: Previous12
Current Page: 2 of 2
Re: No connection could be made because the target machine actively refused it.
Posted by: RiggsFolly (---.as43234.net)
Date: November 15, 2014 04:03PM

Well I would do that so at least you can then have more than one try at recovering this database.

Unfortunately you have to do something to recover this database in order to get MySQL to start again before you can backup all the others that you actually want.

With INNODB databases all the actual data goes into the same file 'ibdata1' in the \wamp\bin\mysql\{mysqlversion}\data folder. So unless you can recover the problem database you will not be able to get to the ones that you actually want to keep.

INNODB databases became the default as of MySQL 5.5 I believe, but that does not stop you specifying the database type when creating a table.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: No connection could be made because the target machine actively refused it.
Posted by: draney (---.lightspeed.tukrga.sbcglobal.net)
Date: November 15, 2014 04:31PM

I ended up deleting all the woodruff_wp .idb tables and it started up fine after that.

Thanks for your help.

Options: ReplyQuote
Re: No connection could be made because the target machine actively refused it.
Posted by: RiggsFolly (---.as43234.net)
Date: November 15, 2014 05:08PM

Ahh nice.

You didn't tell us you had innodb_file_per_table set.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Pages: Previous12
Current Page: 2 of 2


Sorry, only registered users may post in this forum.