WampServer

Hey Guys,
Hope I can get a solution here, I've been all over google trying to look for answers and have tried varies solution with no success. I'll explain what I've done.

My Computer system:

Windows 7
64 bit

I'm running wamp 2.5 (32bit)

I can't remember the previous version wamp I was running, but I have cleanly uninstalled wamp and deleted all it's folder and have freshly installed wamp 2.5. I have copied the data folder from the old mysql5.6.12 and have transferred all the data folders and files including the following folders mysql & performance_schema.

I have backed up the mysql & performance_schema folder of the new installed.

The thing is on the freshly install wamp 2.5 works fine and the lights green, but when I transfer the old data file from mysql5.6.12 to the new mysql5.6.17, it now shows orange with Mysql services not working.

I get the following error in mysql.log:

2015-09-15 13:38:47 5784 [Note] Plugin 'FEDERATED' is disabled.
wampmysqld: Ne peut trouver le fichier: 'plugin' (Errcode: 2 - No such file or directory)
2015-09-15 13:38:47 5784 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2015-09-15 13:38:47 5784 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-09-15 13:38:47 5784 [Note] InnoDB: The InnoDB memory heap is disabled
2015-09-15 13:38:47 5784 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-09-15 13:38:47 5784 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-09-15 13:38:47 5784 [Note] InnoDB: Not using CPU crc32 instructions
2015-09-15 13:38:47 5784 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-09-15 13:38:47 5784 [Note] InnoDB: Completed initialization of buffer pool
2015-09-15 13:38:47 5784 [Note] InnoDB: Highest supported file format is Barracuda.
2015-09-15 13:38:47 5784 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600607
2015-09-15 13:38:47 5784 [Note] InnoDB: Database was not shutdown normally!
2015-09-15 13:38:47 5784 [Note] InnoDB: Starting crash recovery.
2015-09-15 13:38:47 5784 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-09-15 13:38:47 5784 [Note] InnoDB: Restoring possible half-written data pages
2015-09-15 13:38:47 5784 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600617
2015-09-15 13:38:47 5784 [Note] InnoDB: 128 rollback segment(s) are active.
2015-09-15 13:38:47 5784 [Note] InnoDB: Waiting for purge to start
2015-09-15 13:38:47 5784 [Note] InnoDB: 5.6.17 started; log sequence number 1600617
2015-09-15 13:38:47 5784 [Note] Server hostname (bind-address): '*'; port: 3306
2015-09-15 13:38:47 5784 [Note] IPv6 is available.
2015-09-15 13:38:47 5784 [Note] - '::' resolves to '::';
2015-09-15 13:38:47 5784 [Note] Server socket created on IP: '::'.
2015-09-15 13:38:47 5784 [ERROR] Fatal error: Can't open and lock privilege tables: Ne peut trouver le fichier: 'user' (Errcode: 2 - No such file or directory)


Any ideas how to fix this? When I try and access the phpmyadmin it shows some of the tables there but when clicking on one it shows that it doesn't exist but I'm guessing this is because mysql doesn't work.

Please any help would be appreciated, i really need to get my websites up and running.

Thanks

Hi

Ok, start again with a fresh install of WAMPServer. Check it all runs!

Stop WampServer
Then copy the complete mysql5.6.12 folder to a new mysql5.6.12 in the new install.
You now have 2 MySQL Server versions avaiable.

Start WAMPServer

Using the menus swicth to mysql5.6.12
- wampmanager -> MYSQL -> Version -> 5.6.12

Check wampmanager icon goes green!

Backup all YOUR database ( Not mysql's own ones )

Switch to the new version of MySQL 5.6.17
- wampmanager -> MYSQL -> Version -> 5.6.17

Now restore all your databases that you just backed up into the new version of MYSQL


Now you can delete the old mysql5.6.12 folder or keep it for a while as a emergency recovery in case you forgot anything.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hey,
The issue is, I lost to the whole mysql5.6.12, I only copied the data folder only from mysql5.6.12. A silly thing. Is there an alternative way?

I did a fresh install of wamp and have it working.

I only have the data folder from mysql5.6.12 that is available.

Are your databases MYISAM or INNODB or a mixture of both?

Please be sure of the answer you give to this question!

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

So my data folder contains the following. E.g.


1. I have the data folder which contains folders of my web projects and files E.g
beatworks (my web project)
also in the data folder are the files auto.cnf, ib_logfile0, ib_logfile1, ibdata1 and alot of mysql-bin.000001up to mysql-bin.000397 and a file called mysql-bin.index

beatworks (folder)
Files in this beatworks folder are extensions .frm, .MYD, .MYI, . opt


2. What I've done so far.

I've created a new install for wamp 2.5 (32bit) it works fine greenlight. I've also copied a newly fresh mysql5.6.12 folder into wamp 2.5. I have tested it as well and it works fine greenlight.

I copied the data folder from my old mysql5.6.12 into the freshly new installed mysql5.6.12 folder and tested wamp and it works greenlight.

I've tried accessing the phpmyadmin to check but I seem to be going elsewhere cause it's not showing any of the sql of my projects and when I go to phpmyadmin it's asking me for a password. I've put in "root" and no password but don't see any of my project data base.

Hopefully I'm making progress that's easier for you to help me.

If you have a folder called beatworks containing files with .frm, .MYD, .MYI, . opt extensions then these are MYISAM files.

This makes the process easier.

Start with a fresh install of WAMPServer 2.5

Make sure it runs ok!

Stop WAMPServer

Copy your old beatworks folder and all its contents to the new install. Place the beatworks folder in

\wamp\bin\mysql\mysql5.6.17\data\beateworks

Start WAMPServer, MYSQL should register the existance of this MYISAM database.

However, you will have to recreate any user accounts that you may have needed to access the database manually.
If you were conecting to the database using user="root" password="" then you dont even need to add any user accounts.



For furture reference There is this post on this Forum that will tell you how to upgrade version of WAMPServer in a non destructive way for the next time!!!!!
Installing a new release of WAMPServer

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Great so just being doing some testing and adding the files like you said. I've change also httpd.conf and httpd-vhosts.conf

I've added the beatworks to the data folder like you said and have restarted the wamp everything greenlight.

Now when I try and access the beatworks it lands on the localhost home page. But beatworks not even listed there.


httpd-vhost.conf:

<VirtualHost *:80>
DocumentRoot "C:/wamp/www"
ServerName localhost
ServerAlias localhost
<Directory "C:/wamp/www">
AllowOverride All

<IfDefine APACHE24>
Require local
</IfDefine>

<IfDefine !APACHE24>
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 localhost ::1
</IfDefine>
</Directory>
</VirtualHost>

<VirtualHost *:80>
DocumentRoot "C:/wamp/www/craigmedia"
ServerName craigmedia
ServerAlias craigmedia
<Directory "C:/wamp/www/craigmedia">
AllowOverride All

<IfDefine APACHE24>
Require local
</IfDefine>

<IfDefine !APACHE24>
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 localhost ::1
</IfDefine>

</Directory>
</VirtualHost>


Host file:

127.0.0.1 craigmedia
::1 craigmedia

You have not created a Virtual Host for beatworks.

Once you create Virtual Hosts, if Apache cannot find the VH definition for a domain it will default to the first VH defined, which should be localhost and is in your case

So add a VH for beatworks

<VirtualHost *:80>
   DocumentRoot "C:/wamp/www"
   ServerName localhost
   ServerAlias localhost
   <Directory "C:/wamp/www">
      AllowOverride All

      <IfDefine APACHE24>
         Require local
      </IfDefine>

      <IfDefine !APACHE24>
         Order Deny,Allow
         Deny from all
         Allow from 127.0.0.1 localhost ::1
      </IfDefine>
   </Directory>
</VirtualHost>

<VirtualHost *:80>
   DocumentRoot "C:/wamp/www/craigmedia"
   ServerName craigmedia
   ServerAlias craigmedia
   <Directory "C:/wamp/www/craigmedia">
      AllowOverride All

      <IfDefine APACHE24>
         Require local
      </IfDefine>

      <IfDefine !APACHE24>
         Order Deny,Allow
         Deny from all
         Allow from 127.0.0.1 localhost ::1
      </IfDefine>
   </Directory>
</VirtualHost>

<VirtualHost *:80>
   DocumentRoot "C:/wamp/www/beatworks"
   ServerName beatworks
   ServerAlias beatworks
   <Directory "C:/wamp/www/beatworks">
      AllowOverride All

      <IfDefine APACHE24>
         Require local
      </IfDefine>

      <IfDefine !APACHE24>
         Order Deny,Allow
         Deny from all
         Allow from 127.0.0.1 localhost ::1
      </IfDefine>
   </Directory>
</VirtualHost>

And add beatworks to the HOSTS file

127.0.0.1  beatworks
::1   beatworks

Then restart the dnscache from a command window run "As Administrator"

net stop dnscache
net start dnscache

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 1 time(s). Last edit at 09/15/2015 03:29PM by RiggsFolly.

Sorry, im using craigmedia as my sample website as it's the website i need up. So I was using beatworks before but I changed it when we were going thru the process.

However the setup for craigmedia has been successful and the vhost up top is what the file. So it seems it's connecting what's happened was that I had another wamp2.4 folder in my c drive so I deleted it.

However this is the latest update:

when connecting to the website I get these error:

1. Warning: require(C:\wamp\www\craigmedia/wp-includes/functions.php): failed to open stream: No such file or directory in C:\wamp\www\craigmedia\wp-settings.php on line 72

2. ( ! ) Fatal error: require(): Failed opening required 'C:\wamp\www\craigmedia/wp-includes/functions.php' (include_path='.;C:\php\pear') in C:\wamp\www\craigmedia\wp-settings.php on line 72


Now when I go into php my admin I get this when clicking on " wp_blogs" table for craigmedia data base:

#1017 - (Errcode: 2 - No such file or directory)

In the mysql.log Im getting things like this

[Warning] InnoDB: Cannot open table craigmedia/wp_eg_grids from the internal data dictionary of InnoDB though the .frm file for the table exists. See [dev.mysql.com] for how you can resolve the problem.

So it goes back to my database which seems not there for some reason but yet showing. Any ideas. Wamp is still greenlight thought

Anyone had any success fixing this issue?

[Warning] InnoDB: Cannot open table craigmedia/wp_eg_grids from the internal data dictionary of InnoDB though the .frm file for the table exists. See [dev.mysql.com] for how you can resolve the problem.

More information above in previous post.

Ok so your database was not all MYISAM files, some or all where INNODB, which means some or all of your data was in the ibdata1 file that lives in the \wamp\bin\mysql\mysql{version}\data folder.

If you dont have a backup of this file, you have probably lost your database.

Even if you do recovering it may be too difficult.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

I do have it in my old data folder, only thing is I've tried putting it in as well, but had no luck when it was with the files. Is there any other way to get innodb tables working, or you have any other methods I could try?

Maybe I should mention as well that most of the tables that are showing "dont exist" are from plugins for my wordpress site. Hopefully that would mean anything.

No I am all out of ideas

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-