Issue Importing SQL Database via phpMyAdmin

[Brandonlipman]

I have been working on migrating from BlueHost to DigitalOcean and I am using Sentora to manage all my sites. I am currently running into an issue when I try to import the SQL database file (the file I exported from BlueHost phpMyAdmin) in phpMyAdmin on Sentora. I am getting the following error.


I have gone in and edited my php.ini as specified, however I am still running into the issue. I have attached the current php.ini file as well. Thank you for the help!

[Update] So this just got a whole lot worse. I was able to import the SQL file into my database in Sentora by compressing it. Then I proceeded in uploading the Wordpress site files that previously were hosted on BlueHost. Before doing so I edited the wp_config.php file with the database information from Sentora. 

After doing this, I got an Internal Server Error. I tried accessing my Wordpress Admin with no avail. I then tested if the htaccess file was corrupt by changing its name. That did not work. Then I got this error. 

I then read that I should try and check a configuration in admin. Then I got this error.



This is really a problem. Please help. 

[clu55ter]

From your initial post the error message suggests that the issue may be with the db file that your trying to upload and just wanted to point out that you should use a WordPress migration app i.e. duplicator to migrate your sites from one server to another. Simply exporting/importing the db will cause errors.

[TGates]

Also sounds like MySQL is not even running... log in through SSH and use 'top'.

[Brandonlipman]

Also sounds like MySQL is not even running... log in through SSH and use 'top'.

Thanks for the suggestion. I was able to restart the server using the following command. Now however, when I get this error again this solution is not working. : (

Code:

sudo service mysql restart

[TGates]

Do you have enough disk space? How much free HDD space do you have?

[Brandonlipman]

i think I solved it, I did some server maintenance that the Digital Ocean folks recommended. Thanks!