mysql -u root -p -h localhost ngpforum_xf < /tmp/ngpforum_xf.sql
On my vps I setup Mopquill's Database Backup Script as a chron job and when trying to import it, the command line seemed to freeze, but it would let me do the help commands like \h and \s for status (too bad I don't really understand the information the status gave me). When I typed a ";" it told me there was an error in the sql file. I tested the backup in MAMP and phpmyadmin loaded it fine so after a while, I decided to install phpmyadmin. I'm using nginx so it was a struggle to do it and I still gave me an error with linked lists. I tried importing the database, it took a while and then gave me the error that either the file was empty or that the file was too large so I increased the import sizes for both php and nginx greatly. Restarted server/php etc, tried again, same error.
My last resort was, copy paste it into the text box under the sql tab and it worked!
Well. Only problem is, it changed some odd characters such as
CPU: ARM® Cortex™-A9 core (4 core)
CPU: ARM¬Æ Cortex‚Ñ¢-A9 core
Can anyone guide me? Can I fix this problem without going back to the old backup (since people have posted since then).