How did Backup fail to restore the site?

[walt93]

Describe the bug
I created a new videosite.

I went to plugins->backup and I backed up the videos, and I backed up the database.

I went to the new videosite and I restored the database, and I restored the videos.

There is no change to the new videosite. It has generic branding / no users / no videos.

To Reproduce
Steps to reproduce the behavior:

1. Go to videosite 1
2. Go to plugins->backup
3. Run a full backup
4. Copy those files to the /var/www/html/newvideosite/plugin/Backup/backupDir
5. From newvideosite, go to plugins->backup
6. restore database
7. restore videos
8. Observe that nothing happened

Expected behavior
The videosite to be copied to newvideosite

Note: in /var/www/html/newvideosite/videos I can see many GB of videos folders that apparently were restored. The database, however, is not.

Error Logs
Running plugins->backup->restore the database does not generate any messages (apparently) to the avideo.log - I have just initiated restore on the database (for the third time) and here is the log:

NOTE: I also tried Clonesite and the process simply does not work. It seems to be failing the rsync step.

[07-Jun-2024 13:08:58 America/Lima] AVideoLog::WARNING: Time: 1.405s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 166 [navbar.php] IP=3.224.220.101 BOT  USER_AGENT=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5 (Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:08:59 America/Lima] AVideoLog::DEBUG: PlayList::getVideosFromPlaylist(175818) [{"file":"\/var\/www\/html\/conspyre.tv\/plugin\/PlayLists\/PlayLists.php","line":1230,"function":"_getVideos","class":"PlayListPlayer","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/modeYoutube.php","line":85,"function":"__construct","class":"PlayListPlayer","object":{},"type":"->","args":[175818,null]}] SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:08:59 America/Lima] AVideoLog::WARNING: Time: 1.483s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/index.php Line 166 [navbar.php] IP=213.180.203.42 BOT  USER_AGENT=Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) SCRIPT_NAME: /view/index.php
[07-Jun-2024 13:08:59 America/Lima] AVideoLog::WARNING: Time: 1.605s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=13.58.119.203 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) SCRIPT_NAME: /view/user.php
[07-Jun-2024 13:08:59 America/Lima] AVideoLog::WARNING: Time: 1.529s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/index.php Line 166 [navbar.php] IP=213.180.203.158 BOT  USER_AGENT=Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) SCRIPT_NAME: /view/index.php
[07-Jun-2024 13:09:00 America/Lima] AVideoLog::WARNING: Time: 1.397s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=18.117.76.154 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) SCRIPT_NAME: /view/user.php
[07-Jun-2024 13:09:00 America/Lima] AVideoLog::WARNING: Time: 1.319s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/index.php Line 166 [navbar.php] IP=87.250.224.51 BOT  USER_AGENT=Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) SCRIPT_NAME: /view/index.php
[07-Jun-2024 13:09:00 America/Lima] AVideoLog::DEBUG: gotToLoginAndComeBackHere(Video variable not found, please login) 18.223.172.217 [{"file":"\/var\/www\/html\/conspyre.tv\/objects\/functions.php","line":4343,"function":"gotToLoginAndComeBackHere","args":["Video variable not found, please login"]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/oembed.php","line":23,"function":"forbiddenPage","args":["Video variable not found, please login"]}] SCRIPT_NAME: /view/oembed.php
[07-Jun-2024 13:09:01 America/Lima] AVideoLog::WARNING: Time: 1.264s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=3.147.67.191 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) SCRIPT_NAME: /view/user.php
[07-Jun-2024 13:09:01 America/Lima] AVideoLog::ERROR: Time: 2.392s   | Limit: 0.5s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 211 [modeYoutube.php] IP=52.70.240.171 BOT  USER_AGENT=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5 (Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) backtrace=[{"file":"\/var\/www\/html\/conspyre.tv\/view\/modeYoutube.php","line":211,"function":"TimeLogEnd","args":["modeYoutube.php",211,0.5]}] SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:01 America/Lima] AVideoLog::WARNING: Time: 1.194s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 166 [navbar.php] IP=87.250.224.75 BOT  USER_AGENT=Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots) SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:01 America/Lima] AVideoLog::DEBUG: Time: 0.730s   | Limit: 0.7s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 686 [getTotalFromCategory_386_00] IP=47.128.117.139 BOT  USER_AGENT=Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; [email protected]) SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:01 America/Lima] AVideoLog::DEBUG: Time: 0.730s   | Limit: 0.7s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 485 [getAllCategories] IP=47.128.117.139 BOT  USER_AGENT=Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; [email protected]) SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:02 America/Lima] AVideoLog::WARNING: Time: 1.085s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=18.223.172.217 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) SCRIPT_NAME: /view/user.php
[07-Jun-2024 13:09:02 America/Lima] AVideoLog::WARNING: Time: 1.153s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 166 [navbar.php] IP=52.70.240.171 BOT  USER_AGENT=Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_1) AppleWebKit/600.2.5 (KHTML, like Gecko) Version/8.0.2 Safari/600.2.5 (Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:02 America/Lima] AVideoLog::ERROR: Time: 3.002s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/modeYoutube.php Line 166 [navbar.php] IP=47.128.117.139 BOT  USER_AGENT=Mozilla/5.0 (Linux; Android 5.0) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; Bytespider; [email protected]) backtrace=[{"file":"\/var\/www\/html\/conspyre.tv\/view\/include\/navbar.php","line":166,"function":"TimeLogEnd","args":["navbar.php",166,0.2]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":162,"args":["\/var\/www\/html\/conspyre.tv\/view\/include\/navbar.php"],"function":"include"},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":205,"function":"getNavBar","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":233,"function":"getContent","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":243,"function":"getPage","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/modeYoutube.php","line":433,"function":"print","class":"Page","object":{},"type":"->","args":[]}] SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:03 America/Lima] AVideoLog::DEBUG: PlayList::getVideosFromPlaylist(175818) [{"file":"\/var\/www\/html\/conspyre.tv\/plugin\/PlayLists\/PlayLists.php","line":1230,"function":"_getVideos","class":"PlayListPlayer","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/modeYoutube.php","line":85,"function":"__construct","class":"PlayListPlayer","object":{},"type":"->","args":[175818,null]}] SCRIPT_NAME: /view/modeYoutube.php
[07-Jun-2024 13:09:03 America/Lima] AVideoLog::WARNING: Time: 1.447s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=3.145.87.96 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) SCRIPT_NAME: /view/user.php
[07-Jun-2024 13:09:04 America/Lima] AVideoLog::DEBUG: gotToLoginAndComeBackHere(Video variable not found, please login) 18.222.119.251 [{"file":"\/var\/www\/html\/conspyre.tv\/objects\/functions.php","line":4343,"function":"gotToLoginAndComeBackHere","args":["Video variable not found, please login"]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/oembed.php","line":23,"function":"forbiddenPage","args":["Video variable not found, please login"]}] SCRIPT_NAME: /view/oembed.php
[07-Jun-2024 13:09:05 America/Lima] AVideoLog::ERROR: Time: 2.058s   | Limit: 0.2s | Location: /var/www/html/conspyre.tv/view/user.php Line 166 [navbar.php] IP=3.145.100.40 BOT  USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected]) backtrace=[{"file":"\/var\/www\/html\/conspyre.tv\/view\/include\/navbar.php","line":166,"function":"TimeLogEnd","args":["navbar.php",166,0.2]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":162,"args":["\/var\/www\/html\/conspyre.tv\/view\/include\/navbar.php"],"function":"include"},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":205,"function":"getNavBar","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":233,"function":"getContent","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/objects\/Page.php","line":243,"function":"getPage","class":"Page","object":{},"type":"->","args":[]},{"file":"\/var\/www\/html\/conspyre.tv\/view\/user.php","line":43,"function":"print","class":"Page","object":{},"type":"->","args":[]}] SCRIPT_NAME: /view/user.php

[walt93]

Update: I saw your response on #9073 and decided to try the mysql import directly.

I believe that it is failing in the case of restoring using the Backup plugin due to this error. I have not uncovered the root cause, I suspect something in the Backup script itself may be incorrect? Also, the Backup script is failing to report any errors when the restore fails - it probably is a good idea to let the user know that it has failed.

---

$ mysql -u root -p newvideosite < database-2024-06-06-09-3705af32dc840ea73cd5d23889a2f443ab.sql
Enter password:
ERROR 1064 (42000) at line 507: 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 'mysqldump: Couldn't execute 'show create table `CachesInDB_backup`': Tablespace ' at line 1

NOTE: THIS LINE APPEARS IN THE database-2024-06-06-09-3705af32dc840ea73cd5d23889a2f443ab.sql file itself at line 507, so we can see the failure occurred when the Backup was created:

[mysqldump: Couldn't execute 'show create table CachesInDB_backup': Tablespace is missing for table AVideo_conspyretv.CachesInDB_backup. (1812)]

[DanielnetoDotCom]

I suspect the table CachesInDB_backup belongs to you. I do not have this table on AVideo.

some how your database is corrupted.

maybe you (if your backup is good)

you may want to drop your database completely and restore it again

[walt93]

Hi Daniel-

Yes. I just came to the same conclusion. When I was facing that issue with CachesInDB I backed up the table before dropping it - just in case. I dropped that backup table and then Backup worked.