i have 2 mysql databases, and I'm looking for a way to merge a table form one database and the table from the second database to one list - ordered by a date field in the table.
how could i do that?
|pbro||yardensa: if you have access to both tables at the same time then UNION ALL might be your friend|
|yardensa||hat do you mean by "access to both tables at the same time"?|
|pbro||yardensa: the mysql user has to be have access to select from both tables|
|yardensa||is that a uncommon?|
|pbro||e.g. SELECT field1, date1 FROM database1.table1 UNION ALL SELECT field1, date1 FROM database2.table2|
yardensa: well, most of my mysql users only have access to their own databases
oh, the databases need to be on the same mysql server as well
i have 2 db's to merge
how could i do that with php?
wait, UNION ALL is for 1 database
|pbro||when you say "database", do you mean database server?|
A server can contain several databases
UNION ALL is for any amount of tables stored on the same server (also in different databases at the same server)
when i say "database" i mean database in a server
can you point me to doc's about that?
|action||pbro is going to take a shower now :)|
|pbro||is going to take a shower now :)|
|barabas||hi, a good mysql client gui for lin?|
|Techdeck_||Hello, how do I copy one database to another without using mysqldump?|
I have a database named 'test' I want to copy it to 'test2'
|yardensa||pbro: how can i SELECT from 2 databases at the same query? (with union)|
|yardensa||Techdeck_: try- http://www.google.com/search?q=duplicate+database+mysql|
|Techdeck_||hmm I did google for it but I don't see how you do it without mysqldump|
|yardensa||why not mysqldump?|
|Techdeck_||because I don't want to create a file|
is there a way to do it without it?
|xenoterracide||hi, I'm wanting to transfer my db from one mysql db to another on a different machine what's the fastest way to do that?|
|lc||dump to an SQL file -> copy to the destination machine (or sftp, ...) -> restore|
|kc8pxy||I'm looking for a tool i can use similar to dbdesigner/mysql workbench. any suggestions?? dbdesigner isn't connection to my 5.x db, and workbench is in the workshop.|
|xenoterracide||trying to do, dump, it as root from inside the shell but getting error's, looking at the mysql 5.0 docs.|