Alright, I switched hosts. I exported the db from my previous one and downloaded them. On the host I want to import them on has no permissions. So, I go on the WHM and change the permissions through the root phpMyAdmin. Then, I go back to the cpanel for the website and go to phpMyAdmin. But, the permissions are back to normal and when I refresh the WHM page, the permissions are also back to normal. Why does this happen? Also, is there any other way I can import my SQL dbs to that account?
If you exported them using phpmyadmin, you will need to import them into a new database that you create in cPanel using phpmyadmin. If you exported them using cPanel then you will need to import (restore) them using cPanel. If you simply copied them from the root of your old account you will need to use SSH (putty or like) to restore them to the proper location. If I completely misunderstood all this, please explain it better.
Well, I already did try to import them in cpanel using phpmyadmin. But, the problem is that the permissions aren't staying and so it doesn't allow me to import them via phpmyadmin. It says not enough permissions to create database.
Hello, This is very easy to solve. Please go back to cpanel and go to MySQL Databases. After that make a new database, and when ur about to combine the user and the database, check allow all permissions. Then, google 'bigdump', edit the config.php to ur current database name , user, and pass. Run bigdump and it will restore your database in a matter of minutes. Hope that helped
bigdump isn't the best these days however mysqldumper seems to be very good. http://www.mysqldumper.net