Linux Tutorials on the topic “mysql”
-
How To Set Up A Ubuntu/Debian LAMP Server
Author: olddocks • Tags: apache, php, mysql, debian, ubuntu • Comments: 43How To Set Up A Ubuntu/Debian LAMP ServerThis tutorial shows a quick way to set up your own LAMP server (Linux + Apache + MySQL + PHP/Perl) on a Ubuntu or Debian system.
-
Securing the connection between MySQL and MySQL Administrator using an SSH tunnel
Author: Craig • Tags: mysql, security • Comments: 8Securing the connection between MySQL and MySQL Administrator using an SSH tunnelThis is a description of how to set up a secure tunnel between your MySQL Server and a locally running MySQL Administrator using Putty. By creating a secure tunnel to your MySQL server using Putty, you can grant localhost access to powerful applications like MySQL Administrator while at the same time, make your server appear as if it isn't even there. In effect, make your MySQL server disappear from the outside world.
-
How to perform a point in time restoration using ZRM for MySQL
Author: tkr • Tags: backup, linux, mysql • Comments: 0How to perform a point in time restoration using ZRM for MySQL ZRM for MySQL is a powerful, flexible and robust backup and recovery solution for MySQL databases for all storage engines. With ZRM for MySQL a Database Administrator can automate logical or raw backup to a local or remote disk. In this How To, we attempt to explain how to recover from an user error at any given point in time.
-
-
MySQL Backup And Recovery With mysql-zrm On Debian Sarge
Author: Falko Timme • Tags: backup, debian, mysql • Comments: 5MySQL Backup And Recovery With mysql-zrm On Debian Sarge This guide describes how to back up and recover your MySQL databases with mysql-zrm on a Debian Sarge system. mysql-zrm is short for Zmanda Recovery Manager for MySQL, it is a new tool that lets you create full logical or raw backups of your databases (regardless of your storage engine and MySQL configuration), generate reports about the backups, verify the integrity of the backups, and recover your databases. It can also send email notifcations about the backup status, and you can implement multiple backup policies (based on your applications and based on time (e.g. daily, weekly, etc.)).
-
MySQL Replication On The Same Machine
Author: sheikhsa • Tags: mysql • Comments: 2This How To explain the replication in MySQL on the same machine. You have large hits, with database driven site and performance, redundancy, security now comes in mind. DBA is now input by many fingers to seek some good solution to make happy faces. So here comes words like Cluster, Replication, Backup, Fail Over and others. So what these are? We currently discuss Replication in terms of a web based database driven site for large hits.
-
How do I make an sql dump of a MySQL database on the command line?
Author: Falko Timme •
Tags: mysql •
Comments: 2 If your MySQL user has a password: mysqldump -h localhost -u [MySQL user, e.g. root] -p[database password] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql Please note: there's no space between -p and the password!If there's no password: mysqldump -h localhost -u [MySQL user, e.g. root] -c --add-drop-table --add-locks --all --quick --lock-tables [name of the database] > sqldump.sql
-
How do I make my MySQL server use TCP connections instead of Unix sockets?
Author: till •
Tags: mysql, ispconfig •
Comments: 0 Comment out the option skip-networking in the file my.cnf which typically lies under /etc or /etc/mysql. Then restart your MySQL server: /etc/rc.d/init.d/mysql restart or /etc/init.d/mysql restart With netstat -ta you can check if MySQL is reachable via TCP.
-
MySQL 5 In Debian Sarge (Stable ) HowTo
Author: mariuz • Tags: mysql • Comments: 0Configuring mysql 5 in debian sarge (stable ) I needed to run mysql5 on another port on my server with already 2 mysql servers (3.x and 4.x) on itand for this i had to do following steps
