> I have a a database lest say called "test" which is about a gig in size.
I
> want to take a copy of that database and call it "test2" and have it
running
> on the same server.
> I could just do a dump and then insert the dump back in but this seems a
> rather long way of doing it. I had a search on the mysql.com site but
can't
> find anything.
If you are using MyISAM tableas and can stop the server, you can simply
copy
the directory "test" in the mysql data directory to "test2". You should not
do this while the server si running because mysql caches data and the files
may not be up-to-date.
If you are using another table type, you could look at the
"CREATE TABLE .... SELECT" command.
Alec Cawley
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
