Hi together,
another bug i found when I export a table.
Version SQLYog Ultimate v 10.2
MySQL: 5.1.55 Community
OS: Windows 7-64 bit
How to reproduce:
Create a table like this: TestTable1
Put in some values.
Go to table on the left side open the context menue.
Choose Backup/Export – > Backup Table(s) as SQL Dump
Be sure to select structure and data or structure only.
If the export is done read the content of the sql statement. You will see something like this:
/*Table structure for table `TestTable1` */
CREATE TABLE `testtable1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`preis` decimal(5,2) DEFAULT '0.00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;
You will see that the tablename is now lowercase at all.
This is not good when you use Linux.
This will only happens when you use these steps above.
As i mentioned the other bug in this case the Export Table Data as –> SQL will do it right in this case.
create table `TestTable1` (
`id` int (11),
);
kind regards Alex
