Gossamer Forum: General: Databases and SQL: MySQLDump

Sep 6, 2002, 6:22 AM

Paul

Veteran (19537 posts)

Sep 6, 2002, 6:22 AM

Post #1 of 4

Shortcut

MySQLDump

Is it just me or do mysql dumps ignore table case?

For example I have a table called CatRelated and when I dump it I get:

CREATE TABLE catrelated (

Sep 6, 2002, 7:09 AM

Andy

Veteran / Moderator (18441 posts)

Sep 6, 2002, 7:09 AM

Post #2 of 4

Shortcut

Re: [Paul] MySQLDump In reply to

Works fine for me :-/ I use dumps all the time for doing DMOZ imports, and it seems to hold the case ok...

Andy (mod)
andy@ultranerds.co.uk

Sep 6, 2002, 7:14 AM

Paul

Veteran (19537 posts)

Sep 6, 2002, 7:14 AM

Post #3 of 4

Shortcut

Re: [Andy] MySQLDump In reply to

Its when you use something like mysqlman or phpmyadmin that uses SHOW TABLES ....case isn't preserved.

Sep 6, 2002, 7:22 AM

Andy

Veteran / Moderator (18441 posts)

Sep 6, 2002, 7:22 AM

Post #4 of 4

Shortcut

Re: [Paul] MySQLDump In reply to

I've used both of them, in fact, I have used most of the options...MySQLMan, phpMyAdmin and command prompt...all of which seem to work fine for me Unsure

Andy (mod)
andy@ultranerds.co.uk