0
votes
1answer
160 views

I moved my (wordpress) site to a new server. Why adminer cannot login to MySQL?

I just moved my wordpress site to another vps. Everything worked fine and i used sequel pro to connect to database (via ssh) and import my data. The strange thing is that i tried to connect to MySQL ...
-5
votes
1answer
45 views

Process still running from a deleted chroot? [closed]

so I come to you with a somewhat interesting problem. I had a chroot running that had an entire lamp server installed and running on it. I tried to purge and remove the lamp server but messed up ...
1
vote
1answer
2k views

Mysql PID Error, Locking Database

I changed my.cnf file to add some parameters in it but after restarting the service it failed to start giving locking error. i removed locks using rm command and again trying to restart but it not ...
4
votes
3answers
80 views

Dump MYSQL databases to induvidual files

Has anyone got a one liner (command line) that will dump all databases to seperate dump files e.g. forumdb.dump wikidb.dump etc.
0
votes
1answer
77 views

Web Server sercurity (used only for web services)

I am using a Virtual Private Server for accessing Web-Services used only on the Mobile devices, there are many entries in the access and error log, even there is nothing on the web server. I am ...
0
votes
2answers
49 views

MySQL: account/db creation for users I am hosting, advice?

I've a VPS and am hosting a few peoples websites, namely people who I will have a lot of contact with although would like to provide what I can without being there to do it. I have written a script ...
0
votes
3answers
109 views

Can i transfer one MySQL database without stoping MySQL server?

I have some MySQL databases,for example: CREATE DATABASE MyDB1; CREATE DATABASE MyDB2; CREATE DATABASE MyDB3; CREATE DATABASE MyDB4; each one is databased used by another client. MyDB1 started to ...
0
votes
1answer
114 views

Best way to administrate web-app? [closed]

i'm looking for the best and safest way to administrate my mysql-databases etc. on my server. any advice on this? thanks
0
votes
1answer
1k views

How to recover a MySQL InnoDB table?

When I try to launch the Plesk administration page of you server I get the following error: ERROR: PleskMainDBException MySQL query failed: MySQL server has gone away The MySQL Server is working ...
0
votes
1answer
303 views

MySQL: Creating a database without root privileges

I want to have a MySQL user that will only able to create a new user+database(+password) combinations - without being the mysql root user for obvious security concerns. My idea is to have a secure ...