Menu

Tag Archives:mysql

Home / Tag: mysql

[solved] MySQL – Got a packet bigger than ‘max_allowed_packet’ bytes

[solved] MySQL – Got a packet bigger than ‘max_allowed_packet’ bytesYou see the following error while executing a MySQL query:ERROR 1153 (08S01) at line 138: Got a packet bigger than max_allowed_packet bytes SolutionOpen your my.cnf file – on Debian/Ubuntu, it’s /etc/mysql/my.cnf, on Fedora/RedHat/CentOS, it’s /etc/my.cnf – and search for the max_allowed_packet line.I suggest you play around with its value a bit – double or quadruple its value, restart MySQL – on Debian/Ubuntu, the command isservice mysql restart… and on Fedora/RedHat/CentOS, the command isservice mysqld restart- and see if

Read More »
How To Migrate Joomla Content (Articles) Using phpMyAdmin

How To Migrate Joomla Content (Articles) Using phpMyAdmin

On this pageHow To Migrate Joomla Content (Articles) Using phpMyAdminHow to Export Article Content on the old Joomla 1.5 site?
How to import Article Content on the new Joomla 1.7 site?How To Migrate Joomla Content (Articles) Using phpMyAdmin
Joomla is a very popular Content Management System (CMS). This article applies to Joomla 1.5 content (Article) migration to Joomla 1.7 using phpMyAdmin database tool.How to Export Article Content on the old Joomla 1.5 site?Login to phpMyAdmin database tool on the old site. (Database account settings can be found on Joomla configuration.php file.)
Select th

Read More »

MySQL – mysqldump: Got error: 1016: Can’t open file: ‘./exampledb/xxx.frm’ (errno: 24) when using LOCK TABLES

This article will show you how to solve the following problem:Error: MySQL – mysqldump: Got error: 1016: Cant open file: ./exampledb/xxx.frm (errno: 24) when using LOCK TABLESThis issue can happen when you try to create a MySQL database dump with the mysqldump command on Linux:mysqldump -u root -pmysecretpassword –opt exampledb > exampledb.sql[email protected]:/tmp/mysql# mysqldump -u root -pmysecretpassword –opt exampledb > exampledb.sqlmysqldump: Got error: 1016: Cant open file: ./exampledb/xxx.frm (errno: 24) when using LOCK TABLES[email protected]:/tmp/mysql# Solution for the mysqldum er

Read More »

How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTS

How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTSThis tutorial is based on my experience setting up Tungsten Replicator and MySQL-Proxy for a client’s production setup. 1. My SetupFor the tutorial I’ll be using 3 virtual machinesWeb Server 1: web1 IP Address 192.168.56.101Master 1: master1 IP Address 192.168.56.10Master 2: master2 IP Address 192.168.56.11 2. Set Up Web Server$ sudo su$ taskselSelect LAMP server and click OK. 3. Configuring MySQLProxy On The Web Server$sudo apt-get -y install mysql-proxy$vi /etc/default/mysql

Read More »

Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3

Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3Version 1.0Author: Till Brehm This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 6 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers and Unison will be used to Sync the /var/www (websites) and /var/vmail (email account data) folders. 1 Setting Up The Two Base SystemsIn this

Read More »

Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources

Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From SourcesThis tutorial shows how to create a portable MySQL installation on GNU/Linux. It applies to:MySQL 5.5.19CentOS 6.x / Ubuntu 11.10 Oneiric OcelotAt the end of this guide you will obtain a portable MySQL installation on a target directory with its own databases, binaries, logs, pid files, etc.  Consider always the use of a permission preserving packaging (like TAR) for moving the installation between systems or removable storages. RequirementsDownload MySQL 5.5.19 source code (mysql-5.5.19.tar.gz) from MySQL siteA previousl

Read More »
Build A Free, Full-Featured Mail Server On Gentoo Linux With iRedMail

Build A Free, Full-Featured Mail Server On Gentoo Linux With iRedMail

Build A Free, Full-Featured Mail Server On Gentoo Linux With iRedMailSummaryWe’re going to set up a free, full-featured mail server on Gentoo Linux, all mail service related components are free and open source, and you own all data. The installation process is extremly easy and smooth.By following this tutorial, you will have below major software and services ready for production use:Postfix: SMTP serviceDovecot: POP3/POP3S, IMAP/IMAPS, Managesieve serviceApache: Web serverMySQL: Storing mail accounts and application dataAmavisd, SpamAssassin, ClamAV: Anti-spam, anti-virusRoundcube: WebmailAws

Read More »

How To Back Up MySQL Databases With mylvmbackup On Debian Squeeze

How To Back Up MySQL Databases With mylvmbackup On Debian Squeezemylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM’s snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on a Debian Squeeze server.I do not issue any guarantee that this will work for you! 1 Preliminary NoteI’m assuming that MySQL is already set up and running on your system. The system must u

Read More »
Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)

Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support.I do not issue any guarantee that this will work for you! 1 Preliminary NoteIn this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100. These settings might differ for you, so you have to replace them where appropriate. 2 Installing MySQL 5To install MySQL, we do this:yum install mysql mysql-serverThen we create the system st

Read More »
Virtual Hosting With vsftpd And MySQL On Debian Squeeze

Virtual Hosting With vsftpd And MySQL On Debian Squeeze

Virtual Hosting With vsftpd And MySQL On Debian SqueezeVsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.For the administration of the MySQL database you can use web based tools like phpMyAdmin which will also be installed in this howto. phpMyAdmin is a comfortable graphical interface which means you do

Read More »