HLStatsxCE database

[doulos9]

Is there a way for me to get a copy of my hlstatsxce database? I asked the question in a ticket but they said they thought one could export the database. However, I could not find out how to do this. There is an option to Optimize Database but I don't see anything to export the database.

Any suggestions?

[soja]

Do you have access to phpmyadmin for the database? That could be used to export the database.

I have not used NFO's HLX:CE service before, so I likely won't be much help(I run my own install).

[kraze]

Currently we do not offer any way to export the current database.

[Edge100x]

You should actually be able to access the database from another NFO server (a shared webhosting account, etc). We provide FTP access to the HLStatsX:CE install and you have its MySQL login information. But, this is something that we don't directly support, so it's for advanced users only.

[doulos9]

OK thanks.

[$atanic $pirit]

You can try to use phpmyadmin for this task.

[soja]

You can try to use phpmyadmin for this task.

You would need to configure phpmyadmin to connect to a remote database, which isn't the easiest thing(nor is it needed).

You could use the command line tools for windows or linux to log in to the server and do a mysqldump though.

[doulos9]

I tried using MySQL Workbench but it would not connect on port 3306. Using my stats ftp user/password.

I will try to use phpmyadmin from my linux server - if I can figure out how to to do.

[doulos9]

Connection denied.

#1130 - Host 'my ip address' is not allowed to connect to this MySQL server

[$atanic $pirit]

You would need to configure phpmyadmin to connect to a remote database, which isn't the easiest thing(nor is it needed).

We provide FTP access to the HLStatsX:CE install and you have its MySQL login information.

If you have ftp to the HLSTATsX:CE then it's not a remote connection. Am I missing something here?



Is your other server from NFO? The only time I ever seen that IP error is when, the IP is from an outer source.

[doulos9]

The mysql server will not allow me to connect to it from a remote computer. It apparently only allows localhost connections.

I have FTP access only.

[Edge100x]

You're certain that the server you were connecting from had a valid nfoservers.com reverse DNS?

[doulos9]

I will check it again.

[doulos9]

I added the server to phpmyadmin (hosted on my NFO website) but when I try to log in I get this message:

#1045 - Access denied for user 'my stats username'@'hosted31.nfoservers.com' (using password: YES)

Correct me if I am wrong, but are these not the correct settings to add to phpmyadmin config.inc.php?

Code: Select all

$i++;
$cfg['Servers'][$i]['host']          = 'my stats url';
$cfg['Servers'][$i]['port']          = '3306';
$cfg['Servers'][$i]['socket']        = '';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysql';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'config';
$cfg['Servers'][$i]['user']          = 'my hlstatsx username';
$cfg['Servers'][$i]['password']      = 'my hlstatsx password';
$cfg['Servers'][$i]['AllowNoPassword'] = false;

[Edge100x]

If these match the settings in the HLStatsX configuration file, they should work. Are you also unable to use phpmyadmin locally on the HLStatsX box?