Copying (MySQL) Database Without Panel Access.

Mar 7, 2007

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?

View 8 Replies


ADVERTISEMENT

How To Secure Access To MySQL Database

Jan 28, 2008

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.

View 5 Replies View Related

Copying A Database From One Account To Another

Jan 26, 2009

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.

View 9 Replies View Related

Copying A Large Database

Oct 3, 2007

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

View 11 Replies View Related

Plesk 12.x / Linux :: Database Copying Between Subscriptions Missing?

Jun 11, 2015

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.

View 2 Replies View Related

Mysql: Copying To Tmp Table

May 18, 2009

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.

View 3 Replies View Related

Copying Mysql Db In Cpanel

Oct 18, 2009

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.

View 2 Replies View Related

Plesk 12.x / Linux :: No Access To Panel

Jun 21, 2014

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.

View 1 Replies View Related

Get My Database From My Host Without My Control Panel

Oct 31, 2008

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.

View 2 Replies View Related

Plesk 11.x / Windows :: Control Panel Access IIS 7.0 WIN Web Server 2K

Jun 29, 2012

after upgrading to plesk 11 i get this error (Image attached)

so basicaly i cant do nothing..

View 3 Replies View Related

Plesk 11.x / Linux :: Can't Access Panel From Usual Address

Jun 12, 2014

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.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved