I need to move a table each day from olddb to new db. I wonder if it is posisble to run this two commands in only one? without creating the .sql file
mysqldump -u user olddb table_name > moving.sql
mysql -u user newdb < moving.sql
Asked
Active
Viewed 497 times
0
Arnold Roa
- 7,335
- 5
- 50
- 69
-
possible duplicate of [Piping mysqldump to mysql](http://stackoverflow.com/questions/9509008/piping-mysqldump-to-mysql) – Justin ᚅᚔᚈᚄᚒᚔ Jan 15 '13 at 16:25
1 Answers
1
mysql -u user -p -e 'insert into newdb.table_name select * from olddb.table_name'
UPD
to use consition:
mysql -u user -p -e 'insert into newdb.table_name select * from olddb.table_name where olddb.table_name.mydate > ...'
triclosan
- 5,578
- 6
- 26
- 50
-
Mmmm but i only want to import new records, currently the mysqldump is erasing all the table, is posisble to insert only new records? – Arnold Roa Jan 15 '13 at 16:28
-
I think this is what im looking for: INSERT INTO olddb.table_name SELECT * FROM newdb.table_name WHERE newdb.table_name.id > (SELECT id FROM olddb.table_name ORDER BY id DESC LIMIT 1) – Arnold Roa Jan 15 '13 at 16:42
-
`INSERT INTO olddb.table_name SELECT * FROM newdb.table_name WHERE newdb.table_name.id > (SELECT max(olddb.table_name.id) FROM olddb.table_name) ` is better – triclosan Jan 15 '13 at 16:43