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
Help with phpMyAdmin and HLStats
-
- New to forums
- Posts: 4
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Tue Feb 07, 2012 8:01 am
- Vanderburg
- Former staff
- Posts: 1253
- Joined: Sat Nov 13, 2010 7:27 am
- Location: Dallas, TX
Re: Help with phpMyAdmin and HLStats
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.
Re: Help with phpMyAdmin and HLStats
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.
$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.
Re: Help with phpMyAdmin and HLStats
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.
I/E my server is qazctfserver.game.nfoservers.com, so my identifier is qazctfserver?
Thanks for the replies.
- Vanderburg
- Former staff
- Posts: 1253
- Joined: Sat Nov 13, 2010 7:27 am
- Location: Dallas, TX
Re: Help with phpMyAdmin and HLStats
Yes, that is correct. It's also named on the tab for your server in the control panel on the left side.
Re: Help with phpMyAdmin and HLStats
I used this information and exported the stats database without a hitch.
THANKS.
THANKS.