Copy Table

[David L Morris]

Hi there

I get this error when trying to copy a table, with all fields, all indexes and structure only. I am on Win98 and the message box displays:- Can't create table 'Tablename_copy.frm'(errno: 140)

I can work around by copying and running the CREAT TABLE SQL script, however, it would be good to have the Copy table menu item work seamlessly.

Regards

David

[Ritesh]

SQLyog logs all the queries in the History Window. Can you post the SQL command that is giving error out here.

Please mention the MySQL version you are using?

[David L Morris]

Here is the history. The MySql is, I believe Version 4.0 – I only downloaded it a couple of weeks ago.

[17:14:38][ 61 ms] show fields from `aimdb`.`mtv20030105spots`

[17:14:39][ 3 ms] show keys from `aimdb`.`mtv20030105spots`

[17:14:39][ 2 ms] show create table `aimdb`.`mtv20030105spots`

[17:14:47][ 3 ms] use `aimdb`

[17:14:47][ 4 ms] show fields from `aimdb`.`mtv20030105spots`

[17:14:47][ 9 ms] show table status from `aimdb` like 'mtv20030105spots'

[17:14:54][ 4 ms] show keys from `aimdb`.`mtv20030105spots`

[17:14:54][1122 ms] create table `aimdb`.`mtv20030105spots_copy` ( primary key ( AdInstanceID ) ,FULLTEXT KEY `KeyNumber` ( `KeyNumber` ), FULLTEXT KEY `AdvertisementID` ( `AdvertisementID` ) )type=MyISAM select `AdInstanceID`, `AdvertisementID`, `KeyNumber`, `StationID`, `SpotDateTime`, `Duration`, `BreakNumber`, `AdsInBreak`, `PositionInBreak`, `PromoBefore`, `PromoAfter`, `TypeOfAd`, `CommentCode`, `ProgramID`, `MarketInd` from `aimdb`.`mtv20030105spots` where 1 = 0

[17:14:59][ 2 ms] use `aimdb`

I still get the error and hope this gives you a clue.

David

[Ritesh]

You can get the MySQL version by executing the query select version() . Please post the exact version of MySQL?

We are working on it and if there is any bug we will fix it in the next release.

[David L Morris]

The MySQL version is 4.0.13 and I am runing on Win98

Regards

David

[Ritesh]

Thanks.

I will reply back soon.

[CalEvans]

What table type is mtv20030105spots?

Is the SERVER on windows or Linux?

What version of SQLyog are you using?

While I can't run your query because I don't have the original table, I just ran the Copy Table o an existing table in my tst database and it works fine. (MySQL 4.0.13 on Linux, client 3.52 on on Win2k)

=C=

[David L Morris]

Hello Cal, I am operating on Win98, localhost, with SQLyog 3.52 and here is the table definition:-

DDL Information For – aimdb.mtv030105spots

---

Table CreateTable

---

mtv030105spots CREATE TABLE `mtv030105spots` ( `AdInstanceID` bigint(20) default NULL, `AdvertisementID` int(10) default NULL, `KeyNumber` char(15) default NULL, `StationID` int(10) default NULL, `SpotDateTime` datetime default NULL, `Duration` char(3) default NULL, `BreakNumber` char(3) default NULL, `AdsInBreak` char(2) default NULL, `PositionInBreak` char(2) default NULL, `PromoBefore` char(1) default NULL, `PromoAfter` char(1) default NULL, `TypeOfAd` char(1) default NULL, `CommentCode` char(2) default NULL, `ProgramID` int(10) default NULL, `MarketInd` char(1) default NULL, UNIQUE KEY `AdInstanceID` (`AdInstanceID`), KEY `KeyNumber` (`KeyNumber`), KEY `AdvertisementID` (`AdvertisementID`) ) TYPE=MyISAM

[Author]

Posts