Destroyed my XC database...any ideas?

[humat]

Yesterday evening my xc database got corrupted, I have a backup but I'm still lost. I'm trying to restore the DB but I'm pretty sure this is not going to work.

Any ideas?

H

 

[jamesb16]

lolol always make a back up

 

[humat]

I have a backup which I'm restoring but I had to re-install mysql and I don't think that it s going to work.

 

[Iptvgeeker]

Why would it not work? So long as your database is intact you'll be fine.

 

[kingstazi]

You can consider other panels !

 

[humat]

Not really, start_services.sh is saying:
{"error":"MySQL: MySQL server has gone away"}

I'm still restoring but there are quite a few other things that need to be done here.

 

[Iptvgeeker]

Did you change the mysql port after doing a reinstall as it will default to port 3306?

 

[humat]

Did you change the mysql port after doing a reinstall as it will default to port 3306?

It's still the default, but there will be users in the mysql database that are not there now due to reinstallation I believe. These would have been installed with the app, and the installation does not exist anymore. sad times

 

[humat]

When I say mysql database I mean the one with the name mysql that will have the users with asset to mysql

 

[castaway]

@humat before anything you can check mysql database with mysqlcheck
you can read more here: thegeekstuff.com

 

[Iptvgeeker]

It's still the default, but there will be users in the mysql database that are not there now due to reinstallation I believe. These would have been installed with the app, and the installation does not exist anymore. sad times

How are you re importing your users?

 

[humat]

I have the db fully restored, I tried to use the /home/xtreamcodes/iptv_xtream_codes/start_services.sh

And got {"error":"MySQL: Connection refused”}

I think there is a user that they create when they install the DB.

Is it possible to fix this please?

 

[castaway]

your mysql server isn't working, you have to start mysql server.
to check does mysql service is working type:

service mysql status

to start mysql service

service mysql start

If mysql is working contact me on PM

 

[bulge]

Sounds like you changed your mysql password for iptv_user. Located in your xc config file are the credentials for your local db, if they dont match then it wont connect. Ensure your mysql-server is running on port 7999 and you have granted access to the database to that user using the credentials you had previously.
Don't forget to like my post if you found it helpful.

 

[humat]

your mysql server isn't working, you have to start mysql server.
to check does mysql service is working type:

service mysql status

to start mysql service

service mysql start

If mysql is working contact me on PM

SQL is running it must be something to do with an SQL user that they create when they create the database which was lost when I reinstalled Mysql

 

[humat]

Sounds like you changed your mysql password for iptv_user. Located in your xc config file are the credentials for your local db, if they dont match then it wont connect. Ensure your mysql-server is running on port 7999 and you have granted access to the database to that user using the credentials you had previously.
Don't forget to like my post if you found it helpful.

I did grant full rights to the root user, but I think that they use a different user

 

[humat]

I did grant full rights to the root user, but I think that they use a different user

Also I used the same root password when I reinstalled mysql and kept the standard port.

 

[castaway]

SQL is running it must be something to do with an SQL user that they create when they create the database which was lost when I reinstalled Mysql

Usually when you reinstall or update mysql server, package manager doesn't remove or update database. As bulge said, maybe mysql server is working on default port, which is 3306, but xtream installation change that port to 7999 for v2.
You can check on which port your mysql server is working, by looking in mysql configuration file, on location

/etc/mysql/my.cnf

or by running command:

netstat -plnat | grep mysql

if you're looking config file, option port is located under [mysqld] configuration group, else if you running netstat command, at the first line you have output like 0.0.0.0:: Port_no.