If we export (in this case using a hosting providers phpMyAdmin functions) a part of a database, eg mybb_template.sql' (table?), and import a revised mybb_template.sql to the database (file?), does it only change the fixed (vs live, like forum posts etc) table and leave the other fixed and live tables data unchanged ?
And, if we delete/restore (insert?) the original fixed table mybb_template.sql, it likewise would not change any other fixed(templates etc)/live(forum threads etc) tables that may have changed during the revision period ?
The hosting provider, would not give us much in the way of definitive replies, since they felt it was a question we should ask of the 'developer' (hence this post).
So, hopefully we at least got close to the right terminology from them for this question.
It seems like exporting/revising/deleting/importing is like cutting/pasting into parts (tables) of the database file ?
Basically trying to figure out if can modify fonts etc of forum display text (like bbname, Board Name) in certain 'fixed' parts of the database, without effecting other 'live' parts.
Thoughts ?
Its not like cutting and pasting, in cut and paste, you can undo and redo, but in phpmyadmin, once query is run, you cannot undo..
(2011-04-21, 03:02 PM)grave Wrote: [ -> ]Its not like cutting and pasting, in cut and paste, you can undo and redo, but in phpmyadmin, once query is run, you cannot undo..
Thanks for the feedback.
Guess what we meant was, could the whole process be likened to cut/paste, ie...
1. (copy) export mybb_template.sql from database to PC with phpmyadmin
2. edit mybb_template.sql text at PC with notepad
3. (cut) delete mybb_template.sql from database with phpmyadim
4. (paste) import mybb_template.sql from PC with phpmyadmin
5. if doesnt work like wanted, (cut) delete revised mybb_template.sql with phpmyadmin
6. (paste) import original mybb_template.sql back to database with phpmyadmin
With above process/s the rest of the database is left untouched, ie the 'live' (thread additions etc) are not effected ?
Hope that clarifies.
So, question is, does it work like that ?
Thanks again.
Threads will neither get deleted, nor get damamaged, but do all these things by closing your board. and let me tell you when you will delete your template, the theme of your forum will be lost and you will be left with white background page with some blue black written text.
So do it...carefully..but close the board must.
(2011-04-21, 11:57 PM)grave Wrote: [ -> ]Threads will neither get deleted, nor get damamaged, but do all these things by closing your board. and let me tell you when you will delete your template, the theme of your forum will be lost and you will be left with white background page with some blue black written text.
So do it...carefully..but close the board must.
Thanks for the followup !
So, what were saying is that the 1 - 6 process should work, but close the board b4 doing it carefully.
When you say close the board, are you referring to the CP Board Online/Offline switch ?
Thanks again for the help !
yes, you can give hand on that... and by closing the board means
ACP>Configuration>Board Online/offline Switch>Yes.
I have to ask, why would you even want to do this?
If you do this make sure you download two copies of the backup, so if the one you edit mucks up you've always got a backup.
Oh and when you try to import your backup you may get errors such as duplicate entry. If so you'll have to drop all the tables because importing databases does not overwrite the old one, it adds to it.
(2011-04-22, 09:39 PM)AJS Wrote: [ -> ]I have to ask, why would you even want to do this?
1st post in this thread probably said as much as can say.
Quote:Basically trying to figure out if can modify fonts etc of forum display text (like bbname, Board Name) in certain 'fixed' parts of the database, without effecting other 'live' parts.
Guess it gets back to the 'font' question/s and how to edit parts of the forum display without going out an downloading a 'free mybb template'.
Would like to modify, in addition to fonts, background colors etc, but not the basic layout of the basic Mybb template.
Was just wondering if one might need to edit 'template' parts of the database to make display changes, and how to do that.
Am probably just grasping for information on the 'template' topic.
There doesnt seem to be any clear and simple direction on the topic... like a simple (for beginners) manual or something. But then, I could be missing something... hence all the time on this forum.
And again, thank you for your help and patience in that regard !
If I understand what you are trying to do correctly, then I must say, you're taking a looooooong route of doing something that can be done so simply.
You do not have to export/edit/import database tables to make changes to an existing theme/template.
If you want to change the font color/appearance you can do so in your admincp under the Themes & Templates section. Here you'll see all your different themes that you can go in to and edit their css. All elements are assigned a css class which you can change according to what you want.
If you want to do more than just change their appearance and maybe like move things around then you would do that in the templates section. Each part of the site is laid out in a template and you can edit that and if you make a mistake you can easily revert it to its original state.
If you don't want to disturb your live site's look while you do this trial and error you can make a copy of your current theme and make the changes you want on it, when you're happy with the look you can then make it default.
You can read more about this in the wiki:
http://wiki.mybb.com/index.php/Admin_CP_Templates_Style