[Alex]

First of all let me say a big thank you for your great plugin.

I have a website with 150 connections.

I regularly do backups with Duplicator, from the live server to a MAMP server in my PC.

This is the first time I am using Connections and today was the time for my usual backup. After creating a Duplicator package and opening it locally, all the website is ok but the Connections aren’t there.

Is there a specific guide I need to follow to do such a backup or have I done something wrong?

Thanks in advance

Alex

[Steven Zahm]

@ Alex

Look in the package zip file. Open the database.sql file in your favorite text editor and search for _connections. You should find at least several hundred based on 150 entries. If you do not see any, then you need to check your configuration of Duplicator. I just installed, with no configuration, created a package and the tables were included with their data in the database.sql file.

If they are present, then open you local database using your favorite db explorer. Are the tables present and do they contain data. If there is then they imported fine and there is a config issue with your local MAMP install.

Let me know what you find.

[Alex]

Thank you for your fast response Steven.

I did as instructed.

The database.sql file does indeed show several instances of “_connections”.

I opened MAMP’s phpMyAdmin.
There are several tables in it.
I am using only the following fields:

Prefix
First Name
Last Name
Title
Organisation
Email

I can only see the emails, the taxonomy and the terms (in their respective tables), but I can’t find any of the rest of the fields.

Any ideas?

[Steven Zahm]

@ Alex

The following fields are saved in the {db_prefix}_connections table:

Prefix
First Name
Last Name
Title
Organisation

The email is saved in the {db_prefix}_connections_email table.

So, it sounds like the {db_prefix}_connections table does not exist or is empty. Which?

[Steven Zahm]

@ Alex

Once suggestion… make sure the MySql version on your MAMP install matches the version on your server and is configured identically.

[Alex]

In regards to the configuration of MAMP MySQL being identical to my live server’s, I’m afraid I have no way of knowing how the latter is configured.

Seems I don’t have a _connections table at all!

Here’s what I have:

[Steven Zahm]

@ Alex

re: Seems I don’t have a _connections table at all!

That seems to be the issue… for some reason Duplicator did not create the table and insert the data.

Look in the database.sql for this line CREATE TABLE{db_prefx}_connections(. Does it exist?

If it does, then it was exported fine. For some reason, not imported

Best guess is the source db supports FULLTEXT and the MAMP installation does not. If the create table command exists, which I suspect it does, look for a line at the end of the command that begins with FULLTEXT KEYsearch If it does, go to the Connections : Settings admin page, click the Search tab and disable the FULLTEXT search option. Now create a Duplicator package and setup a new installation and import it. Is the table created now?

[Alex]

You, kind Sir, are a legend.

It works perfectly fine now.

Should I re-enable the FULLTEXT search option in the live website?

[Steven Zahm]

@ Alex

Great to hear! And, yes, absolutely, I highly recommend keeping FULLTEXT enabled. This basically allows the db to perform more relevant searches.

Now we know the issue… if you set up you local MAMP config for MySQL so it too support FULLTEXT you should not have issues in the future. The other option would be to disable FULLTEXT make your package and then enable it. I recommend for former over the letter.

Hope that helps!

[Author]

Posts