My most recent sql backup is over a year old and I'm hesitant to keep updating WP without being able to export a complete sql backup. Export via phpMyAdmin stops at 44 Mb and the total size reported is 178Mb. I realize it is time consuming to export one or two tables at a time, but is that a workable solution? I mean, if I needed to restore the existing DB could I import one table at a time and have it work?
I am not a wiz with sql so although I read that there are some other methods, I was lost at the second sentence. I have exported smaller databases and imported them to move WP sites without issue. This is just to have a usable backup, I'm not moving the site. There's over 4 years of work in the site and it is a worry not to have a complete backup.