Export Data As Sql Statements Problem

[arkid77]

hi there

ive upgraded my mysql server to the current stable 5.0 version (and around the same time purchased the v5 revision of sqlyog)

since doing this i cant export a development database i have from sqlyog.

my table is called xxxxname-dev

i get an error at the start of the export when i click the EXPORT button. its mysql error 1064, suggesting theres a problem with the sql statements sqlyog is using in the background to extract the data. the end of the piped error is 'check syntax near '-dev'.

ive just checked and my 4.x version of sqlyog also presents the same error message.

[peterlaursen]

Code:

since doing this i cant export a development database i have from sqlyog.

You don't have a database from SQLyog! You have a database from another MySQL version. Which version ?

How did you import the data the the new MySQL ? Did you just copy the /datadir ? Did you remember to run the update script(s)?

Can you show table definitions from objects-tab ? let us see it !

I

[arkid77]

the problem seems irelivent to my upgraded database. ive just created a new database via sqlyog on my 5.0.16 mysql server. i called the database test-dev. i then created a table with a simple field names without odd characters or anything unstandard. i went to the export option in sqlyog and again i got this error.

[peterlaursen]

Then have a look here:

Code:

/*
SQLyog Enterprise – MySQL GUI v5.02 BETA
Host – 5.0.18-nt-max : Database – test3
*********************************************************************
Server version : 5.0.18-nt-max
*/

create database if not exists `test3`;

USE `test3`;

/*Table structure for table `test-dev` */

DROP TABLE IF EXISTS `test-dev`;

CREATE TABLE `test-dev` (
 `id` bigint(20) NOT NULL auto_increment,
 `t` varchar(50) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `test-dev` */

insert into `test-dev` values (1,'x');
insert into `test-dev` values (2,'y');
insert into `test-dev` values (3,'z');

I have no problems in exporting a database with such a table name.

I asked you some questions but you are not very informative. So I am not very helpful! 🙁

[peterlaursen]

But I just will add that if the system tables with your MySQL originate from an older MySQL version and not have been updated correctly, you can expect all sorts of errors.

[Author]

Posts