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.
40
questions
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) ...
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 ...
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.
...
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 ...
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'...
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) ...
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 ...
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....
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.
...
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 ...
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:
...
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 ...
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, ...
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?
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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.
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 ...
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 ( ...
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 '...
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 ...
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(...
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/...
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 ...
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 ...
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: ...
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.
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 ...
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 ...
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 -&...
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 ...
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 ...