A customer would like to move his hosting from another host to me. But the other host does not want to cooperate and give me access to the panel or files. Threw the customer I did get the ftp information, and within the config file I have the database username and password.
How is it possible to copy the database, without having the hosting panel access?
What can I do to secure access to my MySQL database to stop it from getting compromised from hackers?
Is there any way I can restrict access to the MySQL database to my IP only?
The database is for an IPB 2.3.4 forum and the username/password are stored in a conf_global.php file that is CHMODed 0444.
I have a dedicated managed server (with liquidweb) with Cpanel and WHM.
I want to duplicate a database that I have in one account over to another account on the same server.
Usually the way I would do that is to use the Cpanel Backup tool, download the database from the first account and then restore it on the second account.
This time however the database is fairly large and my connection is not very fast, so downloading, and then uploading the database backup would take ages.
I want to copy a 5GB mysql database, but don't want to dump and then import it again since it will take long time.
Alternatively, I am thinking of copying the directory of the database using the CP command.
First, I will close the forums from the control panel.. then I will use this command:
cp -rp /var/lib/mysql/mydatabase /var/lib/mysql/mydatabase_copy
I've been happily copy databases between subscriptions in Plesk 11.5xx for years but having updated to 12 the feature no longer works.
In the copy database screen when the 'local MySQL server' option is selected in the drop down the 'Copy to existing database' radio button is disabled.
My service provider tells me this is a feature change.
mysql: Copying to tmp table, what causes that?
My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.
is there a way to copy mysql from an existing db, and then renaming it to another name?
I would like to copy my current db from a live forum site, and because I got a test forum but I need that test forum to use my current live db...but i want it to use a copy of the live db. The db has to be a different name for the test site. Sorry hard for me to explain.
Is there an easy way to do that? I would do it via cpanel backup and upload but the db is 2gb's gzip....
I can do it via ssh or whm as well.
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]:
General error: 126 Incorrect key file for table '/tmp/#sql_50f_0.MYI'; try to repair it (Pdo.php:234)
After upgrading to v12 i have no access to the plesk panel. The message above is shown.
I have an online store with products and customers in it. My host is telling me my control panel is unaccessible and they are very hard to get in contact with.
I was wondering if there is a way I can obtain my database another way as I am thinking of changing hosts.
after upgrading to plesk 11 i get this error (Image attached)
so basicaly i cant do nothing..
I currently run a fair size forum which is running IPB and the new version recommends mysql 5.6. Therefore I decided to go ahead and get this installed. In the process I managed to mess up all my sites completely like a moron and at one point couldnt access anything running modcgi. Now I have fixed almost all of it
Problem: Problem I have now is that I cannot access the plesk panel no matter what I try. Firstly I could not restart the service as it said that the database was missing, and therefore I have restored the PSA database from a backup. The service now restarts however looks slightly different to how I would usually see the restart:-
Stopping sw-engine-fpm: [ OK ]
Starting sw-engine-fpm: [ OK ]
However I cannot access the panel from the usual address. All I get is "Firefox can't establish a connection to the server at husky-owners.com:8443" . Im at a bit of a loss as to where to go from here.