WampServer

Ok,

so I created a dump with the php exec function from a certain database on our website. It turns out I can not import it using wamp. Using the import in phpmyadmin, it just keeps on loading saying 'waiting for localhost'.

When I restart Wamp server, the database is there, but the data is missing.

When I then try to delete the database, I can't. I need to delete 31/32 columns before the database can be dropped.

I am using Wamp server v3.2.0


However the same sql file can be imported on the web server and in Xampp without any problems.

Moreover, if I create an sql-file using phpmyadmin and export the same database from the remote server, I can import the file into Wamp.

The same script also works on another database from that server, so I am quite sure it has something to do with the database itself conflicting with wamp. The file is only 23kb so size is not the issue ...

I have compared settings of both databases, the one working and the one not and nothing seems to differ.

So does anyone have any idea how to pursue this issue further? Since I am not getting any errors, I have exhausted my ideas after spending several hours on stackoverflow etc ...

Hi,

See Right-Click -> Help -> MySQL - MariaDB

Maybe setting MySQL as the default database manager will solve the problem.

You can also check for errors in the MariaDB and MySQL log files.

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



Edited 1 time(s). Last edit at 02/06/2020 02:25PM by Otomatic.

Mysql is the default database manager.

If I try to import the file into Mariadb, it works.

However, this is an mysql dump ...

Are you sure its a MySQL dump, mariaDB looks very like MySQL unless you look very closelt, lots of hosters are just droppping mariaDB into place and not saying much about it !

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

Quite sure ..

When performing this command in sql : SHOW VARIABLES LIKE '%vers%', I get


version_comment MySQL Community Server (GPL)