So as the title says, just did our first import from a cpanel backup account, and everything seems fine in terms of folders, files, even mysql user and database.
The problem, is only one table imported. So I manually exported and imported the database via phpMyAdmin, and i get a collation error. I manually fix the collation error, by editing the sql file changing utf8mb4_unicode_520_ci to utf8mb4_unicode_ci
2 errors were found during analysis.
Unexpected beginning of statement. (near "phpMyAdmin" at position 0) Unrecognized statement type. (near "SQL" at position 11) SQL query:
phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Aug 03, 2019 at 05:34 PM -- Server version: 5.7.27 -- PHP Version: 7.2.7 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
MySQL said: Documentation1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'phpMyAdmin SQL Dump
-- version 4.8.5
It's weird that the error references Line 1, but still allowed 6 tables to import. Thoughts anyone?
And going forward, how do i avoid these issues? I have a whole bunch of sites to migrate over. This is a Wordpress site