Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

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
3k 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
375 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 ...
7
votes
4answers
20k 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
258 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
32k 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
3k 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
135 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
618 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
8k 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 ...
8
votes
2answers
5k 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
718 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
476 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
375 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 ...
3
votes
1answer
926 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 ...
37
votes
10answers
60k 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
564 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 ...
1
vote
1answer
2k 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
202 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 ...
19
votes
4answers
18k 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 -> / ...