Help with phpMyAdmin and HLStats

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
UpUranus
New to forums
New to forums
Posts: 4
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Tue Feb 07, 2012 8:01 am

Help with phpMyAdmin and HLStats

Post by UpUranus »

I need to get a backup of my HLstats database for migrating to gameME. I have installed phpMyAdmin as directed, but from there I am lost. I am hoping someone here is familiar with the stats databases and would be willing to give me some directions for backing them up.

Thanks
User avatar
Vanderburg
Former staff
Former staff
Posts: 1253
Joined: Sat Nov 13, 2010 7:27 am
Location: Dallas, TX

Re: Help with phpMyAdmin and HLStats

Post by Vanderburg »

Once in phpMyAdmin, click on the database name, then click on Export on the top. This will let you create a .sql file that will include both the database structure and the data within those tables. Once you've downloaded the .sql file, you can use the import function on the new database and simply upload the .sql file, whcih will create all the goodies you need. Then you'll just change the database information in your server configurations.
User avatar
Edge100x
Founder
Founder
Posts: 12948
Joined: Thu Apr 18, 2002 11:04 pm
Location: Seattle
Contact:

Re: Help with phpMyAdmin and HLStats

Post by Edge100x »

To make phpMyAdmin point to the right host, you'll also need to edit its config.inc.php file. Download this through FTP and edit it on your local computer in a text editor to change this line:

$cfg['Servers'][$i]['host'] = 'localhost';

to:

$cfg['Servers'][$i]['host'] = 'hlstatsx.nfoservers.com';

Then, re-upload it.

The database name used on the HLStatsX machine matches your server's identifier. The login name is also the identifier, and the password is your server's FTP password.
UpUranus
New to forums
New to forums
Posts: 4
Joined: Tue Feb 07, 2012 8:01 am

Re: Help with phpMyAdmin and HLStats

Post by UpUranus »

I assume that by identifier, you mean the first part of my domain name.

I/E my server is qazctfserver.game.nfoservers.com, so my identifier is qazctfserver?

Thanks for the replies.
User avatar
Vanderburg
Former staff
Former staff
Posts: 1253
Joined: Sat Nov 13, 2010 7:27 am
Location: Dallas, TX

Re: Help with phpMyAdmin and HLStats

Post by Vanderburg »

Yes, that is correct. It's also named on the tab for your server in the control panel on the left side.
UpUranus
New to forums
New to forums
Posts: 4
Joined: Tue Feb 07, 2012 8:01 am

Re: Help with phpMyAdmin and HLStats

Post by UpUranus »

I used this information and exported the stats database without a hitch.

THANKS.
Post Reply