Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Backup and recovery		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sikandar
Junior Member

Pakistan
135 Posts
Posted - 19 May 2007 :  04:42:40  Show Profile
I am taking backup of my database using,

-- MySQL dump 9.11
-- ------------------------------------------------------
-- Server version 4.0.24-nt

but when I am restoring the backup the tables names are in small letter which should be caps.

| FORUM_USERFILES |
| FORUM_USERGROUPS |
| FORUM_USERGROUP_MEMBERS |
| FORUM_USERPHOTO |
| forum_a_reply |
| forum_a_topics |
| forum_active_users |

so how I can control and what is the best backup and recovery practice.

Thanks

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 19 May 2007 :  07:21:31  Show Profile  Send ruirib a Yahoo! Message
Unless you are using a linux / unix server, the case is not relevant at all.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 19 May 2007 :  21:42:40  Show Profile
There are some db server settings that may affect this situation

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07