New Mysql 5.0 – Error 1044 Then Error 1064

[cable]

Greetings,

Development Machine – WindowsXP, SQL 5.0, latest ver of SqlYog Enterprise

Server Machine – Win2k3, SQL 5.0, lates ver of SqlYog Enterprise

So I purchased SQLYog Enterprise and updated to MySql 5.0 with a new installation. I had only a couple small databases on my old 4.1 installation, so I just exported them as sql scripts and imported them into my new 5.0 installation.

I want to setup the database and structure synchronization with my development pc and my server.

So I figured I would start by exporting my server database and then import into my development machine to create the database and then setup the sync tools.

The database name I am trying to export is called 'report-data' – pay close attention to that name…

Well, when I log in with my regular admin account (other than root) and try to export my database as SQL comments I get the following error after setting up the options and hitting the export button…

Error No. 1044

Access denied for user '[email protected]' to database name 'report'

Hmm… I have given the user account all the permissions possible for access from the local host and the 12.34.344.344 host. Also – the database name is showing up as 'report' and not 'report-data'… ???

I thought I had permission problems, so I went crazy looking for tools to update credentials, change passwords, run scripts for first time installation etc – which I did and still the same problem…

So then I try to log in with my root account (which I have renamed to something like thesuperaccount for example)…

I try the same thing and get the following error…

Error No. 1064

You have an error in your SQL syntax; check the manual that corresponds to your MYSQL server version for the right syntax to use near '-data' at line 1

So here it throws an error complaining about the -data portion of the table name…

Am I missing something? This feature worked fine w/ my 4.1 installation and an older version of SqlYog … now it seems to be having trouble with that dash in my table name. Works fine I believe if the table does not have that – in it…..

Your help/comments would be appreciated….

Thanks!

[peterlaursen]

Confirmed!

Exactly as you desxribe it with MySQL 5.0.18 and SQLyog 5.02

With MySQL 5.0.18 and SQLyog 4.1 it exports perfectly as

Code:

/*
SQLyog Enterprise – MySQL GUI v4.1
Host – 5.0.18-nt-max : Database – report-data
*****************************************
Server version : 5.0.18-nt-max
*/
create database if not exists `report-data`;
USE `report-data`;

/*Table structure for table `t1` */
drop table if exists `t1`;
CREATE TABLE `t1` (
 `id` bigint(20) NOT NULL auto_increment,
 `t` varchar(50) default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `t1` */
insert into `t1` values (1,'a'),(2,'b'),(3,'c');

hmmm .. they start at work in Bangalore in 2-3 hours. They must be able to tell! I don't know if it could be because it uses the 'Information_Schema' table.

[peterlaursen]

BTW: the 'copy database to other host' works perfect here with SQLyog 5.02 and MySQL 5.0.18.

You may use that instead. Just right-click a database ….

[Ritesh]

@cable: Can you mail me your email address?

[peterlaursen]

Also the data sync runs (sync'ing DB's 'report-data' and 'test')

Code:

Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Jan 24 10:08:13 2006

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`t1`                             8        6         4        1  No change  
`t1`                            10        8         2        0  No change  

Total time taken – 1 sec(s)

So you have two options (until the issue is fixed):

1) Use 'copy database to other host' for the first copy

2) Or simply run the first sync against an empty database

[peterlaursen]

BTW: the Backup 'powertool' also works OK.

[cable]

peterlaursen wrote on Jan 24 2006, 06:47 AM:

BTW: the Backup 'powertool' also works OK.

[post=”8580″]<{POST_SNAPBACK}>[/post]

Thanks for all of your replies! I did end up using that work around last night – I had an old export of my 4.1 database, so imported that locally and then ran the power tools data and structure sync and it worked great.

Again thanks much – it is refreshing to get accurate and friendly support!

-Cable

P.S. Is there any way to be notified when the bug is fixed though?

[peterlaursen]

I think that both Ritesh and I shal try to remember that 'wired' (= weird ?? – sorry 'bout my English spelling …. ) person 😆

SQLyog 5.1 beta 1 should be out by the end of this week (friday or saturday) if not some unforseen issue occurs. This looks like an issue that should be fixed with next release. Check in by the end of the week, if we should forget you!

[Author]

Posts