Tagged Questions

-1
votes
1answer
25 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 ...
0
votes
0answers
16 views

How do I change MySql datadir on windows? [duplicate]

I'm trying to set MySql data directory to a place on another drive. Here's what I did: Created the directory on the drive Created C:\Program Files\MySQL\MySQL Server 5.6\my.ini with following ...
2
votes
1answer
36 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
33 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
41 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
0answers
23 views

The basics of IBM DB2 / Migration from MySQL

I'm practicing with databases, and my professor has given me the task of migrating data from a MySQL server to an IBM DB2 server. Apparently, said data needs to be accessed by an SAP program(?). I'll ...
-3
votes
1answer
31 views

what is the best configuration for my mysql on windows [closed]

down vote favorite I have a windows server 8. 16 GB RAM, 64 bit, 4 processors, 6 core AMD Opteron. I have a database with 3 tables that exceed 500,000 rows (the other 200 tables have about 40,000 ...
0
votes
2answers
57 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
93 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 ...
0
votes
1answer
60 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
138 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 ...
0
votes
0answers
61 views

Windows server 2003 won't start mysql

For serveral days I've been trying start MySQL on Windows. I have no problems installing it as a service but can't start it with the following command: > net start mysql However, I can start ...
1
vote
3answers
193 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
368 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 ...
0
votes
1answer
507 views

Slow connection to Linux MySQL from Windows only (XAMPP)

UPDATE Turns out the issue was with my network settings - I'm not sure what was wrong, as they were the out-of-box settings, but going to System Properties -> Computer Name and running Network ID ...
1
vote
0answers
101 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
1answer
115 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
125 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
207 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" ...
4
votes
3answers
5k 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
259 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
594 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
172 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' ...
-1
votes
1answer
122 views

Can't locate Bugzilla/Search/Recent.pm in @INC [closed]

Software error: Can't locate Bugzilla/Search/Recent.pm in @INC (@INC contains: . lib C:/Bugzilla/perl/perl/lib C:/Bugzilla/perl/perl/site/lib) at CGI.pm line 30. BEGIN failed--compilation aborted at ...
3
votes
1answer
111 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
526 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 ...
0
votes
1answer
53 views

Very large log file in My Documents [closed]

I'm using Windows Server 2008 R2. I made a huge error in mysql and now have a large (18GB) log file in the administrator documents folder. How do I delete it? It either says I don't have permision ...
-1
votes
1answer
440 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 ...
0
votes
0answers
65 views

Windows & Web Passwords sync

We have run into the issue of keeping windows and web passwords synced. What is the best way to keep the two synced? Can you run a script on windows login to set a cookie for the web pages? When ...
-1
votes
3answers
1k 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
555 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
61 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 ...
1
vote
4answers
1k 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
269 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 ...
-5
votes
2answers
74 views

Setting up a WAMP Test Server [closed]

I am getting irritated with having to upload all the code im playing with to a remote server (that can take far too long at slow internet times). To make this easier, im going to setup my desktop that ...
2
votes
1answer
283 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
2k 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
417 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
2answers
329 views

Can't install MySQL 5.5 on Windows 7

This morning I still had a working instance of MySQL on my Win 7 dev box, as part of a XAMPP installation. Then I decide to try a standalone MySQL; I uninstalled XAMPP, downloaded the MySQL 5.5.17 msi ...
0
votes
2answers
96 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
174 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
143 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
231 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
233 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
134 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 ...
5
votes
5answers
3k 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
2k 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
538 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 ...
0
votes
2answers
65 views

Windows 2003/IIS Setup

I work at a university maintaining the computer science department server. I am looking for a more economical way to stream line the set up of student accounts. CS students are granted a Username and ...
0
votes
1answer
96 views

MySQL Continuosuly crahsing

I am continuously receiving below error in event viewer... from which it stop mysql service... This is the following error, Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module ...

1 2