Copy Sql
Jan 11, 2008How do I copy an entire mysql sql database file via ssh?
Inside /var/lib/mysql the sql are per table, not one single sql. The db is over 300mb in size too.
Using mysql 5/centos 4.6
How do I copy an entire mysql sql database file via ssh?
Inside /var/lib/mysql the sql are per table, not one single sql. The db is over 300mb in size too.
Using mysql 5/centos 4.6
In previous thread we made few manual transfer of our domains.
We also made some automated migration of few domains/sites using Web Host Manager's Copy an account from another server feature.
All the files and other settings were properly transferred from old server to new server, but only the mysql database is not visible on new server. I am unsure if the same got copied to new server.
I have around 40 domains and I'm trying to avoid copying each one over manually. I can't remember what files need to be copied and the best command to do that.
View 7 Replies View RelatedI have wrote a small script which copies file names which has name as *default* from backup to users main folder. It works fine with one folder but doesn't copy files from sub-folders.
it works with all the sub-folders as well?
HTML Code:
#!/bin/bash
for i in $(ls /var/cpanel/users)
do
rsync -vrplogDtH /backup/cpbackup/weekly/$i/homedir/public_html/*default* /home/$i/public_html
chown -R $i.$i /home/$i/public_html/*default*
done
I want to use DD to fully duplicate a HD, however, the HD is 120GB and also have a mount folder that is 2TB. If I use DD, will it also trying to copy that 2TB onto my 2nd HD?
View 3 Replies View RelatedHow do I copy all files and directories recursively to another folder?
I did:
cp --preserve -r /sourcefolder/* /destinationfolder/
However, it missed the dot files
It turns out my 250GB hard drive was no match for my data... I need to upgrade the HD.
I'm currently using ClarkConnect Community Edition.
Is it fine to make a duplicate of an existing hard drive and just plug the new one in?
Is there any further configuring or is it all sweet?
Also, what software do you recommend to make the copy?
I have 2 cpanel servers with root access.
I want to copy all the accounts from 1 server to another.
wasn't sure if this should go into "technical" or "programming" but I figure someone here will instantly be able to tell me...
(details: I'm on a shared host with cpanel and centos 3)
My hosting service techs refuse to update gnu TAR on the server even though it's several years old at 1.13 and has some know bugs that are annoying for complex calls - (basically the techs use any request like this to try to upsell me to dedicated or VPS which I don't need at my low level)
So I'd like to install a "local" copy of the newer gnu 1.14 or 1.15 TAR (which I *think* is possible?) into my account and have it run instead of the shared copy?
Unfortunately this is beyond my knowledge so thanks for any help in the right direction...
I have a large directory which I want to copy to another account on the same server. Its 1 folder which contains 20000+ files and its around 2GB in size.
I used:
Quote:
cp -r /home/useraccount/public_html/foldername /home/useraccount2/public_html
It worked but some of the files didn't transfer correctly,
I have about 1.80GB of flash games and I want to copy this flash games to another server, I only want to copy the flash games not the entire account.
FYI I have shell access on both server.
I was trying to copy packages from one cPanel server to other using Copy function in WHM
accounts were moved easily but packages failed , Tried 4-5 times but still failed.
I would like to copy all MYSQL databases, users, etc.. to another server.
One server is RHEL 4 and the other is RHEL5.
What do I need to copy to insure everything is moved over,
What's the biggest site you've copied using Copy Account function in WHM? I have a site about 5GB, containing a forum with a gallery. The database is ~600MB. Do you think it'll timeout during the copying process?
View 13 Replies View Relatedi have a site at [url]
i tried todo a cPanel move to my server here.
[url]
on the new server above i keep getting the errors below. i just dont know what any of this means. can anyone help?
Warning: fopen(/usr/local/apache/htdocs/online.txt) [function.fopen]: failed to open stream: Permission denied in /home/cometora/public_html/onlineold.php on line 14
Warning: fclose(): supplied argument is not a valid stream resource in /home/cometora/public_html/onlineold.php on line 15
Warning: chmod() [function.chmod]: No such file or directory in /home/cometora/public_html/onlineold.php on line 16
Warning: fopen(/usr/local/apache/htdocs/online.txt) [function.fopen]: failed to open stream: No such file or directory in /home/cometora/public_html/onlineold.php on line 19
Warning: flock(): supplied argument is not a valid stream resource in /home/cometora/public_html/onlineold.php on line 20
Warning: feof(): supplied argument is not a valid stream resource in /home/cometora/public_html/onlineold.php on line 22
Warning: fgets(): supplied argument is not a valid stream resource in /home/cometora/public_html/onlineold.php on line 24
I am trying to copy files from one account to another through SSH, files copy with old account permissions and ownership.
Is this possible when I copy, ownership autometically changed to new account.
I am using CPanel and have root access.
I found that with unix's shell is possible copy all the content of a folder to oneother; I see the manual and found the command cp;
but there are many parameters;
which is that good?
I would like to replicate all that I have inner a folder to oneother;
so at the finish they must to hawe the identically content;
but I see, that some parameters can change symlink etc...
I want one clone exactly .
the originally folder have at inner directory,subdirectory, files htaccess etc..
Is it possible to get [Crone job] that sends a backup copy for single user in the server to another hosting via FTP which has [Domain name/ User /Password] either weekly or 3 times a week
View 10 Replies View RelatedI have tried copy files from Linux server to Windows Server using WinSCP3 and it was so fast.
I am not sure who to copy files as well from Windows to Windows with same speed. I tried to use RDC between the Windows Servers and share one drive. But it wasn't fast as WinSCP3.
I want to my friend's files from /home/admin/dc
to /home/ as I am planning to rebuild kloxo for him, this could kill all the files so, I would like to know the code so tht I could copy few files from the above location to the home directory
to move the httpdocs folders of multiple sites on my plesk server to another server (share on other serv is already mounted so thats not an issue) but their is 31 different domains i need to copy. wondering if anyone knows any way to batch automate a cp process to copy each domains files to a new folder on remote server (this is for backup purposes not live sites so i cant use plesk migration etc
View 3 Replies View RelatedWhat tool is there for me to copy a lots of file from one webhost (FTP site) to another webhost? Like in for migrating to another host.
I'm thinking of a tool where I can specify the FTP access information for both sites, and it would perform the copy without needing to store the files on my local hard disk first.
I seem to be having a problem where periodically the data in one file is getting corrupted. I haven't been able to figure out a pattern to it, so I wanted to run command by crontab that would create a copy of the file each day. To avoid overwriting previous backups the filename of each day's copy would have to be unique like...
cp filename filename-2008-07-03
Is there a way to include this year, this month, and this day variables in a linux command?
I want to config my IIS SMTP server to copy ALL sent mail to another address.
Or, to log in more detail what was sent (I have W3C logging turned on but it doesnt record the mail subject or body).
Basically when a user complains they didnt get an email, I want to be able to look in the log to see (a) the mail was sent and (b) the body/subject of the mail.
I want to copy one file index.html to multipal direcoties (40+ directory)how can i do it .
View 3 Replies View RelatedI'm trying to copy the contents of a column from 1 database to another. I need to do this as the contents in the current database have got messed up after an upgrade.
The DB structure
table forum_msgs
It contains a column called "topic_id".
Basically I need to copy over the topic ID fields from the "old" database into the "current" database into table forum_msg replacing any values that are currently in the column "topic_id"
I tried this but it doesn't seem to work correctly. Any ideas how it should be done?
insert current.forum_msgs
( topic_id
)
select topic_id
from old.forum_msgs
i am Changing Web Host so is there any method to copy my website directly to my new hosting account without the help of my new web host?
View 5 Replies View RelatedWe've had someone starting nobody PERL procs on a box and we can't quite track it down or read the file to see what it is. What he does is to create a folder in /tmp, execute the script from there and delete the folder as soon as it's running (yes, /tmp is mounted noexec, makes no difference). We've managed to discover and block the IP that was doing this, but that's no fix. He hasn't been back since banning the IP...so far.
What we would like to do is see if anyone knows of (or can help create) a script that can watch the /tmp folder and copy newly created directories and thier contents to another dir (also notifying via email would be helpful) in order to see what the heck it's doing, and hopefully be able to figure out how it's getting in. Nothing in any logs this time, and the PERL process seems to be able to hide itself from PS. That bit worries me quite a lot, but none of the binaries appear to have been changed, and it doesn't appear we've been rooted in any way.
Thoughts on this, ideas and suggestions welcome.
Failing that, is it possible without breaking the box to prevent the creation of new directories in /tmp? This I seriously doubt, but if all they need to do is create a folder and work from there, noexec is a joke.
to get a copy of their entire site onto our servers.
The problem is that they have no backups, and their current host has denied them access to their account. (It's a long story.)
Rather then try and fight with their old host, I wonder if it's easier to just run some kind of "website copy" program and grab a copy of all pages and images, linked files, etc..
Their current website pages are served using an ASP database application, but the copy they need only has to work. It doesn't need to be dynamic, etc... as long as all the pages are there it's good.
I've a backup on another server and wish to copy that database onto the new server.
Is there any easy way of doing so?
I can only access the VPS (backup) via it's IP and SSH is working fine. PhpMyAdmin on the server is playing up, as well as a lot of other php-mysql applications.