#3830 (ok 4.0) Can't export custom query because it lowercases table names

3.5.6
fixed
Marc Delisle
None
1
2013-11-08
2013-02-18
N/A
No

Bug happens in 3.5.6 Have not tried 3.5.7 yet.

  1. click on a database.
  2. click on a table that has any uppercase letters in it's name
  3. click on the checkbox for one of the rows and then click export at the bottom.

It will export the table schema ok "create table if not exists..." but when it gets to the inserts it says:

-- Error reading data: (#1146 - Table 'dbname.courses' doesn't exist)

If you try to export the entire table with the export button at the top it works just fine.

Discussion

  • Marc Delisle
    Marc Delisle
    2013-02-21

    • assigned_to: Marc Delisle
     
  • Marc Delisle
    Marc Delisle
    2013-02-21

    • summary: Can't export custom query because it lowercases table names --> (ok 4.0) Can't export custom query because it lowercases table names
    • priority: 5 --> 1
     
  • Marc Delisle
    Marc Delisle
    2013-05-03

    • Status: open --> closed-fixed
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-fixed --> fixed
     
  • Seth Borg
    Seth Borg
    2013-11-07

    Using 3.5.8.2 still broken. Why are you only fixing it for version 4?

     
  • Marc Delisle
    Marc Delisle
    2013-11-08

    The team decided that we have to stop supporting old versions at some point (even for security fixes). See the confirmation for this on http://www.phpmyadmin.net/home_page/downloads.php.