sql

  1. T

    cron Job for an SQL query

    Hi guys, I wondered if anyone could help us out. We have an SQL database running on a linux server and wish to regularly run SQL queries on it. It's basically to replace foreign characters which are somehow written to our database from the front-end forms. A typical SQL query we'd like to run...
  2. L

    cpanel shows sql database size 0

    hi i have recently installed cpanel . it shows mysql database size "0" , i havent changed any permission . everything is like yesterday . in /var/lib/mysql the permissions are 700 AND owner/group is mysql:mysql sites are working fine with databases.only cpanel shows wrong db size . What...
  3. M

    Cpanel SQL Backup only 1kb ?

    Hello all, I am having a problem backing up a website I own:confused: Basically I log in to cpanel and click the Databases backup and it downloads:) I then check the file.gz and its only 1kb in size? I know for a fact the database is around 30mb. I then decide to click on the "Download or...
  4. I

    Lost sql database password

    i was using a phpbb forum, an error occured so i deleted my all files, but forgot to backup config.php in which sql database password is stored. Now config.php is shown in legacy file manager deleted files but it is not restored. Now tell me the way to clear sql db password or to restote it.
  5. M

    SQL Access & SSL Problem

    Guys, Forgive my lack of knowledge, but I've tried to research this online and ended with a headache and no further forward, so I think consulting the experts would be the next step. I have a VPS set up, and will be hosting multiple sites. Now the programmer wants to run all the sites (which...
  6. A

    2 Servers one for sql and another for forum files

    Hello I was wondering how can i setup this scenario as many users recommend it in high traffic forums. 1)Let's say server one for my forum files (php) i will need a server using Centos and cpanel and nothing else i think or... 2)Second server must have centos (32 or 64bit does matter?)...
  7. L

    Sphinx SQL search engine

    Is anyone familiar with installing Sphinx SQL search engine? I'm just a bit concerned since its not a Control Panel installed add-on. It's required for a new app that im having developed.
  8. P

    Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in ...

    Do you know how to solve this issue, occurring when restarting cpanel with "service cpanel restart"? The file /var/cpanel/sql/eximstats.sql contains many SQL queries related with email send stats like "INSERT INTO smtp (mailtime,msgid,email,processed)...
  9. L

    httpd and sql errors....

    I have reciently bought a new server, cpanel is installed, however httpd and mysql wont run. these are the errors; mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and...
  10. K

    Postgre SQL restrictions?

    Hello all. We are new to cPanel and was wondering if there was a way to restrict Postgre SQL to the higher end plans. We want to limit the number of PostgreSQL databases separately from MySQL databases so that for different packages we can allow different numbers for each. Thanks! :)
  11. P

    cpanel or WHM sql prob?

    hi. i recently took delivery of server running WHM 10.8.0 & cPanel 10.8.1-R113 with MySQL 4.1 phpMyAdmin 2.6.4-pl2. the problem i have is i setup account in WHM with shell access and no restrictions or quotas. logged in to cPanel. Created mySQL db - user/pass connection=localhost with ALL...
  12. P

    cPanel or WHM sql prob?

    hi. i recently took delivery of server running WHM 10.8.0 & cPanel 10.8.1-R113 with MySQL 4.1 phpMyAdmin 2.6.4-pl2. the problem i have is i setup account in WHM with shell access and no restrictions or quotas. logged in to cPanel. Created mySQL db - user/pass connection=localhost with ALL...
  13. D

    Best way to transfer vb and sql and other files

    Do you know of a best way to transfer vbulletin, sql and other files on a server that doesn't run Cpanel to a Cpanel server?
  14. K

    SQL Injection exploit Advanced Guest Book v2.2

    The AGB 2.2 appears vulnerable to SQL Injection granting the attacker administrator access. The attack is very simple and consists of inputting the string detailed below, leaving the username entry blank: ') OR ('a' = 'a I develop a fix to this issue (other alternative is upgrade to a...