Tagged Questions

Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
665 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
295 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 ...
8
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
410 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
26k 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
271 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
227 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
637 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
736 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
521 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
382 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 ...
43
votes
10answers
80k views

MySQL GUI Tools

Does anyone have any good ideas as to native MySQL GUI clients for Ubuntu? So far I've tried MySQL Workbench, which never seemed to work properly, phpMyAdmin which I found a bit slow, and Navicat ...
3
votes
4answers
570 views

MySQL Data Modeling on netbook

Possible Duplicate: ER diagram software Looking for a MySQL data modeling toll, that will actually fit on my netbook screen. The official Workbench needs a higher resolution, so the bottom ...
2
votes
1answer
3k views

Backup mysql from terminal

I have scheduled a cron job to backup mysql databases on ubuntu9.10. I used the following entries in the cron file. 37 4 * * * root /usr/bin/mysqldump -u root -p<mysql-password> --all-databases ...
6
votes
1answer
2k views

why would /etc/init.d/mysql run the wrong upstart job?

update: /lib/init/upstart-job has been replaced with the MongoDB init script. For some reason, /etc/init.d/mysql start|stop|restart|status (/etc/init.d/mysql is simply a symlink to ...
1
vote
1answer
213 views

Adding quotes to a string in a file

I currently have an SQL file filled with insert statements in the form: INSERT INTO database.table(primary_key, foreign_key, url_one, url_two, int_one, int_two, int_three) VALUES ...
20
votes
5answers
22k views

How to I move MySQL data files onto different partition?

I have my hard drive partitioned with two partitions, so I can easily re-install Ubuntu and try out different versions without losing my home directory data. It is setup like this: 20GB -> / ...
69
votes
11answers
10k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...