mysql database

Anon

I have to create a database on remote server for the first time!
How can I do it? I can't get access to the my subdirectory in the data directory!!!
I have to just create the database how can I use telnet or ???

Anon

You can use telnet, or if you have mysql installed on your own computer, you can use that. The key thing is that you have to log in to the mysql client. From there the command is easy:

create database database_name;

To log into the client, use the following if using telnet:

mysql -uuser -ppassword

Or, from your own computer:

mysql -hwww.yourdomain.com -uuser -ppassword

If those don't work, explain what error you get and someone call help you further.

A second option to try can be used from outside of the client, it depends on your access though.

mysqladmin -uuser -ppassword create database_name

mysqladmin -hwww.yourdomain.com -uuser -ppassword create database_name

Haven't tried it the second way, but as long as your permissions are right, then it should work.

One last thing, if this isn't your server, you usually don't have access to create databases. The server administrator creates a database for you and gives you a login and password. Then within that database, you can create as many tables as you want...that's how it usually works.

Ok...I'm done.

---John Holmes...

Anon

Thank you very much!!!
I have one more problem.
I have to take a file from user & upload it.
In the action file I am not able to copy the file & getting error as

Warning: Unable to create 'aboutced.gif': Permission denied in /www/htdocs/midcindia/su_addnewsact.php on line 33
Couldn't copy the file!

where my code is
copy("$image", "$image_name")
image is form variable name of type file
I am uploading the file in the same directory where my php file resides.

Anon

What are the actual contents of $image and $image_name at this point?

Anon

$image is /tmp/php21392aaa (server path)
$image_name is aboutced.gif (the name of the file I wanted to upload.

Anon

The problem is with permissions. PHP can't write the .gif file to your directory because it doesn't have the proper permissions. Create another directory, and make it's permissions 777, then copy the file into that directory.

$upload_path = "uploads/";
$new_file = $upload_path . $image_name;
copy($image,$new_file);

If you're confused, do a search on here for copy and you'll see where people have discussed this many many times... 🙂

---John Holmes...

Anon

Is it necessary to give absolute destination path in PHP?
or relative path works?

Anon

It can be absolute or relative, as you prefer.
The only requirement is that you have write
permission on the actual location.