25.02.2015, 18:55
Hi guys,
I'm facing some problems with my VPS and would need someone who knows about linux (debian) and mysql...
I'll describe my problem here roughly and if you know a solution it would be nice if you helped me on this..
If this is the wrong section, it would be nice if a mod would move the topic, this one seemed most suitable in my eyes...
I'm having a VPS with Debian on it, running a website and a samp server with a mysql DB.
This morning I couldn't connect to the website anymore, neither could I login into my main account for the website via putty.
After I fixed some bad paths in the user specifications, the website and stuff worked again, although my mysql db didn't. I could not start the mysql server as it returned that there wasn't enough free space...
So I moved my databases from the default location on my vps to another one with more free space. I then adjusted the new paths in the my.conf file.
All DBs are in the new folder and showing the same file size as in the original folder. The website (smf forum) worked without any problems after that movement, all posts and settings were as they should be, although my server's DB was completely empty.
The database itself is showing on phpmyadmin, although it doesn not include any tables. I have failed to save any backup before (yea, quite stupid, I know) and now everything is lost.
I wanted to recreate the tables with, although when trying to create a table called "vehicles" it returned
Trying to create a table that was not existing before works, although I can not create any of the old tables that actually should already be in there... Therefor I suppose that the tables might still be in the database, but having some issue being loaded or whatsoever.. I am not that familar with linux and/or the theory behind that mysql stuff.
It would be great if any of you have had this before, or knows how to solve this....
I'm facing some problems with my VPS and would need someone who knows about linux (debian) and mysql...
I'll describe my problem here roughly and if you know a solution it would be nice if you helped me on this..
If this is the wrong section, it would be nice if a mod would move the topic, this one seemed most suitable in my eyes...
I'm having a VPS with Debian on it, running a website and a samp server with a mysql DB.
This morning I couldn't connect to the website anymore, neither could I login into my main account for the website via putty.
After I fixed some bad paths in the user specifications, the website and stuff worked again, although my mysql db didn't. I could not start the mysql server as it returned that there wasn't enough free space...
So I moved my databases from the default location on my vps to another one with more free space. I then adjusted the new paths in the my.conf file.
All DBs are in the new folder and showing the same file size as in the original folder. The website (smf forum) worked without any problems after that movement, all posts and settings were as they should be, although my server's DB was completely empty.
The database itself is showing on phpmyadmin, although it doesn not include any tables. I have failed to save any backup before (yea, quite stupid, I know) and now everything is lost.
I wanted to recreate the tables with, although when trying to create a table called "vehicles" it returned
Код:
#1146 - Table 'sapr.vehicles' doesn't exist
It would be great if any of you have had this before, or knows how to solve this....