Archive for February 2012

Dynamic MMap ran out of room. Please increase the size of APT::Cache-Limit. 29.02.12

E: Dynamic MMap ran out of room. Please increase the size of APT::Cache-Limit. Current value: 25165824. (man 5 apt.conf)
E: Error occurred while processing yatm (NewVersion1)
E: Problem with MergeList /var/lib/apt/lists/mirror.positive-internet.com_debian_dists_squeeze_main_binary-i386_Packages
W: Unable to munmap
E: The package lists or status file could not be parsed or opened.

These errors occur when adding new apt source list.

Solution :

Add the following line to either /etc/apt/apt.conf or /etc/apt/apt.conf.d/70debconf

APT::Cache-Limit “83886080”;

Install xdebug for PHP5 in Ubuntu 23.02.12

  • Ubuntu Server
  • Comments Off on Install xdebug for PHP5 in Ubuntu
  • 0
  • This is the easy way:

    sudo apt-get install php5-xdebug

    Change the php.ini:

    sudo vi /etc/php5/fpm/php.ini

    display_errors = On
    html_errors = On

    And restart apache/nginx

    Backup MySQL Database in Linux 23.02.12

  • Ubuntu Server
  • Comments Off on Backup MySQL Database in Linux
  • 0
  • mysqldump –opt -u [uname] -p[pass] [dbname] > [backupfile.sql]

    [uname] Your database username
    [pass] The password for your database (note there is no space between -p and the password)
    [dbname] The name of your database
    [backupfile.sql] The filename for your database backup
    [–opt] The mysqldump option

    To backup a database named ‘Tutorials’ with the username ‘root’ and with no password to a file tut_backup.sql, you should accomplish this command :

    mysqldump -u root -p Tutorials > tut_backup.sql

    Specify certain tables of your database you want to backup :

    mysqldump -u root -p Tutorials php_tutorials asp_tutorials > tut_backup.sql

    To back up more that one database at once :

    mysqldump -u root -p –databases Tutorials Articles Comments > content_backup.sql

    To back up all databases at one time :

    mysqldump -u root -p –all-databases > alldb_backup.sql

    Restore MySQL Database in Linux 16.02.12

  • MySQL
  • Comments Off on Restore MySQL Database in Linux
  • 0
  • mysql -u username -p database-name < /path-to/file-name.sql;

    Flush the DNS Cache on Windows 16.02.12

  • Windows
  • Comments Off on Flush the DNS Cache on Windows
  • 0
  • Dalam Command Prompt, taip :

    ipconfig /flushdns