Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

21
votes
7answers
65k 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
1k 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
9k 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
427 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 ...
5
votes
2answers
6k 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 ...
29
votes
5answers
32k 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 ...
7
votes
5answers
14k 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
693 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
21k 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
16k 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
254 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
745 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
5answers
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
1k 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
145 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
5k 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
378 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
681 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 ...
1
vote
1answer
2k views

How to install mysql DB while offline?

I have downloaded mysql-5.5.9-linux2.6-i686.tar.gz file. I don't know how to install it into my Ubuntu os. I don't have an internet connection, I'm posting here from browsing center. I can download ...
1
vote
1answer
296 views

Remote connection problem

Hello I have ubuntu 10.04 installed with mysql on it and I have a problem with remote connection. When I connect through putty it works but sometimes it looks like it hangs for example when I ...
9
votes
1answer
3k views

Can I share MySql database files with Windows on dual boot?

I'd like to use in both Ubuntu and Windows (dual boot) my MySql database files residing on a NTFS partition. Will it work? Any gotchas?
3
votes
2answers
3k views

How to fetch the latest version of MySQL using tools like APT? [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? This fetches revision 5.1 only: sudo apt-get install mysql-server but ...
1
vote
0answers
2k views

PPA for MySQL 5.5 underway? [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? Are there any efforts in this direction? PostgreSQL 9.0 is already available ...
3
votes
2answers
4k views

How do I pin a particular MySQL version to avoid unnecessary upgrades?

I'm running a MySQL server, and want to keep it up to date with regular apt-upgrades. I don't want this to cause MySQL to upgrade unless I'm doing it during scheduled downtime! How do I alter my ...
1
vote
2answers
419 views

Jabbler instant messaging implementation with mysql for a LAN?

how to how do I configure a Jabber IM server on Ubuntu and how do I test with users on LAN?
2
votes
1answer
1k views

Why is mysql unable to configure?

I try to install mysql-server on my Ubuntu vps server, and it's able to install, but not to configure. If it tries to configure I get this: > ...fail! invoke-rc.d: initscript mysql, action ...
9
votes
5answers
27k views

How to configure phpMyAdmin to access multiple servers?

What is the Ubuntu way to configure phpMyAdmin so that I can use it to administer multiple MySQL servers? The database parameters are set in /etc/dbconfig-common/phpmyadmin.conf, but there's only ...
6
votes
2answers
1k views

How to access MySql on Windows from Ubuntu?

Is it possible to have the actual MySQL database installed on Windows and access it from Ubuntu 10.10 on the local network? I think I need a MySQL "client" ? So I looked here (MySQL Linux0Generic), ...
2
votes
1answer
1k views

Installing/configuring mysql server nightmare

I've never had problems installing and configuring mysql server in kubuntu but now it's just being stubborn, here's my issue: I installed the packages mysql-server, mysql-client (both 5.1), the ...
0
votes
1answer
1k views

How do I build MySQL server (5.5.8 is current latest) [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? How do i build MySql server? i was hoping for ./configure;make;make install ...
1
vote
1answer
272 views

How do I configure Ruby on Rails to Always use mySQL as the default database?

How do i configure Ruby on Rails to always use mySQL as the default database? I am a newbie and i just installed Ruby on Rails and mySQL and by default ROR uses sqlite3, but when I configure the db ...
12
votes
7answers
33k views

How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get?

How would I go about upgrading MySQL to version 5.5 on Ubuntu Server 9.10? Would I be better off waiting for it to be an easy $ sudo apt-get install mysql-server job? I'm also unsure as to which ...
3
votes
3answers
4k views

Installing MySQL Ruby Gem

Hi I am unsuccessfully trying to install MySQL Gem on Ubuntu 10.04. I have tried the following commands: sudo gem install mysql sudo gem install mysql -- --with-mysql-config=/usr/bin/mysql_config ...
0
votes
3answers
262 views

I want to install and get to building a personal MySQL DB

So how do I go from installing MySQL from the Software Center to inputing data into fields and bringing in a comma delimited file? I've only had brief experience with MSAccess and OOo Base a long time ...
3
votes
1answer
645 views

Roll-your-own mysql-server (.deb) files and MySQL root password

I know I can make my own .deb files of an installation. However, during a normal mysql-server install, the root password gets asked for and we need to do a 1-click rollout without ANY interaction. It ...
5
votes
2answers
5k views

MySQL server Upstart script not working on boot

For some reason the Upstart script for the MySQL server isn't working when I boot my server, however it does work once the server has booted and I execute sudo start mysql manually. I'm running an ...
0
votes
3answers
9k views

Installing phpMyAdmin from repository, 403 Forbidden error

I have installed phpMyAdmin from the repositories, but I get 403 forbidden when I access http://localhost/phpmyadmin/index.php Apache is running fine, and so is PHP (I'm using apache2-mpm-worker with ...
10
votes
2answers
7k views

Different locations for MySQL databases?

Can I configure MySQL to store a specific database in a separate place on disk? I still want any new databases to go to the default location, but there's a specific database that I'd like to have ...
4
votes
4answers
742 views

Installing and setting up MySQL?

I have been trying to install MySQL on Ubuntu 10.10 and just can't get it to work. I installed it by running sudo apt-get install mysql-server and once that was done, when I try mysql I get the ...
0
votes
2answers
544 views

Apache server A attempts conn to mysql server B. times out [closed]

I have an apache web server running PHP. I am trying to make a connection from apache server to a database server running mysql server. Heres a run down of the settings in place. apache server: ...
3
votes
1answer
384 views

Why does mysql process starts on boot?

As you can see, mysql exists only in the /etc/init.d directory and not in /etc/rcN.d, therefore it shouldn't start on boot. $ sudo find /etc -regex ".*\(rc.*d\|init\.d\).*" | sudo grep "mysql" | sort ...
4
votes
1answer
1k views

Vi in MySQL for command editing

When using the MySQL command line interface, is there any way to get it to let you use vi command editing keys instead of emacs?
4
votes
1answer
2k views

Install old version of mysql in 10.10

I'm using Ubuntu 10.10, but I find that this project is having issues with the version of mysql server that 10.10 installs. I have another machine running the same build of this project but it's ...