Unfortunately, you're using MySQL on a Microsoft product, and you've probably
run into one of those issues where Redmond decided what's best for you (changing
the 'case' of the filenames).
BUT, in both the Microsoft and UNIX realm of products, 'packaging' files (on
UNIX using 'tar' and 'gzip', and on Windows-XX using "pkzip" or "winzip" or
GNU's tar and Gzip for MS products) before moving or backing them up should help
'protect' them (since thought the 'package' might change, the files within are
'protected').
Tim Thorburn wrote:
> Hello,
>
> I have a box running Win2k and MySQL 3.23.36, I had made a backup of all my
> databases/tables to CD-ROM last week. When I tried to access them again
> from the CD-ROM, I noticed that all file names had been altered to be
> displayed in uppercase and now they will not function in the php scripts I
> had generated. I've tried renaming the files to lowercase letters with no
> luck.
>
> Fortunately, these were only test databases so there won't be much
> loss. My question is in the future, is there a recommended way of backing
> up the databases that will not cause any errors?
>
> Also, would anyone know of a fix to my current problem? As I said, it was
> only a test database that was lost, but it was one that I would like back
> without going through another week of tweeking to get it back the way it was.
>
> Thanks
> -Tim
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php