Title: Trouble Exporting database using phpmyadmin, MAMP, localhost Last modified: January 15, 2021 --- # Trouble Exporting database using phpmyadmin, MAMP, localhost * Resolved [amys25](https://wordpress.org/support/users/amys25/) * (@amys25) * [5 years, 4 months ago](https://wordpress.org/support/topic/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/](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’](https://www.facebook.com/drevartslibrary’);,‘ fa fa-facebook’, 0, ‘xxxxxxx’, 1), (4, ‘Instagram’, ‘[https://instagram.com/’](https://instagram.com/’);,‘ fab fa-instagram’, 2, ‘xxxx’, 1), (5, ‘YouTube’, ‘[https://www.youtube.com/channel/xxxxxxxx’](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)](https://wordpress.org/support/users/sterndata/). Viewing 6 replies - 1 through 6 (of 6 total) * [Dion](https://wordpress.org/support/users/diondesigns/) * (@diondesigns) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13913612) * That isn’t an error, it’s the exported database. You should tell phpMyAdmin to save the export to a file. * Thread Starter [amys25](https://wordpress.org/support/users/amys25/) * (@amys25) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13913679) * Thanks for answering. I don’t see where I can tell it that. It gives me “back” and “refresh” options. At the bottom of the page I’m seeing a tab called “console” when I click it it reads “press ctrl+enter to execute query. Is that the spot? * OMG, I will feel so dumb if that was it all along! 🙂 * [Dion](https://wordpress.org/support/users/diondesigns/) * (@diondesigns) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13913887) * If you are displaying the database in phpMyAdmin, there should be an `Export` tab in the tab bar at the top. If you click that tab, you should go to a page with a title like `Exporting tables from "dbname" database`, and there should be numerous options, including the one I mentioned. Do you see that page? * If not, it’s possible (likely?) that MAMP is providing a limited version of phpMyAdmin, and you’ll need to install an official version downloaded from phpmyadmin.net. * Thread Starter [amys25](https://wordpress.org/support/users/amys25/) * (@amys25) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13913937) * Yeah, I got that page. There’s a “quick” option and a “custom” option. I got the above when I used “quick”. I did see a vid on YouTube that said I should copy that, paste it into a text editor and save as .sql * I did that, but haven’t done anything with is yet. * Should I try using the “custom” option? * Thanks again btw… * [Dion](https://wordpress.org/support/users/diondesigns/) * (@diondesigns) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13914942) * Yes, you should use the “custom” option and make sure you’re saving the output to a file. It would save time if you also set the compression option to “gzipped”. The other custom options can remain as-is. * Thread Starter [amys25](https://wordpress.org/support/users/amys25/) * (@amys25) * [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13916223) * Thank you! I have resolved this. I really appreciate your help. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Trouble Exporting database using phpmyadmin, MAMP, localhost’ is closed to new replies. * In: [Localhost Installs](https://wordpress.org/support/forum/localhost-installs/) * 6 replies * 2 participants * Last reply from: [amys25](https://wordpress.org/support/users/amys25/) * Last activity: [5 years, 4 months ago](https://wordpress.org/support/topic/trouble-exporting-database-using-phpmyadmin-mamp-localhost/#post-13916223) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics