On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote:
> What is wrong with the
>
> CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
> [(create_definition,...)]
> [table_options] [select_statement]
>
> syntax. Note that you can append a SELECT statement to a CREATE
> statement to automatically add rows to the new table. Read the following
> manual sections:
>
> http://www.mysql.com/doc/C/R/CREATE_TABLE.html
> http://www.mysql.com/doc/S/i/Silent_column_changes.html
He said he is using 3.22.32. Does that work in 3.22.xx? I thought it
was 3.23.xx specific.
> Guy Waugh wrote:
> >
> > Hi there,
> >
> > One of my users wants to copy a large table. He normally does this through
> > PHPMyAdmin, but the table seems too large for the web browser to handle,
> > and it times out.
> >
> > I'm using mysql version 3.22.32-log on a RedHat Linux 6.2 (Intel) box. The
> > file system is on a hardware RAID array.
> >
> > Can I simply copy the files associated with the table via the OS shell
> > (e.g. 'cp table_name.ISD new_table_name.ISD' etc.) and expect MySQL to know
> > about it? Will I need to create the indexes for the table manually, or will
> > MySQL do that automatically? Do I need to update any database records so
> > that MySQL will know about the table (and indexes)?
> >
> > Alternatively, is there an SQL command I could use to do this? If so, is it
> > any better/worse/safer/unsafer than doing a file system copy?
> >
> > Please excuse my lack of knowledge - MySQL usually just runs along without
> > any problems, so i haven't had to touch it much yet ;-)
> >
> > Thanks,
> > Guy.
> > --
> > Guy Waugh <[EMAIL PROTECTED]>, tel. 61+2 6620 3196
> > Unix Team, Information Technology Services
> > Southern Cross University
> > Military Rd, Lismore NSW 2480 Australia.
> > --
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
