How to import/export a database and fix 'Access denied create database' error

Moving data in and out of Hostaday hosting is done via the Import/Export tabs in phpMyAdmin .

  • Export: Select your database, click Export, and choose the SQL format to download a backup.
  • Import: Select a pre-created empty database and upload your SQL file.
  • Error 'Access denied create database': This occurs if you try to create a new database inside phpMyAdmin on a shared server .
  • The Fix: You must first create the database name in cPanel under "MySQL Databases". Once created, you can then import the tables into it via phpMyAdmin .
  • MySQL import, phpMyAdmin help, استيراد قاعدة بيانات, access denied error, تصدير SQL, export SQL, حل مشكلة الصلاحيات.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to create and maintain Databases in cPanel

Managing your data is simple with Hostaday’s cPanel tools . Creation: Use the MySQL Database...

How to manage databases with phpMyAdmin

phpMyAdmin is a powerful web-based tool available in your Hostaday cPanel for advanced data...

How to optimize your website database for better performance

Over time, databases can accumulate "overhead" (wasted space). Optimizing helps speed up your...