Thread: Any 4images MySQL Experts here?
01-23-2019, 11:37 PM #1Any 4images MySQL Experts here?
I'm currently the admin of a fairly large database, based on 4images MySQL with some custom templates.
The person who created the templates is no longer available.
My problem is that some of the fields where one enters information which is then displayed on the website are not quite long enough.
I thought it would be easy to extend the number of characters that can be entered, say from 30 to 40, but everything I have tried so far has failed.
I thought there would just be a max char (or something like that) number that needs to be changed in the code, but apparently not.
Reading up on this on the net didn't give me any specific answers - I wondered if anyone here is familiar with the 4images code and the custom template arrangement.
- 01-24-2019, 10:12 AM #2
To increase the character limit, you first have to check was the MySQL DB field is set to. If not long enough, you'll have to first increase that and then you can go into the code and remove any restrictions in there.--
01-24-2019, 11:19 AM #3
Is increasing the MySQL DB field something I can do or do I need to ask the webhost to do that?
My knowledge of MySQL is pretty much 'zip' -is there any good documentation on line where I can read up on MySQL or a recommended textbook?
01-24-2019, 11:44 AM #4
If you have direct access to the DB, then that's what you would use. PHPMyAdmin provides a UI if you wish.
You would use the ALTER MySQL command to change the datatype of the column to make it work. You should make a backup of your DB before making any change.--
01-30-2019, 04:10 PM #5
Thanks, I have to think if I should attempt that.
I do have direct access to the database, looked at the phpMyAdmin and a lot in there is not really clear to me what it is.
For instance, when I look at the length of certain entries, it says 3 or 6 cells, but I don't know what the length of a cell is - I assume it must be more than a character ort something totally different.
I'm going to read up a bit on MySQL and decide then if I understand it enough to attempt to extend these fields.
01-30-2019, 04:37 PM #6
The other option you have is to go back to the 4images developer and provide feedback about the short length and see if they can do the work.--
01-31-2019, 01:55 PM #7
The fields that are a bit too short are all part of the custom template of the 4images site..
But a couple of years back when I could still get a hold of the person who created the custom templates, he told me that somehow there is a basic setting in the DB where the field has to be extended before the extension in the custom template will take hold - like I increase the number of characters in the template HTML code from say 20 to 30, but the DB itself limits the length to 25 so 25 becomes the maximum in the template as well.
The other problem is that this template was created more than ten years ago, the base 4images software (on that site) was never updated since that time but of course the base 4images software has gone through a number of updates but we are concerned if we do update the 4images base to the current version, the template may require changes and in the worst case we loose all the data which is close to 10000 entries.
When I look at backup options of the SQL database on the host website, it essentially says that the backup ends up with the host - I would like to somehow download the complete database to my Mac. Is that not possible?
01-31-2019, 02:03 PM #8
Since you have access to the DB and PhpMyAdmin, you can get a full backup following these instructions.--
01-31-2019, 03:00 PM #9
Just followed the instructions - that was easy and straight forward.
Previously I went to the backup options on c/panel.
So now I ended up with three files on my Mac:
The 5.9MB one I think is the export following the instructions you posted.
The 43.2MB text Wrangler document opened automatically
and then when I looked around c/panel a bit more I came across a "Backup" option for all the websites in my account and a subfolder called "Download a MySQL Database Backup" which gave me the 34.9MB Document.
So is the 5.9MB file a compressed version of the complete database including images etc.?
And the 34.9MB document the same but not compressed?
Is there any way I can open this downloaded database on my Mac to see what I actually have?
I was surprised how quick the download was for this 10 000 entry dstabase including 10 000 images
Last edited by krs; 01-31-2019 at 03:09 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By cyberkatis in forum macOS - Operating SystemReplies: 1Last Post: 05-14-2011, 12:49 AM
By msuperbauer in forum Movies and VideoReplies: 5Last Post: 01-16-2011, 09:12 PM
By Banksy in forum Web Design and HostingReplies: 0Last Post: 05-27-2009, 04:49 AM
By akoppes in forum Internet, Networking, and WirelessReplies: 0Last Post: 01-14-2009, 05:33 PM
By needsomehelp in forum Apple NotebooksReplies: 3Last Post: 03-10-2007, 12:55 PM