I have a replicated MySQL environments were the master db gets a continuous "Aborted_connects". How can I find out what IP and what user are causing the aborted connections. There are about 500 connections created by 25 applications. I only have access to the database servers.
I inherited a Codeigniter based PHP application. I'm trying to setup my development workstation to mimic the production system for some development work. An example url would be http://example.production/start/PAF/paf the only way I can get it to work on my dev site is http://example.local/start.php/PAF/paf. The codeigniter application/config.php uses start as the index_page instead of index.php. On the production system there are no rewrite rules in the httpd.conf or .htaccess. How is it possible that the ".php" is being removed without rewrites? Is there another place I should be looking for the rules?
thanks
Is there a way to export the database schema in well formed XML of a MS 2000 SQL Server. I'm looking for just the structure not the data and the more detailed the better. The XML may be used in a migration processes. I'm more familiar with MySQL then with SQL Server so please be detailed if you have time.
Thanks
I understand how to create a new user with privileges, but what is the correct way to change privileges for users that are already created?
We are running a DB audit and some of the users have way more access then is needed. Plus I don't know the passwords for most of these MySQL users, so I don't want to delete them and create new ones.
I have a 2 master and 6 slave MySQL database environment. One master is hot and the other master is considered cold and is just running as a slave. I don't want to do a real master - master where both are replicating from each other. During fail over I want the cold master to start taking the write hits and the failed master to just stop until we can fix and make it a cold master/slave. Is this possible and/or correct?
Thanks
ref - more info about MMM