What Is The Best Procedure To Move MySQL Data From One Disk To Another?
Jul 12, 2007
I have two hard disks, and I would like to move all of my MySQL data onto the second drive. My dilema is this; what is the best way to go about doing this? The tutorial I followed last night had me use cp to copy the /var/lib/mysql folder over to the second drive. However, it took ages to move one of my databases. It's a forum hosting database which has tons and tons of tables. It ran for about 5 hours and still didn't finish because I decided to stop it right there. I know it was working; but still, it took forever and I had to put it back up.
What would you do? Do you recommend say, copying just the 'mysql' database that has the users, and then taking a dump of all databases with mysqldump and moving it that way?
Also, is there any way using the cp command to continue what I started last night, but not write a database file if it hasn't chnaged at all?
View 8 Replies
ADVERTISEMENT
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
Jul 20, 2008
Do any1 have procedure to move cpanel data into plesk. I like to give plesk a try since there are so many clients requesting windows hosting.
View 5 Replies
View Related
Jul 27, 2007
way to move data from one server to another? I have root access to both my servers, but I'm not sure how I would move one entire domain without having to FTP it. The databases I can do manually by importing a dump to the new server. I'm just wondering about the files itself.
View 3 Replies
View Related
Jan 6, 2008
Has anyone pulled off a mass server move during the middle of the night? We have decided 350 E Cermak is where we want to be but are still working out the details of where we want to be in the building.
While the final details are being finished, I need to come up with some kind of plan to pull the move off with the least amount of downtime. Our current dc is about 4 miles away from 350 Cermak and we have approximately 50 servers to move. I plan on leaving a linux box around to redirect any traffic that is ignoring TTLs.
I was thinking the best thing to do would be label and remove all harddrives, then see if a moving company could put the servers on palettes, wrap them, and move them to 350 E Cermak. Not sure if a moving company would work in the middle of the night or not.
Courier services are pretty much out. Anytime we have had a courier service move anything not in a massive box with padding, it gets bent or broken.
View 14 Replies
View Related
Jul 28, 2008
After long time consideration, selected linux eventually from singlehop, good company, good service.
Now we got big problem. Since our forum has 60GB data, I have no idea how to move files over.
If it was another windows server, I would just install a flashget (or similar download software) and put all HTTP links into it and just go to bed.
The data has been ZIPed into dozens of files, 1-3 GB each. HTTP link are ready for downloading, like
www.abc.com/files01.zip
www.abc.com/files02.zip
........
www.abc.com/files50.zip
I was wondering what's the best way to move data. Can we install a programme and put those links into it and download into my server? Thank you for your suggestion.
I tried wget, seems not working, speed drops to 0 after 10 secs, don't know what reason.
View 5 Replies
View Related
Apr 4, 2007
I'm not sure I really understand the ins and outs of upgrading MySQL and I'm afraid to mess it up. From the MySQL site I see there's a 4.1.22 RPM available [url] and I'm running 4.0.18 (Your MySQL connection id is 2763253 to server version: 4.0.18-Max-log)
I'm not sure I want to bump it up all the way to 5, but I would like to run 4.1, but I also would like to stick with the RPMS, even after reading whatever I can find, I'm still not sure I understand what RPMs to install, here's what I have currently.
Code:
>> rpm -qa | grep -i mysql
php-mysql-4.3.11-1.1.rhel3.ct
MySQL-shared-compat-4.0.18-0
MySQL-Max-4.0.18-0
libdbi-dbd-mysql-0.6.5-5
MySQL-server-4.0.18-0
perl-DBD-MySQL-2.1021-4.EL3
MySQL-python-0.9.1-6
MySQL-client-4.0.18-0
MySQL-devel-4.0.18-0
There doesn't seem to be anything newer on the up2date server I use:
Code:
>>up2date --showall | grep -i mysql
MySQL-python-0.9.1-6.i386
libdbi-dbd-mysql-0.6.5-5.i386
mod_auth_mysql-20030510-2.ent.i386
mysql-3.23.58-16.RHEL3.1.i386
mysql-bench-3.23.58-16.RHEL3.1.i386
mysql-devel-3.23.58-16.RHEL3.1.i386
mysql-server-3.23.58-16.RHEL3.1.i386
perl-DBD-MySQL-2.1021-4.EL3.i386
php-mysql-4.3.2-39.ent.i386
qt-MySQL-3.1.2-14.RHEL3.i386
View 5 Replies
View Related
Nov 14, 2013
I want to move the data directory to another partition on all nodes. Apache (vhost), IIS (vhost), MySQL (databases) and Postfix (mailbox content). What's the correct way to do this without breaking functionality of PPA?
View 5 Replies
View Related
Mar 11, 2008
I've got a problem with one of my servers, and i dont now how to do it. I need to find a technical service that I could hire for a job.
It's a small job. I've got one server that was compromised by D.O.S. atack and taken down by hosting company they did a clean instal fedora and cpanel and said that the data would be mounted on a old drive I need to restore the webs about 30 small sites
Would anyone suggest a person that could do that?
View 2 Replies
View Related
Dec 26, 2007
My server (Fedora Core V and Plesk 8) hard disk broke 2 days ago and my bakckup tar.gz is too old.
Datacenter (fdcservers.net) tried to put old harddisk as slave but server is not recognising the old drive. Datacenter say that can not do anything more.
My question:
Is there any software or company that can recovery my harddisk data?
My last 6 months work is gone now.
View 5 Replies
View Related
Apr 21, 2008
Is it possible to move my mysql database to another server?
View 9 Replies
View Related
May 24, 2007
how can i move mysql db from remote server ? (via SSH or most pratical way)
suppose that...
source server
domain : google.com
host : localhost
user : zode
pass : 123
db : source
destination server
domain : yahoo.com
host : localhost
user : hala
pass : 456
db: target
View 2 Replies
View Related
Jun 20, 2008
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now.
After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process
I am moving from a VPS to a dedicated server - both have root access.
View 11 Replies
View Related
Jul 31, 2013
My windows server's hard disk was crashed & now I have mounted it as secondary hard disk on the server .
Now I want to restore the data to new server .
View 6 Replies
View Related
Mar 21, 2008
After 2 years of application hosting on ixwebhosting.com i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.
Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.
I now need to sireously move to a VPS / Dedicated server
or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.
The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.
I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.
Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.
I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.
I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:
1. inmotionhosting VPS.
2. rackforce.com DDS.
3. Iweb.com
Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.
looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.
View 16 Replies
View Related
Oct 2, 2007
how to do this in myphpadmin
also got cpanel if it helps.
View 5 Replies
View Related
May 29, 2007
Today I check my server
the WHM not calculated the MySQL dtabases size from the account quote.
for example , let see this account
Disk Space Usage 95.92 Megabytes
MySQL Disk Space 69.77 Megabytes
Disk space available 4.08 Megabytes
While this account have max of 100MB
so this account not have about 164MB a total mysql ana disk space , so how to fix this problem?
View 1 Replies
View Related