"I want to make an exact copy named "works2.""
what about
INSERT INTO table1 (table1Columns)
SELECT table2Columns FROM table2;
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> --- Schalk <[EMAIL PROTECTED]> wrote:
> > I would suggest exporting your current database as a
> > .sql file taking across
> > all structure and data. Create your new database and
> > run the .sql file on
> > it.
>
> Thanks for the tip. Let me just make sure I understand
> the mechanics. Let's say I have a database named
> "works" that features four tables. I want to make an
> exact copy named "works2."
>
> Would I export "works" as "works2," then create a new
> database named "works2," then place the SQL file
> "works2" inside the database "works2"?
>
> Thanks.
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
