Click to See Complete Forum and Search --> : move sql table from one database to another


cashton2k
04-07-2006, 07:43 AM
is it possible it move a table from one database to another on the same machine and still keep the entries stored in them?

thanks for any help

- using mySQL 5

chazzy
04-07-2006, 09:24 AM
use mysqldump to backup the table(s) in question and then restore it in the new system off of the file generated

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html