1
vote
1answer
16 views

Finding and removing old mysql-bin files

I am running a MySQL server on Windows 8. The MySQL directory requires 118 GB of space and has a lot of 1 GB mysql-bin files that haven't been modified for years according to the file system. All of ...
0
votes
1answer
19 views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
3
votes
1answer
217 views

BGINFO with MySQL for storing computer information

We are trying to set up BGinfo to record network computers' information in a centralized database. We intend to set up BGinfo to start up for all users and record logon and logoff time plus setting up ...
0
votes
0answers
44 views

Transfer mysql database from wamp to a server

i want to transer my data bbase from wamp on my local machine to my vps (ubuntu) can i juste copy the folder of the data base from C:\wamp\bin\mysql\mysql5.6.12\data to /var/lib/mysql ?
1
vote
3answers
1k views

MySQL Startup Error - Root element missing

I have had MySQL installed for about 2 months on Windows Server 2003 R2. On start up we get presented with an error that says "High Severity Error - root element missing" followed by another high ...
0
votes
0answers
161 views

MySQL 5.0.88 and ASP.Net error - Reading from the stream has failed

Recently, our Linux server died so we put up a new Linux server with a newer version of MySQL (went from 5.0.6 to 5.0.8). We updated the connection string in our .Net application and installed the ...
0
votes
0answers
18 views

Logging Apparently Not Working - Can't Set Configure Replication

I'm using a tutorial to set up a master (single) slave setup. When I run the command show master status; I get Empty set (0.00 sec). I have done a lot of research and believe that the log file I have ...
0
votes
1answer
563 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
92 views

Mysql-proxy randomly overloads the system until I kill it

I'm using mysql-proxy 0.8.3 on a Windows 7 system. Sometimes, I get the following debug message in the log : (debug) .\chassis-event-thread.c:254: recv() from event-notify-fd failed: Unknown ...
0
votes
1answer
60 views

Did Cut and Paste of MySQL Database Files Between Servers and the Paste was Canceled

I was moving MySQL Databases between two Windows Servers and the paste action was canceled. I noticed that the original Databases were partially transferred and there were some incomplete databases on ...
0
votes
1answer
201 views

Daily queries log file

Has MySQL a daily log rotation system? like Apache that creates daily log files? I'm having a very hard time to find any good info about this. Win Server 2008 R2 MySQL 5.1.11 I'm logging all ...
1
vote
1answer
544 views

Error installing MySQL: Unable to update security settings

Get this error while trying to install MySQL (as a administrator): I've chosen for just one account, the root-account. Can anybody help me?
-1
votes
1answer
840 views

mysqld 5.6 service error 1067

Upon running this service "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 I get this error windows could not start ...
2
votes
1answer
54 views

Need to run windows service and MySQL, what remote/cloud service options do I have? [closed]

As the title suggests, I need to set up MySQL database which can be accessed by two (or more) different sites. The only snag with this is that we need to run a windows service alongside it (this is a ...
-1
votes
1answer
138 views

Copying raw mysql files to Windows 7 MySQL 5.6 obtained via mysqlhotcopy from Linux MySQL 5.1 [closed]

Assuming I only have access to the raw files (.myd, .myi, .frm), would I simply copy+paste mysql db files obtained from /var/lib/mysql/mydb to C:\Program Files\MySQL\MySQL Workbench CE ...
0
votes
0answers
251 views

windows command line start mysql with --skip-networking

Following How to start a service with certain start parameters on Windows. Any ideas why the following doesn't work? sc start MySQL --skip-networking mysql -uroot -p -e "show variables like ...
0
votes
2answers
165 views

MySQL keeps crashing while using Jira

I have a Jira install running on Windows using MySQL database hosted on the same instance. We're having an issue where the MySQL service keeps crashing (after a few page requests). We've been running ...
0
votes
1answer
347 views

Unable to remote into mysql server on Amazon ec2 windows instance

I'm trying to connect to MySQL server from my dev machine(win 7) using 'Toad for MySQL'. MySQL server is located on AMI windows instance(amazon ec2). I have had success earlier with dedicated servers ...
1
vote
1answer
127 views

mysqld keeps crashing

Mysql kept working normally from many days and suddenly it crashes on all commands. Please help me to solve it. 130206 21:03:03 [Note] Plugin 'FEDERATED' is disabled. 130206 21:03:03 InnoDB: The ...
1
vote
2answers
171 views

Deploying tomcat/mysql application on windows

Our web service software consists of a (precompiled) war file and a mysql database. We provide installation packages to deploy it on Ubuntu or Fedora, in a standard Tomcat7/MySQL/Apache2 setup using ...
1
vote
3answers
302 views

Speed up connection to MySQL

So here's one for you. Any idea on a way to shorten the time it takes to connect to a MySQL database? The reason I'm wondering is because I find that just connecting to the DB adds just over a second ...
0
votes
2answers
791 views

MySQL Memory Limit Windows Server 2003

I am running MySQL 5.0.51a on Windows Server 2003 Standard Edition on an HP DL580 G4 with 3GB installed. One of my database tables has grown to 5.3 GB with an index file of 2.5 GB, which I believe is ...
1
vote
0answers
113 views

Considering MySQL on SSD with NTFS and Windows 2008

My company is considering migrating our MySQL data from an HDD array to an SSD, possibly the Intel SSD 520 series. We have a fairly large set of databases, some with upwards of 100 million rows, so we ...
0
votes
2answers
310 views

MySQL ERROR 1045 (28000)

EDIT: I have found a solution, even if we can't talk exactly of solution. Well, I used RevoUninstaller to remove the MySQL Server, then I've proceed with a standard installation and everything got ...
0
votes
1answer
208 views

A virtual ftp-server for Windows like ProFTPD [closed]

Is there any solution for Windows which allows creating virtual ftp-server with the user's storage in a MySQL or a PostgreSQL database? Something like ProFTPD for Unix. Thanks for any advice and ...
2
votes
1answer
314 views

Cannot connect to mysql

Recently I have moved the data folder of MySql to the other folder as describe in the my.ini following: [mysqld] port= 3306 socket= "D:/xampp/mysql/mysql.sock" basedir="D:/xampp/mysql" ...
8
votes
3answers
15k views

Connecting to MySQL from PHP is extremely slow

I just did a fresh install of XAMPP. When first opening PHPMyAdmin I noticed it was extremely slow. It didn't make sense that on localhost it should take almost 5 seconds for every page to open. I ...
0
votes
1answer
434 views

Slow performance between two Windows Azure Hosted services

We have a Facebook application and we are trying to move to Azure cloud hosting. We've opened two hosted services, one for the MySQL database and the other for our Web application. On each service ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
1
vote
0answers
300 views

mysql error on xampp 1.7.7 for windows

All of a sudden my XAMPP installation is playing silly buggers when I try to Cake bake. I get a recurring error: SQLSTATE[HY000]: General error: 6 Error on delete of 'C:\xampp\tmp\#sql...MYD' ...
3
votes
1answer
222 views

Is MySQL VSS “Safe” Yet?

From what I'm reading, there's plenty of statements that MySQL is at least partially VSS (Volume Snapshot Service) aware, with caveats etc. but all of the things I can find online regarding this are ...
2
votes
2answers
1k views

Best way to backup MySQL database server running in Hyper-V

We are running a production MySQL v5.5 database server on a Windows 2008 R2 VM. We are currently just performing a daily mysqldump of the database, and then backing those up. Our backup solution ...
-1
votes
1answer
659 views

Symfony2 on Windows with Apache, PHP and MySQL - app_dev.php will not load

I am trying to get a Symfony2 standard distribution to work on my Windows 7 laptop. I have installed Apache2 (version 2.2.22), PHP 5.3.10 and MySQL 5.5.22. I have a demo PHP script (php_info() and a ...
-1
votes
3answers
3k views

I can't connect to MySql from another machine

I have installed Apache, PHP, MySql on a Windows 2008 Server. The problem is that I am trying to connect to MySql from my home machine. I have enabled TCP/IP networking in the MySql Configuration ...
0
votes
1answer
1k views

MySQL Server “No such host is known”

I am seeing a weird MySQL warning in Windows server event viewer. The error says : IP Address 'xx.xx.xx.xx' could not be resolved: no such host is known. Any idea what this means and how critical it ...
0
votes
1answer
98 views

Connect linux to mysql on windows

I am trying to connect to a mysql database on a windows server from linux. I don't have much experience working with Windows at all, especially windows server. How do I go about making a connection ...
2
votes
3answers
2k views

cannot start mysql 5.1 windows service under normal user account

MySQL 5.1 service can start under Local System account or Administrator User account. But MySQL 5.1 service cannot start under normal user account. It gives: Error 1067:The process terminated ...
7
votes
1answer
313 views

Mysql change ft_max_word_len bug

So, I have MySQL installed on my machine, and I need to change the ft_max_word_len, the maximum word length that MySQL will index. However, when I set it up via the tools provided, and query it, it ...
2
votes
1answer
434 views

Changing MySQL datadir on active server

I have a server that seems to be setup wrong by previous administrator.. The server has two disks, disk 0 which is the operating system (RAID1 clone) disk 1 which is 3 drives in a RAID5 setup with ...
-1
votes
3answers
4k views

Can't connect to MySQL server on localhost (10060)

i have install the "mysql-6.0.11-alpha-win32" setup in windows 7 . then try to connect to the mysql but it takes long time to connect to the mysql server then show the error message like ...
0
votes
2answers
568 views

Can I choose which CPUs / Cores to be used by MySQL?

I have a Windows VPS (Windows 2008 R2 x64) that runs a couple WordPress blogs and other few ASP.NET things. The VPS runs 2 CPUs (for example). With ASP.NET, in such situation, I usually set the app ...
0
votes
3answers
140 views

Installing MySQL as a local service

I am able to install the service normally, using the --install tag. But I need to be able to run mysql as a local service, due to access privileges. The my.ini file is set up correctly, proven by ...
0
votes
1answer
199 views

Access mysql database from an Amazon Windows EC2 instance to another EC2 windows instance

I have 2 Amazon EC2 instances running WAMP stack. They are both in the same amazon account but different regions. Normally if I had this setup on Godaddy I would have used SOAP service to access data ...
-1
votes
1answer
161 views

Backup and Restore MySQL database

need backup MySQL 5.1 databse. Database is install on Windows Server 2003. I google it and I found many tools but I am little confuse what choose. My requirments are: Tool for backup must have a ...
-1
votes
2answers
478 views

MySQL table “doesn't exist” error

I'm using Windows 7 Ultimate x64. After reinstalling OS copied back whole MySQL data directory to C:/Programdata. But now when i'm trying to open some table from restored db's with Navicat it shows me ...
1
vote
0answers
283 views

Cannot change innodb_buffer_pool_size mysql windows

It seems i'm unable to change any of the values for innodb_buffer_pool_size, innodb_log_file_size, innodb_file_per_table or innodb_flush_method for mysql running on windows. Mysql does not print any ...
0
votes
1answer
181 views

Cannot start MySQL on windows box with named pipes

I've installed MySQL server on Windows although in the configuration have selected to not run MySQL as a server and have disabled TCP/IP access so only named pipes can be used, I'm now having problems ...
6
votes
6answers
6k views

MySQL: Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

All of a sudden my local MySQL 5.5 server stopped running on my Windows XP SP3. I also have WAMP Apache and WAMP MySQL installed, but WAMP MySQL is not running. Error log shows: Can't start ...
1
vote
2answers
3k views

mysqlcheck doesn't support multiple contradicting commands

Any idea why I am seeing this error message? This script works fine on a ever so slightly older version of MySQL running on a different server with a similar config. :: check/analyze/repair/optimize ...
1
vote
1answer
775 views

PHP Named Pipe Problem

I am trying to test a website on a local machine that has Windows 7 installed. I want to use named pipes to connect to the MySQL server, but mysql_connect() seems to throw an error: [2002] No ...