MySql

rasechi · Post by **rasechi** » Tue Mar 06, 2007 11:40 am

is mysql free to use? when i went to the website it says something about buying.

Post by **YamiKaitou** » Tue Mar 06, 2007 11:46 am

Yes, it is free. You can download it from http://dev.mysql.com/downloads/mysql/5.0.html and install it on your personal computer. You can also find free sites that grant SQL databases.

rasechi · Post by **rasechi** » Tue Mar 06, 2007 7:07 pm

after downloading it do i have to register for an acnt? is the acnt where i enter it into the info for mysql info?

Post by **YamiKaitou** » Tue Mar 06, 2007 9:35 pm

It should tell you everything you need to know on the site. I have never used MySQL on localhost before so I am not sure how to set it up.

kp_downarrow · Post by **kp_downarrow** » Tue Mar 06, 2007 9:52 pm

after you download mysql, the database is yours, you configure it, you dont have to register, you can mess with it as much as you like

Senne · Post by **Senne** » Wed Mar 07, 2007 10:04 am

i found a fre mysql host tho, as long you back it up every week , he told me there would be no problems.
and it doesnt make my server lagg, like some paying options did with me.

rasechi · Post by **rasechi** » Wed Mar 07, 2007 5:30 pm

how do i connect the mysql from my computer to my server? should i enter the ip of my computer to the wc3ft.cfg?

kp_downarrow · Post by **kp_downarrow** » Wed Mar 07, 2007 7:10 pm

is your server and mysql on the same machine?

you set these in war3ft.cfg

FT_sql_host "127.0.0.1" // Host Name
FT_sql_user "root" // User Name
FT_sql_pass "" // Password
FT_sql_db "" // Database Name

rasechi · Post by **rasechi** » Wed Mar 07, 2007 7:57 pm

no. i rent a server. so how should work the mysql?

kp_downarrow · Post by **kp_downarrow** » Wed Mar 07, 2007 10:58 pm

you still change those above

rasechi · Post by **rasechi** » Thu Mar 08, 2007 3:47 pm

wat do i change it to? also, is mysql a program that i need to keep running at all times? lets say if i don't turn mysql will the exp not be saved?

Post by **YamiKaitou** » Thu Mar 08, 2007 3:56 pm

Yes, MySQL needs to be always running for it to work.

The host is your external IP.
The user is the user you created.
The pass is the password your user has.
The db is the database you created to store the xp

rasechi · Post by **rasechi** » Thu Mar 08, 2007 4:33 pm

so if i don't keep my computer running 24/7, it won't work? is there a way i can run mysql without using my own personal computer?

Post by **YamiKaitou** » Thu Mar 08, 2007 4:50 pm

Yes, you can search for a free provider

rasechi · Post by **rasechi** » Thu Mar 08, 2007 5:00 pm

What do I search? MySQL Provider?

rasechi · Post by **rasechi** » Thu Mar 08, 2007 5:09 pm

I found a provider. After I get the account, do I have to do anything before I can start saving data onto it?

Post by **YamiKaitou** » Thu Mar 08, 2007 5:19 pm

Yes, you need to set up the cvars.

The host is provided by the provider.
The user is the user you created.
The pass is the password your user has.
The db is the database you created to store the xp

rasechi · Post by **rasechi** » Thu Mar 08, 2007 5:49 pm

when i try to create a table, it asks me for all this stuff. how do i make the table?

Post by **YamiKaitou** » Thu Mar 08, 2007 5:55 pm

You don't. wc3ft creates the table for you

rasechi · Post by **rasechi** » Fri Mar 09, 2007 11:47 am

is there a way to transfer my alrdy existing information from nvault to mysql?

Post by **YamiKaitou** » Fri Mar 09, 2007 2:17 pm

If you don't mind doing it manually. nVault files are in binary format, so you need something to read them if you do it manually

rasechi · Post by **rasechi** » Fri Mar 09, 2007 3:34 pm

where is the nVault file? and what's a program that can read binary?

Post by **YamiKaitou** » Fri Mar 09, 2007 3:40 pm

addons/amxmodx/data/nvault

Not sure, try searching for it