<div>
You can try to add specific settings in [mysqldump] section of the my.cnf.<br />
<br />
Try also quote-names in the my.cnf :<br />
<br />
[mysqldump]<br />
quote-names<br />
lower_case_table_names=0<br />

</div>


You can try to add specific settings in [mysqldump] section of the my.cnf.

Try also quote-names in the my.cnf :

[mysqldump]
quote-names
lower_case_table_names=0


<div>
That results in <br />
<br />
mysqldump: unknown variable 'lower_case_table_names=0'<wbr /><br />
<br />
Which suggests to me mysqldump doesn't understand the lower_case_table_names variable.<br />
<br />
<br />

</div>


That results in

mysqldump: unknown variable 'lower_case_table_names=0'

Which suggests to me mysqldump doesn't understand the lower_case_table_names variable.




<div>
<div class="content wysiwyg-content">
<br />
<br />
I'm trying to dump a MYSQL DB on a linux server (Centos 5.2 32bit, MySQL 5.0.45)<br />
<br />
In /etc/my.cnf the following value is defined:<br />
<br />
[mysqld]<br />
lower_case_table_names=1<br />
<br />
When I try and do a dump with mysqldump I get the following error:<br />
<br />
[root@linuxbox backups]# mysqldump --user=root --password=secret &nbsp; --result-file=/tmp/out.sql<wbr />--all-data<wbr />bases<br />
mysqldump: Got error: 1066: Not unique table/alias: 'foo' when using LOCK TABLES<br />
<br />
I can't figure out what I need to do to work around this, and we can't set lower_case_table_names to 0 in my.cnf because that will break some things that require case insensative table names.<br />
<br />
How can I do a mysqldump in this situation? (or, another way to make a backup of the DB to file would work since that is the goal)<br />

</div>
</div>




I'm trying to dump a MYSQL DB on a linux server (Centos 5.2 32bit, MySQL 5.0.45)

In /etc/my.cnf the following value is defined:

[mysqld]
lower_case_table_names=1

When I try and do a dump with mysqldump I get the following error:

[root@linuxbox backups]# mysqldump --user=root --password=secret   --result-file=/tmp/out.sql--all-databases
mysqldump: Got error: 1066: Not unique table/alias: 'foo' when using LOCK TABLES

I can't figure out what I need to do to work around this, and we can't set lower_case_table_names to 0 in my.cnf because that will break some things that require case insensative table names.

How can I do a mysqldump in this situation? (or, another way to make a backup of the DB to file would work since that is the goal)


mysqldump: Got error: 1066: Not unique table/alias: foo when using LOCK TABLES when lower_case_table_names=1

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

mysqldump: Got error: 1066: Not unique table/alias: foo when using LOCK TABLES when lower_case_table_names=1

mysqldump: Got error: 1066: Not unique table/alias: foo when using LOCK TABLES when lower_case_table_names=1