The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
12 views

Restroring MYSQL databse from .frm and .ibd files (database does not exist error)

please help ... I want to restore MYSQL database using .frm and .ibd files (that's all I am having). here is additional information.. I reinstalled same version of WAMP without taking backup of ...
0
votes
1answer
37 views

Windows MySQL 5.5 Cannot connect to localhost: ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server

I can ping successfully from my Windows command line to localhost and to 127.0.0.1, but attempts to connect with mysql.exe fail... I found similar errors but their suggested solutions don't work/...
2
votes
0answers
669 views

Recover innodb database from ibdata1 and *.frm files only

I have a problem on my server. I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started. I checked all mysql data, ...
2
votes
0answers
219 views

Can't access a specific database from phpMyAdmin

I've installed WAMP on a computer some months ago. Now I'm trying to use it and I was trying to surf the databases using phpMyAdmin. So I went to localhost/phpmyadmin and it showed me the databases. ...
1
vote
0answers
30 views

Source dump interrupted by computer restart

I'm have a wamp server installed on my windows machine (apache 2.4.9, mySQL 5.6, php 5.5, PHPmyAdmin 4.1). I was recently performing a source dump operation to restore a tables in a database. ...
1
vote
0answers
69 views

“Binlog has bad magic number” - recoverying InnoDB tables

A system crash raised the error in the title. I've tried the suggestion here, but then I can't access any of my InnoDB tables. They are still there, but data is missing. The provided solution ...
1
vote
0answers
147 views

Any solution to fix circular replication fail-over?

I've developed a point-of-sale system for our corporation, which has 25+ branches across the country. Each branch has its own MySQL POS database on a WAMP server. I want every event that occurs in ...
0
votes
0answers
14 views

Default Space in WAMP

What is the Default Space for MySQL in WAMP SERVER? We are using MySQL as the back-end for our application development, and it is running out of space. How can we increase the disk space? Or are ...
0
votes
0answers
49 views

Unable to change data directory for MySQL 5.6.17 on Win10

The default directory for storing mysql data is in C:\ disk, now I'd like to move the data directory to E:\ hard disk since C:\ is running out of space. I did following this instruction: http://www....
0
votes
0answers
417 views

MySql Workbench 6.3 error with Server Status on Windows 7

I am using 32 bit Windows 7 Ultimate and MySql Workbench 6.3, with WAMP installation (MySQL5.6). I am able to set connection, and run few SQL queries against test named database. But whenever I ...
0
votes
0answers
145 views

Mysql terribly slow on Xampp

I've looked if it was Apache, but on websites without a database, it loads pretty fast, but on my Joomla site the localhost takes like 15 seconds or more to load a page. I edited the hosts file of ...