Backup problem

The first message is “Job “Backup Job” has started, but not responded for 10 seconds” then after clicking information I get the message in the first post.

I have problem with backup too.

1) normal backup.
Error

SQL query:

DROP TABLE IF EXISTS crypto_files

MySQL said: Documentation
#1046 –

2) backup after delete “drop table if exist”
Error

SQL query:

CREATE TABLE crypto_files (
fileID int(11) unsigned NOT NULL AUTO_INCREMENT,
fileTitle varchar(100) NOT NULL DEFAULT ”,
active tinyint(1) NOT NULL DEFAULT ‘1’,
fileName varchar(100) NOT NULL DEFAULT ”,
fileSize double(15,0) NOT NULL DEFAULT ‘0’,
fileText text,
priceUSD double(10,2) NOT NULL DEFAULT ‘0.00’,
priceCoin double(17,5) NOT NULL DEFAULT ‘0.00000’,
priceLabel varchar(6) NOT NULL DEFAULT ”,
purchases mediumint(8) NOT NULL DEFAULT ‘0’,
userFormat enum(‘MANUAL’,’COOKIE’,’SESSION’,’IPADDRESS’) NOT NULL,
expiryPeriod varchar(15) NOT NULL DEFAULT ”,
lang varchar(2) NOT NULL DEFAULT ”,
defCoin varchar(5) NOT NULL DEFAULT ”,
defShow tinyint(1) NOT NULL DEFAULT ‘1’,
image varchar(100) NOT NULL DEFAULT ”,
imageWidth smallint(5) NOT NULL DEFAULT ‘0’,
priceShow tinyint(1) NOT NULL DEFAULT ‘1’,
paymentCnt smallint(5) NOT NULL DEFAULT ‘0’,
paymentTime datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`u[…]

MySQL said: Documentation
#1046 –

3) sometimes backup work but delete one, two tables from database (wp-post and/or wp-pages)

Now I need restore backup, because I lost all post and pages from database.

• This reply was modified 8 years, 1 month ago by onliniak.

I resolve my problem (and propably your).
You must open phpMyAdmin →?sql →?paste all text without DROP TABLE IF EXISTS xyz; and /*!40101 SET character_set_client = @saved_cs_client */;

For example you have “DROP TABLE IF EXISTS wp_postmeta;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = ‘utf8mb4’ */;
CREATE TABLE wp_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (meta_id),
KEY post_id (post_id),
KEY meta_key (meta_key(191)),
KEY meta_id (meta_id,post_id,meta_key),
KEY meta_id_2 (meta_id,post_id,meta_key)
) ENGINE=InnoDB AUTO_INCREMENT=115904 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;”

Open sql and paste ”
CREATE TABLE wp_postmeta (
meta_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
post_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
meta_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
meta_value longtext COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (meta_id),
KEY post_id (post_id),
KEY meta_key (meta_key(191)),
KEY meta_id (meta_id,post_id,meta_key),
KEY meta_id_2 (meta_id,post_id,meta_key)
) ENGINE=InnoDB AUTO_INCREMENT=115904 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;”

• This reply was modified 8 years, 1 month ago by onliniak.

Hi, there is nothing of your problem that seems related to mine.

This problem was fixed in a update of the plugin.