You should not use phpmyadmin to export big tables from mysql. You may get partial exports because of php server timeouts.
Best way is to connect via SSH to the server and use mysqldump to export the dataset. Then you can download it and transfer it to the new server. There you could use the mysql command to import the dataset.
Continue reading Import and export SQL tables
If you have installed MySQL and you cannot connect to it after installation, you may try the following:
sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
Replace the password with the one you want.
Display a list of running processes:
show full processlist;
Then kill any process you want with kill command:
if, while you are trying to load data, you receive the following error:
Error Code: 1148. The used command is not allowed with this MySQL version
you should perform the following steps:
Continue reading MySQL Load Data error 1148