MySQL Performance: MySQL => New server setup

Members

Help

Home

Home » Performance » MySQL » New server setup

Show: Today's Messages :: Show Polls :: Message Navigator

New server setup [message #3236]

Wed, 02 July 2008 00:20

ramakrishna
Messages: 4
Registered: July 2008
Location: Fremont

Junior Member

I have 8 gig of innodb database running on redhat 5 machine i want copy mysql directory to another machine and start new server is it possible? Can any one tell exact plan.Thanks in advance.

Report message to a moderator

Re: New server setup [message #3237 is a reply to message #3236 ]

Wed, 02 July 2008 02:58

larvus
Messages: 5
Registered: June 2008
Location: india

Junior Member

find out ur mysql directory

mostly this be the dir /var/lib/mysql

all mysql datbase and tables are reside here . just stop the service and tar zip the directory structure.

# cd /var/lib/mysql

#tar -zcf /root/Desktop/mysqlold.tar.gz *

copy tar file form desktop to the new server's data directory and unzip / untar it.

if u want to copy a single database just use # mysqldump

By Larvus

Larvus

Report message to a moderator

Re: New server setup [message #3242 is a reply to message #3237 ]

Wed, 02 July 2008 06:05

ramakrishna
Messages: 4
Registered: July 2008
Location: Fremont

Junior Member

Thanks for your reply.
Do I need to change any permissions to that directories in new server.

Report message to a moderator

Previous Topic:	Allocating memory error
Next Topic:	Needed AutoBackup mysql tool for windows 2000

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 21 02:12:34 EST 2008

Total time taken to generate the page: 0.01002 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.