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

learn more… | top users | synonyms

0
votes
1answer
17 views

How to configure phpmyadmin under Ubuntu

I've installed LAMP but when I put in apache.conf this line as is in instruction Include /etc/phpmyadmin/apache.conf and trying to restart apache I get follow error: ~$ sudo /etc/init.d/apache2 ...
0
votes
0answers
13 views

How to properly move mysql dumps between hosts

One would thing that it will be as easy as mysqldump -u root -p -QqeR --add-drop-table --all-databases | bzip2 -v9 - > blabla.sql.bz2 and then import on the other side, but in real world that's ...
0
votes
0answers
16 views

Weird SQL Time and Date exception in Windows

OS: Windows - Environment: MySQL I am facing a weird problem (for me at least), I was running some tests on database activities, the full scenario is like this: I have two Java programs manipulating ...
-3
votes
0answers
10 views

Large data: Can it really be better to use a large arrray for an active rather than use Mysql? [closed]

I resonantly spoke with a web programmer. My website is going to store a lot of data. A lot is the question ... What is a lot of data? The web programmer seemed to think this "Large data" would ...
0
votes
2answers
22 views

How to store results of multiple sql queries in shell variables in Bash?

I need to store in array the results retrieved from the database. So far this is basically what I'm trying with no success. Myarray=$(echo "SELECT A, B, C FROM table_a" | mysql database -u $user ...
1
vote
1answer
30 views

Setting Vim key bindings for the MySQL client

I add these following lines to ~/.inputrc and now the Postgres client, psql, uses Vim keybindings. set keymap vi set editing-mode vi However, this does not work for MySQL. I understand that MySQL ...
0
votes
0answers
21 views

Create empty MySQL database via batch file

I have read several answers here but can't see to get the syntax right. The task is to get a batch file that inputs a variable (db) and uses that variable to create an empty MySQL database. My ...
0
votes
1answer
18 views

Installing mysqld on Ubuntu 12 (LTS) non-interactively

I want to install MySQL server on Ubuntu 12.04 LTS non-interactively. For most packages, I just use the -y flag, which is described on the apt-get manpage as: Automatic yes to prompts; assume ...
0
votes
1answer
28 views

How to change MySQL status variables?

How can I change Mysql system status variables? I need to increase value for Ssl_default_timeout. Here is more about status variables: ...
0
votes
0answers
25 views

Mampstack Mysql won't start in Yosemite

So I have a problem with the latest OSX version : I installed Yosemite, and now I can't start the mysql server in mampstack I came across that link and tried to edit the scripts but I don't have edit ...
0
votes
0answers
22 views

SQL file can be returned but contents are damaged

I have a DataTraveler brand flash disk (4GB, file system - NTFS). The entire contents (directories and files) were accidentally deleted. Most of the files that were deleted. I got them back using a ...
0
votes
0answers
15 views

phpMyAdmin + TYPO3 = Error code 200, how to solve?

I'm running a TYPO3 4.5.37 with the phpMyAdmin 4.18.4 plugin installed (both latest versions). TYPO3 itself works perfectly fine and the website, too. But if I click on the phpMyAdmin extension in the ...
2
votes
1answer
45 views

Mysql.server through homebrew on macbook

i am getting the following error when trying to run mysql through home-brew. Arshads-MacBook-Air:~ Arshi$ mysql.server start /usr/local/bin/mysql.server: line 256: my_print_defaults: command not ...
-1
votes
0answers
19 views

I Need to provide encryption at rest for a 50GB MySQL instance running on Centos 6.5

I can't use GusterFS because they don't recommend it and Ceph because it's clear they can't guarantee performance. I can't just encrypt certain database objects because it will take too much ...
1
vote
2answers
21 views

Showing filenames when grepping from mysqlbinlog

I am trying to find out when some queries have been executed on our DB. For that I started looking in MySql binarylogs, using mysqlbinlog: find -name "binlog.000056*" -exec mysqlbinlog {} \; | grep ...
0
votes
1answer
37 views

Why won't mysqld start after a yum update?

This morning I ran yum update and it completed successfully. We noticed, however, that the database server wasn't running. As root, I ran: service mysqld restart Which gave me the following error: ...
0
votes
0answers
8 views

Vagrant/Puppet/MySQL localhost issue

I have a vagrant file using puppet to configure mysql. Here is the relevant code in default.pp: class { '::mysql::server': override_options => { 'mysqld' => { 'bind_address' => ...
0
votes
0answers
5 views

MYSQL ORDER BY THEN ORDER BY CASE Issue Wordpress [migrated]

I have a list of movies where the year and imdbTitle are stored in postmeta. I need to sort By year By imdbTitle and post_title by relavence to the search "the rundown" By post_content Here are ...
0
votes
0answers
13 views

High CPU Usage for Mysql after adding partitions

On a amazon m3.large instance (vCPU:2, Mem: 7.5), I run a mysql(5.5.29) server. Initially, the state of the server is OK except that the query is too slow. However, after partitioning the table into ...
2
votes
1answer
63 views

How to check variable returned from MySQL in bash?

I need to run a stored procedure using MySQL from bash. The stored procedure returns a variable and I need to check the value of the variable in bash to display it accordingly. If I echo the variable ...
1
vote
0answers
24 views

install glassfish independently, or from netbeans?

I'm running Ubuntu on a desktop and laptop, and use Netbeans as an IDE. On the desktop, $/glassfish-4.1 has everything configured properly. I may have copied a JAR for MySQL over to the libs folder, ...
0
votes
0answers
21 views

MySQL stops unexpectedly on CentOS 6.5 with WHM/Cpanel after migrating server with transfer tool

I recently moved my entire websites from a dedicated CentOS5 server to a CentOS 6.5 on Amazon EC2 with the same cPanel/WHM version. WHM 11.44.1 (build 19) However after angry calls from clients I ...
0
votes
0answers
32 views

How to connect to mysql database on a remote server behind a vpn requiring an ssh tunnel from another remote server using php?

I need to connect to a mysql database with php from a remote server. The mysql database is on another server owned by me. On the mysql server, the only permissions I have is to read and do database ...
1
vote
0answers
25 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 ...
0
votes
0answers
41 views

#1130 - Host 'localhost' is not allowed to connect to this MySQL server after acunetix scan

I am using the xampp . As stated in the question i am getting the #1130 - Host 'localhost' is not allowed to connect to this MySQL server after i ran acunetix vulnerability scan on my localhost . I ...
0
votes
2answers
67 views

How can I get MySQL workbench to always show the result grid?

When I execute a SELECT query in the MySQL workbench, the result grid appears. Then, when I execute an UPDATE, the grid disappears. Then when I run a SELECT again to view the changes, it reappears. ...
0
votes
1answer
77 views

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I have this error when trying to connect to my phpmyadmin. I tried all the solutions but nothing works. I changed password in config.inc and cleared cookies, restarted services of wamp but nothing. ...
0
votes
0answers
6 views

SQL Query for a Range of Values and One More Value [migrated]

How would I write a SQL query in MySQL to select all from a certain table where the values are between 1 and 10 and also include the value of item 15 in the results of that same query? I mean ...
1
vote
0answers
30 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 ...
0
votes
0answers
6 views

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
1
vote
1answer
18 views

No output / stdout / feedback in mysql prompt on Ubuntu 14.04

I'm running Ubuntu 14.04 and Nginx, and I recently installed mysql-server while following Digital Ocean's LEMP stack setup guide (I intend to run a WordPress site with it). When I try to log into an ...
0
votes
0answers
21 views

Why is it not recommended to use zero in an id column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...
0
votes
0answers
45 views

borked XAMPP upgrade — any way to rebuild my database if i saved var/mysql folder?

After I upgraded to Mac OS X Yosemite, the mySQL server on my XAMPP install stopped turning on. XAMPP released an upgrade that fixed this. So, I copied and pasted my "htdocs" and "var/mysql" folders ...
0
votes
1answer
73 views

PHP site doesn't work on Linux Mint

I started using a Linux Mint and I'm having a little problem. I have a project, where the main folder contains PHP files, and inside this folder there are other folders with images, JS files and CSS ...
0
votes
0answers
15 views

How not to start MySql server on EasyPhp startup?

I'm using EasyPhp 14.1 on Windows XP. I would like to know how to configure EasyPhp to start Apache webserver, but not MySql server when the app starts?
1
vote
1answer
36 views

MySQL in OS X Terminal.app — how to exit mysql command prompt but continue using the Terminal?

I type mysql and enter the mysql command prompt (denoted ~mysql) (I have ohmyzsh installed also). But I can't seem to do anything within it. No commands work. To exit, I type 'exit', and get [Process ...
1
vote
1answer
65 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
0
votes
1answer
45 views

Accessing mysql behind firewall with ssh port forwarding

I have an architecture which looks like this: | - DMZ - | ________ | ________ | _______ | CLIENT | | | SERVER | | | MYSQL | |________| | |________| | |_______| ...
1
vote
1answer
58 views

How do I use MacPorts' Perl installation with MAMP?

I have MAMP 3.0.6 and MacPorts 2.3.1. There are some Perl modules that I need to use (through some CGI scripts), I installed them on the MacPorts Perl installation (e.g., p5.16-dbd-mysql), but I can't ...
0
votes
1answer
42 views

How do I tell if mysql replication is occurring over SSL

We have a SQL server replication in place. I'm trying to ensure that the replication is occurring over secure channels. Given that MASTER_SSL_Allowed is true ("Yes"), does this suggest things are ...
0
votes
1answer
447 views

EC2 instance Linux, MYSQL log error:InnoDB: Unable to lock ./ibdata1, error: 11

I have a working server running Ubuntu 64bit with apache2 on a t2 micro EC2 instance. The problem is that MYSQL (version 5.5.38) has some bug...I tried everything, delete completely and restart ...
0
votes
0answers
23 views

Connect to MySQL from localhost and external IP

I'm struggling to get my MySQL server to accept connections from localhost and external IP adresses at the same time. It's either only local or only external IP, but never both. I have read several ...
0
votes
0answers
24 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
1answer
240 views

gcc error Python.h: No such file or directory

I have python-dev (or, as I'm on Centos, python-devel) already installed. sudo yum install mysql mysql-devel mysql-libs sudo yum install python-devel sudo yum install MySQL-python How come this ...
0
votes
0answers
41 views

OS X MySQL '/tmp/mysql.sock' error after sudo chown -R myname usr

On OS X 10.6, when installing NGINX I inadvertently (hastily, stupidly) ran sudo chown -R myname usr, and think I repaired it with Applejack (app, run from command line). However, Running the ...
0
votes
0answers
14 views

Missing Management options in MySql Workbench

I've installed MySql Workbench 6.1 and for whatever reason, I don't have any Management options (like database restore). The tab exists, but there are no items in it. My colleague has the exact same ...
-2
votes
1answer
39 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
2
votes
0answers
105 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 ...
0
votes
0answers
21 views

Command prompt freezes when I open mysql

I have searched the net and this site, but I haven't found a solution yet. I installed XAMPP, but this wasn't visible through the command prompt. I then installed 32-bit MySQL on my 64-bit machine ...
0
votes
0answers
29 views

XBMC: How to share only the librarys between 2 PCs?

So that's it, how do I do that? I mean, yes, I know how to share my library between 2 or more PCs but it also shares the Watch states and resume points and I don't want that. I want to share the ...