0
votes
0answers
28 views

MySQL Workbench 6.17 error Ubuntu 12.04 x64

Im trying to run MySQL Workbench Migration to transfer a table from MS SQL to MySQL. Using the latest version of workbench (or in fact any of the latest ones), the migration fails instantly and gives ...
0
votes
1answer
23 views

Cron job from mysql and send an email with results

I have a ubuntu box hosted and need to setup a cron job for executing a stored procedure and sending the results via email to one address once a week. How can I do this? I am using Mailgun
0
votes
1answer
22 views

How to install mysql and other software to ubuntu12.04?

I've just installed Ubuntu 12.04 to my laptop. This is the first time I'm using this OS. Their is no software to watch videos and flash player to watch in web. I'm not being able to install also. I ...
0
votes
1answer
25 views

MySQL keeps crashing in Ubuntu 12.04

Every few hours, MySQL crashes on my Digital Ocean Ubuntu 12.04 machine. Below is the errors I am seeing in my MySQL error log. I thought it was a memory issue, so I added a swap, but that didn't fix ...
-1
votes
1answer
32 views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
0
votes
1answer
25 views

How do i export a database in ubuntu to specified location using terminal

I get a blank screen since i have installed the ATI graphic drivers. I tried a lot of things restore my laptop but all in vain. Only formatting seems to be the other option. So i want to export my ...
0
votes
0answers
61 views

Mysql failed to start

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
0
votes
1answer
19 views

Query mysql return an error Incorrect key file for table

I have a site in joomla I hosts locally on an Ubuntu server. When a query is executed by mysql, I get the following error: Incorrect key file for table '/tmp/#sql_6ef4_1.MYI'; Here is my ...
1
vote
0answers
100 views

Apache and MySQL bringing server to a crawl several times a day

I am having difficulty troubleshooting a bottleneck problem with my Ubuntu 12.04 server. I run a very small intranet website off of the server. There are web requests (SOAP, HTML, REST, etc) at a ...
0
votes
0answers
222 views

initctl: Unknown job: mysql ubuntu 12.04.4

I just updated my Ubuntu and mysql service wont start up. I've tried to re-install million time, i still get this error message: initctl: Unknown job: mysql The error log shows this: ERROR: 1064 ...
0
votes
1answer
37 views

MySQL Ambiguous Option issue

MySQL is starting correctly as a service, and my WP instance / phpMyAdmin connects to it successfully. However, I've managed to screw something up such that when I try to log in from the prompt, ...
0
votes
0answers
44 views

Problem after installing phpmyadmin in ubuntu 12.04

I have installed phpmyadmin from the following process sudo apt-get install phpmyadmin Then I opened it throghhttp://localhost/phpmyadmin/ But after giving username and password then pressing the ...
0
votes
1answer
454 views

sometimes Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

I've got my application up and running, with rails on my ubuntu VPS in Linode with mysql. here's the version of mysql: mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (x86_64) using readline ...
0
votes
1answer
376 views

Unable to uninstall MySQL 5.6.17 from Ubuntu 12.04

I installed MySQL 5.6.17 using binary file *.tar.gz. I need to remove MySQL from my Ubuntu system. I tried running the following commands: 1) sudo apt-get remove --purge mysql-server mysql-client ...
1
vote
1answer
42 views

Symbolic Link Error with MySQL Cluster and Ubuntu 12.04

I want to install MySQL Cluster on Ubuntu and I followed this tutorial Install MySQL Cluster on Ubuntu 12.04 LTS. My management node installed successfully, but I am having a problem in my database ...
0
votes
0answers
73 views

How to get write permission on /etc/environment?

I want to add mysql Connector jar file to classpath and by browsing through the net. I read that a global way to do it is to update the /etc/enviroment but the file opens as readonly. What I don't get ...
0
votes
1answer
254 views

Can't get latest PHP or Pear in Ubuntu 12.04 LTS

I'm attempting to install PEAR, and other components.. but getting the following. $ sudo apt-get install php5 libapache2-mod-php5 php5-mysql Reading package lists... Done Building dependency tree ...
0
votes
0answers
140 views

Ubuntu 12.04 problems with mysql

I use Ubuntu Server 12.04 for my Django project. On my local PC there is no errors and etc. Sometimes on server I have error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
58 views

Unable to connect - Apache2 in Ubuntu 12.04 VirtualHost

I have followed the tutorial from here https://www.digitalocean.com/community/articles/how-to-set-up-apache-virtual-hosts-on-ubuntu-12-04-lts to set a local website. I just changed the port 80 to ...
0
votes
1answer
28 views

mysql problem with login in terminal

I read many post including https://help.ubuntu.com/community/MysqlPasswordReset this one one all of method. How much time I do this I don't know. Still my problem was't fixed. I already wasted 6 more ...
0
votes
0answers
33 views

Ubuntu precise 12.04 init.d issue after installing percona 5.5

First of all, it keeps on starting mysqld_safe even if it is not provided by my my.cnffile. I found this in the init.d script: "${PERCONA_PREFIX}"/bin/mysqld_safe > /dev/null 2>&1 & And ...
0
votes
1answer
745 views

how to upgrade phpmyadmin after installing mysql 5.6

After upgrading MySQL from 5.5 to 5.6 I got the following error in phpmyadmin: Your PHP MySQL library version 5.5.33 differs from your MySQL server version 5.6.13. This may cause unpredictable ...
2
votes
2answers
1k views

Unable to install mysql 5.6 in ubuntu 12.04

I download mysql-5.6.16-debian6.0-x86_64.deb from official site. Install using dpkg -i mysql-5.6.16-debian6.0-x86_64.deb It does create file in /opt/mysql/server-5.6/. root@ubuntu:~# cd ...
0
votes
0answers
44 views

Setting Max Connections in MySQL server Globally [duplicate]

I installed my UBUNTU 12.04.4 LTS X64 yesterday and didn't installed anything except mysql-server and mysql-client. But htop showing 20 mysqld identical processes. *--Process----- MEM%---VIRT --- ...
0
votes
2answers
4k views

MySQL Access denied for user 'root'@'localhost'

In my server, everytime I try to access MySQL I get the error: Access denied for user 'root'@'localhost' (using password: NO) when I try mysqladmin -u root -p password I get Access ...
2
votes
1answer
2k views

Installing MySQL 5.6 using PPA

I'm trying to install MySQL 5.6 on my Ubuntu 12.04 over the already installed 5.5 the easy way (using PPAs). I've found Ondřej Surý's PPA here. It sounds promising but I couldn't upgrade my MySQL. ...
0
votes
1answer
26 views

Where is the database file from redmine after using the defaultinstallation?

After I installed redmine, I have a database called redmine and through phpmyadmin I can take a backup etc. , but I can't find the default location of it. Where is it placed? Any Idea? Does mysql ...
0
votes
1answer
118 views

HTML doesn't show php script on Uuntu 12.04 ( PHP5, Apache2, mysql) all are installed properly

But info.php in /var/www/ does show the info. Only PHP embedded in html doesn't show the script. please help me.. I have tried the previous askubuntu questions and didnot get anything useful so ...
1
vote
2answers
1k 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 ...
0
votes
0answers
126 views

MySql cannot start: Job failed to start

I am trying to sync two databases using a local IP. A main database is created on host computer and I'm trying to sync data from another computer to this database through a local network. I changed ...
1
vote
2answers
440 views

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

I am getting this error while importing the database in mysql, and when I resubmit the same file than I am getting this error Error SQL query: -- -- Dumping data for table `adminnotification_inbox` ...
0
votes
1answer
58 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
0
votes
1answer
161 views

12.04.4 + MySQL 5.5 + Wordpress - MySQL Service Fails to Start

It appears that the issue is around the MySQL services starting as I receive the following in my /var/log/syslog when I attempt to restart the mysql service: Jan 17 08:19:38 blog kernel: [ ...
0
votes
1answer
185 views

Installing libmysql on Ubuntu Server 12.04

I really need help installing the dependency of this, which is libmysql (here) I really have no idea how to install it. The author requires me to put it in a specific directory, but I have had no ...
1
vote
1answer
3k views

install libmysqlclient-dev 5.6

I can't use the mysql ruby gem because I get this error: Incorrect MySQL client library version! This gem was compiled for 5.6.15 but the client library is 5.5.34. (RuntimeError) apt-get is ...
0
votes
1answer
485 views

install mysql proxy via ubuntu terminal

How do i install MySql Proxy via ubuntu terminal http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-install-binary.html
0
votes
1answer
78 views

command line syntax that will show MySQL details

Is there a command-line syntax that will show details about my installed MySQL (eg. ports, config file paths, etc.)?
0
votes
0answers
96 views

Migrate from MySQL 5.5.34 to MariaDB 5.5.33 for Ubuntu 12.04 LTS

How to Migrate MySQL to MariaDB since I'm taking most of my time turning in Circles. Sorry if this question is to chicken for you guys. Since I'm new with Ubuntu and in MariaDB. Yet most of the time ...
1
vote
0answers
119 views

Can't purge mysql-server installation

Since I've got no privileged user in my current MySQL-installation on 12.04 LTS I want to re-install the mysql-server completely by using: sudo apt-get purge mysql-server After a very short while I ...
0
votes
1answer
239 views

Why isn't the cppconn folder in /usr/include?

I am new to C++. I am trying to make a MySQL connection. I found that it requires mysql-connector. I installed boost-dev-all . I have put my mysql-connector in local directory ~/bin. I have ...
0
votes
1answer
2k views

Turn off MySQL --skip-grant -tables

I reset my root mysql password with the following instructions: (Works for Ubuntu as well) http://www.debian-administration.org/articles/442 But now I can't turn off mysqld_safe --skip-grant-tables. ...
0
votes
1answer
202 views

replication checking shell script error

I'm trying to create a Database Replication checking script which checks master-master replication but I'm getting error while executing it. Here is the script #!/bin/bash ...
0
votes
0answers
234 views

Postfix+Courier+Mysql / SASL authentication error

Today I've installed Postfix/Courier with Mysql authorisation/virtual users using this guide: https://help.ubuntu.com/community/PostfixCompleteVirtualMailSystemHowto after a lot of searching and ...
2
votes
1answer
568 views

Create firebird database in specific directory

I want to be able to create a firebird database in a specific directory. I know that the firebird user needs to have r/w/x permissions to the directory where I want to create the db. I created a group ...
1
vote
1answer
1k views

can't start mysql service anymore

I had MySQL running ... with many different databases. I install MySQL workbench today.. and was able to create any entity relationship diagram etc. Then i decided to increase the size of my ...
3
votes
3answers
19k 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 ...
0
votes
0answers
253 views

freeradius authentication in ubuntu 12.04 for vsftpd

I am using Ubuntu 12.04 based distro. I have configured Vsftpd and now want to configure freeradius server for authentication of vsftpd. I do not know the mechanism of freeradius and procedure that ...
1
vote
1answer
353 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 ...
0
votes
0answers
609 views

Disable running mysqld at system startup

I am using Ubuntu 12.04.2 LTS (GNU/Linux 3.5.0-37-generic x86_64). I have messed a little in my Ubuntu configuration. Now every startup I have mysqld running: $ ps aux | grep mysqld mysql 959 ...
0
votes
1answer
1k views

12.04 - MySql won't start by using service mysql start

The only way I was able to get MySql to start was to issue: mysqld When I issued this command, it started rolling back some database transactions that were conflicted. I have tried issuing ...