Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
512 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
380 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
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 ...
41
votes
10answers
76k 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
211 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
21k 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 -> / ...
68
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 ...