Re: MySQL Newbie Question

You should be able to use "mysqldump" to dump the structure and contents of the table you want, then in the database where you *want* the table, do this: $ mysql -u mysql_user -p mysql_db < /path/to/mysqldump_file it will prompt you for the mysql_user's password, and will then load the table into the database. Be sure to replace "mysql_user", "mysql_db", and "/path/to/mysqldump_file" with your real values. Look up "mysqldump" on www.mysql.com. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Matt Stone [matt@planetveggie.com] wrote: > Hi, > I have a table of products in one database and a another table in another > database. One of the tables are old and I would like to update this table > with the newer version. Is there some command or such that I can use to dump > all of the data from the new table to the old one? The tables are on diff > databases too. Help much appreciated, > > Matt Stone > > _______________________________ > > This email may contain confidential and/or privileged information for the > sole use of the intended recipient. Any review or distribution by others is > strictly prohibited. If you have received this email in error, please > contact the sender and delete all copies. Opinions, conclusions or other > information expressed or contained in this email are not given or endorsed > by the sender unless otherwise affirmed independently by the sender. > > _________________________________ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net