Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
2k views

“SQL engine 'mysql' not supported” with saslauth

I'm having trouble authenticating incoming SMTP authentication to my postfix server (using Cyrus SASL with a MySQL backend). In my auth.log I get: postfix/smtpd[3389]: sql auxprop plugin using mysql ...
0
votes
1answer
215 views

Is it possible / avaliable to Upgrade to MySQl 5.5 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? Upgrade to MySQL version 5.5? If so. It is not in the synaptics package ...
1
vote
2answers
3k views

How can I load XML data into a MySQL database?

On Windows, I can use this statement to load XML data into the database: LOAD XML LOCAL INFILE 'c:/users/yourname/desktop/myfile.xml' INTO TABLE MyTable ROWS IDENTIFED BY '<product>' ...
10
votes
1answer
27k views

How do I enable the mod_rewrite Apache module for Ubuntu 11.04?

In other linux like CentOS, it works but i am not getting it running in Ubuntu 11.04. /var/www/html/folder/public/.htaccess: Invalid command 'RewriteEngine', perhaps misspelled or defined by a module ...
0
votes
2answers
971 views

Terminal says 'Broken package' when using apt-get to install phpMyAdmin

I have tried to install phpMyAdmin using the sudo apt-get install phpmyadmin command> The terminal says that there are "uninstallable" dependencies, therefore the package is broken.Perhaps the ...
3
votes
3answers
359 views

What to use to monitor MySQL for corrupted tables?

What is a good program to monitor mysql tables for corruption, one that would email me as soon as there is a corrupted table? I'm not looking for mysql workbench or admin to manage the database. But ...
1
vote
3answers
981 views

Having a problem to send message to gmail from our mail server

We use Ubuntu Server and in a days I have installed and configured Postfix+Dovecot+MySQL as it is explained here. From that tutorial I escaped creating certificates and antispam application. Right now ...
2
votes
1answer
187 views

Is there a solid howto for replacing MySQL with Maria in the LAMP stack?

I've heard great feedback on a few folks migrating production machines (including from this question), and I'd like to test the transition in our dev environment. Maria is apparently in the 11.10 ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
1
vote
0answers
440 views

MySQL upgrade options for 11.04? [closed]

As of yesterday I have brought up a new website running on Ubuntu 11.04 (on Linode). The customer was unhappy with the previous vendor and I have brought across their Django site, moving from Python ...
9
votes
6answers
13k views

How to stop mysql from running at boot time?

How could I stop Mysql from running at boot time? Is there any GUI for that or this must be done through console? It's Ubuntu 10.10
3
votes
4answers
7k views

Problem installing mysql, error in post-installation script

Having problems loading/installing mysql Here is the output while installing: mysql-server-5.1 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 0 B/6,258 kB of archives. ...
6
votes
1answer
8k views

Where are the MySQL InnoDB log files stored?

I changed some settings for my InnoDB tables in MySQL and encountered the problem that InnoDB was not shown in SHOW ENGINES output. As an answer I got the suggestion to delete the log files of InnoDB. ...
1
vote
2answers
7k views

Installing old MySQL server 4.1 on Ubuntu 11.04

how do I need to install mySQL server 4.1 on Ubuntu 11.04 server for a legacy app to run (it breaks on mySQL 5). sudo apt-get mysql-server-4.1 doesn't work - "package is missing, obsoleted or ...
1
vote
2answers
869 views

phpmyadmin installed but not opening? [duplicate]

Possible Duplicate: phpmyadmin is not working after I installed it I have ubuntu 11.04. I installed lamp So i automatically got things like mysql , php , apcahe which are needed for it. ...
2
votes
1answer
6k views

Installing MySQL 5.1

this question is surely a dupe of http://stackoverflow.com/questions/1632056/how-do-you-install-mysql-5-1-on-ubuntu-8-10 Since I can't comment on that one...I am starting a new one. I'm having the ...
7
votes
3answers
876 views

What to install for mysql?

I am going to learn mysql by myself, so I would like to install mysql on . But there are many applications related to mysql in synaptics. I was wondering what are some basic applications to be ...
0
votes
2answers
2k views

Having problems getting LAMP installed

Okay, this is like my fifth time trying to get LAMP set up on Ubuntu, and yes, that includes using XAMPP. (All I want to do is practice my PHP so I can write WordPress plugins! sob Why does the ...
5
votes
1answer
629 views

File access: open fails for one program but not another

This is the most unusual thing. I'm trying to start up mysqld with a different my.cnf (so I can have two MySQL daemons running without conflict). The file is /etc/mysql/my2.cnf but mysql won't open ...
-1
votes
4answers
9k views

How do I start/stop mysql in XAMPP?

I installed XAMPP. Now the problems are I can not start mysql root@ubuntu:/# sudo /opt/lampp/lampp startmysql XAMPP: Starting MySQL... XAMPP: Couldn't start MySQL! I can not put my projects so i can ...
2
votes
1answer
3k views

Problem running multiple MySQL instances

I'm trying to run multiple instance of mysql 5.1.49 on ubuntu 10.10 to setup a replication/backup database. I have added following line to /etc/mysql/my.cnf: [mysqld2] server-id = 2 socket = ...
4
votes
1answer
9k views

How do I enable my innodb

I need to enable innodb on my ubuntu server 10.04 and having tons of problems, I have tried posting questions everywhere and I have no answers....i tried this show variables like "%innodb%"; ...
2
votes
2answers
423 views

lamp-server wants to install mysql but i want it to use already installed MariaDB

i want to install lamp-server in ubuntu 10.10 (the end goal is to install redmine), i am using sudo tasksel install lamp-server However after downloading packages it asks for a root password for ...
1
vote
2answers
610 views

Backing up MySQL Database (Up to a month or while theres space)

I am backing up my files using deja-dup. But how do I do the same with MySQL? I see some cron scripts, but that will keep backups forever. I thought the feature of deja-dup that allows backups to be ...
4
votes
1answer
3k views

Is MySQL server installed by default?

I have a fresh installation of Ubuntu 11.04. Since I want to work with a MySQL server on this machine I see, that if I enter mys in the terminal and hit TAB it completes to mysql. But if I do mysql -u ...
28
votes
7answers
89k views

How to install MySQL workbench?

Installing MySQL workbench on 10.04 or 10.10 is not a problem, as the deb packages are available on MySQL's website. But there is no 11.04 deb package available. So, how do I install MySQL workbench ...
1
vote
2answers
2k views

Issues with Java's JDBC (MySQL) for linux - Crontab job causes connection failure in java program, but when run manually is fine

So as the title states, Ive got an issue with Crontab and my Java program connecting to a remote MySQL database. The program itself is quite simple: it connects to the database, grabs two tables ...
6
votes
1answer
12k views

How can I export MySQL database manually - without phpmyadmin [closed]

My phpmyadmin doesn't work, i see only white blank page when i open it(it's has some issue), However, I'd like to export my project databased manually to another computer. i saw all my databases ...
2
votes
0answers
433 views

How to setup LAMP environment? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I have been using XAMP in windows for a long time. Recently I have moved to Ubuntu and now want to have a similar ...
7
votes
2answers
8k views

MySQL Automatic backup tools

I use back-in-time for backuping up my projects. but my Database's are not included. I'd like to backup all database's scheduling by day or hours. Is there any tool to backup MySQL automatically?
0
votes
1answer
1k views

How to take daily backup of database?

Hey I am using mysql in ubuntu along with 15 more ppl who also has root privilege. I am afraid they might accidentally tamper with the database, so I want to take a daily and hourly incremental ...
30
votes
6answers
37k views

how to stop apache2, mysql from starting automatically as computer starts?

My os is 11.04. I have apache2 & mysql installed. How to stop apache2, mysql from starting automatically as computer starts?
2
votes
2answers
2k views

How do I install MySQL workbench?

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
6
votes
9answers
12k views

Are there any GUIs for Mysql? What is recommended? [duplicate]

Possible Duplicate: MySQL GUI Tools I am looking for a mysql GUI for ubuntu 11.04. I am looking for one with a feature set comparable to sqlyog for windows. Does anyone have any ...
3
votes
1answer
2k views

How to avoid mysqld to start on boot

In my laptop I have installed a LAMP environment for developing PHP apps. I would like to prevent these services (Apache, Mysql,..) starting on boot. For apache is pretty simple to avoid it: sudo ...
8
votes
5answers
19k views

What is a good MySQL manager?

On Windows, I use SQLyog. And I am new to Ubuntu. Is there a mysql manager programs as good as SQLyog ?
2
votes
2answers
748 views

Using Upstart after building Apache & Mysql from source

I'm using Ubuntu 10.10, Apache 2.2.17 and Mysql 5.5.10. I need some assistance getting Apache and Mysql running on boot. Reading the getting started over at upstart website attempting to get it to ...
5
votes
4answers
27k views

“Can't connect to local MySQL server through” socket error [duplicate]

I install mysql and try start /usr/local/mysql/bin# ./mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) /usr/local/mysql/bin# Any Idea?
3
votes
2answers
20k views

How to Bind to Static IP address in MySQL

I have an Ubuntu server and I've installed MySQL. How would I use my two physical static IP addresses in my.cnf bind-address -- can I add two IP addresses?
4
votes
1answer
4k views

Make apt-get install an older version

I'm trying to downgrade mysql from 5.1 to 5.0. After running apt-get remove mysql-server-5.1 I am attempting to run apt-get install mysql-server-5.0. It says: Note, selecting 'mysql-server-5.1' ...
2
votes
1answer
270 views

Ubuntu generated new mysql configs

I deleted /etc/mysql, everything in it. I tried: apt-get --purge remove mysql-server Then: apt-get install mysql-server They will not return, how do I get them to? There seems to be some very ...
0
votes
1answer
4k views

How to run mysql commands through shell script?

mysql -u root -pmysql; SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows", ROUND((data_length + index_length)/1024/1024,2) AS "Total Size Mb" FROM information_schema.TABLES WHERE ...
0
votes
1answer
899 views

Does mysqldump return a status?

I am creating a script that backups a mysql db using the mysqldump utility. I am writing this script in the shell "sh". I would like to capture the output status of mysqldump in the script (i.e. if ...
1
vote
6answers
2k views

How to install Ruby on Rails and MySql?

How to install Ruby on Rails and MySql on my Ubuntu 10.04 OS?
0
votes
2answers
2k views

Installing mysql causes Error 2002 error

I tried installing mysql server a couple of times and I'm having problems. First of all, when I install it gives me a message that it's setting up and it just hangs. I can't ctl + c out of it, so I ...
0
votes
1answer
149 views

What should I do for change connection from other network computer mysql to my computer mysql?

What should I do for change my connection from other network computer mysql to my computer mysql? My computer run web application with his apache local server and mysql that located in other ...
1
vote
1answer
6k views

How restore /var/lib/mysql after i delete it?

How restore /var/lib/mysql (UBUNTU 10.04) after i delete it? History: delete /var/lib/mysql folder paste new /var/lib/mysql folder with wrong files delete again /var/lib/mysql folder clean + ...
0
votes
1answer
383 views

Which version of percona db package should I install?

I am new to both percona & Ubuntu. According to this page percona is only available for etch hardy lenny lucid maverick squeeze But i am using 11.04 (Natty). Can someone recommend me which ...
4
votes
1answer
2k views

Install MySQL without apt-get

I want to install MySQL but my internet connection is very slow so I decided to download the database from the MySQL site. I have read this question, but I don't have any friends using Ubuntu.
1
vote
2answers
782 views

Log & monitor mysql databases on servers [closed]

How MySQL databases logged and monitored on ubuntu servers in real time?. I checked /var/log/mysql.log and found it empty. EDIT 1: The log was not enabled in the mysql configuration file. Now it ...