Vault to MySQL Saving Via Windows Steps.
Steps to switch vault xp saving to SQL saving in windows!!
MySQL is a database program. So if you wish to use it, download at http://dev.mysql.com/downloads/mysql/5.0.html#downloads and install it. The following steps are to install mySQL on your local server WINDOWS ONLY, but it can also applied to command steps if you know how to command connect to mySQL via remote linux etc: 1, Download the contribution package: 2, Extract it, and you will need this file from the package:
3, Name it a easier name if you want, say shero.sql 4, Open it with a text editor program.
5, Put it into C: drive. 6, Open DOS Command ( Start -> Run -> type "cmd" ) 7, Go into your mysql/bin folder 8, Type "mysql -uroot -ppassword < C:\shero.sql"
9, Go into your dedicated server folder then -> /addons/amxmodx/configs/modules.ini
11, Open /addons/amxmodx/configs/shero/shconfig.cfg and edit accordingly:
12, Close and ReOpen Server. 13, Join server, open console. Type: amx_shvaulttosql << TYPE IT ONLY ONCE!! Don't know why but if vittu and jtp says so it gotta be right. So there ya go. You have now successfully installed mySQL xp saving. |
Re: Vault to MySQL Saving Via Windows Steps.
Quote:
Simply select the sql file under the menu SQL. And your guide can only be used if the mysql database is located on the same pc as the server. And actually the server creates the databases that is needed, if the connection is right. |
actually... if i'm not mistaken, you can simply telnet to remote server and type the almost exact command to run it on a remote unix server if i'm not mistaken o.O.... so Imma gonna have to argue that you can use this guide even for unix setup. Except for C:\shero.sql it would probably be somethign like /home/user/username/shero.sql assuming you put the shero.sql in the username folder. Also btw, I don't like phpAdmin, I have it installed. I tried both but I find myself going to the command more often than not since not every server use phpmyadmin so I think commands are more versatile. :P
|
If you only have a webhotel on a remote computer, you do not have root access...
Then it can't be used. |
i'm pretty sure when a webhost gives u a mySQL server they give a user access on their mySQL DB no?
|
Mostly you only get access via phpMyAdmin.
You have only one database, and you are not allowed to create any more. |
so then I would just use that database for shero saving no? Just remove the create database part from the shero db install script. Just start from:
USE SHERODB; << or whatever the database name is o.O... cannot be done? |
cant make anything whit dos
doesnt work i says cnat find the file specified |
hi.
i have a quick Q if i may, the last command, does that take the xp out of the vault and put it into the DB ? i wish to move from vault to mysql, but dont know how to import the xp across, am i right in assuming this will take care of that for me? thankyou |
Quote:
|
All times are GMT -4. The time now is 04:12. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.