Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
2answers
10k views

Fixing broken myslq-server package after upgrade to 12.04

After upgrade to 12.04 mysql server was unable to start. I tried many different things but without any luck. Now when I try to install it, I get: $ sudo apt-get install mysql-server-5.5 Reading ...
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?
1
vote
1answer
1k 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
2answers
61 views

Unable to locate package libmysql++-dev

root@avidgamers:~/warcraft/aG-HostbotRU/ghost# apt-get install libmysql++-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
1
vote
2answers
281 views

My Postfix server became a spam server. How can I fix this?

I gotten a VPS recently and I wanted to host my own websites and with that, the ability to send and receive mail. I set up my mail server according to this guide: ...
1
vote
3answers
9k views

How to run mysql command from terminal?

I have the following sql command which I usually run in phpmyadmin by selecting the database, then running it in the command window. DELETE FROM `wp_posts` WHERE `post_type` = "attachment" However ...
1
vote
2answers
1k views

What Are Steps To Install MySQL?

To my downloads directory, I have unpacked the MySQL-server-5.6.11-2.linux_glibc2.5.i386.rpm. There is now a /usr directory with /bin, /lib, /sbin, and /share within the /usr. There is also a /etc ...
1
vote
3answers
3k views

How to remove MySQL completely with config and library files?

I tried everything till now: sudo apt-get remove mysql-server mysql-client mysql-common sudo apt-get purge mysql-server mysql-client mysql-common sudo apt-get autoremove and even more commands... ...
1
vote
2answers
3k views

jdbc 4.0 in Ubuntu 12.04

I'm developing an application using Java and MySQL. I've installed libmysql-java package as a database connector, but the installed connector implements version 3.0 of the JDBC specification. Does ...
1
vote
1answer
2k views

Is multiple mysqld processes for 1 mysql server is normal?

I'm not an server administrator, but i would like to know why on the server i have like 10 myslq instances? Is it good or bad? Does it negatively impact speed of my website? Here's screenshot: ...
1
vote
2answers
346 views

Are Apache, PHP and MySQL installed by default?

Are the Apache server, PHP, and MySQL installed by default when you install Ubuntu 13.10, or should you install them separately later? Original question: Quiero saber si en la instalación de ...
1
vote
1answer
514 views

Script to enter data from mysql database into text file

I have written a script to extract the contents of a table into a textfile. this is my code #!/bin/bash mysql -uroot -ppasswd database select * from table>textfile.txt i have changed ...
1
vote
3answers
2k views

Any apt command not found [closed]

I'm trying to install various packages, such as mySQL, but whenever I try to do "sudo apt-get install mySQL" it says that the command cannot be found. I only have access to the box via SSH, so any ...
1
vote
1answer
2k views

How to install the mysql connector for C#?

I installed Wine and now I have setup Mono & .NET When I try to compile the next sentence, I get an error because I don't have the MySQL connector installed on my system. using ...
1
vote
1answer
1k views

Apache / MySql is not running. What is wrong?

I installed lampp / xampp on my Ubuntu 12.04. After installing, Apache and MySQL were running properly. Now, they're not. Here's what I get when I try to run apache: Command: /etc/init.d/apache2 ...
1
vote
2answers
326 views

Why do the “iodbc” and “libmyodbc” packages conflict with each other? [closed]

When I install iodbc the libmyodbc package is removed, and I don't understand why. Does anyone have an explanation?
1
vote
4answers
2k views

Mysqld not starting on boot?

After upgrading to Pangolin, mysqld is not starting on boot. I've looked into various other MySQL issues with the Pangolin release, and I haven't seen the same issue that other people are having ...
1
vote
1answer
3k views

Connecting to MySQL in Bash (without MySQL installed)

I am trying to connect to a remote MySQL database in Bash. On the server hosting the database I can type: mysql -u _username_ -p to connect. I would like to be able to type: mysql -h _host_ -u ...
1
vote
2answers
6k views

mysql problem '/var/run/mysqld/mysqld.sock'

I got this error on my php script with db: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and on phpmyadmin: #2002 Cannot log in to the MySQL server What is ...
1
vote
1answer
1k views

Can't get MySQL workbench to work

I've installed Ubuntu 11.10 and can't seem to get MySQL workbench to work. I have tried installing both versions from the website by downloading the .deb files for ubuntu 10.04 and 11.04, but both ...
1
vote
2answers
4k 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
470 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 ...
1
vote
1answer
259 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 ...
1
vote
1answer
46 views

Where is mysqldbcompare?

The MySQL docs refer to a utility mysqldbcompare. But it doesn't seem like I have it installed, and when I type mysqldbcompare it doesn't suggest any packages (Ubuntu 12.04). Where can I find this ...
1
vote
1answer
45 views

How can I determine the available amount of disk space when using a charm?

When using juju to deploy a DB, how can I determine the available amount of disk space when using the DB charm? Suppose that I'm using EC2 (or anywhere else) to deploy a PostgreSQL/MySQL/WhateverDB ...
1
vote
1answer
184 views

How can I import multiple .sql files into MySQL?

In my folder, I have a lot of *.sql files... How via one command I can import them? For example; is something like this possible? mysql -u root -p db_development < *.sql If not, how can I ...
1
vote
2answers
96 views

Cannot compile mysql code

I have the following code #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); exit(0); } ...
1
vote
2answers
863 views

/tmp directory: 0 files but shows full?

Related to another post where I was finally able to delete files within /tmp thanks to another poster. However, in the end the sysadmin had to restore a snapshot of a few days ago to get the mysql ...
1
vote
4answers
11k views

how to correctly install apache2, php5, mysql and phpmyadmin

What is the most correct method of installing apache 2 server, php5, mysql and phpMyAdmin? I installed it this week, and I had a lot problems without solutions, so now that I reinstalled Ubuntu 13.04 ...
1
vote
1answer
82 views

Loading current time into mysql database

I have a query which can enter data into mysql database. However,i would like to have the time of an entry entered as well and that entered time should correspond to server time.I am using Ubuntu ...
1
vote
2answers
52 views

save mysql ouput as text?

I am using Ubuntu 13.04 and installed MySQL Server version: 5.5 . All I want simply , if I doing a MySQL query then its output should have to store in a text file. How can I achieve this ? for ...
1
vote
3answers
409 views

How to get arp tables from switch to server mysql database using snmp

I would like to obtain ARP tables from a switch to a syslog server(Ubuntu 12.04 LTS). I have done some research on how to do it and i decided to use SNMP. I have done some research and i know that my ...
1
vote
1answer
315 views

Backup MYSQL DB on one server and restore on other, do i need the same version of MYSQL?

I backupped my old db on ubuntu 10.10 server using mysql 5.1.49 using mysqldump now I want to restore the file on my other machine, using ubuntu 12.04 server with Mysql version 5.5.32 on it. I ...
1
vote
1answer
1k views

How to install MySQL DB 5.6.12 (downloaded from mysql.com) on Xubuntu (kubuntu-desktop) 13.04?

I have an experience of setting up and running MySQL on Windows. It is really easy. I just downloaded .zip, unpacked it in C:\MySQL, placed C:\MySQL\bin to PATH and then ran the server with the ...
1
vote
1answer
97 views

Create database

I want to create database. I know that I should use the following code: mysqladmin -h localhost -u {username} -p create lrs I don't know if something should be replaced with username located between ...
1
vote
1answer
1k views

Nohup with mysql command

I need to run in background mode some mysql-query... But how can i do this with nohup? Standartly i do: musql -uroot -p use SomeDb; Select * from blablalba; But how can i do this with launching ...
1
vote
1answer
8k views

Can't start MySQL server if the .sock file is changed in /etc/mysql/my.cnf

I have installed MySQL server 5.5 on Ubuntu 12.04. I am trying to start MySQL server on a different sock file. By default MySQL runs on /var/run/mysqld/mysqld.sock. I am trying to run the same server ...
1
vote
1answer
4k views

MySQL 5.5 - Lost connection to MySQL server during query

I have an Ubuntu 12.04 LTS server running at a german hoster (virtualized system). # uname -a Linux ... 3.2.0-27-generic #43-Ubuntu SMP Fri Jul 6 14:25:57 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux ...
1
vote
2answers
1k views

MySql - unable to connect as root

I have need to connect to mySql server 5.5 and create database using command line. Ideally it would be using a UI utility but I don't have it. Here is an issue: alex@ubuntu:~$ sudo mysql -u root ...
1
vote
3answers
1k views

How to get MySQL back on Ubuntu 12.04?

The upgrade to Ubuntu 12.04 delete MySQL and I need urgently to get it back. The problem is that I'm getting an error installing it, either with apt-get or aptitude: Errors were encountered while ...
1
vote
1answer
430 views

Upgrade MySQL to 5.5 on Lucid, upgrade server to Precise or switch to Percona?

Looking into upgrading mysql on our development server to which is running 10.04 so is stuck at MySQL 5.1, as it appears there is no apt-get support for upgrading to 5.5 except by certain 3rd party ...
1
vote
1answer
916 views

Installing MySQL in ubuntu with putty

So...i'm trying to install MySQL Server in Ubuntu 10.04 (i don't want other version of ubuntu) and it don't works... I tried : sudo apt-get install mysql-server and also sudo apt-get install ...
1
vote
2answers
4k views

How to install mysql cluster?

How to install Mysql Cluster 7.1 or 7.2 on Ubuntu 10.11 ? On a fresh install of Ubuntu, we must uninstall pre-installed mysql before? What is the best way, use .tar.gz on Mysql Website with or witout ...
1
vote
1answer
42 views

How to install mysql without root access?

I found this article that explains how to install MySQL without root access. However, on the MySQL download page is no download link for Ubuntu. Which one should I choose in this case? If it has a ...
1
vote
2answers
143 views

Cannot start mysql server [closed]

I'm tring to run a website from my server, so I installed php, apache and mysql. I'm having problems with mysql. After installation, it failed to restart. This is the output: ...
1
vote
1answer
39 views

Mysql data provider for TORA

I was a MySQL query browser user in Windows. I switched to Ubuntu 13.10 and now I can't get MySQL query browser so I tried TORA referenced from MySQL GUI Tools Now I could not get any option in ...
1
vote
1answer
51 views

kill sleeping process in mysql?

I have a MySQL database, which is very often filling with sleep process and I have to open my workbench and then have to kill them to free connections & then it will work fine. Is there any way ...
1
vote
1answer
280 views

mysql statement in bash shell script does not work / syntax error

hope someone can help me! I do not know what's wrong with this script (Bash / Ubuntu 12.04 / Mysql / XAMPP 1.8.3). Try to read an input file with a list of csv-filenames (449-R11, 449-R12 ..) in order ...
1
vote
2answers
479 views

Installing mysql 5.1 with Ubuntu 12.04

I have Ubuntu 12.04 installed, I need to install mysql 5.1 in that. Following steps I performed: Other things to be installed: Run this command to install alien and other necessary packages if not ...
1
vote
1answer
357 views

Updating variables in my.cnf

I set lower_case_table_names = 2 in /etc/my.cnf file. I also updated this variable in /etc/mysql/my.cnf file. After setting the variable I restarted mysql server, but still the value is 0, when I use ...