Question Error on MySQL

[someiptvdude]

Hi All,

Hoping someone could help me here, my main panel for xtream UI R22D is down currently.

I originally got an error when starting the MySQL services - looked in the logs and it stated that there wasn't enough space available, so like a numpty i deleted the stream_logs.ibd file which was 11gb instead of opening it and clearing it out.

I have since done a fresh install on another server and copied the file back in

but I keep getting these errors

//removed

I can not start mySQL at all - any ideas on a fix for this? the errors for no space available has now gone.

Many thanks in advance, hope I posted in the right right thread.

 

[urgodfather]

You cannot just copy and paste sql files. Seems to be a PEBCAC error.

 

[someiptvdude]

Apologies, that's just what i get when running journalctl and thank you or coming back.

I actually fixed it with a recovery in the my.cnf not sure if it's temporary or not however

I have logged in on a device, i could login to the panel on all devices, not i put username and password in and it kicks me back to login instantly, any ideas?
--edit--
Scratch that mate I fixed it.

I appreciate you coming back to me