MySQL problem

[Jorvalt]

Okay so I literally have no idea what is going on. I wanted to start up my MaNGOS server after not having started it for quite some time. I tried to and apparently the MySQL server wasn't up. I was like, okay. So I have no idea how to start it up again. I tried like starting it up by running the mysqld.exe but then it gave my some error and I needed to make a bat file where I put in --explicit_Defaults_for_timestamp=true and it worked. But then for some reason when I connected to the database with SQLyog, it was all default shit and none of my WoW stuff was there. For some reason I thought editing mysql_config.pl would change something. So I did. I changed the lines:

my $ldata

my $execdir

my $bindir

because those were set to directories that are non-existant. It was like C:\Program Files\MySQL or something, and that directory didn't exist. Problem is then I ran the server again and I was getting some errors and the server shut itself down. Now I can't remember what it was set to before and I'm pretty pissed off at this point.

So, thoughts?

Edit: Oh I forgot to mention that despite the WoW stuff not being in the database I still have a folder called MySQL Data that contains all the WoW data and a my.ini file.

[bels]

Isn't mysql started as a service in windows instead of going directly to mysqld.exe and running that? Can you check to see if you have a service for mysql that you can try starting?

[Jorvalt]

Isn't mysql started as a service in windows instead of going directly to mysqld.exe and running that? Can you check to see if you have a service for mysql that you can try starting?

I just checked in my services and there's nothing with "MySQL" on there.

[bels]

It could also be referred to Oracle MySql depending on which version you have. Unfortunately I don't use mysql on windows so I don't much how it is supposed to work. Do you have a database to preserve? If not, could you reinstall MySQL?

[Hikari]

You shouldn't change any *.pl files. If you want to configure your MySQL server use the my.ini file.

The three values may look like

my $ldata  = 'C:/Program Files/MySQL/MySQL Server 5.5/data';
my $execdir = 'C:/Program Files (x86)/MySQL/bin';
my $bindir = 'C:/Program Files (x86)/MySQL/bin';

depending on where and which version you've installed.

Usually MySQL is installed as service by default.

Open a command prompt and navigate to the bin folder of your MySQL installation and execute

mysqladmin -u root -p shutdown

to shutdown your instance of MySQL.

mysqld --install

to install MySQL as service.

NET START MySQL

to start the MySQL service.

If MySQL have any problems it will log it into the [hostname].err file, which is located in the data folder where also your databases are.

Maybe there is already something messed up and you should start over by reinstalling MySQL from scratch.

[Jorvalt]

You shouldn't change any *.pl files. If you want to configure your MySQL server use the my.ini file.

The three values may look like

my $ldata  = 'C:/Program Files/MySQL/MySQL Server 5.5/data';
my $execdir = 'C:/Program Files (x86)/MySQL/bin';
my $bindir = 'C:/Program Files (x86)/MySQL/bin';

depending on where and which version you've installed.

Usually MySQL is installed as service by default.

Open a command prompt and navigate to the bin folder of your MySQL installation and execute

mysqladmin -u root -p shutdown

to shutdown your instance of MySQL.

mysqld --install

to install MySQL as service.

NET START MySQL

to start the MySQL service.

If MySQL have any problems it will log it into the [hostname].err file, which is located in the data folder where also your databases are.

Maybe there is already something messed up and you should start over by reinstalling MySQL from scratch.

Worked perfectly. Thank you.

...buuuut my WoW stuff is still gone.

[Jorvalt]

Like I already told you, my MySQL server and the WoW database are in two seperate folders. Here's the path for each of them:

MySQL: C:\World of Warcraft Vanilla\WoW Server\MySQL\MySQL Server 5.6

WoW Database: C:\World of Warcraft Vanilla\WoW Server\MySQL Data

[Hikari]

Can you please explain how you applied the sql files into your database?

[Jorvalt]

What I had done before was I took the source code sql files that I needed to extract and I put them in the database. I can't exactly remember why it's in a seperate folder though.

[Hikari]

Not quite a meaningful statement.

Just to make sure.

You connected with SQLyog to your MySQL server and created there the four new databases for mangos. After that you applied the appropriate sql files via SQLyog to the responsible databases?

You don't have to copy any files into MySQL data folders. Just apply them with command prompt or SQLyog.

[Jorvalt]

Yeah, that's what I did. I don't know how they ended up in a separate folder though, it's been a while.

[Jorvalt]

Hello? Am I going to get a solution to this problem?

[Hikari]

So what exactly is your problem? That your databases are in a folder you don't like?

MySQL has two data folders. One in the installation directory where most likely the system databases are stored and one directory somewhere else for the data of other databases.

If you don't like that behaviour you should adjust the path of the datadir attribute in your my.ini file.

[Jorvalt]

So what exactly is your problem? That your databases are in a folder you don't like?

MySQL has two data folders. One in the installation directory where most likely the system databases are stored and one directory somewhere else for the data of other databases.

If you don't like that behaviour you should adjust the path of the datadir attribute in your my.ini file.

No, the problem is that I have the database files but for some reason they don't show up in the server. Also in my MYSQL folder I don't have a my.ini file, but I have a my-default.ini file anad it says in the file not to edit it because it's a template.

[Jorvalt]

Ok, well I just copied the stuff from the data folder I had to the data folder for MYSQL and that seemed to work.