Export as Batch Scripts

[cseymour]

Hi all,

How would I turn off the '' around the tablenames and fieldnames when I export a table and data to a batch script?

Thanks.

Chris

[Ritesh]

Can you explain a bit more?

[cseymour]

Sure,

Here is what I am getting if I export a table to a script:

drop table if exists `test1`;

CREATE TABLE `test1` (

`col1` int(11) NOT NULL auto_increment,

`col2` int(11) NOT NULL default '0',

PRIMARY KEY (`col1`),

KEY `col2` (`col2`)

) TYPE=ISAM;

This is fine if I import it to my test machine (MySQL4). However in Prod we still have MySQL3 and it does not seem to like the '' around the field names.

I go in and manually edit the script now, but was wondering if there was a seeting somewhere to turn it off when the script is generated.

Thanks.

Chris

[Ritesh]

Which server are you connecting while taking the backup?

SQLyog checks for the server version and if it is less then 3.23.x then it wont quote the object names with '`'

[cseymour]

Thanks Ritesh,

I think I need to use the same version as my Prod machine on my desktop.

Thanks again.

Can't tell you how much sqlYog has helped me. Best money I have ever spent.

Thanks.

Chris

[Author]

Posts