1.12.1 MySQL/server DB help

[turtleswin]

Haha, you get a new modem yet?

[XxXGenesisXxX]

Lol, you love hijacking threads :P

And not really, borrowing a mates, but it gives a bad IP and can't even make a connection between it and my computer. So I cbf setting up a static IP just to get into the modem. Just using my crap one.

[turtleswin]

I love hijacking all! Anyway, i'm making my first guide video, so I won't respond to much =P

[XxXGenesisXxX]

All good I was about to continue on a guide I'm writing atm anyway, was thinking the same thing lol :P

[Carnifex5]

Hey guys, looks like everything is set, besides the config file for world, I've located what -appears- to be the config file, but the information doesn't match that found in the link Genesis gave me, so is there anyway to just copy + paste into this one and use it as a config file or how do I go about it?

For reference:
http://www.ownedcore.com/forums/worl...asy-guide.html (Making your MANGOS/Trinity Server Public (EASY GUIDE))
Step 5

As for my modem it's a Thomson, and I've added the port openings into the firewall, as for the other stuff (Besides Carnifex being kickass) I'm not entirely sure what what you're discussing :s

[XxXGenesisXxX]

No you can't, the guide is for a newer core, their configs would be incompatible. If you copy and paste your configs on here with the [*CODE][*/CODE] tags (minus the astrixes), then I can color and explain to you what needs to be changed. Just put a fake password in the password sections as long as they're consistant.

[Carnifex5]

Okay so this is the only config file I found in there, as I said it looks.. way off,

# large settings.
sort_buffer_size=256K


#*** INNODB Specific options ***


# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb

# Additional memory pool that is used by InnoDB to store metadata
# information.  If InnoDB requires more memory for this purpose it will
# start to allocate it from the OS.  As this is fast enough on most
# recent operating systems, you normally do not need to change this
# value. SHOW INNODB STATUS will display the current amount used.
innodb_additional_mem_pool_size=3M

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.
innodb_flush_log_at_trx_commit=1

# The size of the buffer InnoDB uses for buffering log data. As soon as
# it is full, InnoDB will have to flush it to disk. As it is flushed
# once per second anyway, it does not make sense to have it very large
# (even with long transactions).
innodb_log_buffer_size=2M

# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
# row data. The bigger you set this the less disk I/O is needed to
# access data in tables. On a dedicated database server you may set this
# parameter up to 80% of the machine physical memory size. Do not set it
# too large, though, because competition of the physical memory may
# cause paging in the operating system.  Note that on 32bit systems you
# might be limited to 2-3.5G of user level memory per process, so do not
# set it too high.
innodb_buffer_pool_size=100M

# Size of each log file in a log group. You should set the combined size
# of log files to about 25%-100% of your buffer pool size to avoid
# unneeded buffer pool flush activity on log file overwrite. However,
# note that a larger logfile size will increase the time needed for the
# recovery process.
innodb_log_file_size=50M

# Number of threads allowed inside the InnoDB kernel. The optimal value
# depends highly on the application, hardware as well as the OS
# scheduler properties. A too high value may lead to thread thrashing.
innodb_thread_concurrency=8

>Hope I tagged it right
For a newer core you say, well if all else fails, if you know of a repack that has everything I need (if this one clearly doesn't) then by all means link away.

[XxXGenesisXxX]

You tagged it right, but that's not a config file. You should have a folder called configs. Or possibly in your server folder do you have anything with ".conf.dist" at the end? What repack are you using?

[turtleswin]

Not sure how to help you. Just go hamachi IMO.

[Carnifex5]

Apparently not, sadly. Searched and all, even with hidden folders on, just incase.
Repack =
EPIC Pre-TBC repack! + Dyns/Hosts/1.12.1 Download

[turtleswin]

repacks are bad, b ut use AlterWoW's. Only working vanilla repack out there xD

[Carnifex5]

http://www.ownedcore.com/forums/worl...-1-repack.html (AlterWoW's Pre-TBC/Vanilla 1.12.1 Repack) <= This one? I downloaded that and had a quick look, there's no confs in there either, besides the one already posted here.

[turtleswin]

Get teamviewer, i'll set it up for you.

[Carnifex5]

Get teamviewer, i'll set it up for you.

Alrighty, got MSN?

[turtleswin]

I have skype, that okay?