raindropz12 Posted April 17, 2011 Share Posted April 17, 2011 Is it possible to copy tables from 1 database to another database? Thanks in advanced. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/ Share on other sites More sharing options...
trq Posted April 17, 2011 Share Posted April 17, 2011 Yes. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1202480 Share on other sites More sharing options...
raindropz12 Posted April 17, 2011 Author Share Posted April 17, 2011 Yes. can you please tell me how? Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1202565 Share on other sites More sharing options...
QuickOldCar Posted April 17, 2011 Share Posted April 17, 2011 There are ways to import the tables into new tables.  Here's the easiest method without taking a long time or running into time and memory limits. Method 1: Browse to your MYSQL folder, then data folder, then databasename folder. copy the files associated to that table, rename them and place them back into the database folder  example: MySQL\data\databasename  It will contain 3 files for each table name, copy and rename them table_name.frm table_name.MYD table_name.MYI  to something like below or what you want table_name_copy.frm table_name_copy.MYD table_name_copy.MYI  After you rename and place back the files, do a REPAIR on the table and will have an exact clone.  Method 2: export your table into a .sql file, create a new table and import the .sql back in, but you have to edit the .sql file to have the proper table name first.  Note: if you include the "create table" function in the sql export file, is no need to manually create the new table  Method 3: Otherwise you can do it the long way if you have a very large table  SELECT * INTO table_name_copy FROM table_name;  If I remember correctly this method will not retain your index information. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1202587 Share on other sites More sharing options...
QuickOldCar Posted April 17, 2011 Share Posted April 17, 2011 I realized you said database to database  Copy and rename the database folder itself, place new copy into MYSQL\data, then do the repair. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1202590 Share on other sites More sharing options...
raindropz12 Posted April 18, 2011 Author Share Posted April 18, 2011 how about copying records from 1 table to another table? thanks. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1202784 Share on other sites More sharing options...
fenway Posted April 19, 2011 Share Posted April 19, 2011 how about copying records from 1 table to another table? thanks. Best way is to use the mysql commands directly, if you can connect to both with the same user. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1203442 Share on other sites More sharing options...
raindropz12 Posted April 20, 2011 Author Share Posted April 20, 2011 how about copying records from 1 table to another table? thanks. Best way is to use the mysql commands directly, if you can connect to both with the same user. what are the mysql commands to copy records from 1 table to another table? please give examples, thanks. Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1203773 Share on other sites More sharing options...
fenway Posted April 24, 2011 Share Posted April 24, 2011 INSERT INTO...SELECT WHERE... Link to comment https://forums.phpfreaks.com/topic/233929-copying-tables-from-1-database-to-another/#findComment-1205571 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.