Can not import database from online server
Posted by: Elrond (---.109.103.8.adsl.dyn.edpnet.net)
Date: February 06, 2020 01:18PM

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

Options: ReplyQuote
Re: Can not import database from online server
Posted by: Otomatic (Moderator)
Date: February 06, 2020 02:08PM

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.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.3 32 bit - Apache 2.4.46 - PHP 7.4.9…5.6.40 - MySQL 5.7.31 - MariaDB 10.5.5
Wampserver 3.2.3 64 bit - Apache 2.4.46 - PHP 7.4.9…5.6.40 - MySQL 5.7.31/8.0.21 - MariaDB 10.5.5
PhPMyadmin 5.0.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »



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

Options: ReplyQuote
Re: Can not import database from online server
Posted by: Elrond (---.109.103.8.adsl.dyn.edpnet.net)
Date: February 06, 2020 02:24PM

Mysql is the default database manager.

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

However, this is an mysql dump ...

Options: ReplyQuote
Re: Can not import database from online server
Posted by: RiggsFolly (Moderator)
Date: February 06, 2020 02:26PM

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.2.0 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.19>

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-

Options: ReplyQuote
Re: Can not import database from online server
Posted by: Elrond (---.109.103.8.adsl.dyn.edpnet.net)
Date: February 06, 2020 03:23PM

Quite sure ..

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


version_comment MySQL Community Server (GPL)

Options: ReplyQuote


Sorry, only registered users may post in this forum.