It doesn't allow me to import my database from my local wordpress to my infinityfree database

Website URL

http://piacere.great-site.net

Error Message

Error

consulta SQL:

``

--
-- Base de datos: `#mysql50#performance_schema - copia`
--
CREATE DATABASE IF NOT EXISTS `#mysql50#performance_schema - copia` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

MySQL ha dicho: Documentación

#1044 - Acceso denegado para usuario: 'if0_38246478'@'192.168.0.%' a la base de datos '#mysql50#performance_schema - copia'

Other Information

The file only weighs 12.7 MB to import it, I don’t think I should split it to upload it since it has a maximum amount by default of 300MB, I already checked and I’m trying to import several times to the db where I have my wordpress and still it doesn’t let me upload it, it always gives me an error I suppose it’s because it has privilege limitations, I’m a free user and I would like to be able to load my page from my local environment that is with xampp already deployed

You can’t create databases with SQL command if free hosting, you need to use the control panel to create databases.

7 Likes

i’ve create the db using the panel control, i’m just trying to import the information of my local db through infinityfree db, but don’t let me insert that data, any suggestions to upload
?

You shared a CREATE DATABASE SQL statement, you cannot run that on free hosting.

If the rest of your commands require a certain database name, you probably need to change it so it matches the name of the database you created.

5 Likes

The performance_schema table is a system table, so of course you cannot overwrite that one.

To migrate the database from your own computer to our servers, please make sure to generate an export that only contains the database with your application data. Trying to import a dump of your entire database server will not work, because such dumps also contain system tables that you don’t have access to on a shared server.

4 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.