how to create or upload database

[girl81]

hi everyone...

i'm a new developer..
so i hope someone can tell me detail or links on how to create/upload database into directadmin.

or there are demo to show it???because before this, if im not mistaken i got it but today when i looking for it...i'm not get it.

your helping is very much appreciated
thanks in advance

 

[DirectAdmin Support]

Hello,

1) If you have a gzipped sql file, then you can use the upload tool in your DirectAdmin "MySQL Management" page.
2) if you have a plaintext sql file, then use /phpMyAdmin

There are upload limits, which can be increased for both if needed, but for any really large databases (eg, 100+ meg) I would recommend uploading via ftp and manually inserting the sql file into mysql by hand (through ssh).

mysql -u[b]username[/b] -p[b]pass[/b] [b]user_dbname[/b] < /path/to/your/sqlfile.sql

Note that for all cases, you have to first have to create the database through DA as you cannot use the "CREATE DATABASE name" syntax in mysql with any regular mysql user, only DA has that permission.

John

 

[girl81]

Thanks a lot