spewn
Programmer
- May 7, 2001
- 1,034
how do i go about moving a database between two computers that are networked together. any help is appreciated.
thanks!
- g
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
i have two comps networked, and want to move DB from one to another...
- Thread starter spewn
- Start date
- Status
how do i go about moving a database between two computers that are networked together. any help is appreciated.
thanks!
- g
sleipnir214
Programmer
What type of tables are in the database? On what OS?
If you're using MyISAM tables, simply:[ul][li]Create an empty database with the same name as the database on the old server[/li][li]shut down both MySQL servers[/li][li]Copy the files in the "databasename" directory from the old server to the new server[/li][li]Make sure that permissions and ownership of the files is right (on a Linux box, make the group and user owner the same as which MySQL runs, with permisions 660)[/li][li]Start the new server[/li][/ul]
Want the best answers? Ask the best questions!
TANSTAAFL!!
If you're using MyISAM tables, simply:[ul][li]Create an empty database with the same name as the database on the old server[/li][li]shut down both MySQL servers[/li][li]Copy the files in the "databasename" directory from the old server to the new server[/li][li]Make sure that permissions and ownership of the files is right (on a Linux box, make the group and user owner the same as which MySQL runs, with permisions 660)[/li][li]Start the new server[/li][/ul]
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Thread starter
- #3
- Status
Similar threads