MYSQL - How a database is copied from one machine to another?Explain with an example.

GeekInterview.com > Interview Questions > Database > MYSQL

Go To First | Previous Question | Next Question

MYSQL | Question 36 of 45

How a database is copied from one machine to another?
Explain with an example.

Total Answers and Comments: 4

Last Update: June 17, 2008 Asked by: amarmail_999

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 24, 2007 12:45:09

Mekalakn

Member Since: October 2007 Contribution: 5

RE: How a database is copied from one machine to anoth...

we can copy the table to our table from another table using the following sql command select * into "our table name" from "another table name"

Is this answer useful? Yes | No

March 10, 2008 01:58:14

sampra

Member Since: February 2008 Contribution: 279

RE: How a database is copied from one machine to another?Explain with an example.

select * into "our table name" from "another table name"

Is this answer useful? Yes | No

March 17, 2008 03:00:08

dipeshpatel

Member Since: January 2008 Contribution: 2

RE: How a database is copied from one machine to another?Explain with an example.

You can copy database from one machine to another machine by Export database.

For example, you have a “DB_1” database in IP - 192.168.0.127 machine and you have to transfer it into another machine which has IP – 192.168.0.128.

For this first of all export the database from 192.168.0.127 machine. Then after import it in IP – 192.168.0.128 machine.

Is this answer useful? Yes | No

June 17, 2008 16:05:35

eswarqa

Member Since: April 2008 Contribution: 3

RE: How a database is copied from one machine to another?Explain with an example.

For Mysql database, you can use mysqldump for that.

See details with examples @ http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Is this answer useful? Yes | No

Go To Top