Hi,
Just dump the tables from the original database:
% mysqldump -h yourhost -u root -p yourpass existing_dbname > dbname.sql
Then import the dump into your new database:
% mysql -h yourhost -u root -p yourpass new_dbname < dbname.sql
Should get you started.
Nick
> - Orig
There are a number of ways to do this. Not being sure exactly what you
want, a live copy (replication) or a transfer (mysqldump), it's tough for
me to say which method would be best. Look in the manual under mysqldump
or replication and see if those fit your needs.
Steve
At 04:19 PM 9/25/01
