MySQL is an open-source database owned by Oracle.
1
vote
3answers
570 views
MySQL per-database replication?
So, my problem is interesting: we want to migrate from one server to another. We made a master-slave replication, but my boss came with the idea to make migration one database at a time.
So he asked ...
0
votes
1answer
639 views
How to Install Apache , MySQL and PHP on AIX 7.1
i want to install following open source software on AIX 7.1
Apache 2.2.19
PHP 5.2.6
MySQL - 5.0.67
please help me on this.
0
votes
3answers
3k views
Optimal MySQL my.cnf setting for large Magento site on a dedicated server
Our dedicated server is running a large Magento store with a MySQL database approximately 250MB in size.
The server spec is listed as having 5 Xeon 2Ghz processors (4MB cache) and 12GB of memory.
...
-2
votes
0answers
19 views
I can't change mysql port (5.6.12) changing the lines of my.ini (windows 8)
I was trying to change the port of my mysql server in my local machine but i can't. The version of mysql is 5.6.12, is an installation from wamp and I am on Windows 8.
I change these lines in my ...
0
votes
0answers
16 views
MySQL mistake with grant option [migrated]
I am unsure reading the MySQL documentation if creating a user with the GRANT option will give them the power to create users and grant privileges, or change the privileges of other users databases.
...
1
vote
1answer
799 views
How can I set up mysql logs so that syntax errors are logged?
I've got mysql logging log_slow_queries or whatever, and had turned on all query logging for a moment before I found it to just be spammy and thus useless.
How can I log only mysql queries that ...
0
votes
1answer
20 views
Need to stop SQL Server when using Disk Defragmenter?
Our provider told me today that I should stop Microsoft SQL Server and other database systems like MySQL when using the Windows Disk Defragmenter.
Otherwise, the database might get corrupted.
Since ...
-3
votes
1answer
16 views
How many VPS do I need for my website? [duplicate]
I made a website which aims at simulating a trading market. There are a list of prices and corresponding volumes that people want to purchase. Users can purchase at any price any time. My website ...
0
votes
0answers
11 views
General local PC design/specs for fast RDB (MySQL) performance?
Are the given PC specifications (below) appropriate for a MySQL database that is to be used for analytical type queries on the given database specifications (also below)?
(I understand that both the ...
0
votes
1answer
633 views
Server extremely lags and logs bunch of 'internal dummy connection'
Having a web-server (don't know actually whoset it up, it's my heritage).
Few hours ago it started working very (extremely!) slow, mysqld oftenly fails requests.
/var/log/mysqld.log is empty (well, it ...
0
votes
3answers
46 views
Best way to debug MySQL slow queries?
First of all I like to inform you that I am a new User on Linux administration and I need some help.
I own a CloudLinux web server, and I am faced with a MySQL Slow Queries problem. The problem is ...
6
votes
5answers
3k views
Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?
I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?
0
votes
1answer
37 views
Configuring MySQL for Power Failure
I have absolutely no experience with databases and MySql. Now the problem is I have an embedded device running a MySQL database with a web based application. The problem is when I shutdown my embedded ...
0
votes
4answers
589 views
Keep Uploaded Files in Sync Across Multiple Servers - LAMP
I have a website right now that is currently utilizing 2 servers, a application server and a database server, however the load on the application server is increasing so we are going to add a second ...
0
votes
1answer
32 views
How to run a safe, responsible, fast MySQL backup
I've been tasked with assorted maintenance of a DB. I have very little experience with MySQL, so pardon any ignorance :)
Two (well, four) related questions:
The DB is supposed to be replicated to a ...
0
votes
1answer
19 views
Pure-FTPd do not login via mysql
I've got server on Ubuntu 12.04.3 LTS. I need to install Pure-FTPd with MySQL authentication.
I'm installed pure-FTPd by typing "apt-get install pure-ftpd-mysql". It was installed.
So, there's my ...
0
votes
1answer
20 views
MySQL, bind-address, Windows, Error 1067 my.ini
I trying to set alternate IP for gain access to MySQL Server (accessing from a PC with IP 192.168.1.20) in the file:
my.ini
MySQL starts without problem, when in the configuration file, in the ...
0
votes
1answer
22 views
Configuring php to work with httpd, Autostarting mysqld and apachectl
I am very new to Linux Environment.
But for my client I've designed the website which uses php and mysql.
Now I want to install the site on his RHEL 5.0 server. He already have httpd installed on it.
...
0
votes
1answer
28 views
Mysql Db replication
I have the following setup:
3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3.
I need ...
0
votes
0answers
12 views
MySQL replication hung after slave goes offline and comes back online again
I have a master server and several slave servers replicating a single database. I am using in MySQL 5.0 in SLES 11. During fault tolerance testing I found that when the slave's network connection ...
84
votes
9answers
120k views
MySQL: Bind to more than one IP address?
Is there a secret way to bind MySQL to more than one IP address?
As far as I can see the bind-address parameter in the my.cnf does not support more than one IP and you can't have it more than once.
0
votes
0answers
11 views
MySQL hangs if connection comes from outside the LAN
I have a MySQL Server operating just fine if I access him from his local LAN (192.168.100.0/24). If I try to access hin from another LAN (192.168.113.0/24 in this case) it hangs for a really long time ...
4
votes
4answers
323 views
MySQL: Hunting down unused databases
Is there any commands to look up databases that has no any activity in a month or so?
Just take SQL dumps for a month and run diff and if there's no differences delete that DB?
1
vote
1answer
166 views
MySQL ZRM restore failed with mysql error unknown command \0
I am restoring an incremental backup with ZRM server on mysql database. I am having blob data in the tables. The incremental backup not getting restored and giving mysql error unknown command '\0'.
...
1
vote
3answers
262 views
Clean out a large MediaWiki text table
I just discovered that an old MediaWiki of mine was infested with spam, and the database table named "text" (which contains the page content) is 3GB large. I've deleted all the spam pages manually, ...
0
votes
1answer
7 views
MySQL keeps starting logger and constantly restarts?
Alright, I have updated version 5.1 to version 5.6 without uninstalling the old one by using update-alternatives. This works just fine on our production/master server, but our replication slave seems ...
0
votes
1answer
27 views
PHP loosing connection to MariaDB server each 3 hours
I found my PHP 5.4.20 (from remi repo) on CentOS 6.4 64-bit is loosing connection to my MariaDB 10.0.4 server each 3 hours. I use mysqlclient18 5.5.28 from atomic repo as mysql library.
MariaDB ...
-1
votes
1answer
31 views
MariaDB 10.0.4 different mysqlclient reported
I use MariaDB-server 10.0.4 on my CentOS 6.4 64-bit server.
PHPMyAdmin shows: libmysql - 10.0.4-MariaDB
While phpinfo shows: Client API version 5.3.12-MariaDB
Why I got two versions ? How to ...
0
votes
2answers
2k views
How to setup email server in ubuntu 12.04LTS(debian 7 wheezy/sid) running on linode vps
I am working on email server, since i tried several times to create email server on ubuntu12.04LTS with postfix + dovecote + postfixadmin + courier + clamav + spamassassin. But everytime i install ...
1
vote
1answer
13 views
Set up error logging in mysql server
My mysql server crashes on ubuntu server. I need to retrieve the logs.
When doing the following:
mysql> show variables like '%log%';
I get:
...
