• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mysql

  1. AppleAndMango

    MySQL vs MariaDB

    Hey. So I've been reading around and I've noticed that MariaDB is generally suggested more than MySQL as a database server, I've Googled and I can't seem to find a clear answer to my question of what's the difference and why do people prefer MariaDB over MySQL. Anyone feel like explaining...
  2. T

    xenforo expert needed for customisation and mods

    We are looking for xenForo Developer to add 5-6 new mods to our forums. Here is what I need to be done for reference: - Custom New Thread Options - Reputaion System - Points System - Vote up & Vote Down for particular thread - Member Ranking System Also I want front page for my...
  3. Earl

    XF 1.5 Attached files importing failed

    I've been performing an import from vB 3.8. Everything was going smoothly until I click the "Import Attachments" button, and I got this error: I skipped importing "content tags" step because I don't want tags from previous vBulletin site. Was that the problem? I don't think so. And got...
  4. Drunken

    xenForo Resources - Purchased but do not know how to change pre-fix

    So I just purchased and installed xenForo resources. It looks nice, but I do not know how to edit the example category that displays. I do not seem to have the administrator ability to change that - so any help would be appreciated.
  5. kbarg

    Posting Forum news on PHP page

    Can anyone, anyone show me what I need to do to pull, "date, author, title, avatar, and message body" from my news forum posts and post them on my non-cms website. I do not use wordpress, and everything on my site is coded by hand. I would prefer to keep it that way. I know there will need to...
  6. Matt C.

    MySQL server has gone away

    Before I begin, I'm fully aware that this is a server issue and not a XenForo issue. However, I've tried everything by searching the Xenforo forums, google, etc and nothing seems to work. Hopefully someone can help me out. :) Whenever I try to install addons I always get this error part way...
  7. Neutral Singh

    Composition of MySql Forum Database

    My forum's database has reached 2GB... but lately it is increasing at an alarming pace where as i have not noticed any significant jump in activity over a long period of time... Is there a way to see, what comprises of the database... like how much is the size of the images etc. Is there a...
  8. AppleAndMango

    XF 1.5 External MySQL

    Hello. I'm trying to connect my installation to an external MySQL database which is using SSL. Connecting to the database from my local machine or the VPS running Xenforo when the database server is setup to accept SSL connections only works, however when using the same credentials in the...
  9. Live Free

    XF 1.5 Duplicating custom field choices/values

    I am trying to create a near duplicate custom field - that is, create a new custom user field but duplicate the all of the possible values/choices of an existing through a MySQL query, rather than manually recreating the questions (due to the number of choices this would take hours). I have a...
  10. Live Free

    Table size differences - anything look unusual?

    So I thought I was having a database crisis, long story short it doesn't appear I am. I compared table sizes for my current installation and a two week old backup. A few tables seemed to drop in size which caught my eye and I'm not sure if I should be concerned or not. Left columns contain...
  11. H

    MySQL Memory (HEAP) tables and replication

    For those of you who use replication with more than 1 MySQL active server or even the cluster version of MySQL with your XenForo database: How do you handle the tables in default XenForo database which use "Memory" as their table engine? We use a Galera powered replication cluster. As you know...
  12. semprot

    RAM Usage Builds Up Over Time

    Hello. In my dedicated server, i notice that RAM usage builds up over time. For example 2 days ago after running for several months, RAM usage was constantly around 250 GB almost every time (i monitored using script every minute). But yesterday when i decided to upgrade my RAM (i added 128 GB...
  13. Chris Goldsmith

    XF 1.5 database credentials

    I have added a 2nd web server to the config and need to create a database user for the 2nd web head. I do not remember the password I used for the database user. in other forums like phpbb it is stored in a config.php Where can I find that so I can create a new user with the same password?
  14. vlom31

    Please Help! SQL + Caching optimization

    Hi all, I am implementing a live feed on my xenforo homepage, meaning that it shows a list of recent posts, updated in real time, resulting in some heavy sql query(ies) every 1 second.. I am just testing it myself right now, so 1 user, and it's already putting the CPU under pressure, the way...
  15. OperaManiac

    XF 1.5 Is it possible to create new threads using SQL commands?

    What I am basically aiming to do is to create a batch of threads from data stored in spreadsheet. I am looking for advice on whether SQL statements can be created that would create multiple threads on running them. I have the content for title and post content stored in cells of a spreadsheet. I...
  16. Sim

    Fixed Cache or optimise recent comments block query

    I just finished a test import of ZooChat from vB3.8+PhotoPost to XenForo+XFMG, with 423K posts and 277K photos, including 2,219 galleries. My initial testing is quite positive - no major issues so far, even with large numbers of galleries. However, I've found that the Media home page is taking...
  17. thevon

    Add-on Addon parting users.

    So, first off, hello! The site I am working right now has a few kinks that I need to work out. I have found some addons that help out with some of the problems, but here's a new one. I am going to start by going through the process that I want and what I currently have. Currently, when a new...
  18. KevinnTCG

    External MySQL Connection

    I am having trouble finding methods of connecting to a database outside of my web server box, and using data from that to display on a page. Not only do I have no clue how to do it (barely even know how with PHP) but I just need to know a method that is useable, since you cannot use PHP...
  19. bloop

    XF 1.4 Please Look Over my.cnf, Getting Random White Pages

    When I click a link on the forum (eg. thread, forum index page, member section, etc) it will usually load as expected but sometimes I''ll get a blank page or the page won't load at all and stay at the current page with nothing clickable. This started happening after I changed my.cnf, but I'm...
  20. Tim Jay

    Should I leave cpanel? General server optimization

    I have been using cpanel/whm on centos for years now and I would like to make a change. I'm a little tired of the apache /mysql combo as it seems to become sluggish as time goes on. Cpanel has always been nice and provides some decent tools here and there but I think it hogs too much of the...