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
0answers
8 views

Configuring a centralized rsyslog server with MySQL database, gathering events from multiple servers

I'm trying to configure my rsyslog server to collect logs from many servers and write them to a local database. The problem is, the server writes the data to the DB as local (host, ip, etc) I'm ...
0
votes
2answers
14 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
0
votes
1answer
7 views

MYSQL Connector J in Ubuntu

I'm relatively new to Ubuntu and am developing an application using MySql Server. My question is, where do I put the file? I know in Windows the connector goes in the 'lib' file of the project. Does ...
1
vote
0answers
13 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
0
votes
1answer
30 views

centos7 not installing mysql

I've installed centos7 recently, but, when I am trying to install Mysql using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
0
votes
1answer
10 views

How to change ports in UniserverZ and/or Uniserv?

I'm asking this because every single time i need to update the program, the configuration file is updated too and the port must need rechanged, but my question is honest because: 1) When i try to use ...
1
vote
1answer
23 views

Does windows 7 stop services/processes if low on ram?

I am having an issue with some customers where a service is stopped (Mysql). Mysql uses a fair amount of memory and I am wondering if windows decides to stop it when low on ram. Is there any other ...
0
votes
1answer
21 views

PHP installation issue on a Windows Server hosted in the Azure cloud

I am trying to setup PHP and MySQL on a Windows Server that is currently in Azure cloud using the information from this blog post. Now I am testing the PHP installation using the methods specified in ...
2
votes
1answer
27 views

Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column. For example, in one ...
-1
votes
1answer
22 views

Install mysql on windows on windows 7

When I had a job, MySQL was installed on the Linux server and I used to connect using Xshell. Now, I want to install it on Windows 7 and have a good command line interface (better than cmd). I have ...
0
votes
1answer
26 views

Command Line utility for MySQL

I want to download only MySQL command line utility. I tried searching but unable to find. I even downloaded the entire MySQL Community edition and tried installing only MySQL Utility but the installer ...
0
votes
0answers
6 views

Sequel PRO remote connection to a VPS

I'm using Sequel PRO to establish remote connection to my clients servers but every time I try to remotely connect to a VPS server it gives me the following error: Unable to connect to host ...
0
votes
1answer
23 views

Converting MSSQL Dump to MySQL Dump on Ubuntu

I only have Ubuntu to work with, so Windows programs are not going to work for me. But basically I have both the .bak file and the .sql file from a MSSQL server and I need to import this data into a ...
1
vote
1answer
21 views

Error 10053 on wampserver after sleeping the computer

I use WampServer for development testing purposes on my local computer (windows 8). I don't usually turn off the computer, I just close the cover (a laptop) and it sleeps. When I open it again, the ...
0
votes
0answers
18 views

Migrate Jira to MySql - Unknown system variable 'storage_engine'

I'm migrating JIRA in Windows from HSQL to MySQL and i got stuck with message Unknown system variable 'storage_engine'. Though i created backup, installed MySQL, copied J connector to libs of JIRA. ...
0
votes
1answer
24 views

MySQL server copied from Windows won't start on Ubuntu Linux

I have an external hard drive (formatted NTFS) to which I copied the MySQL data folder from a machine running Windows 7. I have been successfully able to start/stop/use MySQL on the Windows machine ...
0
votes
0answers
44 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
0
votes
2answers
27 views

Services don't have MySQL Server. How to run it?

I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there: But ...
0
votes
0answers
8 views

Result grid in right sidebar in MySQL Workbench

I am using MySQL Workbench. The result grid is always shown below the script window. Can I somehow place the result grid in the secondary sidenav, having the script window and result grid as a split ...
0
votes
1answer
13 views

MySQL: Port issues on an domain network setup

I am looking for options to have a MySQL server on corporate environment where opening a port in the Windows Firewall is quite difficult (a lot of red tape). At this point I am not looking to have a ...
0
votes
2answers
37 views

SSH Connection is established on port 22, but service is not working

I am having this recurrent issue on one of my MySQL Cluster Servers, actually always happens in any random MySQL server of this cluster, on many countries where we have this same configuration. I ...
0
votes
0answers
29 views

How to remotely connect to MySQL database running on Windows Server 2012?

I've been developing my web application locally, but now I need to test remotely. I have a Windows machine running Windows Server 2012 with XAMPP installed and configured. How can I connect remotely ...
1
vote
1answer
49 views

How do I edit an xmlTV file using sed (or a similar tool)?

I have an xmlTV file that looks like this: <channel id="10125.dvb.guide" <!-- number="62" type="0x1" flags="0xf" bouquet="4097" region="4a" sid="10125" -->> <display-name>ITV ...
1
vote
1answer
61 views

Shell Script - Loop to make multiples MySQL Query at once

I've tried to handle this problem, ive a little script to conect into a list of host stored in a file. #!/bin/bash num=$(wc -l < ip.txt) while read ip; do mysql --login-path=login -h $ip ...
0
votes
0answers
14 views

asp connection to asphostportal mysql database

I'm trying to connect via asp to a asphostportal mysql database on their server. I've created the database and added a users table. I have an opensource intranet (UAPortal) that is really ...
0
votes
0answers
16 views

Mysql service is not starting on windows 7

on windows 7, i have started the mysql service (mysql server 5.5) which is running quite fine but when i am trying to start another service named as mysql4 (mysql server 5.1) on same system it gives ...
0
votes
0answers
33 views

Will a homebrew installation of mysql conflict with xampp or netbeans?

I had mysql installed on my OS-X machine via macports a while back. I think it ended up conflicting with something I used for a wordpress test site (something like XAMPP), and I wasn't able to ...
1
vote
1answer
28 views

Recover broken MySQL database after setting Windows back to an earlier date

Yesterday after a driver update my Windows crashed and I got a BSOD right at startup so I didn't had a choice I set Windows back to the last working point but sadly my last working restore point was ...
1
vote
1answer
40 views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: ...
2
votes
1answer
137 views

odbc error connecting mysql: “sql server does not exist or access denied”

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
0
votes
1answer
15 views

how to save mysql dumps for N days?

Is there any best practice for saving mysql-dumps daily backups for 30 days and then delete them, without writing scripts that checks date and delete? maybe a builtin tool?
0
votes
0answers
22 views

can't log into phpmyadmin from browser

It gives the error This server could not verify that you are authorized to access the document requested. Either you supplied the wrong credentials (e.g., bad password), or your browser ...
0
votes
2answers
42 views

Wrong IP address present when connecting from localhost to localhost

I have a Linux server with Ubuntu installed on it. When I connecting to some service (MySQL, apache, icecast for example) from the same machine at address 127.0.0.1, they all show that I connected ...
1
vote
2answers
46 views

MySQL connection works on CLI, but not on Workbench

Fedora release 20 (Heisenbug) 3.19.3-100.fc20.x86_64 Packages: mysql-workbench-community.x86_64 6.1.7-1.fc20 mariadb.x86_64 1:5.5.41-1.fc20 ...
27
votes
8answers
3k views

Can a massive MySQL data import on an SSD damage it?

I have to import quite a lot of data (~100 million rows, ~100 times) into a MySQL database. Currently, it is stored on my hard disk drive, and the bottleneck of my import seems to be the hard disk ...
1
vote
1answer
20 views

How to confirm apt-get confirmation during mysql-server installation

I am trying to write bash script that will install mysql-server-5.6 I want to ask user for password and then I will use it during installation mysql-server and some other configuration. But my script ...
1
vote
1answer
30 views

MySql service start fails without anything meaningful (CentOS 7)

[root@myserver my.cnf.d]# service mysql start Starting MySQL. ERROR! And this is all I get. I tried checking the logs but couldn't find anything related to this. The database worked perfectly fine ...
0
votes
1answer
32 views

Allowing remote connections for MySQL on Ubuntu 14

I am trying to connect to MySQL using a program called Heidi, I want to use this instead of phpmyadmin. It's better than phpmyadmin and I figured it would be more secure than going to ...
-1
votes
1answer
35 views

Incorrect syntax near 'AUTO_INCREMENT' [closed]

I get an error on AUTO_INCREMENT while creating the following table. Please help. CREATE TABLE Invoice( Invoice_No INT NOT NULL AUTO_INCREMENT, Order_ID INT NOT NULL, TotalPrice VARCHAR(30) NOT ...
0
votes
1answer
41 views

Google Maps API and bandwidth consumption

I have a site that uses 2 Google Maps APIs. https://maps.googleapis.com/maps/api/js and https://maps.googleapis.com/maps/api/geocode/json This "mapper" site communicates with 2 Google Maps APIs, ...
0
votes
1answer
18 views

Sub-domains keeps redirecting me to Main web-site

I have just upgraded my version of LAMP Environment. Rest all the things are working fine but with Sub-domains i have a challenge. I have a Main website abc.biz and 5 to 6 sub-domains with it as ...
1
vote
1answer
24 views

Unix permissions error when working with symbolic link and MySQL installation

I'm working to install MySQL on one of our servers. I'm the ec2-user, and I'm attempting to install in the ec2-user home directory, but allowing access to the directory to the mysql user. However, ...
2
votes
1answer
66 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
0
votes
0answers
18 views

Exporting / Importing MySQL from/to different character sets

It's fairly straightforward. I have a db running tables with DEFAULT CHARSET=utf8; The collation is set to utf8_general_ci. Everything is working fine. The application that uses this database saves ...
0
votes
0answers
18 views

Can't change system variables from config files on MariaDB/MySQL on Linux

I want to change two system variables on my MySQL testing server, namely collation_server and collation_database from latin1_swedish_ci to utf8_general_ci, because its annoying that everytime I create ...
0
votes
0answers
20 views

Moodle downgradedcore error

I have a moodle installed on a VPS. MySQL server has stopped, so I have made a power cycle on my server. After restart I have got the following error on admin login: ERROR!!! The code you are using ...
0
votes
0answers
41 views

Starting MySQL database server: mysqldinstall: invalid user `mysql'

i have a problem with mysql on my Raspberry Pi running Linux raspberrypi 3.18.7+ #755 PREEMPT Thu Feb 12 17:14:31 GMT 2015 armv6l GNU/Linux. This is error I have when I run sudo service mysql start ...
0
votes
0answers
17 views

Webmatrix 3 - MySQL

Ive got a newly formatted computer (Win7x64). I've installed Webmatrix 3 fine. When i start something from the gallery that needs a db for php, say joomla, wp or just a php app, it gets to step 4 for ...
0
votes
1answer
14 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
0answers
40 views

Can't access mysql db on Azure Ubuntu VM

Trying to access the DB from a remote system - tried with a Wordpress install and get "erro trying to connect to database" and also tried just using a test php file and get a white screen - no errors ...