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?
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.
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.
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.
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?
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?
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.
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:
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.