How to start mysql server after install, fully successful operation, and reboot

[Admin Hardy]

I have followed the installation instructions very carefully for

Win7 Pro x64

Active Perl 5.22.1 x86 - to gain necessary modules
bugzilla from git release-5.0-stable
All mandatory and some non-madatory pearl modules
Configured IIS
MySQL 5.7 64-Bit
etc

See my earlier (first) post.

Everything has been working very well I have successfully created
products, components, users, additional fields, bugs and custom searches
I have accessed on the LAN and from outside the LAN, etc etc, all
appears to be functioning very very well (only thing at issue is SMTP).

After rebooting my machine, first http request indicates mysql is not
running. I had thought part of the install might have set this to start
on boot up. Not sure how to do this.

So, I start "mysqld --console" manually and amongst notes and warnings I
get the following...

...
2016-01-28T10:18:56.297409Z 0 [ERROR] Can't open the mysql.plugin table.
Please run mysql_upgrade to create it.
...
2016-01-28T10:18:56.842440Z 0 [ERROR] Fatal error: Can't open and lock
privilege tables: Table 'mysql.user' doesn't exist
2016-01-28T10:18:56.845440Z 0 [ERROR] Aborting
...

It seems strange that mysql worked fine straight after installation but
fails to start after just one reboot.

Before I get into just researching a solution to this independently I
thought it would be worth asking about it on this list, in case I am
supposed to start mysql for bugzilla a special way and I have missed the
instructions. I don't recall starting mysql manually when I did the
installation and everything worked fine after it, so perhaps the check
script or something started it ad there is a particular set of actions
for starting it a second time after a reboot and I have missed those
instructions.

If you are able to advise me or point me to the instructions I have
missed I would really appreciate it.

[Thorsten Schöning]

Guten Tag Admin Hardy,
am Donnerstag, 28. Januar 2016 um 11:37 schrieben Sie:

> Before I get into just researching a solution to this independently I
> thought it would be worth asking about it on this list, in case I am
> supposed to start mysql for bugzilla a special way and I have missed the
> instructions.

No, the installer should have installed a Windows service with
automatic boot configured. At least that's my experience from older
MySQL Windows installers. So check the Windows services and maybe
reinstall MySQL and check the installation settings, normally you
should loose any data.

> I don't recall starting mysql manually when I did the
> installation and everything worked fine after it, so perhaps the check

> script or something started it[...]

No.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning E-Mail: Thorsten....@AM-SoFT.de
AM-SoFT IT-Systeme http://www.AM-SoFT.de/

Telefon...........05151- 9468- 55
Fax...............05151- 9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow

[Admin Hardy]

On 28/01/2016 10:59, Thorsten Schöning wrote:
> Guten Tag Admin Hardy,
> am Donnerstag, 28. Januar 2016 um 11:37 schrieben Sie:
>
>> Before I get into just researching a solution to this independently I
>> thought it would be worth asking about it on this list, in case I am
>> supposed to start mysql for bugzilla a special way and I have missed the
>> instructions.
> No, the installer should have installed a Windows service with
> automatic boot configured. At least that's my experience from older
> MySQL Windows installers. So check the Windows services and maybe
> reinstall MySQL and check the installation settings, normally you
> should loose any data.

***
Ok thanks. I couldn't see a MySQL installer application for Win 7 x64
only for Win 7 x86
Thw x64 installation was just a zip file which I unpacked to the
location instructed by the
bugzilla install instructions.
Hopefully then in the zip file there are some install instructions that
will tell me how to
make the server startup into a windows service.

Having said this, even when I have done that, I will surely be faced
with the same startup
failures just they will occurr from an automatic startup.
I don't understand why I am getting these failures as I have not changed
anything before reboot and it was all working fine.
withour mysql running of course bugzilla is useless and I have already
entered a fair bit of data

>
>> I don't recall starting mysql manually when I did the
>> installation and everything worked fine after it, so perhaps the check
>> script or something started it[...]
> No.

I have no idea them how the mysql server started then if as you say the
bugzilla perl check script did not start it
It was definitely running as I used the bugzilla web application for
quite a while

[Thorsten Schöning]

Guten Tag Admin Hardy,
am Donnerstag, 28. Januar 2016 um 14:12 schrieben Sie:

> Ok thanks. I couldn't see a MySQL installer application for Win 7 x64
> only for Win 7 x86
> Thw x64 installation was just a zip file which I unpacked to the
> location instructed by the
> bugzilla install instructions.

Don't do that, use the 32 Bit installer or are you already sure that
you need the 64 Bit version? I'm pretty sure you won't.

Mit freundlichen Grüßen,

Thorsten Schöning

[Admin Hardy]

On 28/01/2016 13:59, Thorsten Schöning wrote:

Guten Tag Admin Hardy,
am Donnerstag, 28. Januar 2016 um 14:12 schrieben Sie:

Ok thanks.  I couldn't see a MySQL installer application for Win 7 x64
only for Win 7 x86
Thw x64 installation was just a zip file which I unpacked to the 
location instructed by the
bugzilla install instructions.

Don't do that, use the 32 Bit installer or are you already sure that
you need the 64 Bit version? I'm pretty sure you won't.

Ok, I kind of followed this instruction in the bugzilla installation instructions

https://bugzilla.readthedocs.org/en/latest/installing/mysql.html#mysql
"Download the MySQL 32-bit or 64-bit MSI installer from the MySQL website"

These seem to "imply" that one ought to choose between 32 and 64 bit (1) (I have Win 7 Pro 64 bit) and
also seem to suggest that there is a 32-bit MSI installer and a 64-bit MSI installer in existance (2).

Since (2) was not the case and I (1) seemed to be implied, I plumbed for the 64 bit zip offering.

Now, here is a very important sequence of events...

1. Did all the install as previously described
2. MySQL running, web site working
3. Used Bugzilla to create all kinds of products, components, users, etc etc
4. Rebooted.
5. Found web site says MySQL is down.
6. Try to start MySQL - failed as described in the earlier parts of this post.
7. try suggestion in errors to run mysql_upgrade, also fails
8. Do some reading and research
9. From this there is a suggestion that I may need to run mysqld --initialize (previously mysql_install_db) to create the data folder
10.  Before trying this I look to see if I have a data folder and I do NOT.

Questions.

Is this where all the database/table/field data is held?
If so, how might it have disappeared?
Or is the database data stored else where in the case of Bugzilla?  How?

If I re-install MySQL using the 32-Bit MSI Installer might I loose all the data I entered?
Might it already be lost if there is no data folder?  How?

I don't understand why it appeared to all be working fine before the reboot
If it turns out I do have to loose all the data I put in, I want to avoid this happening again
at all cost.  Is there a user friendly / bugzilla way to back up all the data just in case?

[Emmanuel Seyman]

* Admin Hardy [28/01/2016 15:21] :

>
> https://bugzilla.readthedocs.org/en/latest/installing/mysql.html#mysql
> "Download the MySQL 32-bit or 64-bit MSI installer from the MySQL website"
>
> These seem to "imply" that one ought to choose between 32 and 64 bit (1) (I
> have Win 7 Pro 64 bit) and
> also seem to suggest that there is a 32-bit MSI installer and a 64-bit MSI
> installer in existance (2).
>
> Since (2) was not the case and I (1) seemed to be implied, I plumbed for the 64
> bit zip offering.

I suspect that 32-bit MSI installer which is the recommended download on that
page will run, detect if you're running it on a 32-bit or 64-bit system and
download the appropriate data.

Emmanuel

[Thorsten Schöning]

Guten Tag Admin Hardy,
am Donnerstag, 28. Januar 2016 um 16:21 schrieben Sie:

> These seem to "imply" that one ought to choose between 32 and
> 64 bit (1) (I have Win 7 Pro 64 bit) and

Of course you need to choose based on your environment, but as you
have a 64 Bit Windows, you can freely choose and therefore should use
the easier one and that is the installer. Please keep in mind that
even though Bugzilla tries to document all steps needed, how to
install MySQL properly is not necessarily the main focus of the
documentation. Those are admin tasks and there are plenty of tutorials
focusing on MySQL out there.

> 9. From this there is a suggestion that I may need to run
> mysqld --initialize (previously mysql_install_db) to create the data folder
> 10.  Before trying this I look to see if I have a data folder and I do NOT.

> Is this where all the database/table/field data is held?

Yes.

> If so, how might it have disappeared?

There could be plenty of reasons, you might have deleted it by
accident, it might have been some in memory temp database for any
reason...

> Or is the database data stored else where in the case of Bugzilla?  How?

Bugzilla doesn't care where MySQL stores its data.

> If I re-install MySQL using the 32-Bit MSI Installer might I loose all the data I entered?

Sounds to me it is already missing unless you get to know where it is
stored currently, why it is stored there and how. Maybe you have a
data folder already and just don't know it yet.

> Might it already be lost if there is no data folder?  How?

Of course that's possible.

> I don't understand why it appeared to all be working fine before the reboot

My educated guess is that you started a user process and MySQL did
save something somewhere which you need to fing. Search for MySQL data
file names for example, something around frm or such, you need to
search the net for it.

> If it turns out I do have to loose all the data I put in, I
> want to avoid this happening again
> at all cost.  Is there a user friendly / bugzilla way to back up all the data just in case?

http://bugzilla.readthedocs.org/en/latest/installing/moving.html

Mit freundlichen Grüßen,

Thorsten Schöning