MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

3
votes
0answers
223 views

Problems with bash script, mysql inserts and launchd

I am developing a automated system, which consists of 3 parts: mysql, bash and launchd. Bash script takes folders of work related stuff, zips, archives and puts info about them into database that is ...
2
votes
0answers
208 views

Microsoft Excel to SQL using Pentaho: syntax error in 'OPTION SQL_SELECT_LIMIT=DEFAULT'

I've been using Pentaho Kettle version 5.1 to transfer Excel data to SQL by following these steps (answered by Edgar: Launch Pentaho Kettle (Typically) click on 'No Repository' Create a new ...
2
votes
0answers
38 views

encfs mysql datadir: Errcode: 13

I'm using encfs to encode the /var/lib/mysql data directory, but mysql returns Errcode: 13 at any attemp of create tables or databases. To do so, I moved all files to a temporary dir, created the ...
2
votes
0answers
1k views

MySQL root user localhost issue

I have a MySQL server (5.6) running on a virtual Debian box on my local computer. Connecting to MySQL from the localhost command line via the following command worked as expected: mysql -uroot ...
2
votes
0answers
578 views

How can I skip the root password prompt when installing mysql-server?

I am writing a bash script that involves installing the mysql-server package on Ubuntu. The package interactively asks the user for the root MySQL password desired, however this is not good for me as ...
2
votes
0answers
609 views

Row is not deleted in PHPMyAdmin

I am having problem deleting a row in PHPMyAdmin. I click the 'Delete' button to delete the row, at the top it says Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec) SELECT * FROM ...
2
votes
0answers
17 views

mysql 5.1.44: -e not executing and exiting properly on OSX

This function works on 5.0.75 on Ubuntu, but not on 5.1.44 on OSX (Lion): mysql --database=sps --host=localhost --user=root --password=somepass -e "SELECT 1;" The expected output is this: +---+ | ...
2
votes
0answers
524 views

MySQL crashes when connecting from localhost with tcp (UNIX sockets work)

I have Ubuntu 12.04 running MySQL server 5.5.24. I can connect with mysql --user root -p. status shows me : ... Connection: Localhost via UNIX socket ... When I try to connect with mysql --host ...
2
votes
0answers
214 views

How to get munin to alert for NaN

I am using this mysql slave status plugin and on the munin master I have added... mysql_slave_status.warning 30 mysql_slave_status.critical 60 So it alerts whenever the slave gets behind the ...
2
votes
0answers
174 views

PHP web application can't connect mysql installed with Zend Server CE on SuSE Linux 11.4

I had a running LAMP system. SUSE 11.4 with Apache 2, MySQL and PHP 5.3 Then I installed Zend Server CE. Everything is OK, but now I can't connect it to MySQL. The MySQL Server is running. If I ...
1
vote
0answers
25 views

Mysql- Changing file name to include date/time stamp when query is run

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE ...
1
vote
0answers
51 views

Set up sftp mysql authentication with chroot

How do I set up an openssh SFTP server that authenticates against a MySQL table where the users are jailed? Each user will need to have its own jail: /home/sftp/john /home/sftp/jane etc.. However ...
1
vote
0answers
328 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
1
vote
0answers
36 views

can filling up a disk and then freeing up space cause filesystem problems a month later?

I had an incident happen not too long ago with a server running mysql. Someone had enabled slow query logging on the server but never bothered to implement a log rotation, so the log files slowly ...
1
vote
0answers
85 views

PHP exec() causing memory usage to stay high?

I am quite new to using exec() command in php. I am using it along with this script called phantomJS (http://phantomjs.org/) to run a process which creates a pdf of my website's pages. The problem ...
1
vote
0answers
168 views

After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)

I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
1
vote
0answers
165 views

Mysql Failed to started after mysql dump restore process

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 ...
1
vote
0answers
41 views

Apache and MySql datbase memory consumption issue with Django

I'm writing a relatively simple web-application as a learning project to learn Django, Apache, Mysql etc. in practice. It consists of a web flash/html5 client which makes two API-calls to Django ...
1
vote
0answers
28 views

watch mysql output w/ tabular columns

how come when I run a mysql query and dump the results to stdout I get a pretty printed table ie: > mysql -e "describe <table>" <database> ...
1
vote
0answers
236 views

mySQL doesn't start in XAMPP on Windows 8

I installed XAMPP. Apache is getting active but when I try MySQL, it doesn't start. I will appreciate if someone can help me. Looks like RC=0 but it doesn't do anything. It gives the following ...
1
vote
0answers
408 views

Mysql socket error 2002 on Linux Mint - Access denied

My apache and xampp servers are running on port 2145 and 16443 respectively. sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.2-5... XAMPP: Stopping Apache...ok. XAMPP: Stopping ...
1
vote
0answers
1k views

I have a MySQL 5.6.17 server on OSX 10.9.2 that “sometimes starts”, and most of the time don't

I have setup a MySQL 5.6.17 server on my Mac OSX 10.9 to run some demo (I usually do not attempt MySQL and Apache things on a Mac), using Homebrew. Everything went just fine (apart usual stinky parts ...
1
vote
0answers
301 views

Corrupted MySQL index caused data-loss! How to recover data?

Introduction to my problem is following. A few days ago I wasn't able to start MySQL service in Wamp! Well, I was google-ing a lot to find solution why it doesn't start and some guy suggested to ...
1
vote
0answers
82 views

Importing pygments' highlighting to vim

Usually, vim does very good job in highlighting, using the packaged syntax files. Unfortunately, it does bad job with MySQL. At first, I looked everywhere for a better MySQL vim syntax file, with no ...
1
vote
0answers
109 views

How to forward data to mysql server using socket module in python

How to forward data to mysql server using socket module in python, i have try to import socket and connect it to mysql server for test, but have no data received from it, my code like this def ...
1
vote
0answers
177 views

resolving host names from parallels (windows) to Mac (mavericks)

I was given a macbook for work that is running mavericks. We also do windows development. I'm currently running windows 8.1. I set up mysql on the mac side that both the windows 8.1 running on ...
1
vote
0answers
57 views

How to prevent mysql blobs from borking my terminal

When using the linux terminal client for mysql, every column with a blob prints out tons of control characters and the terminal has to be reset. This looks something like the following Map: �PNG ...
1
vote
0answers
70 views

Is there any harm in using the MariaDB client to connect to a MySQL server?

I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it. It seems like although the client command is mysql, the version is ...
1
vote
0answers
132 views

Synchronizing folders, configurations, programs, local server and database on 2 debian machines

I am using debian both on a laptop and inside a virtual machine on another computer. I want to be able to synchronize those 2 systems in both ways so that I can do some work say on the VM, then ...
1
vote
0answers
51 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
1
vote
0answers
134 views

Define default column sort order in Sequel Pro?

I am using Sequel Pro 1.0.2 on Mac OS X. In the 'content' view of a table, I can click a column header to sort by that column. This always sorts the column in an ascending order. I would like to ...
1
vote
0answers
23 views

Spreadsheet to MySQL

I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and ...
1
vote
0answers
77 views

MySql dump restore from Run Dialog (not the cmd prompt)

I need to restore a mysqldump on a windows machine, which i perfectly know how. But I need to do it via the Run Dialog in one GO. So we open the Run Dialog and type : "[PathToMysql]\mysql.exe" -u ...
1
vote
0answers
193 views

Slow MySQL in VMWare, but Apache works ok

I have OSX running VMWare with W7 Pro. This machine is configured to bridge the network adapter, so it's in the same network of OSX but with a different local IP. I installed Apache and MySQL, and I ...
1
vote
0answers
131 views

How do I display a newline in a mysql prompt?

I'm trying to make my mysql prompt look like this: root@localhost:3306 database $ [mysql commands…] How might I place the dollar sign on a newline? Here's my current prompt configuration, in which ...
1
vote
0answers
165 views

Unable to install MariaDB on Debian 7

I'm trying to install MariaDB on my Debian 7 development machine and I've hit a problem. Following this tutorial, and this workaround, I enter this command: sudo apt-get install ...
1
vote
0answers
175 views

After rebooting, why doesn't sudo prompt for password when I try to start MySQL server?

I'm having a minor problem, and I'm hoping someone can help me understand why my system behaves this way. By the way, I'm a MySQL + Terminal newbie, so please go easy on me! I've done some due ...
1
vote
0answers
49 views

MySQL create custom error logfile in Apache Root

The title of this question placed in superuser's search box returned "0 Results" What. Everybody in the world but me knows how to do that? :) From the reading I did for the last hour and a half, ...
1
vote
0answers
225 views

Is it possible to delete unused media from the file system in Django, systematically?

I have a django project in which the admins are able to upload media. As items sell, they are deleted from the site, thus removing their entry in the MySQL database. The images associated with the ...
1
vote
0answers
209 views

mysqldump alternatives --hex-blob doesn't convert geometry binary columns to hex

I'm trying to create a mysqldump in utf8 encoding. The table I'm trying to dump contains geometry columns. Now, when I use the --hex-blob option, the geometry columns don't get converted to hex. Are ...
1
vote
0answers
129 views

MySQL db management through FreePBX

Is there an already prebuilt library for adding realtime DB management to an Asterisk Web-based GUI, like FreePBX ?
1
vote
0answers
5k views

Specified port 3306 is already in use when installing MySQL 5.6

How can I solve the problem when I try to install MySQL 5.6 and it tells me that the specified port 3306 is already in use. I uninstall my previous MySQL which is version 5.1 already and I do not have ...
1
vote
0answers
430 views

What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?

I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day. I've tried a couple of options. First, my specs: ...
1
vote
0answers
909 views

MySQL not starting on Mac OSX Mountain Lion (no mysqld process running)

I'm really frustrated about a problem I have with MySQL on my Mac, it's been like two weeks since it just doesn't start, I even tried creating another user account in my mac, with the same results. ...
1
vote
0answers
409 views

mysql remote connection on Amazon ec2 ubuntu

I installed a MySQL server in an Amazon EC2 instance. Then, I made the following changes in /etc/mysql/my.cnf: bind-address = 0.0.0.0 #skip-external-locking After restarting the server, I executed ...
1
vote
0answers
58 views

MySQL formatting problems with UTF8 on Mac terminal

When I do a select in MySQL on a column in Terminal on Mac, it appears like this: +-------------------+ | my_iso8859_column | +-------------------+ |.. ....... | | ..... .... | | .. ...
1
vote
0answers
394 views

Repeating mysql error in OSX console

I'm getting an endlessly repeating set of errors in my mac's console that go as follows: Jan 6 00:21:37 Air com.apple.launchd[1] (com.mysql.mysqld): Throttling respawn: Will start in 9 seconds Jan ...
1
vote
0answers
55 views

Does MySQL Server 64-bit require 64-bit connectors on Windows 7?

On a Windows 7 64-bit machine. Is it appropriate to install: 64-bit MySQL Server 5.5 and 32-bit MySQL Connectors? Or do 32-bit MySQL Connectors require the 64-bit version of the server?
1
vote
0answers
269 views

Apache Periodically Hangs

I have a small Rackspace-hosted Debian VPS running my personal web server. In the last few weeks, there have been several times where Apache (I'm running 2.2.16) appears to be just hanging ...
1
vote
0answers
93 views

fsck did not recover all files - anything else to try or fresh install?

yesterday a server of mine (debian) went into read-only mode because of problems with the main device (ext3). I contacted the hosting support and the guy told me to boot into rescue and do a fsck on ...