yardensa | hello, 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 |
yardensa | yes 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) |
yardensa | ok when i say "database" i mean database in a server can you point me to doc's about that? |
pbro | !man UNION |
the_wench | see http://dev.mysql.com/doc/refman/5.0/en/union.html |
action | pbro is going to take a shower now :) |
pbro | is going to take a shower now :) |
yardensa | ok thnks |
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) |
Techdeck_ | anyone? |
yardensa | Techdeck_: try- http://www.google.com/search?q=duplicate+database+mysql |
Techdeck_ | thanks yardensa |
yardensa | np |
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. |