how can I copy a table with 300000 entries... 1

[halvar]

Hello,
who can tell me the syntax of copying a table with 300000 entries. I'm running phpMyAdmin2.2.2 but the 'Copy table to (database.table): samedatabase.differentname' demand would always cancel the operation before all data is copied. Do you know another way of copying tables? Thanks for helping out,
Michael

 

[Niv3k]

try:

INSERT INTO database.new_table (SELECT * FROM database.old_table);

This will work as long as the table structures are exactly identical.

Kevin

 

[halvar]

Great, this does the job as soon as I abandon the paenthesis. Thanks a lot for helping out.