Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Include this tag if your question relates to usage and configuration of WampServer. Include mySQL version tag such as and Windows version tag such as .

Links

Wikipedia page on WampServer

42 questions
16
votes
1 answer

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) are available. All files including "ibdata1" in…
cyberwani
  • 163
  • 1
  • 1
  • 4
8
votes
2 answers

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 working with max 3 tables. when I run the procedure,…
tread
  • 199
  • 1
  • 2
  • 14
7
votes
2 answers

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. Nearly 200-300 users are expected to use the…
Ajit S
  • 187
  • 2
  • 2
  • 13
6
votes
1 answer

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 understanding on the matter but my ultimate goal is to…
Matt Lester
  • 63
  • 1
  • 3
5
votes
2 answers

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) NOT NULL DEFAULT '', `company` VARCHAR(255)…
user3841653
  • 71
  • 5
5
votes
3 answers

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't have a WIFI so I used cable to connect it to…
Chibuzo
  • 265
  • 2
  • 4
  • 9
3
votes
4 answers

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 access WAMP server homepage from my other computers…
Al-Amin Khan
  • 65
  • 1
  • 2
  • 7
3
votes
1 answer

"zip" a mySQL (phpMyAdmin) database

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.8 Apache ver: 2.2.21 Thanks
user3871
  • 213
  • 2
  • 7
3
votes
0 answers

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. The problem is: I can se all databases except for…
fedejp
  • 31
  • 2
2
votes
0 answers

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, there were mydb/mytable.frm, mydb/db.opt,…
Ankur
  • 121
  • 4
2
votes
1 answer

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 branch, so I can access its database directly when…
CairoCoder
  • 133
  • 6
2
votes
1 answer

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: MySQL was originally using the C:\WINDOWS\TEMP directory…
Craig Efrein
  • 9,418
  • 11
  • 53
  • 94
2
votes
1 answer

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 anything?? MySQL Error LOG: 2018-02-23 21:45:52…
Leo
  • 23
  • 2
1
vote
1 answer

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 view them by using SHOW DATABASES; so far so good…
Sumit4732
  • 11
  • 1
  • 2
1
vote
2 answers

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 structure like this teeth_table teeth_id…
piece
  • 11
  • 1
1
2 3