One thing i noticed between the two hosts is that my old host, i have to login with the sql username, here there is no way to login as the sql user. That, in a few words, would become the “soul” of our blog. On the top left, click the database you want to import the backup into. And created a brand new site. Thanks for your response. As a database, MySQL is a versatile application. Select the source database on the left pane. You may want to try following this StackOverflow forum. We also have articles to help you manage your databases and troubleshoot errors – e.g. If you want to import the database into the local machine, then you have to enter the URL http://localhost/phpMyAdmin/. Here’s the command to do so: GRANT ALL PRIVILEGES ON * . You will need to contact Live Support to have them import anything larger than that. a. MySQL is a popular Linux-based database program. Check out How to create a MySQL database in cPanel if needed. I’m sorry to see that this is the case. Click on the database name we want to import to from the left-hand navigation. Click the Choose file button to select CSV file. If uncertain, you should back up the target database before importing a new one into it. Login to phpMyAdmin. I’m interested is there any way i can automatically import a database with phpMyAdmin at a given interval? The MySQL server error output below, if there is any, may also help you in diagnosing the problem. You can import a MySQL database using the phpMyAdmin web interface. Please solve this problem.. How to Import a MySQL Database using phpMyAdmin, Hi, I am new to dealing with sql databases, I tried to import one and got message below. How to Import Your MySQL Database using phpMyAdmin? Select the name of the database from the drop-down menu which you want to import. I hope this helps! i am getting this error while importing the database into myphpadmin? How large is the import? As always, be sure to verify your request with either the last 4 digits of the credit card on file or the current AMP password if sending an email. Larger databases have to be imported/exported via SSH. Open your database in phpMyAdmin. You can go ahead and upload the database file to your account, preferably in the home directory or public_html folder. I suggest reviewing the details at that link, modifying your Spreadsheet accordingly, and then reattempting the import. To do so, follow the instructions here. Next, select the format in which you want to import the database. Select the database you want to work with from the left-side. Next, we will go to the Import tab on that page. If you have any further questions or comments, please let us know. Bukola, this error indicates that the permissions for your MySQL user ‘id1616023_bfilmz’@’%’ are not set to allow this import. Before importing, you will need to drop all previous tables if you are overwriting existing data.