to transfer a MySQL database with way over 1 million rows to a different server.
What is the best way to do this without losing any data? I've tried using the export feature in phpMyAdmin but it doesn't seem to handle it very well.
There has to be a feature in WHM or cPanel,
In reference to my previous post, i want to tranfer accross 7GB of data, approximatly 80,000 files i believe it is (due to a gallery script).
It's currently on another host (on a webhosting account) which uses their own control panel which has no options but to manage databases, the only way i can see to do this is via FTP but it'll take me days. I've tried using compressing and backup scripts, but the damn execution time on the hosts server is too low to allow the files to be zipped. Are there any ways? Can i login to my VPS via SSH and anyhow pull off the files from the other hosts server?
I have a situation here.
I wanted to transfer a file (about 10GB) from one server to another server. Both server are on the same LAN.
Inside server1, I zipped a folder as file.tar.gz
From server2, I uses wget http://server1.com/file.tar.gz and it says "404 Not Found"
I suspect it won't allow me to download because the file is too big.
I have a debian box, and have archived a gallery in to a .tar file, 5.77gb.
I have a centOS box, and have used wget to bring the data file over to the new server.
However upon doing so it only detects it as 1.8gb when it starts downloading.
I have terminal access to both servers, just trying to bring my files over from one server to another.
Compared to others my sites may not be that big but I have one site that is 5 gigs and another that is about 9 gigs. I was wonder what is the best or most recommend way to transfer these sites to a new host.
I tried downloading the whole site using FireFtp but always seem to get about 3rd of the way done and something messes up the conection. Are there any better tools or methods to do this.
I also have pretty large Dbs that I'll need to transfer as well.
Knowing Qoodaa was quite by chance.
A few days ago, my friends studying in America recommended me a new popular transfer toolQoodaa. And he told me that it was a quite good software to download files and movies. At first,I was skeptical, but after using it, I found its a good choice to choose Qoodaa. And I have summarized the some features of Qoodaa:
1.Its speed is faster than any other softwares I used before to upload movies.
2.It can download files quickly through downloading links, in a word, it is time-saver and with high efficiency.
3.No limit of space.No matter where you are, it can download fast.
4. Qoodaa is a green software with high security and easy use.
It really can give you unexpected surprise.
I am a person who would like to share with others, and if you have sth good pls share with me
Recently I changed server providers, so now I'm looking for a way to transfer all the data to my new server. I have a total of 420GBs of files in my secondary HDD that need to be transferred.
The old server is at a 10Mbps line, the new one is at a 100Mbps one. From old server, less than half the pipe is being actively used. So theoretically, I should be able to transfer it all in about a week.
I tried
1) SCP. That was waaay too unreliable. And I couldn't get it to restart from the point left on whenever the transfer stopped (like when the servers were restarted).
2) Transfer using a web script. Way too slow, got to about 35GBs, total would take like 2 months.
Is there any other, reliable way of transferring data from server to server?
I'am looking for a dedicated server located in USA and Canada (one in US and one in Canada) with unlimited or large (5-10TB) bandwidth on 100mbit port ....
View 11 Replies View RelatedI run a large adult vBulletin community with 70,000 members, 1/2 million posts, 186,000 attachments (a lot video), and closing in on 100 million downloads since our start some odd years ago. I've been battling keeping the site up for quite some time, and I am starting to wonder whether we shot too low on the server setup. I figure I would ask the pros here at WHT for some advice.
This is our current setup:
Site server:
Quote:
CPU: Intel(R) Core(TM)2 Duo CPU E4500 @ 2.20GHz
4 Gig ram
250 Gig sata harddrive
Unix FreeBSD 6.2
Apache
MySQL server:
Quote:
CPU: Pentium III/Pentium III Xeon/Celeron (2666.62-MHz 686-class CPU)
Cores per package: 4
4 Gig ram
750 Gig SATA harddrive
Unix FreeBSD 6.4
Apache
Do you think the site would perform better under one server and maybe a more powerful processor? What should I be looking at exactly as far as hardware goes for this type of site. I should note we push about 2.5TB of bandwidth monthly.
server for send large number of emails per day?
What would be the best solution for that?
VPS ? Dedicated ? and Do I need to have Cpanel too?
I have found SL can offer you 12*1 TB drive based systems, after RAID-5 and Win 2003 install you get just over 10 TB of storage. The monthly price works out to $1000/Month.
I know some time ago LeaseWeb offered these type of storages....any one else know of any others ?
Amazon S3 works out to about $1500 for 10 TB
for months my server has been running fine, since about a week ago the server crashed and was up and down
the fault was found to be faulty ram which has been replaced.
now I have had every tom, dick & harry take a look at the server to get it stable again but im still having issues.
The server seems to run fine but crashes when I try and repair or backup my database.
the database is large like 30gig but the server used to do this fine before but it wont now, it get so far then hangs.
Server:
Dual Core Xeon
4GB Ram
2x 250GB HDD
Raid 1
on optimizing mysql
My server specs:
Quote:
Server: Quad Processor Quad Core Opteron 8344 - 1.80GHz - 16 x 512KB cache
Ram: 8 GB DDR2 Registered 667
Disk Controller: SA-SCSI RAID 1 Disk Controller
First Hard Drive: 147GB SA-SCSI 10K RPM
Second Hard Drive: 147GB SA-SCSI 10K RPM
my.conf file:
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
max_connect_errors=10
thread_concurrency=16
"/etc/my.cnf" 57L, 893C
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_user_connections=25
max_connections=500
interactive_timeout=10
wait_timeout=10
connect_timeout=10
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
max_connect_errors=10
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1
#[mysql.server]
#user=mysql
#basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
#[mysqldump]
#quick
#max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M
[mysqlhotcopy]
interactive-timeout
is this good enough or we could fine tunning it more?
my main client wants to rehash his database. Now this is a 1.5m strong list. All legitimately collected with time/IP stamp, privacy policy, etc. These clients are from the online gambling industry (legally licensed).
The problem is many of these users subscribed to our services up to 4 years ago (not all are that old, but some are), and they haven't heard from us for up to 2 years (again, some heard from us more recently).
Anyway, I've never deal with that number of emails and potential bounces. Obviously, the first round of emailing will have a large number of bounces, but that will quickly subside.
So, can you guys point me to a quality dedicated server, with at least 4 IPs (hopefully 10) and that can handle this type of activy? I'll be glad to sign up under an affiliate link if I can get a good answer.
My company is going to launch four online retail site and in need for a dedicated server service provider that can provide us with room to grow from minimal traffic to possibly 2-5k traffic an hour.
View 14 Replies View RelatedWe had some issues with old server hence we migrated some websites to another new server from our old server.
We did a backup of all existing webfiles and database from old server and transferred the same to new server, a manual transfer few weeks ago.
However, we were not able to backup our awstats logs for this domains, can someone guide how to transfer awstats from old server to new server?
We cannot perform an automated transfer from old server to new server now, is there some way we can migrate our awstats from old server to new server for this domains?
I have a vps (CPANEL)... I would like to have incoming emails for a certain cpanel account transfer to another external server (after coming thru the VPS).
I store my emails on the external server and have more space there.
The reason behind this is:
I have spamassassin on my VPS and would like to run email thru that before it delivers on the external server. I do not have the capability to install spamassassin on the external server.
Is the above possible? How can I accomplish this?
I changed servers. It's been three days since we swapped DNS, and I have a slew of people that still can't access anything.
The thing is, the old server should have been set up to forward everyone to the new server, and it wasn't initially. This was done by the admin company by changing the "localhost" setting on the old config file for the mysql database to the new server's IP address.
So, I have people, a LOT of people, who have been unable to reach anything for the last three days. Neither old server nor new server. Nothing, zip, nada.
Yesterday, the admin company said that they had found something wrong with port 80, and had changed the settings, and we began to see some traffic, FINALLY. I though maybe we were fixed, but this morning, I still have a crapload of emails from people who can't reach anything.
This was a cPanel to cPanel swap, in the same datacenter, on the same vlan.
We're working on Day 4 here, and everyone seems to be guessing, and In get the sense that if I don't stay proactive, nothing will be resolved.
Thing is, I know just enough about this stuff to be dangerous, which is why I pay professional server admins.
I have read some in this forum and the sites I saw linked to others seemed ok but none I've seen really gave me options on more bandwidth.
I figured I would just post what I need and my budget and see if anyone could help me out or point me in the right direction and it be a site I havn't seen before.
I am currently with another dedicated provider that I will not name but I messed up something simple (I know what it is) while trying to add an ip to the box. I submitted a ticket Friday morning at 4am EST time explaing exactly what I need done, and how to do it just so they don't have to even research it. Needless to say the ticket was not even TOUCHED all day today (Friday) and now I am told it will not be looked at until Monday. This means I am without a server for the weekend unless I want to pay a good chunk for "emergency support". I personally find this absurd and think something simple should be a phone call away.
I typed all of this out to explain why I am looking for a new server.
I need a decent (but not hard core) processor, preferably not celeron or sempron.
Atleast 1 gig of ram and 100-200 gig or so HD. The biggest thing I need is transfer, I honestly do not care if its a 10 or 100Mbps port. I need atleast 3 to 4 TB (4000 GB) of transfer.
My price range is 100-150 USD a month.
I just signed up with a new host. How long should I expect it to transfer sites through WHM? I know it depends on the size of the sites but how long does the average 100M site?
View 6 Replies View RelatedI have to move 140 domains from my old cpanel dedicated server to the new one and have root access on both.
Earlier I wanted to avoid copying unnecessary files and was thinking of creating fresh domains/emails on new server and transfering content, but then realised that it will need more than 160 hours of manual labour (including informing clients that their passwords have changed).
Please advice as to which transfer method will be best based on the following constraints:
1. 70 domains will be done one week and remaining 70 next week while both servers continue to run.
2. On the new server all domains will have different nameservers.
METHOD 1. Putting same version of WHM-stable on both servers and using its "Copy an account from old server" feature. After copying the 70 accounts (one-by-one seems to cause less issues with large sites) we change nameservers for those 70 domains over the weekend.
METHOD 2: For every account on old server use "Generate a full cp backup" and let cPanel FTP it to a dummy account on the new server. Restore on new server and change nameservers for those 70 domains over the weekend.
METHOD 3: Run "/scripts/pkgacct username" on old server, move the tar.gz file to new new server. Restore on new server and change nameservers for those 70 domains over the weekend.
METHOD 4: Reduce TTL for A records on old server. Use WHM "Copy an account" on new server. Then modify DNS on old server to point to new server IPs. Now change nameservers at Registrar.
METHOD 5: Asking my datacenter people to use rsync etc. But this will move all data together,
how to transfer folder contains backups from my server to another one coz i have to relod the system .
i have another space on another server.
is there any soft for windows who can transfer files from one server to another? I have Shell access on both servers but dont know how to do that via shell..is there any GUI soft for windows where I can on one window see files from one server and on other to see files from second server?
View 3 Replies View RelatedI have a dedicted server (Windows) i am not satisfy with the current company
In these days i decided to move to another company but the new company (liquidweb) reject to transfer the accounts from old server to the new one
I don't have much experince in windows server so any body can guide me to any company doing that for me? or any body can help me with best way to do that i will appreciate
1-current company using Plesk Version 7.6 and the New company using Version 8.1
2- I have about 40 accounts in my server
Are there any good software that will backup current server files and restore them on a new server?
I'm looking for full backup, that would backup all the files in less time instead of going to each account's cpanel first and downloading backup than restoring it to new server.
I am moving a site from one provider to another. My client wants to keep the existing webalizer stats after the transfer. Could anybody help with how to do the transfer and to make webalizer continue working on the new server?
View 5 Replies View RelatedCould I Transfer Gzipped Files From 1 Server to Another?
I'm in the process of changing servers, and I was wondering if there was some sort of command where I Could transfer my backups to the new server?
One of my Cpanel servers is showing heavy data transfer this month. In 6 days, it crossed 600 GB data transfer which is equal to what it did last month. Also, all the websites collectively have only consumed around 60 GB data transfer in 6 days. How do I find out what exactly is causing heavy data transfer?
View 14 Replies View RelatedI have 2 servers connected privately..
The servers have a public and private ip.
For transfer privately bandwidth is not counted.
I wanted to know how to transfer data between 2 private servers?
Also is it possible to have symlink from one server to another (both servers connected privately also).
I am having a linux and a window servers, I want to move my
domain from Linux to windows server.
I can transfer the public_html folder to "wwwroot".
can any one tell me that how to transfer the data base from linux
to windows server?
how i transfer 20 website to another server with reseller password?
i use cpanel and whm