The free forums are no longer in use. It remains available as read-only archive.
8:52 pm
February 4, 2014
I just did a backup of my wordpress site and then cloned it to a subdirectory. When checking the live cloned site- I was missing widgets from most pages
When I checked phpmyadmin - I saw that only 25 of the 53 tables were copied and this is why the site does not appear correctly + I cannot log in to the admin of the site
How can I create a successful backup?
thanks
Susan
9:02 pm
February 4, 2014
XCloner! Support said:
HI Susan. Did you get any errors when restoring the backup? Did you by any chance excluded some of the tables when creating the original backup?
I did not exclude any tables when creating the original backup
when restoring the backup- I did get an sql error - regarding a table that could not be copied and we edited the code and at the end the backup got stuck at 99.53%. The SQL error had to do with the fact that there was a foreign key constraint on a table that was being created but the referenced table had not been created yet. It seemed like the tables were being recreated in alphabetical order but that was not the way they had been created originally. Below is the part of the create table sql that caused the problem. The table that was being created was wordpress_rokgallery_file_loves which referenced wordpress_rokgallery_files
CONSTRAINT `wordpress_file_loves_file_id_files_id` FOREIGN KEY (`file_id`) REFERENCES `wordpress_rokgallery_files` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
I don't know how to resolve that issue for further backups
what do you advise?
thanks
Susan
++++++++++++++++++++
1 Guest(s)