Jump to content

Support Our Free and Open Source Software

Please support us financially so we may continue to keep our software free and best in class



  • Content Count

  • Joined

  • Last visited

  • Days Won


Prodigy last won the day on January 23 2012

Prodigy had the most liked content!

Community Reputation

123 Excellent

About Prodigy

  • Rank
  • Birthday 01/28/1983

Profile Information

  • Gender
  • Location
    The Boondocks
  1. Become a client; http://www.cutorrent.com/
  2. Amount of positive and negative reputation award points that can be given per 24hour period has been adjusted.
  3. Prodigy

    Site Changes

    01/22/12 - Forum UpdatesNew Theme Added - devCU Sleek Members now have the ability to select between themes; devCU Open and devCU Sleek.
  4. Prodigy


    All forums will be public and viewable to both members and non-members. However only registered members are allowed to post new content and reply to existing content.
  5. These scripts will take the backup of a given database using a dated naming convention TODAY=DBname`date +%d-%m-%y`TODAY=$TODAY.sql#dest_dir keeping the backu locallydest_dir=/home/installation/backup/#arch_dir is the place folder ftp locationarch_dir=/home/installation/ftp/mysqldump -B <DB> -r$dest_dir$TODAY -u<DBuser> -p<pwd> #tar cvf – $dest_dir$TODAY | gzip > $arch_dir$TODAY.tar.gz]# moving to local backup directorycd$dest_dir#removing old ftp backuprm -rf$arch_dir/*tar czvf$arch_dir$TODAY.tar.gz$TODAY
  6. MySQL permission sets required most of the time.Create a user and grant all the access to that database mysql> create database demo; Query OK, 1 row affected (0.00 sec) mysql> grant all on demo.* to demouser@localhost identified by 'demopass'; Query OK, 0 rows affected (0.00 sec) Permitting a user to create Views and routine ( most user level privileges) mysql> grant select, insert, update, delete, create, drop, index, alter, create temporary tables, lock tables ,CREATE VIEW,CREATE ROUTINE,REFERENCES, EXECUTE, ALTER ROUTINE on demo.* to demouser@localhost identified by 'demopass'; Query OK, 0 rows affected (0.00 sec) Granting MySQL remote access to a user on a particular IP mysql> grant all on demo.* to demouser@ identified by 'demopass'; Query OK, 0 rows affected (0.00 sec) Removing a user mysql> drop user demouser@localhost ; Query OK, 0 rows affected (0.00 sec) Sometimes PMA doesn’t allow you to login even you are granting local access (localhost) to user. In that case, you may need to grand the system IP to access the database and configure system IP in the place of “localhost” in config.inc.php file. Creating a read only user. mysql> grant select on demo.* to readonlyuser@localhost identified by 'pass'; Query OK, 0 rows affected (0.00 sec) Creating a MySQL slave user with replication privilege mysql>GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY 'pass'; Want to enable General logs in MySQL...It is a very rare scenario to check the MySQL SQL logs to identify the SQL execution happening most often and optimizing the code accordingly. Most of the time certain queries are talking too much time and waiting to get execution completed from the MySQL engine. These SQL queries are still running in memory which may affect the MySQL performance badly. We can identify such a query easily by adding the following entries in my.cnf file. long_query_time = 1log-slow-queries = /var/log/mysql/mysql-slow.log View the users permissions list.You may use ” Grants for user@serverip” to view the permissions. The following will be the perfect user permission set. This user can‘t use sensitive command like drop,create statement.mysql> show grants for produsr@; Grants for produsr@ GRANT USAGE ON *.* TO 'produsr'@'' IDENTIFIED BY PASSWORD '226d742c' GRANT SELECT, INSERT, UPDATE, DELETE, INDEX ON `DB1`.* TO 'produsr'@'' GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, LOCK TABLES ON `DB2`.* TO 'produsr'@'' Privilege Used for ALL [PRIVILEGES] Sets all simple privileges except GRANT OPTION ALTER Enables use of ALTER TABLE or Database CREATE Enables use of CREATE TABLE or Database CREATE TEMPORARY TABLES Enables use of CREATE TEMPORARY TABLE for Views , trigger and stored procedure DELETE Enables use of DELETE DROP Enables use of DROP TABLE EXECUTE Privilege to create store procedure and executing view, trigger querries FILE Enables use of SELECT … INTO OUTFILE and LOAD DATA INFILE INDEX Enables use of CREATE INDEX and DROP INDEX INSERT Enables use of INSERT LOCK TABLES Enables use of LOCK TABLES on tables for which you have the SELECT privilege PROCESS Enables the user to see all processes with SHOW PROCESSLIST Listing server process list RELOAD Enables use of FLUSH REPLICATION SLAVE Needed for replication slaves (to read binary log events from the master) SELECT Enables use of SELECT SHOW DATABASES SHOW DATABASES shows all databases SHUTDOWN Enables use of MySQLadmin shutdown SUPER Enables use of CHANGE MASTER, KILL, PURGE MASTER LOGS, and SET GLOBAL statements, the MySQLadmin debug Command; allows you to connect (once) even if max_connections is reached UPDATE Enables use of UPDATE USAGE Synonym for privileges GRANT OPTION Enables privileges to be granted
  7. Scripts to backup tables from a database where tables are containing static data which doesn’t change frequently. #!/bin/bash# Created by Liju on 09/03/2011#DB_NAME=’db’USER=’username’PASS=’user_pass’HOST=’localhost’DUMP_LOC=’/storage1/temp’NOW=”$(date +”%d-%m-%Y”)”echo “Fmi daily tables backup started on ” `date` >> /home/installation/scripts/database-backup.logtbl_names=’table1 table2 table3 table4 table5 table6 table7 table8 table9 table10 table11 table12 table13 ‘ mysqldump –max_allowed_packet=1G –add-drop-table -ui$USER -p$PASS $DB_NAME $tbl_names | bzip2 -c > $DUMP_LOC/$DB_NAME-$NOW-tbles_bkp.bz2echo “Fmi daily tables backup has ended at ” `date` >> /home/installation/scripts/database-backup.log
  8. How to enable PHP work with Apache on 64 bit Windows 2008 server Scenario One: Run PMA ( phpmyadmin) on windows server through Apache. After installing PHP (used php windows installer downloaded) Apache wont start. It can start after removing the php library entry from the httpd.conf file.Used : PHP 5.2.14 Windows 64 Installer along with Apache 2.2.3 32 bit installer. Solution : 1. Added php path in system path (c:PHP) and type php -m from the command line. Which throws me file missing error followed by Windows system error closing message. php installs has crashed. 2. Uninstall the PHP from add/remove programs 3. Download php-5.3.8-Win32-VC9-x86.zip and extract it to C:PHP. Rename php.ini-production to “php.ini” 4. Add the following entry in Apache LoadModule php5_module “C:PHPphp5apache2_2.dll” AddType application/x-httpd-php .php PHPIniDir “C:php” 5. Restart Apache. It’s running !!!!!!!!!!!! Scenario Two: Need to enable certain extensions required for PHP to run PMA like php_mysql, php_mbstring and php_mcrypt and the default php.ini won’t enable it. 1. Un comment the lines in “php.ini” respect to each module entry and restart Apache. But not luck extension was not there. 2. Verifiy it by executing #php -mC:UsersAdministrator>php -m PHP Warning: PHP Startup: Unable to load dynamic library ‘C:phpphp_mbstring.dll’ – The specified module could not be found. in Unknown on line 0 bcmathHow to solve this kind of error ??? Extension_dir path was incorrectly set in php.ini and I changed it to [b]extension_dir = “C:PHPext”[/b] then restart Apache.Verify it by >php -m and found the modules listed in it.
  9. Getting an error message while accessing a remote MySQL database running on WAMP? Simple fix is to add “skip-name-resolve” in my.cnf file which will be shown in MySQL installation directory.Since the MySQL server is using WAMP environment, You need to put the same line inside [wampmysqld]. The my.cnf file location will be the “C:wampbinmysqlmysql5.5.8my.cnf” Example: [wampmysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M basedir=c:/wamp/bin/mysql/mysql5.5.8 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp/bin/mysql/mysql5.5.8/ dataskip-name-resolve
  10. Currently the private messaging system is functioning but you will receive an error message after sending a private message. These errors will vary in message. Your messages will still be sent regardless of the errors that are showing. Please bare with us as we work to resolve this issue.RegardsdevCU Staff.
  11. Prodigy

    Were Back!

    As PlanetMaster has stated, we are looking and will be looking for staff members as well as developers. Anyone with interest should contact me via private message for further details.
  • Create New...