UBB.Developers Forums UBB.threads 7 Development How Do I? How to add Logo on Main? See Passwords? Backup?

3 Questions:

(1) I want to add a logo to the top of my UBBT pages without using the insert header/footer feature. I simply want to insert a logo above the:

Main Index | Search | New user | Login | Who's Online | FAQ

cell but with a clear background. HOW?

(2) Is there a way to see user passwords?

(3) How do I backup my UBBT SQL Files?

Thank you!

(2) No, they're encrypted.

(3) mysqldump

Question 1:

If you have a transparent .gif as a graphic, simply insert the HTML into these 2 template files, above the menu bar.

ubbt_registerednav.tmpl and
ubbt_unregisterednav.tmpl

Those 2 files are what generate the Menu bar at the top. One for users who are logged in, and another for users who aren't.

Dave_L and JoshPet, thank you for your help!

I'm reading/learning about mysqldump and I tried to do a full database dump via UBBT's "Execute an SQL Command" feature in the admin menu. However, I'm getting syntax errors.

mysqldump svj_clubsda > backup-file.sql

Is mysqldump a separate program I need to install on our Unix hosting server? If not, what am I doing incorrect to get a full backup?

Thank you for any insight.

Mark

mysqldump is a separate program. It's included in the standard MySQL distribution, so it should already be on your server. If you have telnet (or equivalent) access to the server, you should be able to run mysqldump from a command prompt.

Don't forget to use the --opt flag on mysqldump which makes restoring much simpler (otherwise you have to drop the database first).

code:
mysqldump --opt -uUSER -pPASS -hHOST dbname > dbname.sql

---

Then you can restore with:

code:
mysql -uUSER -pPASS -hHOST dbname <./dbname.sql

---

Now that's cool!

Learn something new every day here at ThreadsDev!

I always end up having to drop all the tables, then restore. Much better.
Thanks.