Question

Jan Immeker on Wed, 07 Mar 2018 22:01:29


Can you figure out what goes wrong?

Sponsored



Replies

SamCogan on Wed, 07 Mar 2018 22:16:25


Can you provide us with some more details please? The error message you receive or any logs.

Jan Immeker on Wed, 07 Mar 2018 22:28:34


I can't find anything related to the error mentioned in the logfile: MySql backup exited with code 3 for db:wimpedb. Output:-- MySQL dump 10.13 Distrib 5.6.15, for Win64 (x86_64) -- -- Host: http://wimpedb.mysql.database.azure.com  Database: wimpedb -- ------------------------------------------------------ -- Server version5.6.26.0 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `wmpaiowps_events` -- DROP TABLE IF EXISTS `wmpaiowps_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wmpaiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `username` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referer_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `event_data` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wmpaiowps_events` -- LOCK TABLES `wmpaiowps_events` WRITE; /*!40000 ALTER TABLE `wmpaiowps_events` DISABLE KEYS */; /*!40000 ALTER TABLE `wmpaiowps_events` ENABLE KEYS */; UNLOCK TABLES; mysqldump: Error 5: Out of memory (Needed 4610768 bytes) when dumping table `wmpaiowps_global_meta` at row: 0

Jan Immeker on Wed, 07 Mar 2018 22:39:52


I can't find anything related to the error mentioned in the logfile: MySql backup exited with code 3 for db:wimpedb. Output:-- MySQL dump 10.13 Distrib 5.6.15, for Win64 (x86_64) -- -- Host: http://wimpedb.mysql.database.azure.com  Database: wimpedb -- ------------------------------------------------------ -- Server version5.6.26.0 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `wmpaiowps_events` -- DROP TABLE IF EXISTS `wmpaiowps_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wmpaiowps_events` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `event_type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `username` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `event_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ip_or_host` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `referer_info` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_code` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `event_data` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `wmpaiowps_events` -- LOCK TABLES `wmpaiowps_events` WRITE; /*!40000 ALTER TABLE `wmpaiowps_events` DISABLE KEYS */; /*!40000 ALTER TABLE `wmpaiowps_events` ENABLE KEYS */; UNLOCK TABLES; mysqldump: Error 5: Out of memory (Needed 4610768 bytes) when dumping table `wmpaiowps_global_meta` at row: 0

Jan Immeker on Thu, 08 Mar 2018 14:13:10


Fixed. I disabled the WP-DBManager plugin and now it works. Thanks for the time and support.

vikranth s on Sun, 11 Mar 2018 14:11:02


Thank you for sharing your solution and experience here. It will be greatly beneficial for other community members who have related questions.         

Do click on "Mark as Answer" on the post that helps you, this can be beneficial to other community members.