When trying to import my current database to OVH multisite hosting, I get this message in the phpmyadmin manager "504 Gateway Time-out" yet it works ok in both mamp and aquia on local machine. This is a new issue, the site I'm developing locally only started to do this in the last attempt import.

If I remove the config table it imports ok, if I use an older, by a few days MySQL dump, and import every other table it works, but obviously i'm missing the configuration for those days. I have 08, 09, 10, 11 and 12 of May dumps, 08 and 09 work fine, but not the others ?

My Local development environments

Mamp Pro 4.1.1
Database Version 5.6.35
PHP 7.1.1
phpmyadmin Version information: 4.6.6

Acquia Dev Desktop 2
Database Version 5.5.48-37.8-log
PHP 7.0.14
Apache/2.4.17 (Unix) OpenSSL/1.0.1h mod_fcgid/2.3.9
phpmyadmin Version information: 4.4.14,

Trying to upload the latest build with the ovh phpmyadmin, which I do regularly, the site fails to open and giving this message “There website encountered an unexpected error. Please try again later.”

Yet I can import and export this database with ease on the local servers which makes no sense to me. It seems to be a problem with the import on the ovh server, or is their something 'bad' in the config table.. ?

Any insight or assistance would be most welcome, thank you. Alex

Comments

AlexJ created an issue. See original summary.

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented
Issue summary: View changes
AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented
Issue summary: View changes
cilefen’s picture

cilefen CreditAttribution: cilefen commented

@AlexJ Apologies if I am misread what you wrote but I do not understand the connection to the Drupal configuration system, the component in which this issue was opened. This seems to be something to do with importing and exporting a database in phpmyadmin. As such, it seems more like a support request for OVH.

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented

cilefen, thanks for replying, I see I was not clear about the config connection.. if I remove the config table it imports ok, if I use an older, by a few days MySQL dump, and import every other table it works, but obviously i'm missing the configuration for those days. There was lots of work too. If I then try to import the config file I have exported locally it fails during the import process and I get the unexpected error try later message.

I have a support request made to OVH too and will follow that up. What I don't understand is that two previous dumps work.

I have 08, 09, 10, 11 and 12 of May, 08 and 09 work fine, but not the others ?

I'm confused by this and not an expert by any means but know my way around. I have learned allot about config in the last day. It's quite inflexible really. I tried the configuration tool module but it fails if I try to set up another path to force the config flies out of the database.

Thanks again and happy to test further or supply more info

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented
Issue summary: View changes
AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented
Issue summary: View changes
AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented
Title: Database fails when inporting config table » Database fails when importing config table
AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented

OVH have disclaimed this issue saying I need to look at the database logs myself to see what the issues is. I don't know how to do that yet, so another level of learning is upon me regarding mySql.

cilefen’s picture

cilefen CreditAttribution: cilefen commented

I am not sure what is going on. You may want to check the value of max_allowed_packet in the mysql configuration.

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented

Good lead cilifen, thanks, I need to get into the whole database area. I was looking at some logs on ovh site and blob size was mentioned as being over the 10% ok. Their MySQL config is where I am heading and compare it to my own MySQL configs. It is just the config table that is the issue and it's size is 2.5mb. I'll keep this posted.

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented

Checked the max_allowed_packet = 33554432 on OVH, and on my Mamp its max_allowed_packet =16777216 so that's not the cause.

AlexJ’s picture

AlexJ CreditAttribution: AlexJ commented

I upgraded to a private database facility with OVH and that has sorted out my database issues.. so you were right cilefen, Thanks again. AlexJ

cilefen’s picture

cilefen CreditAttribution: cilefen commented
Status: Active » Closed (works as designed)
drupaleye’s picture

drupaleye CreditAttribution: drupaleye commented

I had problems importing a database using phpmyadmin on localhost MAMP 3.5 (FREE). Increasing max_allowed_packet solved it for me. I had to create a my.cnf file in /Applications/MAMP/conf/

[mysqld]
max_allowed_packet = 64M

https://stackoverflow.com/a/2869707/762640