thank you. my last google backup was Nov 22 2021. meaning this year no backup has been done.
am able to get the sql file of that backup. Thanks
thank you. my last google backup was Nov 22 2021. meaning this year no backup has been done.
am able to get the sql file of that backup. Thanks
am able to scp files from old server to new one but mysq files always end up with 0 size.
Check /var/lib/mysql/ if you can find your DBās
good pointā¦
if you can ftp that would be easierā¦
yes so this is what i did.
i found mysql backups only in .frm and .ibd format so i copied them to my desktop then i used
āALTER TABLE TABLENAME DISCARD TABLESPACEā
āALTER TABLE TABLENAME IMPORT TABLESPACEā
now i have all my sql database back and also i was able to use winscp to copy my website files to my desktop and then ftp into the new server.
Reall want to thank you guys for the help. am grateful