Re: duplicate a table
| From: | Chris Lee | Date: | Mon, 02 Apr 2001 18:03:01 +0000 |
| Subject: | Re: duplicate a table | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-46672@lists.php.net to get a copy of this message | ||
im to lazy to figure out the mysql commands, just copy the files.
cp sometable.MYI sometable2.MYI
cp sometable.MYD sometable.MYD
cp sometable.frm sometable.frm
mysqladmin flush-tables
easier.
--
Chris Lee
lee@mediawaveonline.com
""McShen"" <webmaster@celebritieszones.com> wrote in message news:9aak9c$t7t$1@toye.p.sourceforge.net...
how do i duplicate a table?
i tried
create table refer2 select * from refer;
create table refer2 as select * from refer;
they didn't work.
my mysql version is mysql 3.22.28,
--
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