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
22 views

store mysql database details in linux

I have a test server and live server which has all the files the same (a cio) except I want to connect to a test copy of my msql database on the test server. How secure would it be to have a ...
1
vote
0answers
128 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 ...
0
votes
2answers
43 views

Linux server update

I know that for security reasons the server services have to be up to date, and since my server was attacked by a virus I think this a good time to upgrade the system. Linux sytem: Distributor ID: ...
1
vote
0answers
88 views

Mysql Master database goes offline for a while and slave database do not update data changes made during downtime [closed]

I have configured master-slave bidirectional replication.Both are syncing database properly.When master goes offline/down(disconnected from slave) and meanwhile I make some changes(create/delete table ...
0
votes
0answers
32 views

Bizarre lag in HTTP connection

Running on a LAMP stack, CentOS 6, Apache 2.2.3, PHP 5.4.25, MySQL 5.5.31 Have a very complex web application. It's been running pretty smoothly for about 5 years, now. Of a sudden we've run into ...
0
votes
1answer
147 views

Can i give foreign key relationships of ODBC tables from ms sql to ms access

I have a question regarding the ODBC relationships between SQL and MS ACCESS as i have migrated several tables from SQL to ms access and i performed some operations but the problem occured in ...
0
votes
4answers
719 views

Internal server error on user_directory

Today I am trying to install httpd and mysql on my fedora 14 PC. That works fine. After this I try to create a public_html folder on the user directory and allow php to access that folder. For that I ...
3
votes
4answers
2k views

bind-address = ::1 # however, netstat shows 0.0.0.0:3306 LISTENING

I'm running MySQL 5.6 on 64-bit Windows 7 with IPv6 and IPv4 enabled. In my.ini: port=3306 bind-address = ::1 I was hoping to use IPv6 and restrict to the loop-back adapter. I used ::1 instead ...
0
votes
0answers
64 views

Save rows effected from mysql delete statement in bash

I am trying to create a bash script that will connect to my database and purge older records, I would like to keep a record of the number of rows are deleted in a file (lets call it rowseffected.log). ...
1
vote
2answers
143 views

Nagios: monitor mysql auto_increment overflow

Recently we had an overflow in an auto_increment column in a mysql table. Now I'd like to monitor our databases with nagios, so that we'll be alerted whenever an auto_increment column comes near to ...
1
vote
0answers
50 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 ...
0
votes
0answers
52 views

Reading Text file in Where clause in mysql

I want to look up a table upon certain column whose values are present in text file in mysql. like select * from table where user LIKE '%user1%' here all users like user1, user2.. usern are stored in ...
0
votes
1answer
87 views

Why there is always a tilde (~) sign in the result message in mysql

Whenever I refresh or search anything in the table in mysql, the result message always shows result like this. Showing rows 0 - 10 ( ~11 total , Query took 0.0004 sec) When it is showing the exact ...
0
votes
3answers
69 views

Setting up a local webserver using CentOS on VM

im new here, and basically new at setting up a webserver... now im already googling, and searching here in stackexchange on how to setup a webserver, they tend to direct me to a working server.. i ...
0
votes
1answer
136 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
1answer
1k views

MySQL Notifier High Severity Error at startup

When i start MySQL Notifier up and error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when i click over "Show Details" I can see the ...
1
vote
1answer
186 views

How to ensure version 5.5.* for mysql with puppet?

How can i ensure that the latest patch version of 5.5 will be installed by the yum installer under CentOS? class { '::mysql::server': package_ensure => '5.5.*' }
1
vote
1answer
666 views

Can't find mysql data in install directory

I was looking for my mysql data on my harddrive, so i went to the install directory (C:\ProgrammData\MySQL\MySQL Server 5.6\data) but there are only a few of the databases displayed I actually use. ...
2
votes
1answer
592 views

MYSQL fails with: InnoDB: Operating system error number 30 in a file operation

My MYSQL server has been stopping recently about once a week. It requires a reboot to get is working again. But once its rebooted, it will work again for another week or two. The error in question is ...
0
votes
1answer
319 views

mysql_secure_Installation is missing in my mysql installation

I'm following this guide with my new Linux AMI on EC2. After installing mysql: yum install mysql-server And running it: service mysqld start I tried running: mysql_secure_Installation But ...
1
vote
1answer
4k views

WAMP - Reset Root password on mysql

I'm getting this error: access denied for user 'root'@'localhost' using paswword (NO). Its a fresh install of wampserver 2.2 32 bit. Is there a way I can reset the mysql root password? I have tried ...
0
votes
0answers
50 views

AWS RDS Reserved Instance vs on Demand Instance

I've set up several AWS RDS on-demand instances. Each time, the process was the same, and it included selecting instance type, capacity, storage, etc. When I'm done, and click on the instance icon, I ...
0
votes
2answers
788 views

csv file to phpmyadmin import error

here is the pattern of my csv file -------------------------------------------------------------- | col1 | col2 | | col4 | | ...
1
vote
1answer
2k views

MySQL can't create pid file: Permission Denied

I'm using MySQL on my macbook pro, which worked fine for the last 2 years. A week ago it suddenly stopped and I'm not able to restart it again. I've changed the permission on /usr/local/mysql to 0777 ...
0
votes
1answer
272 views

Start server: /bin/sh: 1: /etc/init.d/mysql: not found

I have tried MySQL workbench on linux mint 14, and got this Start server: /bin/sh: 1: /etc/init.d/mysql: not found error when trying to start local server on it. Please help how to resolve this ...
0
votes
1answer
25 views

Editing finished mysql table

I'm new to mysql and I want to edit my table. My primary key should be auto generated. So where can I get the option to edit my table? thanks
0
votes
1answer
72 views

How to check if mysql server is active in Linux

I'm writing a monitoring script to restart mysql server if it is down in Linux( Centos+Cpanel). Will running the command: "mysqladmin status" be sufficient to be sure that it is fully functional?
1
vote
2answers
449 views

Linux server running out of memory

I have a VPS with a hosting company. I do have some badly written perl scripts tha use MySQL. My MySQL server crashed. The hosting company says the server ran out of memory. At a time when I have ...
0
votes
0answers
60 views

Connecting To MySQL with MAMP via Terminal - Mountain Lion?

I just installed MAMP 2.2 and use OSX Mountain Lion and am having trouble connecting to MySQL via the Terminal prompt; iMac:~ Home$ mysql -u root -p root -bash: mysql: command not found Sudo: ...
0
votes
2answers
113 views

Replace string in string but not when its somewhere between double square bracket

I have a long string from mysql field containing the data of a mediawiki page. I have to replace a string in that mediawiki page but not when the string is in mediawiki link. The mediawiki link is ...
2
votes
1answer
50 views

MySQL “lost” all data (InnoBD)

Today I was making some work with site and I get error what MySQL can't rename file (to make changes in BD). Next I tried to restart MySQL, and it failed to stop MySQL. Then I did go to /var/lib/mysql ...
0
votes
2answers
63 views

MySQL server stopped working

Yesterday, out of the blue, the MySQL working as a backend for my private postfix server stopped working. No log entries, nothing, it just won't start. I reinstalled it and it worked until I copied ...
0
votes
1answer
274 views

Mysql error in Ansible task

Hello I am running Ansible with Vagrant. But with one of of my Mysql tasks I get the following error TASK: [MySQL | Delete anonymous MySQL server user for example.com] **** fatal: [default] => ...
0
votes
1answer
1k views

How to resolve Apache Service path conflict - running both Apache and portable XAMPP on Windows 7

I've got Apache 2.4.7 (Win32) running on Windows 7 and a visiting portable XAMPP on an external drive. After resolving the port issues I'm "only" down with having the "Apache/MySQL Service detected ...
2
votes
1answer
2k views

Can't start MySQL on Fedora 20

I'm a newbie with Fedora and MySQL. I just installed Fedora 20 (virtual), then installed Apache and started it and then installed MySQL. When I tried to start MySQL using this command: sudo service ...
0
votes
0answers
72 views

Analyzing MySQL network traffic usage

I have a MySQL server and an application server (running Python/Celery), communicating via standard TCP. A couple weeks ago, the network traffic between the two servers jumped from less than 1GB/day ...
1
vote
1answer
1k views

What is the difference between MySQL, SQLite and other SQL servers?

I was digging around in my server and I started to wonder what the difference is between MySQL and SQLite and other SQL servers. If anyone can make this clearer, could you also explain if they have ...
-1
votes
2answers
90 views

How to make a MySQL database on Ubuntu server? [closed]

I am trying to make a WordPress blog and install WP manually, but the MySQL databases are giving me headaches. Can someone explain what is MySQL and how to make a database? I am using Ubuntu Server ...
1
vote
2answers
135 views

clear currently edited line in mysql console

What key combination will clear MySQL console command line? I am not sure if this is just a sub scenario of clearing the currently edited line in any Unix/Linux terminal or is the behavior actually ...
1
vote
0answers
1k views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
0
votes
1answer
466 views

SLES11 - DBD: Can't load driver file apr_dbd_mysql.so

We're trying to set up a htaccess authentication with user data from a MySQL database. The part of vhost.conf looks like that: DBDriver mysql DBDParams "host=<XXX> dbname=<XXX> ...
2
votes
2answers
2k views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
4
votes
1answer
108 views

Autostart PtokaX at boot only after mysqld has started

I've the following script in /etc/init.d/server.sh #!/bin/bash ### BEGIN INIT INFO # Provides: PtokaX server # Short-Description: PtokaX P2P server ### END INIT INFO ...
0
votes
0answers
91 views

Trying to run toad for mysql with wine in mint 16

I'm trying to run toad for mysql with wine in mint 16, however I get this error: me@me-mint ~/Downloads $ ./ToadforMySQL_Freeware_7.0.0.2038.exe fixme:storage:create_storagefile Storage share mode ...
1
vote
1answer
49 views

Dual web servers that load balance and point to the same database

So I am currently running a web server at my house with a Raspberry Pi. Quite successfully might I add. The only problem is that sometimes the SD card becomes corrupt and my site goes down for an hour ...
0
votes
1answer
64 views

Understanding Postfix and Courier IMAP

I'm setting up my own mail server, and I'm very new at this... and I'm getting lost. I need your help in determining some parameters the way I know them already, because the configuration is huge. ...
0
votes
1answer
487 views

Using PHPMyAdmin or MySQL Workbench, how to search across 10 tables and return all records matching a specific criteria?

This seems like it should be so simple but I'm having a hell of a time solving it. I have 10 tables named in the following way: b1_settings b2_settings ... b10_settings I need to search across all ...
0
votes
0answers
206 views

Mysql error 28 no space left on the device

I keep running in to the same problem with mysql with error code 28 which means there is not enough space left on the device. Now the weird part is that there is enough space, here are some tips i ...
0
votes
1answer
161 views

delete a MySQL database with a strange name

I started to maintain a MySQL database and I have no idea who and why this database was created: "#mysql50#backup-2012-03-01". I want to get rid of this one, but the following commands did not work: ...
0
votes
2answers
132 views

Backup mysql from files

I have problems running MySQL (I'm in rescue disk and can't run anything) and I would like to backup up the databases from the system files because I'm planning on formatting the system. How can I do ...