v4.0.6 RC1 – SQL dump doesn´t work

[larsen]

Hello,

I just download the current version and when I try to export a table as a sql dump, the created file just contains this:

Code:

/*
SQLyog v4.06 RC1
Host – 4.1.12-Max : Database –
*********************************************************************
Server version : 4.1.12-Max
*/

Lars

[peterlaursen]

yes it should look somewhat like

Quote:

/*

SQLyog Enterprise v4.06 RC1

Host – 5.0.6-beta-nt-max : Database – test

*********************************************************************

Server version : 5.0.6-beta-nt-max

*/

create database if not exists `test`;

USE `test`;

/*Table structure for table `mytable` */

drop table if exists `mytable`;

CREATE TABLE `mytable` (

 `ID` bigint(20) NOT NULL,

 `mytext` varchar(255) NOT NULL,

 PRIMARY KEY  (`ID`,`mytext`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `mytable` */

insert into `charindex` values (1,'dfdfdfdf');

insert into `charindex` values (2,'dfdfhhdf');

insert into `charindex` values (3,'dfdfjjdf');

[Shadow]

Perhaps you tried to export an empty table!

[larsen]

Hello. I just tested this once more.

Quote:

Perhaps you tried to export an empty table!

Nope. But something very similiar 😕

I barely dare to say… I didn´t select any table to export 🙄

I´m really very sorry for that!

As a suggestion to prevent others from doing this (if anyone is as stupid as me what I can´t imagine): There should be a warning message if one hasn´t selected any table.

[Ritesh]

Which option are you using?

In Export As SQL Dump window, SQLyog will throw a warning if there are no table(s) selected.

Can you post a screenshot of the window?

[peterlaursen]

@ Ritesh

Her is your screen-dump!

Chosing One DB in the object browser and ANOTHER in the export dialogue generates this eror!

[Ritesh]

Its due to the same reason as reported at http://www.webyog.com/forums/index.php?act…=6&t=1458&st=0&

It will be fixed in v4.07.

[larsen]

Hmm, perhaps it wasn´t my mistake: When you select the root entry and in the sql dump window select any DB, select all tables and click on export, the output is empty (besides the above mentioned comment).

[Ritesh]

Bug fixed in v4.07 development tree.

[Author]

Posts