Uploading my database

[mallena]

Hi,

I would like to upload my database but i get many problems. I am using mysql and i
am trying to import the database file into phpmyadmin. THis file has several create database statements,inside it. Please advise me on the best way to go about it as i have already uploaded the rest of the site. See URL

 

[chatwizrd]

What format is your database currently in?

You can either inject it with straight sql by clicking the sql section on phpmyadmin or else click import to import a zip or tar.gz type file.

In order to upload a really large file your php must have settings for large uploads or else you need to inject via the command line on the shell.

You can do that with a sql file by doing it like this:

mysql -u username -p < /path/to/file.sql

 

[mallena]

Uploading the database

The file is in sql format. I have tried both direct injection and importing which have given me the following errors respectively.

Imports- #1044 - Access denied for user 'dalceduc_learn'@'localhost' to database 'adm'

direct injection - drop database statements are disabled.

What could be the problem here. I completely do not know how to use the shell command please give me a detailed instructions.

But the zipped file size is 539KBs, is this very large?


Thank you for your speedy reply.

Would it help if i attached the zipped database file with this message?

Mallena

 

[nobaloney]

DA uses a format for naming databases which is username_databasename.

I don't know if this is creating your problem or not.

Have I misunderstood you or did you say your file requests new databases to be written? If so, I have no idea how that would be supported, but make sure you have the rights to create enough databases.

Do you own DA, or are you a customer of a hosting company that uses DA?

If the latter, perhaps your hosting company can help you get it installed.

Jeff