| Author |
 Topic  |
|
campinmom03
Junior Member
USA
190 Posts |
 Posted - 05 April 2008 : 13:00:07
|
Hello. I have converted over from an Access DB to a MySQL DB with Muzishun's help. (Thank you again Bill) Considering I have SHN v 9 he did a great job!
However, I found after conversion that my tables are done in lower case. I'm finding that in order for my forum to function properly that those tables need to be renamed all in uppercase. Muzishun like many of us here, is very busy and I would like to help by trying to fix this myself if it's possible for me to do so.
I am totally new to this so please bare with me as I am not familiar with using phpMyAdmin.
I have tried this: http://it.youtube.com/watch?v=FqCW-Da97Xk , and it would not let me rename my tables.
I have also tried this:
1.) login phpadmin
2.) select with your database
3.) Under your database select "SQL" function
4.) try this sql statment
"RENAME TABLE table_old_name TO table_new_name"
Both attempts have not allowed me to rename my tables.
Can someone please tell me of another way to accomplish this?
|
Have a great day!
Terry |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 April 2008 : 13:26:25
|
You may want to see if your host will chage MySQL's set up so that the table names are not case-sensitive. They may not depending on your package. Alternately is a little quality time with your favorite editor's "Find and Replace" feature...
I'm sure there are other ways to do it. But those are the two that tend to get over looked. The former is simple and (relatively) fast, the latter is simple but time consuming. |
 |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 05 April 2008 : 15:38:09
|
Originally posted my AnonJr
quote:
You may want to see if your host will chage MySQL's set up so that the table names are not case-sensitive.
Great suggestion and tried it. When I contacted them, the guy said his tech said that it wouldn't make a difference if they did change it. Also, because no one there in charge to have the authority to make that change in the settings.
quote:
Alternately is a little quality time with your favorite editor's "Find and Replace" feature...
I have dreamweaver.
Originally posted by modifichicci
quote:
export database in a .sql file with phpadmin
change lower case in upper case with a text editor like araneae or similar with find and replace function
reupload your db with the import function in php admin
(take care to the collation you have in your forum , i think it is latin1)
I can't remember, is araneae free? edited: Found it, it is free :)
As to the collation, anything in particular that I should look for?
Yes, it is in latin1. Your post is scaring me... maybe I got in way over my head?
Thank you for the info guys. Looking forward to your reply postings on this.
|
Have a great day!
Terry |
Edited by - campinmom03 on 05 April 2008 15:48:32 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 05 April 2008 : 16:12:30
|
originally posted by modifichicci
quote:
whe you import te file you can choose the collation, default it 's utf8, but in this way you can lost accented chars.
Good to know. I will keep note of that. 
quote:
It is not so scaring, you can try it if you have another mysql db. Many hosts give you more than one db...
Ok. I have a mysql that is just the snitz 3.406 version with only a handful of mods, mainly the security ones that AnonJr posted in the general forum for preventing spammers. Will that one be ok to use?
|
Have a great day!
Terry |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 05 April 2008 : 16:54:48
|
Great! I will try that later on this evening.
Thank you both for everything! |
Have a great day!
Terry |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 05 April 2008 : 17:33:37
|
quote:
Originally posted by campinmom03
Great suggestion and tried it. When I contacted them, the guy said his tech said that it wouldn't make a difference if they did change it. Also, because no one there in charge to have the authority to make that change in the settings.
It would make a difference, but if they don't have the authority then its a moot point. 
quote:
Originally posted by campinmom03
I have dreamweaver.
Dreamweaver (From MX on up) will let you do a find and replace in every file in a given folder. It may be a way to go if modifichicci's solution doesn't work. |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 05 April 2008 : 18:08:14
|
quote:
Originally posted by AnonJr
Dreamweaver (From MX on up) will let you do a find and replace in every file in a given folder. It may be a way to go if modifichicci's solution doesn't work.
I find this info very interesting. Sorry for the stupid questions, just want to be sure I have as much info as I can before I dive into this. |
Have a great day!
Terry |
Edited by - campinmom03 on 05 April 2008 20:59:26 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 April 2008 : 05:24:27
|
quote:
Originally posted by AnonJr
quote:
Originally posted by campinmom03
Great suggestion and tried it. When I contacted them, the guy said his tech said that it wouldn't make a difference if they did change it. Also, because no one there in charge to have the authority to make that change in the settings.
It would make a difference, but if they don't have the authority then its a moot point.
It would make all the difference, indeed. It would make the forum work no matter what the case used for table names! |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 06 April 2008 : 10:23:09
|
Just wanted to let you guys know that I have not yet tried modifichicci's solution just yet. (I want to see if the former will work first). Especially knowing that my hosting could do this, as AnonJr initially pointed out. I have been all over them about it ever since their tech guy said it wouldn't make a difference when it does.
I have been bounced from every department for over 13 hours. They have finally forwarded this request of mine to the Admin Server guy who can and should take care of this. Hopefully I will hear from him soon... I better hear from them. I have had a premier account with them for 5 years I don't want the run around anymore.
|
Have a great day!
Terry |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 06 April 2008 : 13:18:42
|
Here was the final response I received to my request in asking them to change MySQL's set up so that the table names are not case-sensitive.
"Hi, mysql database in windows system are not case-sensitive, you can check the detail here "http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html"
Updated: And here was another staff members response to this matter.
"Dear client, I have checked that all your tables in the database myfamilyforumz are using db collation of latin1_swedish_ci, the ci there implies that your tables are case insensitive." |
Have a great day!
Terry |
Edited by - campinmom03 on 06 April 2008 13:31:04 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 April 2008 : 16:26:41
|
Question is, why do you state that the tables need to be in uppercase? That's what started this thread...
The reply about collation is absurd, since collation matters to table contents, not table names. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
campinmom03
Junior Member
USA
190 Posts |
Posted - 06 April 2008 : 17:36:26
|
quote:
originally posted by ruirib,
Question is, why do you state that the tables need to be in uppercase? That's what started this thread...
uhh, cause I was told by a member at SHN that the reason why some things in my site were not working correctly was because my tables were not done in uppercase. That is what got me into looking further into this.
I'm totally inexperienced with mysql ruirib....and seemingly way over my head. Sorry. I'm not trying to cause confusion to this topic by adding those responses by my hosting.
|
Have a great day!
Terry |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
