Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
2answers
2k 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 ...
2
votes
3answers
6k views

How do I import an mdf database file into MySQL?

I have an .mdf file(which is supposed to have database). I'm using Ubuntu 12.10 . I want to import the database into mysql.5.5.28-0ubuntu0.12.10.2 (Ubuntu) as this is version I'm using for mysql.
2
votes
1answer
221 views

Is it safe to Install Both Redis and MySQL on the same system?

Mine is a question not on how to install either but on whether I can have both MySQL and Redis-Server on my Ubuntu 12.04 machine. I need both for different projects, any help forthcoming will be ...
2
votes
2answers
5k views

phpmyadmin 404 error on fresh ubuntu 12.04 install

I regularly set up Virtualbox ubuntu setups to run as local webservers. I have set these up several times and never had an issue. However, something has changed: 1)VB guest additions no longer allow ...
2
votes
1answer
92 views

How do I turn on a login page for Bugzilla?

I have Bugzilla 4.2.1 running on my Ubuntu 11.10, It working as it should and everything is fine. Now when somebody accesses the URL www.myapplication.com/bugs without logging in, it allows the user ...
2
votes
1answer
521 views

Where is mysqld.sock?

I am missing mysqld.sock in Ubuntu Server 12.04. Neither locate nor even apt-file search mysqld.sock (ran apt-file update before) can find it. Where is it?
2
votes
2answers
7k views

How to install mysql 5.1 on 12.04?

I just installed Ubuntu 12.04 at work, which runs very well. Unfortunately, for work reasons, I need to use mysql version 5.1. I can't find a clean way of installing it. I must install it the usual ...
2
votes
1answer
2k views

Why isn't the MySQL extension loading?

Please help! I've been going at it for a while and I can't get it to install, keep getting the ol message below. Running on my own server. MYSql, PHP, Apache instaled. Already uncommented the ...
2
votes
1answer
5k views

mysql service do not launch

Sorry for my English; I was trying to create db with rake in RoR application that has been configured for MySQL(gem installed, settings changed). After that attempt mysql-server broke: d@calister:~$ ...
2
votes
1answer
920 views

How to debug a server that crashes once in a few days?

One of my servers crashes once in a few days. It does low traffic static web serving + low trafic dynamic web serving (PHP, local MYSQL with small data, APC, MEMCACHE) + some background jobs like XML ...
2
votes
1answer
3k views

Problem running multiple MySQL instances

I'm trying to run multiple instance of mysql 5.1.49 on ubuntu 10.10 to setup a replication/backup database. I have added following line to /etc/mysql/my.cnf: [mysqld2] server-id = 2 socket = ...
2
votes
1answer
48 views

Trying to sync live data to a backup server

I'd like to take the data from the live system to a backup system (to test new features etc) Piecing together an rsync command, I have the following. How do I ensure everything is copied? Things ...
2
votes
1answer
291 views

MySQL import never completing

I wrote a bash script, and here is my problem. The script run for hours, and it never completes. I see the MySQL import process finish, but the script never gets any further. I have tried adding an ...
2
votes
1answer
56 views

Start services only when really required

I use my desktop box as dev "server", so I have installed mysql+apache+whatever. This causes boot to last longer, also memory consumption is high since I have all this services running. Does a ...
2
votes
2answers
2k 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` ...
2
votes
1answer
2k 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 ...
2
votes
1answer
207 views

upgrade MySQL through apt not effect?

I am upgrading mysql-server and mysql-client my 12.04 using apt-get. seems the upgrade didn't take effect? Any thoughts why this happen? I did reboot after upgrade. Thanks. $ mysql -V mysql Ver ...
2
votes
1answer
776 views

How to fix AppArmor `could not open` error when installing php+mysql?

I want to install php5-imap php5-ldap php5-curl sudo apt-get install php5-imap php5-ldap php5-curl I get this error: AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in ...
2
votes
1answer
569 views

MySQL Replication

I have 2 MySQL servers, Master & Slave , running on Ubuntu 12.04. I have replication working from the Master to the Slave. If the Master goes down and the Slave is used, how do I get data to ...
2
votes
3answers
368 views

How to disable mysqld in 10.04?

I have a few (Linode) Ubuntu 10.04 (64bit) VPSes, and mysqld keeps starting on every reboot on all of them -- $ uptime 16:32:26 up 1 min, 1 user, load average: 0.09, 0.08, 0.07 $ ps -ef | grep -i ...
2
votes
1answer
702 views

Package error while trying to upgrade mysql-server

I am trying to upgrate mysql 5.1 to version 5.5 Since official ubuntu repositories do not provide 5.5, I've decided to go with Dotdeb repository. When I've updated the package information and typed ...
2
votes
2answers
2k views

Why can't I telnet to MySQL?

When trying to connect to mysql server via telnet I am getting following error: telnet localhost 3306 Trying ::1... Trying 127.0.0.1... telnet: Unable to connect to remote host: Connection timed out ...
2
votes
1answer
185 views

Is there a solid howto for replacing MySQL with Maria in the LAMP stack?

I've heard great feedback on a few folks migrating production machines (including from this question), and I'd like to test the transition in our dev environment. Maria is apparently in the 11.10 ...
2
votes
1answer
6k views

Installing MySQL 5.1

this question is surely a dupe of http://stackoverflow.com/questions/1632056/how-do-you-install-mysql-5-1-on-ubuntu-8-10 Since I can't comment on that one...I am starting a new one. I'm having the ...
2
votes
2answers
718 views

Using Upstart after building Apache & Mysql from source

I'm using Ubuntu 10.10, Apache 2.2.17 and Mysql 5.5.10. I need some assistance getting Apache and Mysql running on boot. Reading the getting started over at upstart website attempting to get it to ...
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 ...
2
votes
0answers
541 views

MySQL Workbench on MySQL 5.6.19

I tried to install MySQL Workbench 6.1.7 on Ubuntu 14.04 after installing Mysql 5.6 library, but get the following: error: Package dependencies cannot be resolved This error could be caused by ...
2
votes
1answer
136 views

MySQL: Can only login from command line or as root

I've been trying to solve this problem for the last 3h. I've just set up a MySQL server on my dedicated root server, running Ubuntu 14.04-minimal. I have no problem logging in as root anywhere - it ...
2
votes
1answer
245 views

How can I dump and restore MySQL databases to and from Dropbox from the command line?

I have a few MySQL databases that I would like to sync between two computers. What I'd like to do is be able to have a quick command or script on one computer that I can use to quickly dump the ...
2
votes
2answers
34 views

Chown Not Responding as I expected.

New to Ubuntu, so bare with me. I recently changed the permission of mysql, /var/lib/mysql so I could save a database in it manually (was only option currently, instead of importing it the proper ...
2
votes
2answers
460 views

Is securing phpMyAdmin with .htaccess considered sufficient?

I have just installed Linux / Ubuntu for the first time in order to learn, and to get some experience with LAMP servers. I also installed phpMyAdmin and used an .htaccess file (stored in ...
2
votes
0answers
105 views

404 not found error on apache2 [duplicate]

I have installed apache2, actual php version, mysql server and vsftp on my new Ubuntu server. I also installed wordpress and gave the user www-data all rights for /var/www/* and put it to 755. I ...
2
votes
4answers
873 views

Unable to send data to mysql database. It is not taking by my php code [closed]

I am new to PHP in Ubuntu 13.10. But I am pretty much able to handle Ubuntu. However my question is that I can't add any data to phpmyadmin through a PHP code, though my code is perfect. Because I ...
2
votes
1answer
3k views

Remotely access mysql db on vm from windows as host [closed]

I have ubuntu on vmware. I've installed mysql-server on it. And now I'd like to connect to this db directly from the Host(windows) machine. Ubuntu is connected to the router via bridge. I can ping it ...
2
votes
0answers
18 views

SSL is not in use on MySQL server [duplicate]

I installed MySQL server and I want to allow SSL support. I added these lines to my.cnf [client] ssl-ca=/etc/mysql/ca-cert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem ...
2
votes
1answer
322 views

what is the command to connect a database remotely from other PC

what is the command to connect a database remotely from other PC. I am running a application in a PC1(client) and storing some content of that application on a database. There is also one another ...
2
votes
0answers
200 views

Ubuntu virtual memory overcommit apparently hitting MySql performance

I have several installations using Ubuntu Server 10.04 and 12.04 LTS running on Dedicated and VPS with various hosting companies. I am hitting a problem where, especially on migrating to a new server ...
2
votes
1answer
1k 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 ...
2
votes
3answers
127 views

Using existing mysql database in lampp

I'm using ubuntu 13.04 in a 32 bit machine. I have Windows 8 installed also. I have set up lampp in my ubuntu OS. Now I want to use mysql databases of Windows in ubuntus lampp. I have searched a lot ...
2
votes
0answers
94 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 ...
2
votes
4answers
7k 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 : ...
2
votes
4answers
1k views

Why I can't open mysql 5.6.10 from terminal on Ubuntu 12.10?

I've always used Ubuntu to host my servers and I wanted to try the new MySQL version. So I downloaded MySQL 5.6.10 (.deb) from their official site and installed it like this: Tutorial for MySQL ...
2
votes
0answers
595 views

How I can connect the syslog-ng with a mysql database?

Hi guys I want to use a syslog-ng server for logging data from the firewall and I get Data from the Firewall in the file /var/firewall.log but now I want that the logs go to a database. For this I ...
2
votes
1answer
2k views

How can I install specific version of MYSQL

I'm trying to install mysql-server 5.0. because I want to install a program which depend on this version. I've surfed the net to find a solution but none of them worked. I'm really disappointed. I ...
2
votes
0answers
304 views

Another apparmor / mysql wont install

I am trying to config another instance of mysql on my present but i can't mysql_install_db --user=mysql --datadir=/var/lib/mysql2 Installing MySQL system tables... ERROR: 1005 Can't create table ...
2
votes
0answers
2k views

MySQL Workbench will not open on my Ubuntu 12.04

I have install mysql-workbench version 5.2.38+dfsg-3 via Ubuntu Software Center on my Ubuntu 12.04 laptop for some week ago, This work fine until now! Now when I press in the mysql-workbench icon ...
2
votes
1answer
1k views

MyODBC with MySql in Ubuntu 11.04

I want to read mysql table data to an excel file. So I decide to install MyODBC in my Ubuntu 11.04 with these command lines: sudo apt-get install iodbc sudo apt-get install libmyodbc I start the ...
2
votes
0answers
428 views

How to setup LAMP environment? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I have been using XAMP in windows for a long time. Recently I have moved to Ubuntu and now want to have a similar ...
1
vote
4answers
19k views

How to upgrade mysql 5.5 to Mysql 5.6 on 12.04? [duplicate]

I need to install Mysql-server-5.6 in my ubuntu development server 12.04. Now it is running percona-server5.5. How can i upgrade this to mysql-5.6 ?
1
vote
5answers
12k 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 ...