An older TYPO3 (v4.4.15) database appears to corrupt a local sandbox MySQL 5.7 schema. The server hosting the CMS says

$ mysql -V
mysql  Ver 11.18 Distrib 3.23.55, for suse-linux

Details: Installing the legacy version of CMS locally allows the creation of a database and/or populates it with tables. An admin user's credentials can be created and the admin user can successfully log in to the CMS backend. The host's PHPMyAdmin (v4.0.5) is used to dump the live site's database. The local database is then updated using the local system's PHPMyAdmin (v4.6.5) and the dumped script. Although the import succeeds, the admin user can no longer log in. Even creating admin credentials after import does not allow this new admin user to log in.

The legacy database has the latin1 character set. Even if the local system creates an empty database with latin1 the login fails after import.

How to get the local sandbox of the CMS to use the live site's pages and working admin credentials? [Should this question be moved?]


I found this link that discusses how to migrate MySQL from 3.23 to MySQL 5. Unfortunately, the shell id I have for the host fails with

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

when attempting $ mysql -u {username} -p

Edit #2:

It is likely that the db in question is instead in version 5.5 since that is what phpmyadmin says to select version(); I'm converging instead on an import error due to an improperly escaped serialized array. The attempt to build a sandbox will now focus on figuring out how best to import such arrays. (The uncompressed script is about 45MB.)

  • Take a look at stackoverflow.com/questions/11990708/… – Simon Hayter Feb 18 '17 at 21:36
  • Thanks. Unfortunately, that solution seems to require root privileges that I don't have.. – geoB Feb 18 '17 at 22:29
  • Just file up a virtual machine with full privileges... update the DB and then once updated import it back to the live server. I wouldn't even mess around with MySQL command-line on a server that you don't have root. Alternatively you could try mysqladmin -u username -p instead. – Simon Hayter Feb 18 '17 at 23:31
  • The database is on a remote host so a virtual machine doesn't seem possible. And mysqladmin: command not found is what I get with the alternative. – geoB Feb 18 '17 at 23:52
  • And why can't your export the DB and then copy it to a VM? – Simon Hayter Feb 19 '17 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.