Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
1answer
7k views

Xampp : http://localhost/xampp/splash.php :english : nothing happens

After I start Xampp on my Ubuntu 12.04 I go to the localhost and I come to the site, where all languages are listed .... when I click any of these languages nothing happens. Follow steps are already ...
-1
votes
2answers
108 views

Should I use desktop or server version for my own java+mysql trading system? [duplicate]

I am going to build a trading system with java and mysql but I am not sure should I use desktop or server version. The backtest part would involve a lot of calculation and live trade part requests ...
2
votes
0answers
109 views

Using multiple cheap server to scale my website needs, which technology? [closed]

I have developed a website that is running on MySql/Php/Apache and it is performing quite well. But with more users uploading their stuff the space available on my server is reducing and eventually I ...
3
votes
1answer
992 views

wordpress mysql physical files .MYD not in /var/lib/mysql/dbname

I installed wordpress on my home server (multisite install + varnish cache). Now I'm looking into /var/lib/mysql/dbname to recover the mysql files, and here is what I find : All the important tables ...
0
votes
2answers
1k views

Mysql server installed but not running

I tried to install mysql 5.6.12 using the following procedure # Preconfiguration setup shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions ...
0
votes
1answer
5k views

Mysql 5.6.12 Installation from source code

I downloaded the Mysql-5.6.12 source code from the official website and extracted its contents in /usr/lib but the problem Im facing is now how do I install it? I followed the steps to install it it ...
1
vote
2answers
5k views

Connect to MySQL DB tunneling with SSH using Emma

I have tried using the mysql-workbench but it was too confusing, then I decided to use emma instead. I am trying to connect to my MySQL DB through SSH, but I don't see that option when I try to make a ...
1
vote
2answers
5k views

install mysql connector

I am attempting to copy mysql.jar.com.mysql.jdbc.Driver in the Java directory. I get a permissions error. I have administrative privileges so I don't know what the problem is. My feeling is that ...
11
votes
4answers
11k views

Install Apache, Php, Mysql latest versions not available via apt

I need to install the latest versions of apache, php and mysql that are available on their websites, but the problem is that apt repositories don't have these updates versions yet. Versions that I ...
1
vote
1answer
3k views

How to remotely backup a MySQL database?

How to backup MySQL database in a remote location using rsync? I tried mysqldump but it is storing the backup in the local machine only. Also I need the backup files to be stored in tar format in the ...
0
votes
2answers
9k views

php-server setup not working

I have installed php and apache2 server before but I'm getting bogged down with errors. The process so far is as follows: sudo apt-get install tasknet sudo apt-get install lamp-server During the ...
0
votes
1answer
3k views

mysql server backup using copying database files

I want to backup mysql databases to another new server. I don't want to use mysql replication and mysqldump for backup as they are using higher cpu and higher i/o on server. I tried mysqlhotcopy to ...
6
votes
3answers
31k views

phpmyadmin throws a 404 on opening

I have installed php5 and phpMyAdmin from the Ubuntu Software Centre on a fresh install of Ubuntu 13.04. when I enter localhost in my browser the following is displayed: It works! This is the ...
2
votes
2answers
4k views

Mysql broken packages

I am not able to fix broken packages to my ubuntu machine. I followed many command posted on forums. Nothing happened! The packages that have the problem are: mysql-server-5.5 mysql-server Any way ...
0
votes
0answers
27 views

Unable to install MYSQL Natty-security issue [duplicate]

I am running a Ubuntu 11.04 on my system. Trying to uninstall mysql server from the terminal: sudo apt-get install mysql-server But it fails with the following set of errors: Reading package lists....
0
votes
1answer
357 views

uninstalling mysql from ubuntu

I installed mysql in my system using ubuntu12.10 by tar.gz file. Now,I wanted to remove it from the system,please suggest me the ways to uninstall it. Thanks in advance
4
votes
1answer
10k views

apt-get upgrade - packages have been kept back: mysql [duplicate]

On my ubuntu vps, I've this error, What does it mean? Why were packages kept back? I was advised not to do dist-upgrade. My question is not how to solve this, but why this happened? The following ...
1
vote
2answers
170 views

Have I over-installed MySQL?

I ran the following from the terminal: sudo apt-get install mysql-server mysql-client I then checked to see if MySQL was running: sudo netstat -tap | grep mysql I saw something similar to ...
0
votes
1answer
224 views

Trouble starting mysqld on mysql cluster

I set a cluster using mysql-cluster-gpl-7.2.12, first it was working fine but suddenly started to fail. I can start the nodes (ndbd) but when I try to start mysqld (API), it shows an error it says "...
0
votes
3answers
693 views

GUI mysql tool for multiple databases

I have two discrete mysql databases (located in different servers). In windows, I can use odbc and ms access and query from tables residing in different databases. In ubuntu, is there a way or tool to ...
1
vote
2answers
4k 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 ...
0
votes
1answer
2k views

How to Automatically synchronize phpmyadmin on two lampservers?

My setup for my website is that i have a load balancer server, and two lamp servers and on the two lamp servers i have phpmyadmin installed. I have synced the two lamp servers /var/www folders with ...
1
vote
3answers
2k views

upgrade percona-server package fails

This has been happening for a few weeks. Every other package upgrades without issue except this one, but I'm not sure what's causing this or how to debug it. sudo apt-get upgrade Reading package ...
3
votes
0answers
582 views

Using gnome-keyring with svn via ssh and mysql-workbench

Problem: mysql-workbench fails to connect to the keyring to connect to mysql. I'm trying to get my svn command (which uses an svn+ssh uri) to prompt me to enter my password for my local rsa secrets. ...
4
votes
3answers
12k views

Recommended testing tools to test MySQL performance?

What is the recommended tool(s) for testing the performance of MySQL 5.5 (innodb) under Ubuntu 12.04? We have purchased a new multi-cpu multi-core server to replace our current MySQL dual-core server....
0
votes
1answer
511 views

Java Hibernate: Download MySql or LAMP

I am going to be writing a Spring based Java application and I was wondering if I should install MySql directly or should I just install LAMP. I would like to install LAMP, but would this have any ...
-1
votes
1answer
812 views

myloader Segmentation fault (core dumped) [closed]

myloader --directory=$DB_DUMP --queries-per-transaction=50000 \ --threads=$THREADS --compress-protocol --verbose=3 \ --socket=$MYSQL_SOCK --user=$MYSQL_USER --password=$MYSQL_PASS # ...
3
votes
6answers
19k views

Upstart can't start MySQL

After an installation of MySQL, I get a few errors and I can't run the MySQL daemon. I've tried uninstalling and reinstalling several times, and I'm not sure what's going on. Here's a snippit of what ...
1
vote
1answer
1k views

Mysql5.6 and problem of php5-mysql , mysql-common packages

I install Mysql 5.6 with this documentaion(in ubuntu 13.04) , now I need to install php5-mysql and mysql-common packages. can I install them with apt-get? I think they will install mysql5.5 compatible,...
2
votes
1answer
3k views

Can't connect to mySQL server which is running

I installed the latest mySQL Ubuntu distribution on my Ubuntu 13.04. The installation of the localhost server was succesfull and was working fine for a while. After creating a couple models (with no ...
0
votes
2answers
3k views

How do I display an html file on a web browser in Ubuntu?

I am tasked with displaying a program on a web browser for my final project. The browser would be run from a cloud instance, and I have chosen to show an java applet that I have made. I have already ...
0
votes
1answer
3k views

Mysql Datadir on different hard drive

I'm currently running Ubuntu 13.04 and MySQL 5.5. I have been using InnoDB, and the default location for installation. The problem is that my main OS partition is fairly small (36GB), and I need to ...
0
votes
1answer
974 views

What won't MySQL start?

MySQL will not start, and I need some help to figure out why. $ download mysql-common [sudo] password for zero: Reading package lists... Done Building dependency tree Reading state ...
9
votes
1answer
24k views

Upgrade MySQL server issue [duplicate]

I failed to upgrade MySQL server. Here's what I tried: I first issue this command to update the package list: sudo apt-get update Then, upgrade by: sudo apt-get upgrade It shows the following ...
3
votes
3answers
5k views

Cannot get mysql to work/start even after clean install

I am completely stumped right now, whilst I am not an advanced user, I know my way around Ubuntu and so tried to look into things with the help of certain forum topics. The Problem: Today, quite ...
0
votes
1answer
443 views

g++ fails to link to libmysqlclient

I use Ubuntu 12.04 on a virtual machine on my MacbookPro. I installed build-essential, mysql-server and libmysqlclient-dev. Both commands 'mysql' and 'mysql_config' work. However, the following ...
1
vote
2answers
558 views

Partial upgrade - why remove MariaDB?

My 12.04 system wants to run a partial upgrade, as part of which it proposes to remove certain MariaDB packages (see screenshot below). Attached is my sources.list file - I don't understand why the ...
1
vote
2answers
2k views

no mysql workbench in ubuntu 12.04 software center

I have already installed MySQL workbench from the Software Center on a recent installation of Ubuntu 12.10 (32 bit) with no problems. Since then, I just installed ubuntu 12.04 LTS on another machine (...
1
vote
1answer
3k views

learning of mysql with java in ubuntu

Hello as Im new to ubuntu i want to learn Mysql database with Java,So how to install the software and configure them for the Programming in ubuntu 13.04
0
votes
1answer
241 views

Problem while moving Mysql DB from Windows to Ubuntu?

I was planning to move mysql DB from windows to Ubuntu. Whenever I try to change lower_case_table_names to 1 (for case insensitivity) using set query it says it is read-only variable. When I tried ...
5
votes
3answers
67k views

can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' [duplicate]

I just installed appache, MySQL and PHP, suring my installation, I was prompted for a MySQL root user password, but when I start my MySQL, it pops the error, and I just can't seem to find a way around ...
0
votes
1answer
737 views

mysql-client-core-5.5 : Breaks: mysql-client (< 5.5.31-0ubuntu0.12.04.1)

the automatic security update broke my mysql installation and I don't understand how to fix it. As far as I can tell the packages mysql-client-core-5.5 and mysql-client are on the same versio0n 5.5.31....
0
votes
1answer
883 views

Can't install apache on Ubuntu 13.04 [duplicate]

I have apache files downloaded, and I've not been able to install the, it keeps listing dependencies and when I check my list of installed packages, it lists apache2 as deinstall, I equally have not ...
1
vote
2answers
968 views

Is there a way I can transfer all my web sites on localhost to a new computer?

I have a whole set of web sites on my Ubuntu computer that I use for testing and development. I don't host them on the internet, I just access them locally for design and debugging. Each one is built ...
12
votes
3answers
16k views

MySQL can't open files after updating server: errno: 24

Ubuntu: 12.04 LTS (Linux mysql02 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 21:22:10 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux) MySQL: Ubuntu distro 5.5.31 Apparmor: REMOVED! Server has been running ...
0
votes
1answer
309 views

Ubuntu server boot without keyboard/monitor

Hope someone can help me with this unusual problem. I installed Ubuntu 12.04 server on a Gigabyte GA-H61M-USB3 motherboard. This all went well. I subsequently installed Apache, MySQL and PHP. This ...
1
vote
1answer
647 views

how to install apache/php from apt alongside mysql 5.6 from source

I managed to install MySQL 5.6 on obuntu 12.10 but now I need apache/php packages but when I try to install them thorough apt they try to install mysql-common (presumably 5.5) How to solve this?
4
votes
4answers
15k views

Can't install MariaDB 5.5 or 10 in Ubuntu 12.04. MYSQLD Failed to start?

I tried o install MariaDB on my Ubuntu 12.04 server. First it gave dependency issues and I fixed it by following this question : http://stackoverflow.com/questions/16214517/installing-mariadb-unmet-...
0
votes
1answer
686 views

Bring in old databases in MySQL?

Ok, so when mysql updated a while back, it broke. It was simply not starting. So I tried fixing it, but hadn't been successful. I finally gave up, copied all the directories & files under /var/...
1
vote
2answers
325 views

Database create in mysql database

I am using Ubuntu 12.10 and recently I install XAMPP 1.8.1. My problem I can not create new database using both sql command and phpmyadmin. In phpmyadmin database creation input box is not shown and ...