hello!
need some database advise or tips on how to exactly copy/ move('contents of') a 'Table' from one Database,
to another Database.
tanx in advanced!
cheerz!
Copy Or Moving Database(TABLE'S) to Another Database. HOW?
Moderator: General Moderators
- khaki_monster
- Forum Commoner
- Posts: 73
- Joined: Tue Oct 11, 2005 12:36 am
- Location: Philippines
- Contact:
Log in as root, then run a query like this:
Code: Select all
INSERT INTO newDatabase.newTable SELECT * FROM oldDatabase.oldTableReal programmers don't comment their code. If it was hard to write, it should be hard to understand.
- khaki_monster
- Forum Commoner
- Posts: 73
- Joined: Tue Oct 11, 2005 12:36 am
- Location: Philippines
- Contact:
- khaki_monster
- Forum Commoner
- Posts: 73
- Joined: Tue Oct 11, 2005 12:36 am
- Location: Philippines
- Contact:
hi again..
questions are:
- what if('I TRIED') another sets of records added to oldDatabase and pass each values to the newDatabase using same statement.
result, the newDatabase.newTable was not update with the new records. why?
- do i have to empties('TRUNCATE Table tablenme') those tables in newDatabase before inserting the data's?
- is their anyway to optimize('Fast/ speed'up') copying/ moving the data's to another database?
please help
cheerz!
questions are:
- what if('I TRIED') another sets of records added to oldDatabase and pass each values to the newDatabase using same statement.
Code: Select all
INSERT INTO newDatabase.newTable SELECT * FROM oldDatabase.oldTable- do i have to empties('TRUNCATE Table tablenme') those tables in newDatabase before inserting the data's?
- is their anyway to optimize('Fast/ speed'up') copying/ moving the data's to another database?
please help
cheerz!