#mysql - Sun 18 Mar 2007 between 10:10 and 11:00

NY Lost Funds



yardensahello,
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?
pbroyardensa: if you have access to both tables at the same time then UNION ALL might be your friend
yardensahat do you mean by "access to both tables at the same time"?
pbroyardensa: the mysql user has to be have access to select from both tables
yardensais that a uncommon?
pbroe.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
yardensayes
i have 2 db's to merge
how could i do that with php?
wait, UNION ALL is for 1 database
pbrowhen 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)
yardensaok
when i say "database" i mean database in a server
can you point me to doc's about that?
pbro!man UNION
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/union.html
actionpbro is going to take a shower now :)
pbrois going to take a shower now :)
yardensaok thnks
barabashi, 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'
yardensapbro: how can i SELECT from 2 databases at the same query? (with union)
Techdeck_anyone?
yardensaTechdeck_: try- http://www.google.com/search?q=duplicate+database+mysql
Techdeck_thanks yardensa
yardensanp
Techdeck_hmm I did google for it but I don't see how you do it without mysqldump
yardensawhy not mysqldump?
Techdeck_because I don't want to create a file
is there a way to do it without it?
xenoterracidehi, 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?
lcdump to an SQL file -> copy to the destination machine (or sftp, ...) -> restore
kc8pxyI'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.
xenoterracidetrying to do, dump, it as root from inside the shell but getting error's, looking at the mysql 5.0 docs.

Page: 4 11 18 25 32 39 46 53 

IrcArchive

NY Lost Funds