473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MySQL startup error under Windows Installing MySQL as an Service

The service already exists!

The current server installed: C:\AppServ\MySQL\bin\mysqld-nt the --defaults-file=C:\

AppServ\MySQL\my.ini mysql



Try to start the MySQL daemon as service ...



The mysql service starts.

The mysql service failed to start.



System error.



System error 1067.



The process was unexpectedly completed.



Press any key to continue . . .
Apr 10 '18 #1

✓ answered by despairing

As soon as we have dumps of all tables we need to create new instance of MySQL.
If it’s a single table corruption it makes sense to try innodb_force_recovery=6 to DROP the table.
If MySQL can’t even start, try to move the corrupt actor.ibd elsewhere. In the recovery mode after DROP TABLE actor MySQL will remove a record from the dictionary. Remove actor.frm if it still remains.
The point is to get clean up&running MySQL, ready to import the table dump.
Once MySQL is ready create an empty table actor:
mysql> CREATE TABLE `actor` (
-> `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
-> `first_name` varchar(45) NOT NULL,
-> `last_name` varchar(45) NOT NULL,
-> `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-> PRIMARY KEY (`actor_id`),
-> KEY `idx_actor_last_name` (`last_name`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
Query OK, 0 rows affected (0.01 sec)
or you can try to use mysql recovery :

2 3284
Luuk
1,047 Expert 1GB
Yur first notice seems to indicate the MySQL is already started. You can check this by doing this on a command =prompt (as Administrator):
Expand|Select|Wrap|Line Numbers
  1. C:\>netstat -antb | findstr "3306 mysql"
  2.   TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING
  3.  [mysqld.exe]
  4.   TCP    [::]:3306              [::]:0                 LISTENING
  5.  [mysqld.exe]
  6.  

You also could try to find out the name of the service by doing this:
Expand|Select|Wrap|Line Numbers
  1. C:\>sc queryex | findstr /i "mysql"
  2. SERVICE_NAME: MySQL57
  3. DISPLAY_NAME: MySQL57
  4.  
And thn query the information of this service with:
Expand|Select|Wrap|Line Numbers
  1. C:\>sc qc MySQL57
  2. [SC] QueryServiceConfig SUCCESS
  3.  
  4. SERVICE_NAME: MySQL57
  5.         TYPE               : 10  WIN32_OWN_PROCESS
  6.         START_TYPE         : 3   DEMAND_START
  7.         ERROR_CONTROL      : 1   NORMAL
  8.         BINARY_PATH_NAME   : "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57
  9.         LOAD_ORDER_GROUP   :
  10.         TAG                : 0
  11.         DISPLAY_NAME       : MySQL57
  12.         DEPENDENCIES       :
  13.         SERVICE_START_NAME : NT AUTHORITY\NetworkService
  14.  
This should help you with "The service already exists!", if not try to give what your system responded on above example
Apr 14 '18 #2
As soon as we have dumps of all tables we need to create new instance of MySQL.
If it’s a single table corruption it makes sense to try innodb_force_recovery=6 to DROP the table.
If MySQL can’t even start, try to move the corrupt actor.ibd elsewhere. In the recovery mode after DROP TABLE actor MySQL will remove a record from the dictionary. Remove actor.frm if it still remains.
The point is to get clean up&running MySQL, ready to import the table dump.
Once MySQL is ready create an empty table actor:
mysql> CREATE TABLE `actor` (
-> `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
-> `first_name` varchar(45) NOT NULL,
-> `last_name` varchar(45) NOT NULL,
-> `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-> PRIMARY KEY (`actor_id`),
-> KEY `idx_actor_last_name` (`last_name`)
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
Query OK, 0 rows affected (0.01 sec)
or you can try to use mysql recovery :
Apr 25 '18 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Cathy Hui | last post by:
Do u know why do i get the following message when trying to build the MySql-Python (1.2.0) on my Solaris 8 system? (with mysql 4.0.21 and python 2.4). thanks! error mesg: ld: fatal:...
2
by: jmlynn | last post by:
Help! I installed MySQL 4.0.20C and it works if I started it with mysqld --console However, if I do the following: mysqld --install net start MySQL
0
by: Kyle Baley | last post by:
I'm developing an MCMS web service and am getting a 401 unauthorized error when I try to consume it from a client. It works fine when I use the test harness to navigate to the asmx file directly....
0
by: niclarke | last post by:
I have created a windows service based on a walkthrough in the MSDN library (ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_radcon/html/e24d8a3d-edc6-485c-b6e0-5672d91fb607.htm - ...
1
by: manish deshpande | last post by:
Hi, When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command: rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown: ...
3
by: Phil989 | last post by:
Hi, I hope you can help me. As I try to install Devil'z Clanportal, i only recieve this error message: MySQL-Query failed: ErrorNo = 1064 Error = You have an error in your SQL syntax; check...
1
by: jdresow | last post by:
I installed MySQL on a windows server 2003, in an acxtive directory domain and I get error 32 which is a sharing error. I do not understand this and I am also adding the first several lines of my...
3
by: Ananthu | last post by:
Hi I have downloaded mysql server 5.0.45 for windows and when i try to install all the steps i followed the installation process but at the last stage that is configuration stage i get error like...
2
by: Bill Davidson | last post by:
All: I have a Win32 service that takes about 30 seconds to shutdown (give or take a few seconds). I shut the service down via the 'Services' console on Windows Server 2003. When the service...
0
by: despairing | last post by:
The problem with the MySQL startup The services have a MySQL server installed. The error occurs on 4.1.16 and 5.0.24. "The MySQL service could not be started on the Local computer. Error...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.