The free forums are no longer in use. It remains available as read-only archive.
Log In
Home
Topic RSS
2:38 pm
June 1, 2011
Offline
hi there,
everything works fine in xcloner. but there is a problem occuring on every wordpress installation is backup with xcloner.
the option "select tables to exclude from backup" is not working. on every time the whole database with all tables is saved, no matter which table i select for exlusion.
anyone the same problem here?
3:48 pm
September 26, 2010
Offline
Hi Lars, could you send me a copy of the administrator/backups folder from inside the backup, the exclude tables option excludes actually only the tables content, and not also the tables structure. To exclude the full table(structure+content) you might want to set the "Refresh mode" option to Normal in your XCloner Config->System Tab
Ovidiu
4:44 pm
June 1, 2011
Offline
wow, that was ist! it's working now 
just changed from ajax to normal mode in the system tab and xcloner only saves the tables i selected. and there is another difference ... it includes a lock tables query, ain't it? when it backuped the whole database with all tables (not only the table structure -> but structure + data), there was no table locking at all.
so, thanks for the solution 
6:02 pm
September 26, 2010
Offline
Can post here an example of the locking table query to see what you have there?
Ovidiu
10:28 pm
June 1, 2011
Offline
this is an excerpt from the sql backup file with ajax option:
#
# Dumping data for table `agesrock`
#INSERT INTO `agesrock` VALUES ('POINT(-67.82 -26.57)', '1', '-67.82', '-67.82', '-26.57', '-26.57', '617808.00000', '7060577.00000', '0.0', '0.00000', 'K-Ar', 'Glass', 'volcanic', '-67.81716', '-26.57026', '1');
INSERT INTO `agesrock` VALUES ('POINT(-68.12 -26.56)', '2', '-68.12', '-68.12', '-26.56', '-26.56', '587616.00000', '70
and so on ...
it ends with the closing ";" and nothing more
this is the same data input command with the xcloner option normal, instead of ajax - generating an table locking query:
--
-- Dumping data for table `agesrock`
--LOCK TABLES `agesrock` WRITE;
/*!40000 ALTER TABLE `agesrock` DISABLE KEYS */;
INSERT INTO `agesrock` VALUES ('POINT(-67.82 -26.57)',1,-67.82,-67.82,-26.57,-26.57,'617808.00000','7060577.00000','0.0','0.00000','K-Ar','Glass','volcanic','-67.81716','-26.57026',1),('POINT(-68.12 -26.56)',2,-68.12,-68.12,-26.56,-26.56,'587616.00000','7061711.0and so on ...
/*!40000 ALTER TABLE `agesrock` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2011-06-03 0:15:27
the lock tables query can easily be seen. there is no further modification than the switch between ajax and normal mode.
1 Guest(s)
