[SOLVED] Need some help to edit sql database

[luminous]

I've made a bit of an error with the Gallery module on my first site.

I've created lots of sub directories that use names that have spaces.  These work ok, even online, however validators are complaining about the naming structure.

Now the easiest option would be to hop into my ftp server and simply change the names of the offending directories.  Issue with doing this is that I will lose all the comments that I have made in the Gallery module.  

The next easiest option would be to move the folders from within the Gallery module itself.  Problem with this is that there are in excess of 100 folders.  

Last option I think it to make a backup of my database and have a go at editing it.  I've never done this and do not even know how to start.  I'm looking for a few pointers.  I have MS Access.  Anyone have some tips or links to get me started from a cmsms point of view?

I'm hoping to do find and replace operations within the database to change things like "For Sale" to "For_sale" or similar.  Am I barking up the wrong tree here?

[JohnnyB]

You will ned to change the directory names on the server and in the database. Do you have access to phpmyadmin?  There are database tools like (I think it is called) Navicat Lite for mysql databases.  I wouldn't use access....  you can always export your db as sql and open it in a text editor, like notepad, and edit that way too.

[nockenfell]

Look at this:
http://www.mediacollege.com/computer/da ... place.html

execute this in phpMyAdmin

(make fist a backup)

[luminous]

Super, thank you both.  I will get onto those ideas now.

Yes, I do have access to phpmyadmin.  Its on a shared host, so I don't have access to a unix style command line, just a web management interface (which is basic), phpmyadmin, and ftp access to server files.

Will go and take a back, make the install local and start and play.  It may be tomorrow before I get back to this thread as, well....I forsee having a few attempts before I post back

[Jos]

Option 2 is a good one that will work

Wath out! Option 1 and 3 should both be done at the same time! The moment there is some inconsistency between the filename and the name in the database, the record in the database will be deleted when someone opens that gallery page in frontend or backend.

Does this only concern the foldernames, or the filenames too?
And are only space the issue or are there any other weird characters?

[luminous]

Its just spaces in the directory names in the Gallery section.  It was causing the links that were generated to have several %% characters in them - which I believe is not good for indexing.

I've just completed the steps above and I think its all working as planned.

You are welcome to take a look if you like...
www.johnpyemotors.com

This is my first site, and initially was going to be done as a little project of a total of 5 pages....oh how it grew

Even if you are not interested in cars you should check out the videos section under Motorsport

P.S. - there is a an extra step to all of this, once the new database and file structure have been made and uploaded to the server you will have to clear the server's cache in order for things to work....I had a little panic attack until I thought about that