MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
2 views

Mysql error : #1033 - Incorrect information in file: '.\ibra_id\product.frm'

I have been search the similar case with me in this site, and I found it. mysql Incorrect Information in File: (corrupt) error. But when I try that solution to my issue, it doesn't work. My table is ...
0
votes
0answers
7 views

MySQL Unable to cd to '/nonexistent'

After a server restart, our MySQL server completely broke. When trying to start Mysql with service mysql start we get the following: Unable to cd to '/nonexistent' ...... * MySQL Community Server ...
0
votes
1answer
11 views

Is there a way to find out why MySQL crashed or quit working?

I have MySQL running on an Ubuntu 12.04 web server. A basic LAMP stack. I just have a couple of small websites running. a WordPress site A SugarCRM app little apps here and there. Only 2 ...
0
votes
1answer
2 views

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the ...
0
votes
0answers
29 views

Ubuntu MySQL won't start because disk is full, but it isn't

I've a Linode with Ubuntu (12.04.4 LTS) installed. The HDD is 200GB but when I log-in via SSH, it tells me this: Usage of /: 99.1% of 8.83GB MySQL fails to start because there is no free space... ...
0
votes
0answers
25 views

MySQL production server experiencing high traffic from debian-sys-maint user

I am running a MySQL server on Debian 7 in a production environment. I recently (more or less accidentally) took a look into the server stats that can be shown in phpMyAdmin. I saw that the MySQL ...
-7
votes
0answers
22 views

Is ACID related to the snort's mysql support? [on hold]

Recently I just knew that snort does not support mysql anymore from http://blog.snort.org/2012/07/database-output-is-dead-rip.html. Otherwise, I should use Barnyard instead. But I found I could not ...
-5
votes
0answers
35 views

What System Does Facebook Use To Manage It Files? [on hold]

How Does Facebook Manage It System ? What System Does It Use To Manage It Files , Database , etc.. ?
0
votes
1answer
27 views

Reducing the size of MyISAM table

I have a MyISAM table that currently contains about 54 million records and is 20 GB in size. Poor choices were made when this database was designed. I'm no DB pro but since this table is constantly ...
0
votes
0answers
7 views

How to use XAMPPs tomcat server and MySQL with eclipse [on hold]

I want to create a Dynamic Web Project in Eclipse, but that option isn't available since DB and local server hasn't been configured. I downloaded XAMPPS How can I use the MySQL and Tomcat server of ...
0
votes
0answers
16 views

VServer Apache: Is 5s page load normal for ~100 clients?

I administrate a virtual server with 16x Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz with a shitload of 32GiB system memory. The server is used as a web server and has 100 to 150 users at rush hour. In ...
0
votes
0answers
16 views

Given: iptables entry in place; my.cnf properly set up; MySQL user & permissions properly set - but still cannot access MySQL remotely: Suggestions?

I would like to access MySQL remotely on an Amazon EC2 CentOS instance (I assume it is CentOS because I use yum to update installed applications and libraries). I believe that iptables is set ...
0
votes
0answers
11 views

Change timeout only for particular instance of mysqldump

I'm trying to make frequent backups of my DB. But the DB is large and dumping take several minutes; in order for it to not have an impact in the server's operations regarding disk usage, I lower its ...
0
votes
0answers
28 views

MySQL/Percona Server sudden CPU usage spikes

I've got some trouble with Percona Server 5.5: suddenly abnormous MySQL CPU usage caused the system to become unresponsive as it was eating up all CPU with a large number of threads. It's a 24 core ...
0
votes
1answer
43 views

unable to login remotely in MYSQL

I am very new to mysql and I want to use remote login I followed this stack process but the command gives me nothing on the screen as listed on that link $ lsof -i -P | grep :3306 $ this is the ...
0
votes
0answers
6 views

Couldn't connect to MySQL remotly without skip-grant-tables option [duplicate]

I trying to connect to MySQL remotely over a Win Server 2012 EC2 instance, to do so I'd: Enabled inbound traffic to MySQL port 3306 in the EC2 Security Group; Disabled Windows Firewall service. ...
-2
votes
1answer
17 views

Import MySQL Database : No such file or directory

Im am trying to get the following script to import a database. Every time I run the script I get a mysql -u username -pmypassword my_database < /var/hostdata/databases/my_database.sql -bash: ...
0
votes
1answer
20 views

Can't add Nodes to Percona XtraDB cluster

In my case, I have two nodes in cluster, but when I use $service mysql bootstrap-pxc to start XtraDB cluster, I found nodes were not added to cluster. I also check /var/log/mysql/error.log, but no ...
0
votes
1answer
20 views

mysql tunnel restrict server login

We currently only allow external mysql access by using ssh tunnels (with a variety of read only/write/admin users) with each end-user having a different user login on the server. Is it possible to ...
-1
votes
1answer
17 views

Run two mysql process on one data directory

I would like to launch two mysql process on one data directory (/var/lib/mysql) I have two servers, web-01 and web-02 but web-01 locked mysql data directory, and i would like to break this security. ...
-1
votes
0answers
15 views

I get the error message of: #2054 - Connecting to 3.22, 3.23 & 4.0 servers is not supported [closed]

I have installed and uninstalled almost all of the versions of phphmyadmin. I have also tried to uninstall and install xampp few times. Every time I try to connect, I get the below error messages: ...
0
votes
0answers
18 views

MySQL ALTER TABLE table_name AUTO_INCREMENT=1 doesn't work [migrated]

I'm using yii and it's test system. Yii's fixture manager resets tables and their AI keys so: DELETE FROM table_name; ALTER TABLE table_name AUTO_INCREMENT = 1; It was working good on server before ...
0
votes
0answers
10 views

MySQL binary log location Windows 2008 Server

I'm running a Windows 2008 Server with IIS, PHP and MySQL. MySQL is installed as a service. There's software on the server that uses a database that I need good backups of, including transaction ...
0
votes
1answer
22 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. ...
0
votes
1answer
20 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
16 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
13 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
26 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
12 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
47 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
votes
1answer
41 views

mysql_install_db command fails after upgrading MySQL5.0 to 5.1 [on hold]

I've upgraded MySQL 5.0.84 to 5.1.72 in an Ubuntu 14.04.1 LTS machine. I have downloaded the source code 5.1.72 from Internet and followed the steps as described in the Ubuntu help. ./configure, make ...
1
vote
1answer
37 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
17 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 ...
1
vote
0answers
38 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
80 views

Can't start MySQL on CentOS 7 [closed]

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
35 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
16 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
13 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
29 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
1answer
24 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 ...
0
votes
1answer
22 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
34 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
35 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
63 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 ...
-1
votes
2answers
58 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 ...
0
votes
2answers
56 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
34 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
21 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
104 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 ...