I’ve just had a nightmare of a development problem. In a nut-shell, I’ve had to import data, (specifically content articles), from one server to another.
This is normally not a problem, but in this instance the source database had each article’s content split into multiple ‘page’ rows. Also, the source database was developed and hosted by another company. They refused to install PHPMyAdmin, (for “security” reasons), and would not give me FTP access. All I had to work with was a terrible database admin system which they’d cobbled together.