Mekalakn

 Profile Answers by Mekalakn 

• Oct 24th, 2007

 

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"

sampra

 Profile Answers by sampra 

• Mar 10th, 2008

 

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

dipeshpatel

 Profile Answers by dipeshpatel 

• Mar 17th, 2008

 

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.

eswarqa

 Profile Answers by eswarqa Questions by eswarqa

• Jun 17th, 2008

 

For Mysql database, you can use mysqldump for that.

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

DBAGop

 Profile Answers by DBAGop 

• Aug 8th, 2010

 

For consistent backup get downtime and then proceed.
Source machine: serverip1
destination machine: serverip2

login to serverip1:
mysqldump -u root -p --all-databases --opt --single-transaction > /moredisk_space_path/database_all.dmp

move the above file to destination machine as below

scp root@serverip1:/moredisk_space_path/database_all.dmp root@serverip2:/backup/

login to serverip2::
cd /backup
mysql -u root -p < /backup/database_all.dmp

gakorde

 Profile Answers by gakorde 

• Oct 5th, 2010

 

Using Replication database of one machine can be copied to other machine.

Armstrong Bala

 Profile Answers by Armstrong Bala 

• May 23rd, 2011

 

export the database in .sql format from 1 system and import that .sql file to another system using phpmyadmin tool.

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Hello everybody,

We can copy database through following means
Backup( Physical or logical)
Replication

In physical backup database files are copied and pasted to target location.We can use any file backup tool for the same. In logical backup data structure and its contain are converted to create and insert queries and stored to file. When we run this file these queries are fired to destination server.

In replication there is always one master server which stores primary copy of data and one or more slave servers which stores replicated data. In slave server configuration file master server connection information is stored. Before starting replication first  master server information is copied to slave server. On master server as there is data update,delete or insert log files are updated. This updated files are transferred to slave server and same queries are fired their to update data.

Please contact me for further discussion or help at altafhsayyed@yahoo.com

Thanks and regards