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
ADVERTISEMENT
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
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
View Related
Nov 21, 2008
I get error while copying accounts from Plesk to Cpanel and hence the emails are not copied though the data is copied. The error goes like this
pXa Copying Mail files....ERROR 1064 at line 1: You have an error in your SQL syntax near 'SELECT cl_id FROM domains WHERE id = 1018 )' at line 1
I am running Plesk 8.01 and the latest stable release of Cpanel. Is it because of the Plesk version I have? If yes, then what should be the Plesk version?
View 2 Replies
View Related
May 20, 2009
There is a directory with many files and subdirectories. I want to copy ALL the filesnames beginning with post-1111 to another folder. What is the command to do this?
View 5 Replies
View Related
Jul 6, 2007
I am having a hosting account with old host which is limited to 10 GB, and there i am having a mysql Database which is of 2 GB, i want to move it to new host via SSH ... as that Database can not be downloaded via phpmyadmin due to its size.
So i want to "tar" the mysql directory and ssh/scp to new host!...
I am applying this command...
tar -cvf r.tar /var/lib/mysql/in_supp | ssh user@newhost.com
But i am getting errors,
Please give me a command which can move my entire Database dump to new server, without creating any copy at old server "as i do not have any space there"
View 14 Replies
View Related
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
Apr 5, 2008
to execute the following command into a Solaris 5.11 system.
cp -al ......
The problem is that either -a or -l works on Solaris.
Man pages are not installed and all I can get is:
Usage: cp [-f] [-i] [-p] [-@] f1 f2
cp [-f] [-i] [-p] [-@] f1 ... fn d1
cp -r|-R [-H|-L|-P] [-f] [-i] [-p] [-@] d1 ... dn-1 dn
What I want to achieve is link files instead of copying and also keep permissions on files.
View 1 Replies
View Related
May 1, 2008
Did anyone ever had an issue, when you click fetch accounts list and it displays 0 packages and 0 accounts? Even if there are hundreds of accounts in server.
cPanel 11.18.5-R23897
Could this be cPanel bug?
View 2 Replies
View Related
Jan 30, 2007
I am trying to copy one account from another server through the option "Copy an account from another server with password" in WHM but after filling server ip, username and password it starts trasnfering and showing me dosts like below :-
............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ............... ...............
After few lines its just stoped working,
View 14 Replies
View Related
Nov 8, 2007
We seem to be doing a lot of this lately with clients upgrading to larger hard drives, etc.
I'm curious as to what works best for most folks that do have physical access to their servers when copying drives in servers, like when upgrading to larger hard drives or replacing a hard drive.
I know there are "hardware" drive copiers, but what about software methods?
Especially when upgrading both hard drives in a dual hard drive server.
View 5 Replies
View Related
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
Apr 23, 2008
a way to preserve folder/file permissions in a windows environment. We are copying files from one drive to another on one of our servers. It's crucial to preserve the permissions - but i've done some research and can't find any way to get this done...
Anybody familiar with any methods on how to approach this? We're running windows 2003 server.
View 2 Replies
View Related
Sep 25, 2007
I've been searching for the best way to copy a file, say .htaccess, to multiple users dir, tried "cp -f .htaccess /home/*/public_html" but received an error "omitting dir /home...."
View 3 Replies
View Related
May 6, 2014
I am trying to write a PHP script for copying the content of one subdomain to another, like with the button Website Copying but automatically.
I can't seem to find the API model for that, but I am sure it must be possible to do.
View 3 Replies
View Related
Jul 8, 2009
I recently bought a VPS and set up everything for it manually (apache, php, mysql). I had an old host which I got my files and MySQL database from. I have successfully copied them all over and imported the .sql file. I have also checked my config options and updated them to the new settings.
However, when I go to my site, I just get a blank, white screen. The site is fine because a test file that doesn't use my phpBB installation from before renders properly as well as the index.php file from the ./install/ directory of phpBB. If it was a connection problem with MySQL, I would assume that it would print some sort of error stating that it can't connect.
Here are some steps that I've tried so far (I would use a list here but I supposedly need five posts):
* chmod 777 on my entire /var/www/html/ directory.
* chown /var/www/html/ to the apache user, which is the one running the apache webserver.
* Checking error logs and not finding anything that seemed catastrophic (i.e. just notifications about a favicon being missing).
* Editing the .htaccess file to be empty.
At this point, I don't know what to do. I am willing to reinstall phpBB properly, although I would really rather not, and I imagine that there's some way to salvage my previous installation. If you're wondering why I'm posting here instead of the phpBB forums, it's because I have a hunch that it's more likely related to my installing MySQL, Apache and PHP.
My site is apollorp (dot) org (I would link here but I need five posts). As a test, try going to apollorp (dot) org (slash) test (dot) php, which should work.
View 0 Replies
View Related
Jun 4, 2014
I want to be able to copy 1000's of files from one subscription to another or rather from one domain to another on the server without having to FTP them each time. Is there a way which this can be done directly in Plesk and avoid the need to ftp the same 1000's of files into each subscription ? FTPing on my connection is really slow and takes 2-3 for each subscription / domain, whereas if I could just FTP to the server once and then copy&paste the files between subscriptions then this would save me a huge amount of time...
View 2 Replies
View Related
Aug 9, 2014
I'm having a problem when copying folders into another folder using the same name.e.g. there's a folder called css in httpdocs/backup/css and also httpdocs/css. However, I'm trying to restore the backup and actually copy the /css dir from httpdocs/backup to httpdocs. Plesk should overwrite the existing target css dir (and its content/files) in httpdocs/css. However, Plesk creates a new css dir inside httpdocs/css so I have the "original" httpdocs/css dir content intact and also the css dir (from httpdocs/backup/css) copied into httpdocs/css so the full path is httpdocs/css/css
I'm highlighting the httpdocs (not /css dir) in the File manager - Copy Files window. I've tried that on a few installs and experiencing issue on each of them. Please see the attached screenshots.
Step 1. Select (check) the css dir and click copy (or move, result is the same)
Step 2. Mark the httpdocs dir (it doesn't matter if you click the Replace existing files checkbox)
Step 3. Final result, css dir from httpdocs/backup copied into httpdocs/css/
I've compared the dir content several times and definitely the css dir from httpdocs/backup is copied to httpdocs/css so the full path would be: http docs/css/css and the original "old" files from css will remain there.
View 1 Replies
View Related
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
Jul 12, 2009
I've noticed I've been getting a lot of "Copying to tmp table" and from a google search this is bad. Any idea on how I can fix this in my shared hosting environment?
Running MySQL 5.0.81 on CPanel.
View 2 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Mar 14, 2007
I have 2 servers both have cpanel. I want to use 2nd server's mysql in my site which is on 1st server. I think thats not that hard. I don't wanna do clustering as this is temproary.
View 2 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Aug 13, 2007
I accidentally clicked upgrade to 5.0 from 4.1 in Cpanel.
Then I ran the update to latest version.
EVERYTHING BROKE!
Sites can't connect to mysql anymore, and also during the update, I'm getting:
Code:
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@74.200.65.162......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
...skipping 74.200.65.162...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@75.126.236.226......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
...skipping 75.126.236.226...Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
Download Failed... trying again...in....60....59....58....57....56....55....54....53....52....51....50....49....48....47....46....45....44....43....42....41....40....39....38....37....36....35....34....33....32....31....30....29....28....27....26....25....24....23....22....21....20....19....18....17....16....15....14....13....12....11....10....9....8....7....6....5....4....3....2....1..Fetching http://httpupdate.cpanel.net/cpanelsync/RELEASE/cgi-sys/formmail.cgi (0)....@69.90.250.34......connected......receiving...1%...2%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%...32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...60%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
md5sum mismatch (actual: 1f32cbcf13cce797cdc2a5c9553b5c35) (expected: 5a4c0dd1d71417a6d07452bb47d1259e)
View 6 Replies
View Related
Jul 18, 2009
i am running a VPS and recently installed cPanel DNS Only so it can operate as a standalone DNS server.
I would also like to serve standard webpages on it via apache and php, i therefore tired to install php, mysql etc via 'yum install php' but it says there is no package to be installed.
Has the cPanel DNS only install done someting to the yum config? I have installed Yum Priorities plugin, and my repos files are as follows:
Code:
root@stripe [~]# yum list installed | grep httpd
httpd.i386 2.2.3-22.el5.centos.1 installed
root@stripe [~]# yum list installed | grep php*
root@stripe [~]# cat /etc/yum.repos.d/CentOS-Base.repo
# CentOS-Base.repo
#
# This file uses a new mirrorlist system developed by Lance Davis for CentOS.
# The mirror system uses the connecting IP address of the client and the
# update status of each mirror to pick mirrors that are updated to and
# geographically close to the client. You should use this for CentOS updates
# unless you are manually picking other mirrors.
#
# If the mirrorlist= does not work for you, as a fall back you can try the
# remarked out baseurl= line instead.
#
#
[base]
name=CentOS-$releasever - Base
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1
#released updates
[updates]
name=CentOS-$releasever - Updates
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1
#packages used/produced in the build but not released
[addons]
name=CentOS-$releasever - Addons
mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=addons
#baseurl=http://mirror.centos.org/centos/$releasever/addons/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-5
priority=1
View 3 Replies
View Related
Apr 14, 2009
The automatic backups you can setup in cpanel/whm bundle the entire user account. Is it possible for it to save everything except the mysql databases?
I have an account that has databases over 5GB+ and would like to handle backing those up separately.
View 6 Replies
View Related
Dec 11, 2008
A few weeks ago I installed clamav using the cPanel "Manage Plug-Ins". It all seemed fine but my server load kept going ridiculously high. I couldn't work out what was wrong until I managed to get a ps aux when it was very high and found that clamd was using ridiculous amounts of memory/cpu. It's not such a big deal having it on my server, so I decide to uninstall it. After uninstalling it, MySQL started to randomly turn off regularly (around every 30 minutes). I tried forcing a cPanel update, updating the MySQL files, reinstalling MySQL, etc. but nothing has seemed to fix it. So as a last resort, I've reinstalled Clamav and now my MySQL is fine but my server load keeps going ridiculously high again; causing problems still.
Has anyone/cPanel ever experienced this problem? I need to find a solution as almost every account on my server uses MySQL as a basis for their website, so I can't have it going down even for less than a minute.
View 2 Replies
View Related
