MySQL Forums
Forum List  »  Backup

Moving dbs to new server
Posted by: ed ziffel
Date: March 31, 2012 05:25PM

Am moving a very large db, as in the mysqldump was 193gb when I dumped the db as a whole, to a new server. Did not know at the time that the indexes that were in the tables would have to be rebuilt as the tables were created. Some tables (myisam) have over 150mg records, 47 columns and upto 5 indexes. The orginal time to create the indexes was over three hours per table on some of the tables.

The OS supporting the new server and all other software on the new server is the same as the old system to include the server version, OS version etc. Suspect hardware not an issue but don't know for sure.

Question: Is there a problem if you just more or less cut and paste/copy the existing files from the data directory on the old server into the data directory on the new machine? What restrictions apply to doing something like this.



Options: ReplyQuote

Written By
Moving dbs to new server
March 31, 2012 05:25PM
April 01, 2012 11:32PM
April 02, 2012 08:32AM
April 03, 2012 09:15AM
April 03, 2012 12:17PM
April 04, 2012 09:00AM
April 05, 2012 02:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.