WampServer

Hi,

I just made my first export with wamp 3
I only set it to zip file

it seems that the create table are missing fields and are corrupted, and so cannot be imported

CREATE TABLE `communication_mails` (
`id` int(11) NOT NULL,
`communication_id` int(11) NOT NULL,
`email_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0'COMMENT
) ;

see the last line

with mysqldump it works

CREATE TABLE `communication_mails` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`communication_id` int(11) NOT NULL,
`email_id` int(11) NOT NULL,
`type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 departements emails 1 backend users emails',
PRIMARY KEY (`id`),
UNIQUE KEY `communication_id` (`communication_id`,`email_id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

how can I solve this ? is there a patch ?

thanks



Edited 1 time(s). Last edit at 09/27/2016 02:24PM by phil123456.

Hi,

Use PhpMyAdmin 4.6.4

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

how do I "use" php 4.6.4 ? I use wamp 3 cos it has the right php version that I need

You install that ADDON

And then that is the version of phpMyAdmin that will be current on your PC

---------------------------------------------------------------------------------------------
(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-

Hi,

> how do I "use" php 4.6.4 ?

It is not php 4.6.4 it is, as I wrote, PhpMyAdmin Put on your glasses!

And I have also given the link that allows the downloading Addon PhpMyAdmin4.6.4.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

- sorry I meant phpmyadmin, not a glass problem, more like a "thousand things to do at a time" problem
- I just installed the latest wamp3

Hi,

There are some "glitches" with PhpMyAdmin before 4.6.4.
Install PhpMyAdmin 4.6.4 and use it to export databases.
----- ^^^^^^^^^^^^^^ --- This is a link to download.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

You said: I just installed the latest wamp3

So can we assume that you installed WAMPServer3.0.6 which comes with phpMyAdmin4.6.4 and the issue with EXPORT has now gone away?

It really does help if your communications are precise and clear

---------------------------------------------------------------------------------------------
(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 2 time(s). Last edit at 10/03/2016 10:06AM by RiggsFolly.