MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
15 views

MySQL server stops. Cant find the reason in log files

I am running a Debian ISPConfig MySQL Php Apache server for hosting a web application and some of my websites. I am using uptime robot for monitoring too. The MySQL server gets stopped at times. ...
-1
votes
0answers
3 views

Integration Platforms for Dynamics CRM and MySQL

I'm interested in integrating Dynamics CRM with MySQL database. Can any one suggest an software solutions for integrating these together? I have used Jitterbit in the past but the hefty price tag ...
0
votes
1answer
14 views

cronjob executing mysql and get root access denied

cron job file: 46 13 * * * root /home/tmp/test_mysql.sh script: execute_query(){ query="$1" res=`mysql --skip-column-names -e "$query"` echo "$res" } res=`execute_query "show ...
0
votes
1answer
13 views

MySQL spends too much time cleaning tmp tables

I'm running some Django migrations on an AWS RDS MySQL instance. My team has tested the migrations very thoroughly and they ran fine (even taking less than 30 minutes when run on our laptops against a ...
0
votes
1answer
12 views

Linked MySQL Server Hanging on Insert

I'm running a task every 5 minutes on MS SQL Server 2008 that links to MySQL on another server in the network. It works probably 80% of the time. The remaining 20% results in MySQL hanging, and a ...
0
votes
1answer
24 views

Where do you edit the MySQL config?

Hi I am looking to change the minimum amount of characters MySQL needs to do a full text search and I can't seem to find that file. The code I am looking to paste in is ft_min_word_len=3 What file do ...
0
votes
0answers
8 views

Percona xtradb cluster MASTER MASTER asynchronously

I have setup a percona master-master cluster the same way as detailed here: http://www.percona.com/doc/percona-xtradb-cluster/5.5/features/multimaster-replication.html The document doesn't say but I ...
0
votes
1answer
37 views

MySQL in CentOS can't start service

after I reboot my server, I can't start mysql: $ sudo service mysql start $ Starting MySQL. ERROR! Manager of pid-file quit without updating file. "/var/log/mysqld.log" shows: 150225 21:39:49 ...
-1
votes
0answers
4 views

How to find the unicode character of a particular tamil word in mysql [migrated]

I need to find the length of particular tamil word in the mysql database. I used the command SELECT LENGTH(phrase)as Len FROM table WHERE Condition; But i did not get the correct length.. What is ...
1
vote
1answer
26 views

Special characters in mysql password using mysqldump

I have the following ssh script: #Here I am getting the mysql password for the root user password=$(cat /root/.my.cnf | grep "password" | awk -F\" '{print $2}') #here I am trying to dump the ...
0
votes
1answer
15 views

http requests working on KVM virtual machine, mysql not?

I have an Ubuntu server with KVM virtual machines. I allowed SSH in the firewall so I could access the host. Also I allowed incoming traffic that has state related, established. This is the full ...
-4
votes
0answers
17 views

nginx Query Driven Content per Every Page and Angular.js Frontend [on hold]

I was originally considering nginx for a new project hosted on a Linux box. Every page on the website will be primarily dynamic, derived from numerous database queries. Most every page will contain an ...
0
votes
1answer
33 views

Tools for scanning database for viruses [on hold]

I wonder if anyone knows some useful tool for scanning threats like sqlinjection, command injection in mysql databases? The db is for multiple wordpress, drupal installations. The first step obviously ...
1
vote
0answers
28 views

Mysqldump complains about chosen databases regardless of command line

Mysqldump complains about command line options I have never specified. I don't have shell aliases nor a custom .my.cnf file set. What am I doing wrong? Using the --database long option: $ mysqldump ...
-3
votes
1answer
57 views

Can't start MySQL on CentOS 7 [on hold]

The system had MariaDB before which I couldn't start either. Now I deleted MariaDB and installed MySQL. $ mysql --version mysql Ver 14.14 Distrib 5.6.23, for Linux (x86_64) using EditLine wrapper ...
0
votes
0answers
34 views

Database import error with no reason

Can't import dump of bd because of error importing with no reason! CREATE TABLE IF NOT EXISTS `phpbb_acl_users` ( `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `forum_id` mediumint(8) ...
0
votes
1answer
15 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
0answers
8 views

Testing MySQL 32-bit ODBC connection via CMD

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There ...
-1
votes
0answers
22 views

MySQL databases, phpMyAdmin, exporting and importing = CORRUPTED :(

I tried to export all of the MySQL databases using phpMyAdmin as an SQL file. After downloading it, I did an SCP of it to the new server which is a local to remote transfer. Now, when I am trying to ...
0
votes
0answers
18 views

FULLTEXT search not working [closed]

I am using FULLTEXT index for search word in five table. Now if i am going to search by using below search keyword then search process getting stuck. Keyword : test - test * test + test _ So can ...
0
votes
1answer
19 views

How to install only mysql client on solaris?

I have a mysql server already running on RHEL 5 server. I have other Solaris 10 and Solaris 11 machines (SPARC based T4-4 servers) which need to connect to the server. I downloaded a pkg ...
-2
votes
0answers
13 views

Migrate a site from localhost [closed]

I am completely new to web development. I recently learned PHP,HTML,JavaScript and MySQL and could develop a website that runs on my machine. Where should I start off with buying a domain? Do hosting ...
0
votes
1answer
18 views

InnoDB “Table xx Is Full” during database alterations

I am running Percona Mysql Server 5.6.14-56 on CentOS 6.3 64bit. Server has plenty ram (96gb) and storage free. File system type: ext4 dev/sda6 ext4 1093623528 56576512 981494148 6% ...
1
vote
1answer
30 views

granting database permissions in mysql

I have a new mysql installation and am trying to create a separate user to have have access to their own database. mysqladmin -u root -p create people mysql> create user 'cgp'@'localhost' ...
0
votes
1answer
30 views

phpMyAdmin can't import file exported from command line [closed]

I have two web servers: a live server (Server A) and a development server (Server B). I am often required to export the entire database contents from B and import into A. This was previously done from ...
0
votes
1answer
52 views

Can't boot Mysql on Centos 7

I've installed mysql on Centos 7 (mysql-community-server) as root. The problem is that I can't start the daemon with "service mysqld start", It never return me to prompt and even if I try to use ...
0
votes
1answer
49 views

Can't log into mysql server root user using password?

root@DS-S007:/etc/dspam# mysql -u root –ppassword ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) root@DS-S007:/etc/dspam# I clearly specified a password. Why ...
-1
votes
1answer
26 views

Having difficulty adding MySQL dependencies to pom.xml [closed]

I followed the TomCat getting started example, and their linked guide to git based WAR file deployment, which told me to delete the src and pom.xml files when publishing a war file from /webapps - so ...
0
votes
2answers
54 views

Is it OK to have database name the same as user name in MySQL?

Many web services require a database and quite often that is MySQL. Typically, the installation instruction of the software tells you to create a database and a user with permission for that database. ...
1
vote
0answers
31 views

PHP requests to insert to database are missing [closed]

i have this code in PHP that insert the data to DB 1 table, for example: The DB Table CREATE TABLE IF NOT EXISTS `thistable` ( `id` bigint(20) NOT NULL, `code` varchar(7) NOT NULL, `sku` ...
0
votes
0answers
19 views

Mysql sed error

I upgraded mysql from 5.5 to 5.6 in Debian 7 Wheezy box via apt-get command and all seems fine, but when I restart mysql, I get: [info] Stopping MySQL Community Server 5.6.23. ...... [info] MySQL ...
0
votes
2answers
99 views

How to troubleshoot high CPU usage on a server?

On my cloud server, the MySQL CPU usage jumps to over 100% on Sundays at 1PM GMT. How can I troubleshoot the cause of this? I have been told to run the cmd 'top' on the server but this only tells me ...
0
votes
3answers
66 views

MySQL “Duplicate entry” Errors on the Slave break replication all the time

I followed this tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql Unfortunately the replication stops on the slave all the time with: ...
1
vote
1answer
21 views

Mysql Undocumented Default Setting for sort_buffer_size in Options File

From a recent install of MySQL Workbench V. 6.2 (MySQL 5.6), while inspecting the options file (Edit > Preferences > General) I see that sort_buffer_size is set to 256k\n256k. What does the \n256k ...
-4
votes
0answers
20 views

Make a copy of my website [closed]

I am a new web developer. I use FileZilla and I want to make a copy of my website, so as to test some changes on it. How can I do that? My scripts are written in ASP.. Anyone?
0
votes
1answer
42 views

mysql innodb crash assertion

I've got some very big trouble with my innodb database since friday. The mysql server crashes whenever I do some operations on a specific table which is about 22GB. inserting data works, all other ...
0
votes
0answers
25 views

Trying to replicate a MySQL 5.6 master, the replication server crashes

We run a MySQL 5.6 server that acts as a replication master. Recently, due to some other bug in upgrading from 5.5 the replication seems out of sync so we're trying to create a new replication on a ...
1
vote
1answer
26 views

MySQL Server fail to restart after trying to import database from command line

My server is CentOS 6.5 64bit, running MySQL 5.5.42 community server by Remi. I tried to import a database from command line by running mysql -u root -p website_database < website_database.sql ...
0
votes
0answers
4 views

How to create insert procedure with input parameters in xampp ? and where it is located in PHPADMIN [migrated]

how to create insert procedure in mysql using XAMPP and where it will be located ? how to see my procedure in phpmyadmin ? here is the query delimiter // CREATE PROCEDURE reg_db ( uname ...
0
votes
1answer
43 views

localhost != localhost for MySQL/PHP

System: Mac OS X Server 10.6.latest I just switched from the ancient MySQL (<5?) that came with Mac OS X Server to MariaDB 10.1, installed via MacPorts. (That was a whole 'nuther barrel of fun...) ...
-1
votes
1answer
13 views

Is there any way to backup all mysqldatabses in single file

Usually i have cron job to dump separate databases in separate sql file and then i can restore it. Is there any way , any command so that i run as cron job everynight and i have single file which i ...
0
votes
1answer
58 views

why won't mysql accept connections from local programs?

I am getting a "Host 'mydomain.com' is not allowed to connect to this MariaDB server" error whenever a program on my CentOS 7 server tries to access the MySQL/MariaDB database located on the same ...
0
votes
1answer
56 views

Ubuntu apache process consuming 100% cpu PHP/MySQL app

I have a server at Rackspace connecting to a Cloud DB instance running MySQL. I'm not a server admin so I apologize for not having enough data. I'm having a hard time determining what is causing my ...
-1
votes
0answers
15 views

mysql return true when int = 1 [migrated]

this seems a simple question, but i cannot find the awnser. I want to save a true/false in my mySQL database. So i'm saving 1/0 in a INT column. When i select this i get the 1/0, but i want it to ...
0
votes
1answer
20 views

mysqldump without SQL_BIG_SELECTS

Trying to dump all databases for replication creation using mysqldump --all-databases --master-data --single-transaction > all_databases.sql Results in the following error mysqldump: ...
0
votes
0answers
20 views

MySql server keep crashing inside docker

I am running mysql inside docker with its /var/lib/mysql mounted on HOST. Eveything was working fine . Then i upgraded the docker from 1.4 to 1.5 . I rebuild the mysql image and but /var/lib/mysql ...
0
votes
1answer
78 views

CentOS 7 : cannot create mysql.sock

I've installed MySQL on CentOS 7. It looks fine, start mysqld service and change root password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ...
2
votes
1answer
41 views

Sending Data extremely slow or RDS

I have the following two profiles for a basic SELECT STATEMENT: select count(*) from mturk_completion; Here are the two profiles: # My Local machine, using a local db Status ...
0
votes
0answers
32 views

Yet another “Can't connect to local MySQL server through socket” after a security update

SOLVED As yoonix pointed out, it was only an issue with the root partition being full... Thanks for your help! - So yes, this question has been asked several times, here and elsewhere. I apologize ...
0
votes
1answer
36 views

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 ...