Trouble Exporting database using phpmyadmin, MAMP, localhost

Hi There,
I’m hoping someone can help me. I’m new to developing sites using localhost. I installed WP using MAMP and have been building a site for my town’s public library. I now need to move it to a host so the team can view it to make final changes etc.

The problem is, I’m having issues moving the site (first tried local by flywheel, then a couple of free hosts). I’m encountering problems exporting my database using phpmyadmin (also had a problem using Duplicator plugin. All my theme mods were lost. Although I was able to use it successfully with another, less developed site I had started for them and scrapped).

When I attempt an export in phpmyadmin I get an incredibly long error message that lists several tables with issues that I’m not sure how to fix. I honestly don’t know what it means.

Error message begins with what’s below… (Please note: the “generation time” is incorrect as well – even though my time zone is set properly in WP – not sure that matters. I’m also noticing now that the host says localhost:8889, but to access the site I go to localhost:8888, I also included the first table error message).

— phpMyAdmin SQL Dump
— version 4.9.5
— https://www.phpmyadmin.net/
—
— Host: localhost:8889
— Generation Time: Jan 15, 2021 at 04:58 PM
— Server version: 5.7.30
— PHP Version: 7.4.9

SET SQL_MODE = “NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00”;

—
— Database: drevartsfour_db
—

— ——————————————————–

—
— Table structure for table wp_cn_social_icon
—

CREATE TABLE wp_cn_social_icon (
id int(11) NOT NULL,
title varchar(255) DEFAULT NULL,
url varchar(255) NOT NULL,
image_url varchar(255) NOT NULL,
sortorder int(11) NOT NULL DEFAULT ‘0’,
date_upload varchar(50) DEFAULT NULL,
target tinyint(1) NOT NULL DEFAULT ‘1’
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

—
— Dumping data for table wp_cn_social_icon
—

INSERT INTO wp_cn_social_icon (id, title, url, image_url, sortorder, date_upload, target) VALUES
(1, ‘Facebook’, ‘https://www.facebook.com/drevartslibrary’, ‘fa fa-facebook’, 0, ‘xxxxxxx’, 1),
(4, ‘Instagram’, ‘https://instagram.com/’, ‘fab fa-instagram’, 2, ‘xxxx’, 1),
(5, ‘YouTube’, ‘https://www.youtube.com/channel/xxxxxxxx’, ‘fab fa-youtube’, 1, ‘1608666994’, 1);

I was able to force an export by using the custom function and changing the export format, but then several tables were missing.

The site menus link out to several other sites for community resources. Could that be the problem? I’m also using several plugins, but I don’t think that’s it because the site is running beautifully on localhost.

Sorry this is so long, just thought I’d give as much background as possible. Been struggling with this for a while.

Thank you in advance!!
Amy

• This topic was modified 5 years, 4 months ago by Steven Stern (sterndata).