wir sind dabei einige ältere Wordpress-Installationen auf neue Server umzuziehen.
WP hat 6.1.x; PHP noch 7.2 ... Updates etc. ist alles für "nach" dem Umzug geplant.
Nun haben wir das PlugIn "WP Migrate Lite" genutzt, nur um die DB zu bearbeiten und dann zu exportieren.
Egal ob komprimiert oder direkt als sql File ...
wenn man dann dieses SQL File dann versucht mit dem MyOOS Dumper wiederherzustellen ... kommt immer die Error-Message schon direkt bei der erste Tabelle :
Error-Message : Restore failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `aktuelles_actionscheduler_claims`;
Die DB ist nur angelegt und leer.
Die ersten Tabellen im SQL Script sehen so aus ...
Code: Alles auswählen
/*!40101 SET NAMES utf8mb4 */;
SET sql_mode='NO_AUTO_VALUE_ON_ZERO';
#
# Delete any existing table `wptab_actionscheduler_actions`
#
DROP TABLE IF EXISTS `wptab_actionscheduler_actions`;
#
# Table structure of table `wptab_actionscheduler_actions`
#
CREATE TABLE `wptab_actionscheduler_actions` (
`action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`hook` varchar(191) COLLATE utf8_unicode_ci NOT NULL,
`status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',
`scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',
`args` varchar(191) COLLATE utf8_unicode_ci DEFAULT NULL,
`schedule` longtext COLLATE utf8_unicode_ci,
`group_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`attempts` int(11) NOT NULL DEFAULT '0',
`last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',
`last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',
`claim_id` bigint(20) unsigned NOT NULL DEFAULT '0',
`extended_args` varchar(8000) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`action_id`),
KEY `hook` (`hook`),
KEY `status` (`status`),
KEY `scheduled_date_gmt` (`scheduled_date_gmt`),
KEY `args` (`args`),
KEY `group_id` (`group_id`),
KEY `last_attempt_gmt` (`last_attempt_gmt`),
KEY `claim_id` (`claim_id`),
KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=17731 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Data contents of table `wptab_actionscheduler_actions`
#
INSERT INTO `wptab_actionscheduler_actions` ( `action_id`, `hook`, `status`, `scheduled_date_gmt`, `scheduled_date_local`, `args`, `schedule`, `group_id`, `attempts`, `last_attempt_gmt`, `last_attempt_local`, `claim_id`, `extended_args`) VALUES
(17719, 'rank_math/analytics/daily_tasks', 'failed', '2022-09-23 06:45:42', '2022-09-23 08:45:42', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1663915542;s:18:"\0*\0first_timestamp";i:1608868348;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1663915542;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-09-23 06:45:50', '2022-09-23 08:45:50', 0, NULL),
(17720, 'rank_math/analytics/data_fetch', 'failed', '2022-09-23 13:28:13', '2022-09-23 15:28:13', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1663939693;s:18:"\0*\0first_timestamp";i:1618573320;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1663939693;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-09-23 13:28:50', '2022-09-23 15:28:50', 0, NULL),
(17722, 'rank_math/analytics/daily_tasks', 'failed', '2022-09-30 06:45:50', '2022-09-30 08:45:50', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1664520350;s:18:"\0*\0first_timestamp";i:1608868348;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1664520350;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-09-30 06:45:56', '2022-09-30 08:45:56', 0, NULL),
(17723, 'rank_math/analytics/data_fetch', 'failed', '2022-09-30 13:28:50', '2022-09-30 15:28:50', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1664544530;s:18:"\0*\0first_timestamp";i:1618573320;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1664544530;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-09-30 13:31:11', '2022-09-30 15:31:11', 0, NULL),
(17724, 'rank_math/analytics/daily_tasks', 'failed', '2022-10-07 06:45:56', '2022-10-07 08:45:56', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1665125156;s:18:"\0*\0first_timestamp";i:1608868348;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1665125156;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-07 06:49:15', '2022-10-07 08:49:15', 0, NULL),
(17725, 'rank_math/analytics/data_fetch', 'failed', '2022-10-07 13:31:11', '2022-10-07 15:31:11', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1665149471;s:18:"\0*\0first_timestamp";i:1618573320;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1665149471;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-07 13:31:37', '2022-10-07 15:31:37', 0, NULL),
(17726, 'rank_math/analytics/daily_tasks', 'failed', '2022-10-14 06:49:15', '2022-10-14 08:49:15', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1665730155;s:18:"\0*\0first_timestamp";i:1608868348;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1665730155;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-14 06:50:39', '2022-10-14 08:50:39', 0, NULL),
(17727, 'rank_math/analytics/data_fetch', 'failed', '2022-10-14 13:31:37', '2022-10-14 15:31:37', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1665754297;s:18:"\0*\0first_timestamp";i:1618573320;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1665754297;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-14 13:31:44', '2022-10-14 15:31:44', 0, NULL),
(17728, 'rank_math/analytics/daily_tasks', 'failed', '2022-10-21 06:50:39', '2022-10-21 08:50:39', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1666335039;s:18:"\0*\0first_timestamp";i:1608868348;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1666335039;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-21 06:51:10', '2022-10-21 08:51:10', 0, NULL),
(17729, 'rank_math/analytics/data_fetch', 'failed', '2022-10-21 13:31:44', '2022-10-21 15:31:44', '[]', 'O:32:"ActionScheduler_IntervalSchedule":5:{s:22:"\0*\0scheduled_timestamp";i:1666359104;s:18:"\0*\0first_timestamp";i:1618573320;s:13:"\0*\0recurrence";i:604800;s:49:"\0ActionScheduler_IntervalSchedule\0start_timestamp";i:1666359104;s:53:"\0ActionScheduler_IntervalSchedule\0interval_in_seconds";i:604800;}', 3, 1, '2022-10-21 13:33:02', '2022-10-21 15:33:02', 0, NULL) ;
#
# End of data contents of table `wptab_actionscheduler_actions`
# --------------------------------------------------------
#
# Delete any existing table `wptab_actionscheduler_claims`
#
DROP TABLE IF EXISTS `wptab_actionscheduler_claims`;
#
# Table structure of table `wptab_actionscheduler_claims`
#
CREATE TABLE `wptab_actionscheduler_claims` (
`claim_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`date_created_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`claim_id`),
KEY `date_created_gmt` (`date_created_gmt`)
) ENGINE=InnoDB AUTO_INCREMENT=59002 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Data contents of table `wptab_actionscheduler_claims`
#
#
# End of data contents of table `wptab_actionscheduler_claims`
# --------------------------------------------------------
#
# Delete any existing table `wptab_actionscheduler_groups`
#
DROP TABLE IF EXISTS `wptab_actionscheduler_groups`;
#
# Table structure of table `wptab_actionscheduler_groups`
#
CREATE TABLE `wptab_actionscheduler_groups` (
`group_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`group_id`),
KEY `slug` (`slug`(191))
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
#
# Data contents of table `wptab_actionscheduler_groups`
#
INSERT INTO `wptab_actionscheduler_groups` ( `group_id`, `slug`) VALUES
(1, 'action-scheduler-migration'),
(2, 'wp_mail_smtp'),
(3, 'rank-math') ;
#
# End of data contents of table `wptab_actionscheduler_groups`
# --------------------------------------------------------
......
Der MyOOS Dumper legt die erste Tabelle an ... importiert die ersten 9 von 10 Datensätzen ... und dann ist Schluß.
Nimmt man die einzelnen SQL Befehle per "copy & paste" ... klappt alles wunderbar ...
aber im gesamten bricht der MyOOS Dumper immer ab
Ich wäre über jeden helfenden Hinweis dankbar
Viele Grüße und schönes Wochenende
Michael Hinrichs
