Questions tagged [wamp]

WAMP refers to the WampServer software stack for the Microsoft Windows operating system, consisting of the Apache web server, OpenSSL for SSL support, MySQL database and PHP programming language. Be sure to add additional appropriate tags such as which version of MySQL, and type of problem.

Filter by
Sorted by
Tagged with
17 votes
1 answer
64k views

Recover MySQL database from data folder without ibdata1 from ibd files

My WAMP directory accidentally get deleted by another user. Only data folder in MySQLis available. And, in that only database-folders (folders in "\bin\mysql\mysql5.6.12\data\" with name of databases) ...
cyberwani's user avatar
  • 173
8 votes
2 answers
27k views

Cannot Utilize Maximum CPU and Memory Usage for MySQL

Good day. I know this may be a duplicate of other questions however I have applied all the suggestions in many of the threads, but I remain with the same problem. I have a single stored procedure ...
tread's user avatar
  • 199
7 votes
2 answers
15k views

WAMP server performance tuning for MySQL

We have a Drupal site with nearly 2000 pages running on WAMP server. The pages also contain images, and flash videos embedded into them. So, they are taking some time to load under normal settings. ...
Ajit S's user avatar
  • 187
6 votes
1 answer
7k views

MySQL Slave Relay Logging but not logging Binary Log

I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
Matt Lester's user avatar
5 votes
3 answers
64k views

Master - master replication not working

I configured two WAMP servers running on different machines for master-master replication. I am using a linksys router for the network. I created a wireless network, but one of the server boxes doesn'...
Chibuzo's user avatar
  • 265
5 votes
2 answers
2k views

MySQL fulltext selection performance

I have 1.5M rows in a table. Following is the table create code: CREATE TABLE `jobs` ( `id` INT(8) NOT NULL AUTO_INCREMENT, `job_id` VARCHAR(50) NOT NULL DEFAULT '', `title` VARCHAR(255) ...
user3841653's user avatar
3 votes
4 answers
62k views

How could I connect to MySQL database running on WAMP server from other computers in same LAN?

I'm new in web development. I'm requesting help from all of you. My problem is: I installed WAMP server in my desktop computer. My desktop computer has a static LAN IP (192.168.0.101). I'm able to ...
Al-Amin Khan's user avatar
3 votes
1 answer
3k views

"zip" a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: 5.3....
user3871's user avatar
  • 213
3 votes
0 answers
405 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. ...
fedejp's user avatar
  • 31
2 votes
1 answer
1k views

Database replication using wamp?

I have created a POS system for our corporation, in the HQ we have a wamp server with the main database, we also have more than 25 branches across the country. I will setup a wamp server on each ...
CairoCoder's user avatar
2 votes
1 answer
3k views

Can't create/write to file MySQL

Server Configuration: MySQL 5.051a-community-nt-log Community Edition installed on Windows Server 2003 Standard Edition SP1. This MySQL Server is part of a client's WAMP installation Problem: ...
Craig Efrein's user avatar
  • 9,640
2 votes
1 answer
769 views

Optimize MySQL Configuration - MySQL crash and after restart works

My WAMP MySQL has crashed 2 times the last week and I really wonder why! Once I restart the server everything works fine! Below I attach the error log of MySQL and the my.ini file! Can anyone suggest ...
Leo's user avatar
  • 23
2 votes
0 answers
2k 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, ...
Ankur's user avatar
  • 121
1 vote
1 answer
104 views

Mysql is larger than wamp

Wamp which includes mysql,php,apache is only 24.7 MB but the only Mysql is 207 MB here.Why?
bugwheels94's user avatar
1 vote
1 answer
13k views

How to enable remote access to wamp mysql

I have wamp server which is installed in windows server. Since database is becoming large want to move code to other machine from there I want logon to wamp mysql. I have disabled bind-to-address ...
niran's user avatar
  • 111
1 vote
1 answer
2k views

MySQL Replication - 1 Master - 2 Slaves. Inserting works for One, not the other

I am a Python developer, working with 3 databases, configured in Master -> slave,slave style. Each slave has their own application associated with it. I am not too familiar with database ...
Busturdust's user avatar
1 vote
1 answer
4k views

phpMyAdmin and mysql not showing the same database

I have setup WAMP which I managed by using a tutorial and everything seems fine... I am logging into mysql as the root user with full privileges granted and I am able to create databases in mysql and ...
Sumit4732's user avatar
1 vote
2 answers
206 views

Suggestion for Tooth Chart Data Structure

Hello I'm not sure if this is an OK question here but here goes, I'm quite confused on how am I going to make the data structure of my tooth chart database. I had first this thought of making a data ...
piece's user avatar
  • 11
1 vote
1 answer
6k views

How do I configure multi master replication on WAMP?

I want to configure mysql multi master replication, but I've not seen any comprehensive article or tutorial on how to do that on WAMP. I will be grateful if some will point me to a tutorial, or ...
Chibuzo's user avatar
  • 265
1 vote
1 answer
556 views

MySQL stops in windows VM and shows innodb os error in logs(error no. 5)

2020-08-23 17:22:36 5688 [Note] Plugin 'FEDERATED' is disabled. 2020-08-23 17:22:36 5688 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-08-23 17:22:36 5688 [Note] InnoDB: The InnoDB ...
Anushree's user avatar
1 vote
0 answers
749 views

Can I reinstall Wamp on Windows 10 without overwriting my databases?

I have another open question which at the moment seems to be a bit tricky to answer: phpMyAdmin - Cannot login even when changed password I am hoping someone can still answer it. I think one of the ...
Rewind's user avatar
  • 211
1 vote
0 answers
62 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. ...
ADT's user avatar
  • 11
1 vote
0 answers
293 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 ...
rzb's user avatar
  • 135
1 vote
0 answers
171 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 ...
CairoCoder's user avatar
0 votes
5 answers
19k views

How to switch from MariaDB to MySQL in WAMP server?

I installed wamp server on my PC and by default wamp server is connected to MariaDB as showed below How can i switch to MySQL? Thank you in advance for your help.
user avatar
0 votes
3 answers
25k views

MySQL incredibly slow on WAMP and XAMPP

I've installed WAMP on my new Windows 8 machine and for some reason when I use PHPMyAdmin to import an sql file (it's only about 5mb), it takes several minutes before timing out. And then when I check ...
user avatar
0 votes
1 answer
268 views

Mysql - how to create an id column for a specific column

i want to create a table that have 3 column : visit_times : have a unique id for every specific visitor visitor_ID Date i tryed to create the table as showing this code CREATE TABLE test.table ( ...
OMAR TOUIL's user avatar
0 votes
1 answer
3k views

i cannot install mysql plugin keyring_file.dll

I have been trying to install the keyring_file.dll of MySQL 5.7.26 plugin from WAMP 3.1.9 without success. It keeps me telling in the CMD Prompt: ERROR 1123 (HY000): Can't initialize function '...
noob's user avatar
  • 1
0 votes
1 answer
321 views

Incomplete MysqlDump Files - Mysqldump Inside For Loop

I am running a Windows 10 Machine with WAMP installed. I have also a Git Bash Installed. I was trying to backup all my databases in each separate file using the code below. for DB in $(mysql -uroot ...
Harish ST's user avatar
  • 103
0 votes
1 answer
137 views

Can't login to sql server custom db

I have wamp installed in my system and sql server 2014, and configure so i can access sql server db through php.. with this code: <?php $serverName = "MY-PC\sqlexpress"; $connectionInfo = array(...
George Panagiotinos's user avatar
0 votes
1 answer
2k 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/...
fiprojects's user avatar
0 votes
2 answers
677 views

microsoft webmatrix deleted my wamp databases?

I've been using WAMP server for a while and I have several databases on the mysql server. today I installed microsoft webmatrix and when I opened one of my sites on wamp I got a mysql error saying ...
Dotan's user avatar
  • 101
0 votes
0 answers
3k views

Innodb error log sequence number is in future

2020-08-28 16:46:02 d64 InnoDB: Error: page 1 log sequence number 23113680 InnoDB: is in the future! Current system log sequence number 3181581. InnoDB: Your database may be corrupt or you may have ...
Anushree's user avatar
0 votes
0 answers
2k views

InnoDB: Could not find a valid tablespace file for ' table '?

i have some project hosted by wampp server, which used to work without any issue. this week , it can't serve anymore , examining the mysql logs i got this lines: 2019-12-05 08:23:00 1464 InnoDB: ...
A.HADDAD's user avatar
  • 119
0 votes
1 answer
4k views

How to change default engine in WAMP to InnoDB

Can someone tell me how to change my default storage engine to InnoDB using wamp? Currently it is MyISAM.
Sead Silajdzic's user avatar
0 votes
0 answers
28 views

Migrate 2 mysql folders on same server

I have installed wamp initailly. But now we have moved to xamp. So, I have 2 mysql folders, C:\xampp\mysql C:\wamp\bin\mysql\mysql\data Now my localhost is pointing to C:\xampp\mysql. I just wanna ...
Imran Qadir Baksh - Baloch's user avatar
0 votes
1 answer
3k views

How to Recover My database From Old WampServer?

Previously I am using wampserver2 with "mysql5.6.17" version.I have many database in that version. I uninstall the wampserver and install new latest version wampserver3.1.0_x64. Before uninstalling ...
shri ram's user avatar
0 votes
0 answers
1k views

Wamp - Can I back up My Databases in the MySQL Console?

I am having trouble loggin on to my Wamp phpMyAdmin. Those are other questions on this site at the moment. Is there any way to make a backup of my databases through the MySQL Console? wampmanager -&...
Rewind's user avatar
  • 211
0 votes
1 answer
2k views

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

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 ...
user100638's user avatar
0 votes
1 answer
185 views

Why the mysql MSI Installer is more huge than wamp installer packages size?

In http://dev.mysql.com/downloads/windows/installer/5.6.html, you can get Windows (x86, 32-bit), MSI Installer whose size is 252.6M . In http://sourceforge.net/projects/wampserver/files/, you can get ...
showkey's user avatar
  • 334